[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