Bug#457266: marked as done (ITP: mysqltunner -- high-performance MySQL tuning script)
Your message dated Mon, 07 Jan 2008 00:15:19 +0000
with message-id <E1JBfeB-0001dq-Ud@ries.debian.org>
and subject line Bug#457266: fixed in mysqltuner 0.1-1
has caused the attached Bug report to be marked as done.
This means that you claim that the problem has been dealt with.
If this is not the case it is now your responsibility to reopen the
Bug report if necessary, and/or fix the problem forthwith.
(NB: If you are a system administrator and have no idea what I am
talking about this indicates a serious mail system misconfiguration
somewhere. Please contact me immediately.)
Debian bug tracking system administrator
(administrator, Debian Bugs database)
--- Begin Message ---
- To: submit@bugs.debian.org
- Subject: ITP: mysqltunner -- high-performance MySQL tuning script
- From: Marcela Tiznado <mlt@debian.org>
- Date: Fri, 21 Dec 2007 02:37:32 -0300
- Message-id: <476B511C.7040908@debian.org>
Package: wnpp
Owner: Marcela Tiznado <mlt@debian.org>
Severity: wishlist
* Package name : mysqltunner
Version : 20071201
Upstream Author : Major Hayden <major@mhtx.net>
* URL : http://www.mysqltuner.com/
* License : GPL
Programming Lang : Perl
Description : 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.
-- System Information:
Debian Release: lenny/sid
APT prefers testing
APT policy: (500, 'testing')
Architecture: i386 (i686)
Kernel: Linux 2.6.18-3-686 (SMP w/2 CPU cores)
Locale: LANG=en_US, LC_CTYPE=en_US (charmap=ISO-8859-1)
Shell: /bin/sh linked to /bin/bash
--- End Message ---
--- Begin Message ---
Source: mysqltuner
Source-Version: 0.1-1
We believe that the bug you reported is fixed in the latest version of
mysqltuner, which is due to be installed in the Debian FTP archive:
mysqltuner_0.1-1.diff.gz
to pool/main/m/mysqltuner/mysqltuner_0.1-1.diff.gz
mysqltuner_0.1-1.dsc
to pool/main/m/mysqltuner/mysqltuner_0.1-1.dsc
mysqltuner_0.1-1_all.deb
to pool/main/m/mysqltuner/mysqltuner_0.1-1_all.deb
mysqltuner_0.1.orig.tar.gz
to pool/main/m/mysqltuner/mysqltuner_0.1.orig.tar.gz
A summary of the changes between this version and the previous one is
attached.
Thank you for reporting the bug, which will now be closed. If you
have further comments please address them to 457266@bugs.debian.org,
and the maintainer will reopen the bug report if appropriate.
Debian distribution maintenance software
pp.
Marcela Tiznado <mlt@debian.org> (supplier of updated mysqltuner package)
(This message was generated automatically at their request; if you
believe that there is a problem with it please contact the archive
administrators by mailing ftpmaster@debian.org)
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
Format: 1.7
Date: Sat, 22 Dec 2007 03:48:59 -0300
Source: mysqltuner
Binary: mysqltuner
Architecture: source all
Version: 0.1-1
Distribution: unstable
Urgency: low
Maintainer: Marcela Tiznado <mlt@debian.org>
Changed-By: Marcela Tiznado <mlt@debian.org>
Description:
mysqltuner - high-performance MySQL tuning script
Closes: 457266
Changes:
mysqltuner (0.1-1) unstable; urgency=low
.
* Initial release (Closes: #457266)
Files:
49b529c2ca7e0ce7beba9e55ff5e9145 560 admin extra mysqltuner_0.1-1.dsc
e5dfe17c99d5b5c5aa3be32b0eabe1f2 7127 admin extra mysqltuner_0.1.orig.tar.gz
f886a328b88cbf9de7d4b410b56d7ca8 2285 admin extra mysqltuner_0.1-1.diff.gz
643ca322660d0d5cf701472a64b50341 9912 admin extra mysqltuner_0.1-1_all.deb
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)
iD8DBQFHfdqlsrBfRdYmq7YRApqcAJ4rvVPTwNadGqhRIStv7B/oSyBY6wCcDK2W
U755tF1pUnSekDGq+whCFGM=
=XnJD
-----END PGP SIGNATURE-----
--- End Message ---
Reply to: