Registered
2008-06-20
by
TodoInTX
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
Max Connections
Worker Threads
Memory Usage
Key Buffer
Query Cache
Sort Buffer
Joins
Temp Tables
Table (Open & Definition) Cache
Table Scans (read_buffer)
Table Locking
Innodb Status
View full history Series and milestones
MySQL Tuning Primer Script trunk series is the current focus of development
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
More contributors Top contributors
- Mary 8 points
- Don Lindsay 4 points
All questions Latest questions
-
host option
Posted on 2011-08-01 -
What are the prerequisites to run tuning-primer.sh?
Posted on 2008-06-20
