froscon2009 - 1.0
FrOSCon
Free and Open Source Software Conference
| Speakers | |
|---|---|
|
Sheeri K. Cabral |
| Schedule | |
|---|---|
| Day | Day 1 (2009-08-22) |
| Room | C120/OpenSQLCamp |
| Start time | 14:00 |
| Duration | 01:00 |
| Info | |
| ID | 421 |
| Event type | Lecture |
| Track | OpenSQLCamp |
| Language used for presentation | English |
| Feedback | |
|---|---|
|
Did you attend this event? Give Feedback |
A Better mysqltuner
mysqltuner (<A HREF=http://www.mysqltuner.com>www.mysqltuner.com</A>) is an open source tool that looks at a select number of parameters, including system and status variables, and outputs tuning recommendations. Sheeri K. Cabral of the Pythian Group has modified mysqltuner to be more comprehensive, to output information and to have a "spreadsheet" mode where the results of mysqltuner are outputted as a single column, so that you can easily compare subsequent runs of the modified mysqltuner -- for example, running it monthly or weekly to see how performance is progressing (or degrading). There is also a truly offline mode that requires no database connectivity where files containing the output of SHOW GLOBAL STATUS and SHOW GLOBAL VARIABLES are used.
This workshop will go through all the details of the modified mysqltuner, and take suggestions for further improvements.
mysqltuner (http://wiki.mysqltuner.com/MySQLTuner) is an open source tool that looks at a select number of parameters, including system and status variables, and outputs tuning recommendations. Sheeri K. Cabral of the Pythian Group has modified mysqltuner to be more comprehensive, to output information and to have a "spreadsheet" mode where the results of mysqltuner are outputted as a single column, so that you can easily compare subsequent runs of the modified mysqltuner -- for example, running it monthly or weekly to see how performance is progressing (or degrading). There is also a truly offline mode that requires no database connectivity where files containing the output of SHOW GLOBAL STATUS and SHOW GLOBAL VARIABLES are used.
This workshop will go through all the details of the modified mysqltuner, and take suggestions for further improvements.