1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
 >>  MySQLTuner 1.2.0 - Major Hayden <[email protected]>
 >>  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
[OK] Currently running supported MySQL version 5.1.63-0ubuntu0.10.04.1-log
[!!] Switch to 64-bit OS - MySQL cannot currently use all of your RAM

-------- Storage Engine Statistics -------------------------------------------
[--] Status: +Archive -BDB -Federated +InnoDB -ISAM -NDBCluster
[--] Data in MyISAM tables: 218M (Tables: 305)
[--] Data in InnoDB tables: 7M (Tables: 118)
[--] Data in MEMORY tables: 0B (Tables: 4)
[!!] Total fragmented tables: 126

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

-------- Performance Metrics -------------------------------------------------
[--] Up for: 42m 48s (55K q [21.588 qps], 3K conn, TX: 165M, RX: 17M)
[--] Reads / Writes: 73% / 27%
[--] Total buffers: 570.0M global + 2.7M per thread (400 max threads)
[OK] Maximum possible memory usage: 1.6G (10% of installed RAM)
[OK] Slow queries: 2% (1K/55K)
[OK] Highest usage of available connections: 16% (67/400)
[OK] Key buffer size / total MyISAM indexes: 512.0M/63.8M
[OK] Key buffer hit rate: 100.0% (178M cached / 6K reads)
[OK] Query cache efficiency: 54.3% (18K cached / 33K selects)
[OK] Query cache prunes per day: 0
[OK] Sorts requiring temporary tables: 0% (0 temp sorts / 5K sorts)
[!!] Joins performed without indexes: 1082
[!!] Temporary tables created on disk: 35% (4K on disk / 11K total)
[OK] Thread cache hit rate: 98% (67 created / 3K connections)
[OK] Table cache hit rate: 30% (600 open / 1K opened)
[OK] Open file limit used: 9% (812/8K)
[OK] Table locks acquired immediately: 96% (40K immediate / 41K locks)
[OK] InnoDB data size / buffer pool: 7.8M/8.0M

-------- Recommendations -----------------------------------------------------
General recommendations:
    Run OPTIMIZE TABLE to defragment tables for better performance
    MySQL started within last 24 hours - recommendations may be inaccurate
    Adjust your join queries to always utilize indexes
    When making adjustments, make tmp_table_size/max_heap_table_size equal
    Reduce your SELECT DISTINCT queries without LIMIT clauses
Variables to adjust:
    join_buffer_size (> 128.0K, or always use indexes with joins)
    tmp_table_size (> 1G)
    max_heap_table_size (> 16M)