کد PHP:
[--] Up for: 25m 6s (846K q [561.932 qps], 129K conn, TX: 437M, RX: 126M)
[--] Reads / Writes: 43% / 57%
[--] Total buffers: 10.7G global + 34.6M per thread (1000 max threads)
[!!] Maximum possible memory usage: 44.5G (145% of installed RAM)
[OK] Slow queries: 0% (0/846K)
[OK] Highest usage of available connections: 80% (800/1000)
[OK] Key buffer size / total MyISAM indexes: 64.0M/41.1M
[OK] Query cache efficiency: 53.7% (241K cached / 449K selects)
[OK] Query cache prunes per day: 0
[OK] Sorts requiring temporary tables: 0% (0 temp sorts / 7K sorts)
[OK] Temporary tables created on disk: 0% (1 on disk / 6K total)
[OK] Thread cache hit rate: 99% (800 created / 129K connections)
[OK] Table cache hit rate: 95% (141 open / 148 opened)
[OK] Open file limit used: 1% (170/11K)
[OK] Table locks acquired immediately: 100% (532K immediate / 532K locks)
[OK] InnoDB data size / buffer pool: 5.1M/128.0M
-------- Recommendations -----------------------------------------------------
General recommendations:
Run OPTIMIZE TABLE to defragment tables for better performance
MySQL started within last 24 hours - recommendations may be inaccurate
Reduce your overall MySQL memory footprint for system stability
Enable the slow query log to troubleshoot bad queries
کد PHP:
[--] Up for: 25m 6s (846K q [561.932 qps], 129K conn, TX: 437M, RX: 126M)
[--] Reads / Writes: 43% / 57%
پاسخ : دوستانی که تو کانفیگ حرفه ای ان نظر بدن
