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 code Code
- Version control system:
- Programming languages:
- GNU bash
All questions Latest questions
Posted on 2011-08-01
What are the prerequisites to run tuning-primer.sh?
Posted on 2008-06-20
All bugs Latest bugs reported
Bug #1565227: Mysql 5.7 InnoDB support
Reported on 2016-04-02
Bug #1541552: errors in slowlog hangling
Reported on 2016-02-03
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