|File Search||Catalog||Content Search|
* Memory Usage: Calculates MySQL memory usage at max load and makes recommendations for increasing or decreasing the MySQL memory footprint. Per-thread and server-wide buffer data is calculated separately for an accurate snapshot of the server?s configuration. * Slow Queries: Reviews the amount of slow queries relative to the total queries. Slow query time limits are also analyzed and recommendations are made. * Connections: Current and historical connection counts are reviewed. * Key Buffer: Takes configuration data and compares it to the actual indexes found in MyISAM tables. Key cache hit rates are calculated and variable adjustments are suggested. * Query Cache: Query cache hit rates and usage percentages are used to make recommendations for the query cache configuration variables. * Sorting & Joins: Per-thread buffers that affect sorts and joins are reviewed along with the statistics from the queries run against the server. * Temporary Tables: Variable recommendations are made to reduce temporary tables that are written to the disk. * Table Cache: Compares total tables opened to the currently open tables. Calculates the table cache hit rate in order to make suggestions. * Open Files: Determines if the server will approach or run into the open file limit set by the operating system or the MySQL server itself. * Table Locks: Finds table locking that forces queries to wait and makes suggestions for reducing locks that require a wait. * Thread Cache: Calculates how many times MySQL must create a new thread to respond to a query. * Aborted Connections: Finds applications that are not closing connections to MySQL properly. * Read/Write Ratios: Calculates the percentage of read and write operations on your MySQL installation.
mysqltuner(1) mysqltuner(1) NAME mysqltuner - high-performance MySQL tuning script SYNOPSIS mysqltuner [ option ] DESCRIPTION High-performance MySQL tuning script that will provide you a MySQL server's health. Based on the statistics gathered, spe‐ cific recommendations will be provided that will increase a more»
mysqltuner (1.1.0) unstable; urgency=low * New release (Closes: #497639) -- Marcela Tiznado <email@example.com> Sun, 15 Nov 2009 23:59:46 -0300 mysqltuner (0.9.0) unstable; urgency=low * New release * Colours fixed by new release (Closes: #470588) * Removed debian/watch * Updated manpage -- Marcela Tiznado <firstname.lastname@example.org> Sun, 25 May 2008 03:11:25 -0300 mysqltuner (0.1rev29-1) un more»
This package was debianized by Marcela Tiznado <email@example.com> on Sat, 22 Dec 2007 03:48:59 -0300. It was downloaded from http://www.mysqltuner.com/ Upstream Author: Major Hayden <firstname.lastname@example.org> Copyright: Copyright (C) 2007 Major Hayden License: GPL The Debian packaging is (C) 2007, Marcela Tiznado <email@example.com> and is licensed under the GPL, see `/usr/share/common more»