Thank you to anyone who has already donated - your generous donations helped make three months of treatment possible.

My brother Nate continues to fight stage IV Hodgkin's lymphoma. He's just 31, with a wife and baby girl. They have no active income (since he's been unable to return to work), no insurance, and cannot afford the treatment he needs. Nate and his family need your help. Please consider a donation, every dollar helps. Thanks.

Read Nate's story Support Nate by buying an official Pastie t-shirt Hide this message

Document@2x
|
Chain_link@2x
|
Arrow_down@2x
|
Spiral_paper@2x
A A A

Plain text       Report abuse 

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 <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
[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)