[debian-mysql] http://www.day32.com/MySQL/
Christian Hammers
ch at debian.org
Mon Dec 10 20:26:19 UTC 2007
Hello
Perhaps we could include the following program alongside mysqlreport. It
gives less numbers but more recommendations if the current numbers are good
or bad:
bye,
-christian-
http://www.day32.com/MySQL/
MySQL Performance Tuning Primer Script
This script takes information from "SHOW STATUS LIKE..." and "SHOW VARIABLES LIKE..."
to produce sane recomendations for tuning server variables.
It is compatable with all versions of MySQL 3.23 and higher (including 5.1).
# Currently it handles recomendations for the following:
# Slow Query Log
# Max Connections
# Worker Threads
# Key Buffer
# Query Cache
# Sort Buffer
# Joins
# Temp Tables
# Table (Open & Definition) Cache
# Table Locking
# Table Scans (read_buffer)
# Innodb Status
More information about the pkg-mysql-maint
mailing list