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.
Third day at IOUG 2007.
Second day at IOUG 2007.
First day at IOUG 2007.