Don't like ads? PRO users don't see any ads ;-)
Public Pastes
Guest

Untitled

By: a guest on May 1st, 2012  |  syntax: None  |  size: 2.05 KB  |  hits: 91  |  expires: Never
download  |  raw  |  embed  |  report abuse  |  print
Text below is selected. Please press Ctrl+C to copy to your clipboard. (⌘+C on Mac)
  1. root@poker1 [~]# ./mysqltuner.pl
  2.  
  3.  >>  MySQLTuner 1.0.1 - Major Hayden <major@mhtx.net>
  4.  >>  Bug reports, feature requests, and downloads at http://mysqltuner.com/
  5.  >>  Run with '--help' for additional options and output filtering
  6.  
  7. -------- General Statistics --------------------------------------------------
  8. [--] Skipped version check for MySQLTuner script
  9. [OK] Currently running supported MySQL version 5.0.90-community-log
  10. [OK] Operating on 64-bit architecture
  11.  
  12. -------- Storage Engine Statistics -------------------------------------------
  13. [--] Status: +Archive -BDB -Federated +InnoDB -ISAM -NDBCluster
  14. [--] Data in MyISAM tables: 23M (Tables: 89)
  15. [--] Data in InnoDB tables: 1G (Tables: 15)
  16. [!!] Total fragmented tables: 3
  17.  
  18. -------- Performance Metrics -------------------------------------------------
  19. [--] Up for: 5d 17h 13m 41s (65M q [132.044 qps], 5M conn, TX: 132B, RX: 4B)
  20. [--] Reads / Writes: 59% / 41%
  21. [--] Total buffers: 2.5G global + 40.4M per thread (110 max threads)
  22. [OK] Maximum possible memory usage: 6.8G (58% of installed RAM)
  23. [OK] Slow queries: 0% (4K/65M)
  24. [OK] Highest usage of available connections: 79% (87/110)
  25. [OK] Key buffer size / total MyISAM indexes: 1.0G/24.7M
  26. [OK] Key buffer hit rate: 99.7% (7M cached / 25K reads)
  27. [OK] Query cache efficiency: 43.5% (10M cached / 23M selects)
  28. [OK] Query cache prunes per day: 0
  29. [!!] Sorts requiring temporary tables: 40% (1K temp sorts / 4K sorts)
  30. [OK] Temporary tables created on disk: 1% (596 on disk / 40K total)
  31. [OK] Thread cache hit rate: 99% (194 created / 5M connections)
  32. [OK] Table cache hit rate: 67% (220 open / 324 opened)
  33. [OK] Open file limit used: 4% (221/4K)
  34. [OK] Table locks acquired immediately: 99% (24M immediate / 24M locks)
  35. [!!] InnoDB data size / buffer pool: 1.2G/1000.0M
  36.  
  37. -------- Recommendations -----------------------------------------------------
  38. General recommendations:
  39.     Run OPTIMIZE TABLE to defragment tables for better performance
  40. Variables to adjust:
  41.     sort_buffer_size (> 16M)
  42.     read_rnd_buffer_size (> 16M)
  43.     innodb_buffer_pool_size (>= 1G)
create a new version of this paste RAW Paste Data