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