Created
March 2, 2014 02:25
-
-
Save centminmod/9300938 to your computer and use it in GitHub Desktop.
mysqltuner 1.3.0 modded by George Liu (eva2000) vbtechsupport.com sample output on MariaDB 10.0.8 on centminmod.com web stack
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
>> MySQLTuner 1.3.0 mod - Major Hayden <major@mhtx.net> | |
>> Bug reports, feature requests, and downloads at http://mysqltuner.com/ | |
>> Modified by George Liu (eva2000) at http://vbtechsupport.com/ | |
>> Run with '--help' for additional options and output filtering | |
[!!] Currently running unsupported MySQL version 10.0.8-MariaDB | |
[OK] Operating on 64-bit architecture | |
-------- Storage Engine Statistics ------------------------------------------- | |
[--] Status: -ARCHIVE +Aria +BLACKHOLE +CSV -FEDERATED +InnoDB +MRG_MyISAM | |
[--] Data in MyISAM tables: 1G (Tables: 11) | |
[--] Data in InnoDB tables: 208K (Tables: 13) | |
[--] Data in PERFORMANCE_SCHEMA tables: 0B (Tables: 52) | |
[OK] Total fragmented tables: 0 | |
-------- Performance Metrics ------------------------------------------------- | |
[--] Up for: 4m 40s (57 q [0.204 qps], 8 conn, TX: 22K, RX: 2K) | |
[--] Reads / Writes: 100% / 0% | |
[--] Total buffers: 176.0M global + 800.0K per thread (300 max threads) | |
[OK] Maximum possible memory usage: 410.4M (41% of installed RAM) | |
[OK] Slow queries: 0% (0/57) | |
[OK] Highest usage of available connections: 0% (1/300) | |
[!!] Key buffer size / total MyISAM indexes: 32.0M/300.5M | |
[!!] Query cache efficiency: 0.0% (0 cached / 6 selects) | |
[OK] Query cache prunes per day: 0 | |
[OK] Temporary tables created on disk: 0% (0 on disk / 6 total) | |
[OK] Thread cache hit rate: 87% (1 created / 8 connections) | |
[OK] Table cache hit rate: 311% (81 open / 26 opened) | |
[OK] Open file limit used: 0% (36/8K) | |
[OK] Table locks acquired immediately: 100% (73 immediate / 73 locks) | |
[OK] InnoDB buffer pool / data size: 48.0M/208.0K | |
[OK] InnoDB log waits: 0 | |
-------- Recommendations ----------------------------------------------------- | |
General recommendations: | |
MySQL started within last 24 hours - recommendations may be inaccurate | |
Variables to adjust: | |
key_buffer_size (> 300.5M) | |
query_cache_limit (> 512K, or use smaller result sets) |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment