Package: mysqltuner
Version: 0.9.0
Severity: normal
MySQLTuner worngly report InnoDB statistics for data and index usage.
If I check my MySQL with following SQL I get different data:
mysql SELECT engine, sum(table_rows) as table_rows, (sum(data_length)/1048576)
as data_length, (sum(index_length)/1048576) as index_length, (sum(data_length +
index_length)/1048576) as total_length FROM information_schema.tables WHERE
table_schema NOT IN ('information_schema', 'mysql') GROUP BY engine ORDER BY
table_schema;
+++-+--+--+
| engine | table_rows | data_length | index_length | total_length |
+++-+--+--+
| MyISAM |5316014 |710.9443 | 160.0234 | 870.9678 |
| InnoDB | 33084457 | 2744.9688 |2054.8125 |4799.7813 |
+++-+--+--+
MySQLTuner report following statistics:
General Statistics --
[--] Unable to check for the latest MySQLTuner version
[OK] Currently running supported MySQL version 5.0.51a-24+lenny1-log
[OK] Operating on 64-bit architecture
Storage Engine Statistics ---
[--] Status: +Archive -BDB -Federated +InnoDB -ISAM -NDBCluster
[--] Data in MyISAM tables: 710M (Tables: 120)
[--] Data in InnoDB tables: 2G (Tables: 15)
Performance Metrics -
[--] Up for: 2d 1h 5m 25s (5M q [31.390 qps], 258K conn, TX: 2B, RX: 546M)
[--] Reads / Writes: 69% / 31%
[--] Total buffers: 1.7M per thread and 5.1G global
[OK] Maximum possible memory usage: 5.4G (69% of installed RAM)
[OK] Slow queries: 1% (105K/5M)
[OK] Highest usage of available connections: 23% (47/200)
[OK] Key buffer size / total MyISAM indexes: 1.0G/160.1M
[OK] Key buffer hit rate: 99.4%
[!!] Query cache efficiency: 17.5%
[!!] Query cache prunes per day: 3160
[!!] Sorts requiring temporary tables: 16%
[!!] Temporary tables created on disk: 41%
[OK] Thread cache hit rate: 99%
[!!] Table cache hit rate: 0%
[OK] Open file limit used: 7%
[OK] Table locks acquired immediately: 99%
[OK] InnoDB data size / buffer pool: 2.7G/4.0G
Diffrences are in 'Data in InnoDB tables: 2G' which is in fact 2.7G and 'InnoDB
data size / buffer pool: 2.7G/4.0G' is wrongly calculated because in InnoDB
buffer pool are both data and indexes so threre should be smth like 'InnoDB
structures size / buffer pool: 4.7G/4.0G'.
-- System Information:
Debian Release: 5.0.2
APT prefers stable
APT policy: (500, 'stable')
Architecture: amd64 (x86_64)
Kernel: Linux 2.6.26-2-amd64 (SMP w/4 CPU cores)
Locale: LANG=en_US.UTF-8, LC_CTYPE=en_US.UTF-8 (charmap=UTF-8)
Shell: /bin/sh linked to /bin/bash
Versions of packages mysqltuner depends on:
ii perl 5.10.0-19 Larry Wall's Practical Extraction
Versions of packages mysqltuner recommends:
ii mysql-server 5.0.51a-24+lenny1 MySQL database server (metapackage
ii mysql-server-5.0 [mysq 5.0.51a-24+lenny1 MySQL database server binaries
mysqltuner suggests no packages.
-- no debconf information
--
To UNSUBSCRIBE, email to debian-bugs-dist-requ...@lists.debian.org
with a subject of unsubscribe. Trouble? Contact listmas...@lists.debian.org