Category Archives: Performance

OurSQL Episode 71: Table Manners, part 2

This week, we continue our discussion about MySQL and its forks. We discuss the Percona server and MariaDB.
Percona Live comes to Washington, DC on Wednesday, January 11th, 2012 at the Walter E. Washington Convention Center. There is a 50% discount f… Continue reading

Posted in General, Learning, Performance, Podcasts, Server Tuning | Comments Off on OurSQL Episode 71: Table Manners, part 2

OurSQL Episode 68: Scaling, or Sailing?

This week Sheeri visits the Schooner offices and inteviews Dr John Busch, the CTO, Founder, and Chairman of the Board for Schooner. Schooner is able to fully use multi-core processors and do fully synchronous replication without losing performance. … Continue reading

Posted in Performance, Podcasts | Comments Off on OurSQL Episode 68: Scaling, or Sailing?

OurSQL Episode 67: HA and Replication

This week, we talk about mysql ha and replication.
News/Feedback
Last week we talked about how we learn and keep up to date with changes to MySQL. Mark Grennan of mysqlfanboy.com posted his own list of MySQL resources.
Call for papers for Percona Liv… Continue reading

Posted in Learning, Performance, Podcasts | Comments Off on OurSQL Episode 67: HA and Replication

OurSQL Episode 54: Scaling MySQL

This week, we discuss the Percona MySQL conference and scaling with ScaleBase.
Percona Live MySQL Conference and Expo event page, and Baron’s announcement of the conference.
Dates to keep in mind:
September 1st – call for speakers opens
November 1st – … Continue reading

Posted in Performance, Podcasts, Server Tuning | Comments Off on OurSQL Episode 54: Scaling MySQL

OurSQL Episode 50: MySQL at Facebook, Current and Future

This week we post the audio from the closing keynote of Percona Live by Harrison Fisk of Facebook, “MySQL at Facebook, Current and Future”. There is no ear candy this week.
Continue reading

Posted in Performance, Podcasts | Comments Off on OurSQL Episode 50: MySQL at Facebook, Current and Future

OurSQL Episode 43: Repli-cans and repli-can’ts

Note: We said this was episode 44, but it’s really episode 43!
In this episode we give the basics of how replication works, giving knowledge about the fundamentals about replication to better understand why it has certain limitations and benefits.
S… Continue reading

Posted in Performance, Podcasts | Comments Off on OurSQL Episode 43: Repli-cans and repli-can’ts

OurSQL Episode 42: The Buzz about MySQL 5.6

This week we talk about what’s new in MySQL 5.6 and the return of labs.mysql.com. We also feature people’s reactions to the 5.6 announcement and a special song by Solomon Chang (lyrics below).

Show notes:
If you want to see it for youreslf, there is a video from the O’Reilly Conference of Tomas Ulin’s Keynote, “State of the Dolphin”.

Olav Sandstå’s blog post on index condition pushdown optimization.

read more

Continue reading

Posted in Conferences, Learning, Performance, Podcasts, Server Tuning | Comments Off on OurSQL Episode 42: The Buzz about MySQL 5.6

OurSQL Episode 40: TokuDB 5.0 part 2

This week we conclude the interview with Tokutek’s co-founder and Chief Scientist, Martin Farach-Colton. Part 1 of the interview. TokuDB is a transactional, fully ACID-compliant storage engine that uses fractal trees for data and indexes, instead of … Continue reading

Posted in Learning, Performance, Podcasts | Comments Off on OurSQL Episode 40: TokuDB 5.0 part 2

OurSQL Episode 37: It’s Still Not Our (De)fault! Part 2

This week, Giuseppe Maxia joins us as a special guest and we complete our 2-part series on what we always put in our configuration files, and why.
Part 1 in the series.
strings man page
MySQL manual page about defaults-group-suffix
Giuseppe’s article a… Continue reading

Posted in Performance, Podcasts, Server Tuning | Comments Off on OurSQL Episode 37: It’s Still Not Our (De)fault! Part 2