daily pastebin goal
61%
SHARE
TWEET

Untitled

a guest Jul 22nd, 2018 82 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. -------- Storage Engine Statistics -------------------------------------------
  2. [--] Status: -Archive -BDB -Federated +InnoDB -ISAM -NDBCluster
  3. [--] Data in MyISAM tables: 182M (Tables: 79)
  4. [--] Data in InnoDB tables: 1M (Tables: 77)
  5. [!!] Total fragmented tables: 77
  6.  
  7. -------- Security Recommendations  -------------------------------------------
  8. [!!] User 'root@127.0.0.1' has no password set.
  9. [!!] User 'root@localhost' has no password set.
  10. [!!] User 'root@skwp-mbp.local' has no password set.
  11.  
  12. -------- Performance Metrics -------------------------------------------------
  13. [--] Up for: 1h 35m 22s (1K q [0.319 qps], 12 conn, TX: 110K, RX: 458M)
  14. [--] Reads / Writes: 7% / 93%
  15. [--] Total buffers: 26.0M global + 832.0K per thread (151 max threads)
  16. [OK] Maximum possible memory usage: 148.7M (0% of installed RAM)
  17. [OK] Slow queries: 0% (0/1K)
  18. [OK] Highest usage of available connections: 0% (1/151)
  19. [OK] Key buffer size / total MyISAM indexes: 16.0K/28.0M
  20. [OK] Key buffer hit rate: 98.4% (2M cached / 34K reads)
  21. [!!] Query cache is disabled
  22. [OK] Sorts requiring temporary tables: 0% (0 temp sorts / 1 sorts)
  23. [OK] Temporary tables created on disk: 21% (3 on disk / 14 total)
  24. [!!] Thread cache is disabled
  25. [!!] Table cache hit rate: 0% (1 open / 418 opened)
  26. [OK] Open file limit used: 0% (2/755)
  27. [OK] Table locks acquired immediately: 100% (245 immediate / 245 locks)
  28. [!!] Connections aborted: 8%
  29. [OK] InnoDB data size / buffer pool: 1.2M/8.0M
  30.  
  31. -------- Recommendations -----------------------------------------------------
  32. General recommendations:
  33.     Run OPTIMIZE TABLE to defragment tables for better performance
  34.     MySQL started within last 24 hours - recommendations may be inaccurate
  35.     Enable the slow query log to troubleshoot bad queries
  36.     Set thread_cache_size to 4 as a starting value
  37.     Increase table_cache gradually to avoid file descriptor limits
  38.     Your applications are not closing MySQL connections properly
  39. Variables to adjust:
  40.     query_cache_size (>= 8M)
  41.     thread_cache_size (start at 4)
  42.     table_cache (> 4)
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
 
Top