gistfile1.txt

Uptime in seconds: 4553038.00
Uptime: 52d 16h 43m 58s                                                                                                                                                                                             
Questions: 1129662736.00                                                                                                                                                                                            
% slow queries: 0.04                                                                                                                                                                                                
slow query rate: 0.00 per day                                                                                                                                                                                       
Long query time: 2.00
Slow query logging: ON                                                                                                                                                                                              
% reads: 71.38                                                                                                                                                                                                      
% writes: 28.62
qps: 248.11                                                                                                                                                                                                         
reads per sec: 0.01 per day                                                                                                                                                                                         
writes per sec: 0.01 per day
Queries: 248.11 per second
Connections: 24 Million
Bytes sent: 1590 Billion
Bytes received: 432 Billion
Supported Version: 5
Release Series: 5.1
Minor Version: 37
Distribution: (Ubuntu)
Distribution: (Ubuntu)
MySQL Architecture: x86_64
Query cache efficiency (%): 37.94
% query cache used: 48.51
Query cache low memory prunes: 1.12 per second
Query cache size: 256.0 Mb
Query cache min result size: 2.0 Mb
Total sorts: 4525063.00
% sorts that cause temporary tables: 0.01
rate of sorts that cause temporary tables: 9.91 per day
sort_buffer_size: 2.5 Mb
read_rnd_buffer_size: 320.0 Kb
Sort rows: 592.21 per second
rate of joins without indexes: 38.96 per minute
rate of reading first index entry: 29.26 per minute
rate of reading fixed position: 601.87 per second
rate of reading next table row: 159570.99 per second
tmp_table_size-max_heap_table_size: 0.00
tmp_table_size: 20.0 Mb
max_heap_table_size: 20.0 Mb
% temp disk tables: 6.96
temp disk rate: 4.21 per minute
temp table rate: 56.33 per minute
MyISAM key buffer size: 256.0 Mb
max % MyISAM key buffer ever used: 81.76
% MyISAM key buffer used: 100.00
% index reads from memory: 99.99
table open cache size (5.1+): 768.00
rate of table open: 2.09 per second
% open files: 23.00
rate of open files: 17.46 per day
Immediate table locks %: 97.04
Table lock wait rate: 4.90 per second
thread cache: 8.00
Total threads created: 1012292.00
thread cache hit rate %: 0.04
Threads that are slow to launch: 0.00
Slow launch time: 2.00
% connections used: 49.25
Max connections used: 394.00
Max connections limit: 800.00
% aborted connections: 0.00
rate of aborted connections: 2.68 per day
% aborted clients: 1.84
rate of aborted clients: 5.95 per minute
Is InnoDB enabled?: YES
% innoDB log size: 62.50
MyISAM concurrent inserts: 1.00


RECOMMENDATIONS:
The query cache is not being fully utilized.
Increase query_cache_size -- there are too many low memory prunes.
There are lots of rows being sorted.  Consider using indexes in more queries to avoid sorting too often.
There are too many joins without indexes -- this means that joins are doing full table scans.
The rate of reading the first index entry is high; this usually indicates frequent full index scans.
The rate of reading data from a fixed position is high; this indicates many queries need to sort results and/or do a full table scan, including join queries that do not use indexes.
The rate of reading the next table row is high; this indicates many queries are doing full table scans.
Too many temporary tables are being written to disk.  Increase max_heap_table_size and tmp_table_size.
Too many intermediate temporary tables are being created; consider increasing sort_buffer_size (sorting), read_rnd_buffer_size (random read buffer, ie, post-sort), read_buffer_size (sequential scan).
MyISAM key buffer (index cache) % used is low.  You may need to decrease the size of key_buffer_size, re-examine your tables to see if indexes have been removed, or examine queries and expectations about what indexes are being used.
The rate of opening tables is high, increase table_open_cache to avoid this.
Too many table locks were not granted immediately. Optimize queries and/or use InnoDB to reduce lock wait.