Created
July 30, 2010 18:19
-
-
Save andre/501046 to your computer and use it in GitHub Desktop.
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.0.1 - Major Hayden | |
-------- General Statistics -------------------------------------------------- | |
[--] Skipped version check for MySQLTuner script | |
[OK] Currently running supported MySQL version 5.1.41-3ubuntu12.3 | |
[OK] Operating on 32-bit architecture with less than 2GB RAM | |
-------- Storage Engine Statistics ------------------------------------------- | |
[--] Status: -Archive -BDB -Federated +InnoDB -ISAM -NDBCluster | |
[--] Data in InnoDB tables: 267M (Tables: 9) | |
[!!] Total fragmented tables: 9 | |
-------- Performance Metrics ------------------------------------------------- | |
[--] Up for: 23d 5h 10m 52s (1M q [0.928 qps], 13K conn, TX: 2B, RX: 544M) | |
[--] Reads / Writes: 34% / 66% | |
[--] Total buffers: 386.0M global + 12.3M per thread (151 max threads) | |
[!!] Allocating > 2GB RAM on 32-bit systems can cause system instability | |
[!!] Maximum possible memory usage: 2.2G (111% of installed RAM) | |
[OK] Slow queries: 0% (0/1M) | |
[OK] Highest usage of available connections: 7% (11/151) | |
[!!] Cannot calculate MyISAM index size - re-run script as root user | |
[OK] Query cache efficiency: 53.8% (267K cached / 497K selects) | |
[!!] Query cache prunes per day: 4842 | |
[OK] Sorts requiring temporary tables: 0% (0 temp sorts / 4K sorts) | |
[!!] Temporary tables created on disk: 36% (21K on disk / 58K total) | |
[OK] Thread cache hit rate: 99% (11 created / 13K connections) | |
[OK] Table cache hit rate: 23% (48 open / 207 opened) | |
[OK] Open file limit used: 4% (46/1K) | |
[OK] Table locks acquired immediately: 99% (668K immediate / 668K locks) | |
[!!] InnoDB data size / buffer pool: 267.2M/8.0M | |
-------- Recommendations ----------------------------------------------------- | |
General recommendations: | |
Run OPTIMIZE TABLE to defragment tables for better performance | |
Enable the slow query log to troubleshoot bad queries | |
When making adjustments, make tmp_table_size/max_heap_table_size equal | |
Reduce your SELECT DISTINCT queries without LIMIT clauses | |
Variables to adjust: | |
*** MySQL's maximum memory usage is dangerously high *** | |
*** Add RAM before increasing MySQL buffer variables *** | |
query_cache_size (> 60M) | |
tmp_table_size (> 16M) | |
max_heap_table_size (> 16M) | |
innodb_buffer_pool_size (>= 267M) |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment