Advertisement
Guest User

Untitled

a guest
Aug 21st, 2014
342
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.64 KB | None | 0 0
  1. -------- General Statistics --------------------------------------------------
  2. [--] Skipped version check for MySQLTuner script
  3. [OK] Currently running supported MySQL version 5.5.35-0ubuntu0.12.04.2
  4. [OK] Operating on 64-bit architecture
  5.  
  6. -------- Storage Engine Statistics -------------------------------------------
  7. [--] Status: -Archive -BDB -Federated +InnoDB -ISAM -NDBCluster
  8. [--] Data in MyISAM tables: 19M (Tables: 98)
  9. [--] Data in InnoDB tables: 226M (Tables: 148)
  10. [--] Data in PERFORMANCE_SCHEMA tables: 0B (Tables: 17)
  11. [!!] Total fragmented tables: 152
  12.  
  13. -------- Performance Metrics -------------------------------------------------
  14. [--] Up for: 13m 27s (68K q [84.686 qps], 2K conn, TX: 519M, RX: 69M)
  15. [--] Reads / Writes: 96% / 4%
  16. [--] Total buffers: 190.0M global + 2.7M per thread (40 max threads)
  17. [OK] Maximum possible memory usage: 297.5M (8% of installed RAM)
  18. [OK] Slow queries: 0% (0/68K)
  19. [!!] Highest connection usage: 95% (38/40)
  20. [OK] Key buffer size / total MyISAM indexes: 14.0M/2.4M
  21. [OK] Key buffer hit rate: 98.7% (36K cached / 457 reads)
  22. [OK] Query cache efficiency: 91.9% (55K cached / 60K selects)
  23. [OK] Query cache prunes per day: 0
  24. [OK] Sorts requiring temporary tables: 0% (0 temp sorts / 280 sorts)
  25. [!!] Joins performed without indexes: 4
  26. [!!] Temporary tables created on disk: 31% (299 on disk / 958 total)
  27. [OK] Thread cache hit rate: 90% (197 created / 2K connections)
  28. [OK] Table cache hit rate: 26% (313 open / 1K opened)
  29. [OK] Open file limit used: 23% (245/1K)
  30. [OK] Table locks acquired immediately: 100% (3K immediate / 3K locks)
  31. [!!] InnoDB data size / buffer pool: 226.7M/128.0M
  32.  
  33. -------- Recommendations -----------------------------------------------------
  34. General recommendations:
  35. Run OPTIMIZE TABLE to defragment tables for better performance
  36. MySQL started within last 24 hours - recommendations may be inaccurate
  37. Enable the slow query log to troubleshoot bad queries
  38. Reduce or eliminate persistent connections to reduce connection usage
  39. Adjust your join queries to always utilize indexes
  40. When making adjustments, make tmp_table_size/max_heap_table_size equal
  41. Reduce your SELECT DISTINCT queries without LIMIT clauses
  42. Variables to adjust:
  43. max_connections (> 40)
  44. wait_timeout (< 180)
  45. interactive_timeout (< 180)
  46. join_buffer_size (> 128.0K, or always use indexes with joins)
  47. tmp_table_size (> 16M)
  48. max_heap_table_size (> 16M)
  49. innodb_buffer_pool_size (>= 226M)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement