mysqltuner_1.7.13-1_all.deb


Advertisement

Description

mysqltuner - high-performance MySQL tuning script

Property Value
Distribution Ubuntu 19.04 (Disco Dingo)
Repository Ubuntu Universe amd64
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
Category universe/admin
Homepage http://mysqltuner.com
License -
Maintainer Ubuntu Developers <ubuntu-devel-discuss@lists.ubuntu.com>
Download size 121.84 KB
Installed size 1.42 MB
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 Architecture Repository
mysqltuner_1.7.13-1_all.deb 1.7.13 all Ubuntu Universe
mysqltuner - - -

Requires

Name Value
perl:any -

Download

Type URL
Mirror archive.ubuntu.com
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_amd64.deb real-time logging system in MySQL - Courier traffic-logger
mysqmail-dovecot-logger_0.4.9-10.2_amd64.deb real-time logging system in MySQL - Dovecot traffic-logger
mysqmail-postfix-logger_0.4.9-10.2_amd64.deb real-time logging system in MySQL - Postfix traffic-logger
mysqmail-pure-ftpd-logger_0.4.9-10.2_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
mythtv-status_1.0.1-1_all.deb Show the status of a MythTV backend
mythtvfs_0.6.1-3build1_amd64.deb userspace filesystem client for MythTV
mytop_1.9.1-4_all.deb top like query monitor for MySQL
mz_0.40-1.1build1_amd64.deb versatile packet creation and network traffic generation tool
mzclient_0.9.0-6_all.deb CLI library for multicast DNS service discovery (commandline tool)
n2n_1.3.1~svn3789-7_amd64.deb Peer-to-Peer VPN network daemon
nabi_1.0.0-3_amd64.deb Korean X input method server plus imhangul status monitor
nacl-tools_20110221-6.1_amd64.deb NaCl and CurveCP tools
nadoka_0.9.2-1_all.deb IRC logger, monitor and proxy program ("bot") in Ruby
naev-data_0.7.0-2build1_all.deb 2D action/rpg space game - game data
Advertisement
Advertisement