This script takes information from "SHOW STATUS LIKE..." and "SHOW VARIABLES LIKE..." then attempts to produce sane recommendations for tuning server variables. It is compatible with all versions of MySQL 3.23 and above.
Currently the script handles recommendations for the following:
Slow Query Log
Table (Open & Definition) Cache
Table Scans (read_buffer)
All bugs Latest bugs reported
Bug #1482902: An error has occurred after changing the settings mysql: "mysql: unknown variable 'innodb_buffer_pool_size=512M'"
Reported on 2015-08-08
Bug #1460848: misreports on mariadb 10
Reported on 2015-06-01
Bug #1310997: log-slow-queries needs to change to slow-query-log
Reported on 2014-04-22
Bug #1202940: Script ends at Join section
Reported on 2013-07-19
Bug #1176011: innodb values incorrect
Reported on 2013-05-03
All questions Latest questions
Posted on 2011-08-01
What are the prerequisites to run tuning-primer.sh?
Posted on 2008-06-20