Advertisement
Guest User

Untitled

a guest
Jun 25th, 2018
184
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.75 KB | None | 0 0
  1. -------- Performance Metrics -------------------------------------------------
  2. [--] Up for: 1d 5h 45m 2s (16M q [156.624 qps], 267K conn, TX: 6B, RX: 9B)
  3. [--] Reads / Writes: 4% / 96%
  4. [--] Binary logging is disabled
  5. [--] Total buffers: 8.1G global + 1.1M per thread (151 max threads)
  6. [OK] Maximum reached memory usage: 8.1G (51.57% of installed RAM)
  7. [OK] Maximum possible memory usage: 8.2G (52.48% of installed RAM)
  8. [OK] Slow queries: 0% (0/16M)
  9. [OK] Highest usage of available connections: 8% (13/151)
  10. [OK] Aborted connections: 0.00% (2/267064)
  11. [!!] Query cache is disabled
  12. [OK] Sorts requiring temporary tables: 0% (0 temp sorts / 262K sorts)
  13. [!!] Joins performed without indexes: 355
  14. [!!] Temporary tables created on disk: 97% (132K on disk / 135K total)
  15. [OK] Thread cache hit rate: 99% (98 created / 267K connections)
  16. [!!] Table cache hit rate: 0% (416 open / 6M opened)
  17. [OK] Open file limit used: 1% (14/1K)
  18. [OK] Table locks acquired immediately: 100% (256 immediate / 256 locks)
  19.  
  20. -------- MyISAM Metrics -----------------------------------------------------
  21. [!!] Key buffer used: 18.2% (3M used / 16M cache)
  22. [OK] Key buffer size / total MyISAM indexes: 16.0M/43.0K
  23. [!!] Read Key buffer hit rate: 76.9% (324 cached / 75 reads)
  24.  
  25. -------- InnoDB Metrics -----------------------------------------------------
  26. [--] InnoDB is enabled.
  27. [OK] InnoDB buffer pool / data size: 8.0G/5.5G
  28. [OK] InnoDB buffer pool instances: 8
  29. [!!] InnoDB Used buffer: 49.13% (257556 used/ 524224 total)
  30. [OK] InnoDB Read buffer efficiency: 99.92% (268365003 hits/ 268568571 total)
  31. [!!] InnoDB Write buffer efficiency: 0.00% (0 hits/ 1 total)
  32. [OK] InnoDB log waits: 0.00% (0 waits / 8761555 writes)
  33.  
  34. -------- AriaDB Metrics -----------------------------------------------------
  35. [--] AriaDB is disabled.
  36.  
  37. -------- Replication Metrics -------------------------------------------------
  38. [--] No replication slave(s) for this server.
  39. [--] This is a standalone server..
  40.  
  41. -------- Recommendations -----------------------------------------------------
  42. General recommendations:
  43. Run OPTIMIZE TABLE to defragment tables for better performance
  44. Adjust your join queries to always utilize indexes
  45. When making adjustments, make tmp_table_size/max_heap_table_size equal
  46. Reduce your SELECT DISTINCT queries which have no LIMIT clause
  47. Increase table_open_cache gradually to avoid file descriptor limits
  48. Read this before increasing table_open_cache over 64: http://bit.ly/1mi7c4C
  49. Beware that open_files_limit (1024) variable
  50. should be greater than table_open_cache ( 431)
  51. Variables to adjust:
  52. query_cache_type (=1)
  53. join_buffer_size (> 256.0K, or always use indexes with joins)
  54. tmp_table_size (> 16M)
  55. max_heap_table_size (> 16M)
  56. table_open_cache (> 431)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement