SQL
Command counters

Variable	Value	Description
Variable	Value	Description
Com_select	4	The number of SELECT-statements.
Com_insert	0	The number of INSERT-statements.
Com_update	0	The number of UPDATE-statements.
Com_delete	0	The number of DELETE-statements.
Com_lock_tables	0	The number of table locks.
Com_unlock_tables	0	The number of table unlocks.
Query performance

Variable	Value	Description
Select_full_join	0	The number of joins without an index; should be zero.
Select_range_check	0	The number of joins without keys that check for key usage after each row; should be zero.
Sort_scan	0	The number of sorts done without using an index; should be zero.
Table_locks_immediate	234294	The number of times a lock could be acquired immediately.
Table_locks_waited	21846	The number of times the server had to wait for a lock.
Query cache information

The MySQL query cache can improve performance of your site by storing the result of queries. Then, if an identical query is received later, the MySQL server retrieves the result from the query cache rather than parsing and executing the statement again.

Variable	Value	Description
Qcache_queries_in_cache	14303	The number of queries in the query cache.
Qcache_hits	687048	The number of times MySQL found previous results in the cache.
Qcache_inserts	124494	The number of times MySQL added a query to the cache (misses).
Qcache_lowmem_prunes	0	The number of times MySQL had to remove queries from the cache because it ran out of memory. Ideally should be zero.

mysqltuner report
-------- General Statistics --------------------------------------------------
[--] Skipped version check for MySQLTuner script
[OK] Currently running supported MySQL version 5.1.41-3ubuntu12.6
[OK] Operating on 64-bit architecture

-------- Storage Engine Statistics -------------------------------------------
[--] Status: -Archive -BDB -Federated +InnoDB -ISAM -NDBCluster 
[--] Data in MyISAM tables: 151M (Tables: 106)
[!!] InnoDB is enabled but isn't being used
[!!] Total fragmented tables: 13

-------- Performance Metrics -------------------------------------------------
[--] Up for: 2h 17m 39s (952K q [115.334 qps], 9K conn, TX: 5B, RX: 256M)
[--] Reads / Writes: 69% / 31%
[--] Total buffers: 106.0M global + 2.7M per thread (151 max threads)
[OK] Maximum possible memory usage: 511.8M (13% of installed RAM)
[OK] Slow queries: 0% (3/952K)
[OK] Highest usage of available connections: 18% (28/151)
[OK] Key buffer size / total MyISAM indexes: 16.0M/76.4M
[OK] Key buffer hit rate: 100.0% (6B cached / 12K reads)
[OK] Query cache efficiency: 83.6% (726K cached / 869K selects)
[OK] Query cache prunes per day: 0
[OK] Sorts requiring temporary tables: 0% (0 temp sorts / 2K sorts)
[!!] Joins performed without indexes: 48
[OK] Temporary tables created on disk: 16% (84 on disk / 524 total)
[OK] Thread cache hit rate: 95% (383 created / 9K connections)
[!!] Table cache hit rate: 1% (64 open / 4K opened)
[OK] Open file limit used: 8% (87/1K)
[!!] Table locks acquired immediately: 91%

-------- Recommendations -----------------------------------------------------
General recommendations:
    Add skip-innodb to MySQL configuration to disable InnoDB
    Run OPTIMIZE TABLE to defragment tables for better performance
    MySQL started within last 24 hours - recommendations may be inaccurate
    Enable the slow query log to troubleshoot bad queries
    Adjust your join queries to always utilize indexes
    Increase table_cache gradually to avoid file descriptor limits
    Optimize queries and/or use InnoDB to reduce lock wait
Variables to adjust:
    join_buffer_size (> 128.0K, or always use indexes with joins)
    table_cache (> 64)