I snuck into the 5.1 new features session halfway through but definitely well worth it. Lots of new features coming out in 5.1 though Brian Aker admits some of them are not quite production-ready yet, so don’t go deploying it just yet.
A quick note for those of you enjoying the MySQL Conference & Expo 2007 in Santa Clara this week. Please join Pythian VP Martin Wisniewski at 4:40pm on Tuesday, in Ballroom G for his session on Augmenting Your In-House MySQL Resources.
If you’re looking for information on Pythian, come see us early.
I got tired of going all over the place to get information about mysqld variables, so I decided to make a summary of most of them (for version 5.0.27 linux). (Due to lack of horizontal space, I had to make two tables — the second one containing a short description of the variable.) Corrections, additions, and amplifications are welcome. Enjoy!
Pythian will be at the MySQL Conference in Santa Clara, taking in all the material we can, processing it, and spewing out what I hope will be some useful blogs. Watch this space!
Welcome to the 41st edition of Log Buffer, the weekly review of database blogs.
Closing session is a “Great Tools Debate”, being chaired by Michael Abbey.
Here is the perl script referred to by mysql-memory-usage-profile.
Final day at IOUG 2007.
I’m not going to try to post a comprehensive mysql tuning manual here. This post is about taking a snapshot profile of a mysql instance that will allow you to define what type of instance you are dealing with, and give you some idea about whether the current configurations are stable or not.