root@raspberrypi:/home/pi# perl /var/www/mysqltuner.pl >> MySQLTuner 1.2.0 - Major Hayden >> 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.5.31-0+wheezy1 [OK] Operating on 32-bit architecture with less than 2GB RAM -------- Storage Engine Statistics ------------------------------------------- [--] Status: +Archive -BDB -Federated +InnoDB -ISAM -NDBCluster [--] Data in MyISAM tables: 28B (Tables: 10) [--] Data in InnoDB tables: 2M (Tables: 8) [--] Data in PERFORMANCE_SCHEMA tables: 0B (Tables: 17) [!!] Total fragmented tables: 8 -------- Security Recommendations ------------------------------------------- [!!] User '@localhost' has no password set. [!!] User '@raspberrypi' has no password set. -------- Performance Metrics ------------------------------------------------- [--] Up for: 5h 49m 20s (1K q [0.048 qps], 64 conn, TX: 394K, RX: 148K) [--] Reads / Writes: 100% / 0% [--] Total buffers: 192.0M global + 2.7M per thread (151 max threads) [!!] Maximum possible memory usage: 597.8M (136% of installed RAM) [OK] Slow queries: 0% (0/1K) [OK] Highest usage of available connections: 1% (2/151) [OK] Key buffer size / total MyISAM indexes: 16.0M/123.0K [!!] Key buffer hit rate: 75.0% (8 cached / 2 reads) [!!] Query cache efficiency: 11.6% (107 cached / 919 selects) [OK] Query cache prunes per day: 0 [OK] Sorts requiring temporary tables: 0% (0 temp sorts / 69 sorts) [OK] Temporary tables created on disk: 25% (110 on disk / 435 total) [OK] Thread cache hit rate: 96% (2 created / 64 connections) [OK] Table cache hit rate: 25% (64 open / 248 opened) [OK] Open file limit used: 6% (68/1K) [OK] Table locks acquired immediately: 100% (328 immediate / 328 locks) [OK] InnoDB data size / buffer pool: 2.8M/128.0M -------- Recommendations ----------------------------------------------------- General recommendations: Run OPTIMIZE TABLE to defragment tables for better performance MySQL started within last 24 hours - recommendations may be inaccurate Reduce your overall MySQL memory footprint for system stability Enable the slow query log to troubleshoot bad queries Variables to adjust: *** MySQL's maximum memory usage is dangerously high *** *** Add RAM before increasing MySQL buffer variables *** query_cache_limit (> 1M, or use smaller result sets)