maria-discuss team mailing list archive

[Reindl Harald <h.reindl@xxxxxxxxxxxxx>]

mysqltuner seems to be no longer maintained

while you should not take any recommendation blindly
it was really usefull over the years, with MariaDB
some values are looking wrong

Up for: 3d 17h 7m 44s (15M q [47.927 qps], 477K conn, TX: 33B, RX: 3B)
[OK] Query cache efficiency: 48.1% (10M cached / 21M selects)

21M selects out of 15M queries as example :-)

it would be pretty cool have a compareable tool (maybe native code)
in the MariaDB setup - sadly Bash/PHP are my skills :-(
______________________________________

 >>  MySQLTuner 1.2.0 - Major Hayden <major@xxxxxxxx>
 >>  Bug reports, feature requests, and downloads at http://mysqltuner.com/
 >>  Run with '--help' for additional options and output filtering
Please enter your MySQL administrative login: root
Please enter your MySQL administrative password:

-------- General Statistics --------------------------------------------------
[--] Skipped version check for MySQLTuner script
[OK] Currently running supported MySQL version 5.5.34-MariaDB-log
[OK] Operating on 64-bit architecture

-------- Storage Engine Statistics -------------------------------------------
[--] Status: -Archive -BDB -Federated -InnoDB -ISAM -NDBCluster
[--] Data in MyISAM tables: 472M (Tables: 4995)
[--] Data in PERFORMANCE_SCHEMA tables: 0B (Tables: 17)
[!!] Total fragmented tables: 141

-------- Security Recommendations  -------------------------------------------
[OK] All database users have passwords assigned

-------- Performance Metrics -------------------------------------------------
[--] Up for: 3d 17h 7m 44s (15M q [47.927 qps], 477K conn, TX: 33B, RX: 3B)
[--] Reads / Writes: 92% / 8%
[--] Total buffers: 1.8G global + 1.8M per thread (500 max threads)
[OK] Maximum possible memory usage: 2.6G (26% of installed RAM)
[OK] Slow queries: 0% (2/15M)
[OK] Highest usage of available connections: 8% (44/500)
[OK] Key buffer size / total MyISAM indexes: 256.0M/189.1M
[OK] Key buffer hit rate: 100.0% (328M cached / 71K reads)
[OK] Query cache efficiency: 48.1% (10M cached / 21M selects)
[OK] Query cache prunes per day: 0
[OK] Sorts requiring temporary tables: 1% (737 temp sorts / 55K sorts)
[!!] Joins performed without indexes: 1140
[OK] Temporary tables created on disk: 22% (45K on disk / 201K total)
[OK] Thread cache hit rate: 99% (44 created / 477K connections)
[OK] Table cache hit rate: 36% (5K open / 14K opened)
[OK] Open file limit used: 1% (10K/750K)

[OK] Table locks acquired immediately: 99% (1M immediate / 1M locks)



-------- Recommendations -----------------------------------------------------

General recommendations:

    Run OPTIMIZE TABLE to defragment tables for better performance

    Adjust your join queries to always utilize indexes

Variables to adjust:

    join_buffer_size (> 1.0M, or always use indexes with joins)

Attachment: signature.asc
Description: OpenPGP digital signature