mysqltuner 2.2.12-1 source package in Ubuntu
Changelog
mysqltuner (2.2.12-1) unstable; urgency=medium * Taking over and rebuild package from scratch. (closes: #1053393) + added cleanup for manpage and fixing of executable (closes: #1038051) + updated documentation-files + updated debhelper version + fix Rules-Requires-Root + update Source-Link + remove Vagrant-Files and examples from Package + add lintian-overrides + fix debian/watch + adding libjson-perl to recommends. * New upstream release 2.2.12 -- Cord Beermann <email address hidden> Sun, 10 Dec 2023 10:51:17 +0100
Upload details
- Uploaded by:
- Cord Beermann
- Uploaded to:
- Sid
- Original maintainer:
- Cord Beermann
- Architectures:
- all
- Section:
- database
- Urgency:
- Medium Urgency
See full publishing history Publishing
Series | Published | Component | Section |
---|
Downloads
File | Size | SHA-256 Checksum |
---|---|---|
mysqltuner_2.2.12-1.dsc | 1.7 KiB | 222796b2274b3277e9f6829a58b7f7aba2cacffe52fd8ad7bf41ce42e1661150 |
mysqltuner_2.2.12.orig.tar.gz | 4.9 MiB | 51d7f569ec2fde5ffbe38731e79c8b113899bbf5ea200fc407c622a359b2cca4 |
mysqltuner_2.2.12-1.debian.tar.xz | 4.1 KiB | 1bfd0119f8b31ddce412c02319b4a27b5cef3e92bf3f3b963435e32927ddaf36 |
Available diffs
- diff from 1.9.9-2 to 2.2.12-1 (4.5 MiB)
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.