Posts Categorized: Pythian

Table of MySQL Parameters

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!

MySQL Memory Usage Profile Script

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.

Page 192 of 223« First...102030...190191192193194...200210220...Last »