mysqltuner_1.7.13-1_all.deb


Description

mysqltuner - high-performance MySQL tuning script

Property Value
Distribution Debian 10 (Buster)
Repository Debian Main amd64 Official
Package filename mysqltuner_1.7.13-1_all.deb
Package name mysqltuner
Package version 1.7.13
Package release 1
Package architecture all
Package type deb
Homepage http://mysqltuner.com
License -
Maintainer KURASHIKI Satoru <lurdan@gmail.com>
Download size 121.83 KB
Installed size 1.42 MB
Category
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.

Alternatives

Package Version Repository
mysqltuner_1.7.13-1_all.deb 1.7.13 Debian Main Official
mysqltuner_1.7.13-1_all.deb 1.7.13 Debian Main Official
mysqltuner_1.7.13-1_all.deb 1.7.13 Debian Main Official
mysqltuner All All

Requires

Name Value
perl:any -

Download

Type URL
Mirror ftp.br.debian.org
Binary Package mysqltuner_1.7.13-1_all.deb
Source Package mysqltuner

Install Howto

  1. Update the package index:
    # sudo apt-get update
  2. Install mysqltuner deb package:
    # sudo apt-get install mysqltuner

Files

Path
/usr/bin/mysqltuner
/usr/share/doc/mysqltuner/CODE_OF_CONDUCT.md
/usr/share/doc/mysqltuner/CONTRIBUTING.md.gz
/usr/share/doc/mysqltuner/INTERNALS.md.gz
/usr/share/doc/mysqltuner/README.fr.md.gz
/usr/share/doc/mysqltuner/README.it.md.gz
/usr/share/doc/mysqltuner/README.md.gz
/usr/share/doc/mysqltuner/README.ru.md.gz
/usr/share/doc/mysqltuner/USAGE.md.gz
/usr/share/doc/mysqltuner/changelog.Debian.gz
/usr/share/doc/mysqltuner/copyright
/usr/share/doc/mysqltuner/template_example.tpl
/usr/share/doc/mysqltuner/Vagrant/Vagrantfile.gz
/usr/share/doc/mysqltuner/Vagrant/Vagrantfile_for_MariaDB10.0.gz
/usr/share/doc/mysqltuner/Vagrant/Vagrantfile_for_MariaDB10.1.gz
/usr/share/doc/mysqltuner/Vagrant/Vagrantfile_for_MariaDB10.2.gz
/usr/share/doc/mysqltuner/Vagrant/Vagrantfile_for_MariaDB10.3.gz
/usr/share/doc/mysqltuner/Vagrant/Vagrantfile_for_MySQL5-6.gz
/usr/share/doc/mysqltuner/Vagrant/Vagrantfile_for_MySQL5-7.gz
/usr/share/doc/mysqltuner/Vagrant/Vagrantfile_for_MySQL8-0.gz
/usr/share/doc/mysqltuner/Vagrant/prepare.sh
/usr/share/man/man1/mysqltuner.1.gz
/usr/share/mysqltuner/basic_passwords.txt
/usr/share/mysqltuner/vulnerabilities.csv

Changelog

2019-01-05 - KURASHIKI Satoru <lurdan@gmail.com>
mysqltuner (1.7.13-1) unstable; urgency=medium
* New upstream release.
* New Standards-Version: 4.3.0
* Move to salsa.
2017-07-06 - KURASHIKI Satoru <lurdan@gmail.com>
mysqltuner (1.7.2-1) unstable; urgency=medium
* New upstream release.
* New Standards-Version: 4.0.0
* fix to recommends metapackage default-mysql-server. (Closes: #848442)
2016-10-13 - KURASHIKI Satoru <lurdan@gmail.com>
mysqltuner (1.6.18-1) unstable; urgency=medium
* New upstream release.
* New Standards-Version: 3.9.8
2015-11-26 - KURASHIKI Satoru <lurdan@gmail.com>
mysqltuner (1.6.0-1) unstable; urgency=medium
* New upstream release.
- support report templating feature.
2015-09-09 - KURASHIKI Satoru <lurdan@gmail.com>
mysqltuner (1.5.1-1) unstable; urgency=medium
* New upstream release.
* Use generated manpage instead of debian's.
* Change package section from admin to database.
* Add virtual mysql package to its dependency. (Closes: #781973)
2014-10-22 - KURASHIKI Satoru <lurdan@gmail.com>
mysqltuner (1.3.0+git20140812-1) unstable; urgency=medium
* sync with upstream git repository.
* New Standards-Version: 3.9.6
2014-03-27 - KURASHIKI Satoru <lurdan@gmail.com>
mysqltuner (1.3.0-1) unstable; urgency=medium
* New upstream release.
* New Standards-Version: 3.9.5
* debian/watch: update.
2012-06-22 - KURASHIKI Satoru <lurdan@gmail.com>
mysqltuner (1.2.0-1) unstable; urgency=low
* New Maintainer.
* New upstream release. (Closes: #629652)
* New Standards-Version: 3.9.3
* New Source format: 3.0
* debian/copyright: switch to DEP-5.
* debian/rules: switch to dh7.
* debian/watch: add.
2009-11-15 - Marcela Tiznado <mlt@debian.org>
mysqltuner (1.1.0) unstable; urgency=low
* New release (Closes: #497639)
2008-05-25 - Marcela Tiznado <mlt@debian.org>
mysqltuner (0.9.0) unstable; urgency=low
* New release
* Colours fixed by new release (Closes: #470588)
* Removed debian/watch
* Updated manpage

See Also

Package Description
mysqmail-courier-logger_0.4.9-10.2+b1_amd64.deb real-time logging system in MySQL - Courier traffic-logger
mysqmail-dovecot-logger_0.4.9-10.2+b1_amd64.deb real-time logging system in MySQL - Dovecot traffic-logger
mysqmail-postfix-logger_0.4.9-10.2+b1_amd64.deb real-time logging system in MySQL - Postfix traffic-logger
mysqmail-pure-ftpd-logger_0.4.9-10.2+b1_amd64.deb real-time logging system in MySQL - Pure-FTPd traffic-logger
mysqmail_0.4.9-10.2_all.deb real-time logging system in MySQL
mythes-ar_6.2.0-1_all.deb Arabic Thesaurus for LibreOffice
mythes-bg_6.2.0-1_all.deb Bulgarian Thesaurus for LibreOffice
mythes-ca_6.2.0-1_all.deb Catalan Thesaurus for LibreOffice
mythes-cs_6.2.0-1_all.deb Czech Thesaurus for LibreOffice
mythes-da_6.2.0-1_all.deb Danish Thesaurus for LibreOffice
mythes-de-ch_20160424-3_all.deb German Thesaurus for OpenOffice.org/LibreOffice (Swiss Version)
mythes-de_20160424-3_all.deb German Thesaurus for OpenOffice.org/LibreOffice
mythes-en-au_2.1-5.4_all.deb Australian English Thesaurus for OpenOffice.org
mythes-en-us_6.2.0-1_all.deb English (USA) Thesaurus for LibreOffice
mythes-es_6.2.0-1_all.deb Spanish Thesaurus for LibreOffice