Ubuntu
mysqltuner package

mysqltuner 1.3.0+git20140812-1 source package in Ubuntu

Changelog

mysqltuner (1.3.0+git20140812-1) unstable; urgency=medium


  * sync with upstream git repository.
  * New Standards-Version: 3.9.6

 -- KURASHIKI Satoru <email address hidden>  Wed, 22 Oct 2014 14:15:54 +0900

Upload details

Uploaded by:
KURASHIKI Satoru
Uploaded to:
Sid
Original maintainer:
KURASHIKI Satoru
Architectures:
all
Section:
database
Urgency:
Medium Urgency

See full publishing history Publishing

Series Pocket Published Component Section

Builds

Vivid: [FULLYBUILT] amd64

Downloads

File Size SHA-256 Checksum
mysqltuner_1.3.0+git20140812-1.dsc 1.9 KiB 1074f2ebdbc5ef881a4c40e2cae1c57e9ceb96ce76adc46d7906010be9e2202f
mysqltuner_1.3.0+git20140812.orig.tar.gz 24.8 KiB 9a2bcd3a3e2dea47fb2370baa6605a4dfd06e082cca3ec363cf9c5decce16dcc
mysqltuner_1.3.0+git20140812-1.debian.tar.xz 3.1 KiB 69e791a5dc6103da07f2e656f61d03ba4bd4213e956c18c56cd0d09bf6cea035

Available diffs

No changes file available.

Binary packages built by this source

mysqltuner: high-performance MySQL tuning script

 High-performance MySQL tuning script written in perl that will provide
 you with a snapshot of a MySQL server?s health. Based on the statistics
 gathered, specific recommendations will be provided that will increase a
 MySQL server's efficiency and performance. The script gives you
 automated MySQL tuning that is on the level of what you would receive
 from a MySQL DBA.
 .
 Features:
 .
    * 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.