My Pastes
Public Pastes
Layout Width
Share Pastebin
Guest
Public paste!

Untitled

By: a guest | Jul 28th, 2010 | Syntax: None | Size: 2.42 KB | Hits: 22 | Expires: Never
Download | Raw | Embed | Report abuse
Copy text to clipboard
  1.  >>  MySQLTuner 1.0.1 - Major Hayden <major@mhtx.net>
  2.  >>  Bug reports, feature requests, and downloads at http://mysqltuner.com/
  3.  >>  Run with '--help' for additional options and output filtering
  4.  
  5. -------- General Statistics --------------------------------------------------
  6. [--] Skipped version check for MySQLTuner script
  7. [OK] Currently running supported MySQL version 5.1.41-3ubuntu12.3-log
  8. [OK] Operating on 64-bit architecture
  9.  
  10. -------- Storage Engine Statistics -------------------------------------------
  11. [--] Status: -Archive -BDB -Federated +InnoDB -ISAM -NDBCluster
  12. [--] Data in MyISAM tables: 132M (Tables: 103)
  13. [--] Data in InnoDB tables: 64K (Tables: 4)
  14. [!!] Total fragmented tables: 17
  15.  
  16. -------- Performance Metrics -------------------------------------------------
  17. [--] Up for: 26m 9s (4K q [3.009 qps], 159 conn, TX: 31M, RX: 621K)
  18. [--] Reads / Writes: 19% / 81%
  19. [--] Total buffers: 74.0M global + 48.7M per thread (151 max threads)
  20. [!!] Maximum possible memory usage: 7.3G (376% of installed RAM)
  21. [OK] Slow queries: 2% (109/4K)
  22. [OK] Highest usage of available connections: 5% (9/151)
  23. [OK] Key buffer size / total MyISAM indexes: 16.0M/113.8M
  24. [OK] Key buffer hit rate: 95.9% (3M cached / 146K reads)
  25. [OK] Query cache efficiency: 43.5% (554 cached / 1K selects)
  26. [OK] Query cache prunes per day: 0
  27. [OK] Sorts requiring temporary tables: 0% (0 temp sorts / 69 sorts)
  28. [!!] Joins performed without indexes: 15
  29. [OK] Temporary tables created on disk: 21% (57 on disk / 268 total)
  30. [OK] Thread cache hit rate: 94% (9 created / 159 connections)
  31. [!!] Table cache hit rate: 13% (128 open / 922 opened)
  32. [OK] Open file limit used: 24% (247/1K)
  33. [OK] Table locks acquired immediately: 100% (3K immediate / 3K locks)
  34. [OK] InnoDB data size / buffer pool: 64.0K/8.0M
  35.  
  36. -------- Recommendations -----------------------------------------------------
  37. General recommendations:
  38.     Run OPTIMIZE TABLE to defragment tables for better performance
  39.     MySQL started within last 24 hours - recommendations may be inaccurate
  40.     Reduce your overall MySQL memory footprint for system stability
  41.     Adjust your join queries to always utilize indexes
  42.     Increase table_cache gradually to avoid file descriptor limits
  43. Variables to adjust:
  44.   *** MySQL's maximum memory usage is dangerously high ***
  45.   *** Add RAM before increasing MySQL buffer variables ***
  46.     join_buffer_size (> 128.0K, or always use indexes with joins)
  47.     table_cache (> 128)
create new paste | create new version of this paste RAW Paste Data