Category Archives: Server Tuning

OurSQL Episode 108: Legendary Searches

This week we present the Sphinx Storage Engine. Ear Candy is a gotcha about setting variables in the configuration file, and At the Movies is a video about MariaDB.
Events
MySQL Connect will be held in San Francisco on Saturday September 29th and Sunda… Continue reading

Posted in Performance, Podcasts, Query Optimization, Server Tuning | Comments Off on OurSQL Episode 108: Legendary Searches

OurSQL Episode 102: Virtualization 102

This week, we continue the virtualization talk about what to know when doing virtualization. We also talk about using KVM & virtualbox.
Episode 101, part 1 of virtualization.
Conferences
FrOSCon will be held Saturday and Sunday, August 25th – 26th … Continue reading

Posted in Podcasts, Server Tuning | Comments Off on OurSQL Episode 102: Virtualization 102

OurSQL Episode 98: MySQL Puppeteering

This week we present using Puppet to manage MySQL. Ear Candy is netcat and At the Movies is a video about the Master High Availability toolkit by Yoshinori Matsunobu.

Feedback
Daniël van Eeden gave us lots of great feedback this week:
Episode 93, which included iotop and ionice in ear candy
CFQ scheduler for Linux
noop scheduler for Linux
deadline scheduler for Linux

read more

Continue reading

Posted in Learning, Podcasts, Server Tuning | Comments Off on OurSQL Episode 98: MySQL Puppeteering

OurSQL Episode 97: Who’s Watching the Databases?

This week we present an interview with Rohit Nadhani of WebYog about MONyog, a MySQL monitoring and advisory tool.
Conferences
OSCon will be held Monday Jul 16th through Friday Jul 20th and has a data track. We did a podcast about OSCon, including a d… Continue reading

Posted in Learning, Podcasts, Server Tuning | Comments Off on OurSQL Episode 97: Who’s Watching the Databases?

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 60: Charming Data

This week we talk with Giuseppe Maxia (pronouncing his name correctly!) about new features in Tungsten replicator, and go over a lot of news.
News:
There was a lot of news this week! There were three really big announcements at Oracle OpenWorld that r… Continue reading

Posted in Conferences, Learning, Podcasts, Server Tuning | Comments Off on OurSQL Episode 60: Charming Data

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 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 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

OurSQL Episode 36: It’s Not Our (De)fault! Part 1

Nick Pisarro, aka @highenergybeams, suggested we do a podcast about the MySQL defaults we recommend always having, as MySQL’s pre-configured option files are not particularly helpful. So we have put together a 2-part podcast on the options that we cha… Continue reading

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