-
Recent Posts
Recent Comments
Archives
- August 2017
- June 2015
- April 2015
- March 2015
- February 2015
- December 2014
- November 2014
- August 2014
- July 2014
- June 2014
- May 2014
- April 2014
- March 2014
- February 2014
- January 2014
- December 2013
- November 2013
- October 2013
- September 2013
- August 2013
- July 2013
- June 2013
- May 2013
- April 2013
- March 2013
- February 2013
- January 2013
- December 2012
- November 2012
- October 2012
- September 2012
- August 2012
- July 2012
- June 2012
- May 2012
- April 2012
- March 2012
- February 2012
- January 2012
- December 2011
- November 2011
- October 2011
- September 2011
- August 2011
- July 2011
- June 2011
- May 2011
- April 2011
- March 2011
- February 2011
- January 2011
- December 2010
- February 2009
- January 2008
- October 2007
- August 2007
- July 2007
- May 2007
- April 2007
- March 2007
- February 2007
- January 2007
- December 2006
- November 2006
Categories
Meta
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
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.
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