omega8cc / boa

Barracuda Octopus Aegir 5.5.0-PRO
https://omega8.cc/compare
394 stars 75 forks source link

Update mysqltuner.perl to support MariaDB 10.0 #424

Closed pricejn2 closed 10 years ago

pricejn2 commented 10 years ago

Hello,

mysqltuner.perl 1.3 was released that provides support for MariaDB 10.0 -- https://github.com/major/MySQLTuner-perl/releases/tag/v1.3.0

This corrects incorrectly calculated results, such as Data in InnoDB tables.

See the following 1.2 vs 1.3 output on the same server:

1.3

>>  MySQLTuner 1.3.0 - Major Hayden <major@mhtx.net>
 >>  Bug reports, feature requests, and downloads at http://mysqltuner.com/
 >>  Run with '--help' for additional options and output filtering
[OK] Logged in using credentials from debian maintenance account.
[!!] Currently running unsupported MySQL version 10.0.13-MariaDB-1~wheezy
[OK] Operating on 64-bit architecture

-------- Storage Engine Statistics -------------------------------------------
[--] Status: +ARCHIVE +Aria +BLACKHOLE +CSV +FEDERATED +InnoDB +MRG_MyISAM
[--] Data in InnoDB tables: 106M (Tables: 751)
[--] Data in PERFORMANCE_SCHEMA tables: 0B (Tables: 52)
[!!] Total fragmented tables: 10

-------- Performance Metrics -------------------------------------------------
[--] Up for: 9h 35m 22s (8M q [236.683 qps], 331K conn, TX: 5B, RX: 1B)
[--] Reads / Writes: 92% / 8%
[--] Total buffers: 2.1G global + 20.4M per thread (382 max threads)
[OK] Maximum possible memory usage: 9.7G (62% of installed RAM)
[OK] Slow queries: 0% (0/8M)
[OK] Highest usage of available connections: 14% (56/382)
[OK] Key buffer size / total MyISAM indexes: 3.0M/121.0K
[OK] Query cache efficiency: 45.3% (5M cached / 12M selects)
[!!] Query cache prunes per day: 593765
[OK] Sorts requiring temporary tables: 0% (159 temp sorts / 440K sorts)
[OK] Temporary tables created on disk: 6% (48 on disk / 780 total)
[OK] Thread cache hit rate: 99% (56 created / 331K connections)
[!!] Table cache hit rate: 6% (128 open / 1K opened)
[OK] Open file limit used: 0% (6/196K)
[OK] Table locks acquired immediately: 100% (1M immediate / 1M locks)
[!!] InnoDB  buffer pool / data size: 32.0M/106.1M
[OK] InnoDB log waits: 0

1.2

>>  MySQLTuner 1.2.0 - Major Hayden <major@mhtx.net>
 >>  Bug reports, feature requests, and downloads at http://mysqltuner.com/
 >>  Run with '--help' for additional options and output filtering
[OK] Logged in using credentials from debian maintenance account.

-------- General Statistics --------------------------------------------------
[--] Skipped version check for MySQLTuner script
[!!] Your MySQL version 10.0.13-MariaDB-1~wheezy is EOL software!  Upgrade soon!
[OK] Operating on 64-bit architecture

-------- Storage Engine Statistics -------------------------------------------
[--] Status: +Archive -BDB +Federated +InnoDB -ISAM -NDBCluster
[--] Data in MyISAM tables: 3K (Tables: 25)
[--] Data in CSV tables: 0B (Tables: 2)
[--] Data in InnoDB tables: 2M (Tables: 754)
[--] Data in PERFORMANCE_SCHEMA tables: 0B (Tables: 52)
[!!] Total fragmented tables: 610

-------- Performance Metrics -------------------------------------------------
[--] Up for: 9h 35m 54s (8M q [236.752 qps], 331K conn, TX: 5B, RX: 1B)
[--] Reads / Writes: 92% / 8%
[--] Total buffers: 2.1G global + 4.2M per thread (382 max threads)
[OK] Maximum possible memory usage: 3.7G (23% of installed RAM)
[OK] Slow queries: 0% (0/8M)
[OK] Highest usage of available connections: 14% (56/382)
[OK] Key buffer size / total MyISAM indexes: 3.0M/121.0K
[OK] Sorts requiring temporary tables: 0% (159 temp sorts / 440K sorts)
[OK] Temporary tables created on disk: 6% (48 on disk / 788 total)
[OK] Thread cache hit rate: 99% (56 created / 331K connections)
[!!] Table cache hit rate: 2% (128 open / 4K opened)
Use of uninitialized value $myvar{"table_cache"} in concatenation (.) or string
        at mysqltuner.pl line 868 (#1)
[OK] Open file limit used: 0% (4/196K)
[OK] Table locks acquired immediately: 100% (1M immediate / 1M locks)
[OK] InnoDB data size / buffer pool: 2.7M/32.0M
pricejn2 commented 10 years ago

Excellent! Thanks for the quick commit!