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!
Table 1: MySQL Variables
| Variable Name | Variable Type | SET OFFLINE ONLY | SET GLOBAL | SET SESSION |
| auto_increment_increment | numeric | OFFLINE | ||
| auto_increment_offset | numeric | … |