-------- Performance Metrics ------------------------------------------------- [--] Up for: 1h 28m 29s (53K q [10.153 qps], 2K conn, TX: 28M, RX: 8M) [--] Reads / Writes: 43% / 57% [--] Total buffers: 2.7G global + 2.3G per thread (50 max threads) [OK] Maximum possible memory usage: 117.5G (82% of installed RAM) [OK] Slow queries: 0% (166/53K) [OK] Highest usage of available connections: 70% (35/50) [OK] Key buffer size / total MyISAM indexes: 128.0M/66.5M [OK] Key buffer hit rate: 99.9% (83M cached / 75K reads) [OK] Query cache efficiency: 45.1% (5K cached / 11K selects) [OK] Query cache prunes per day: 0 [OK] Sorts requiring temporary tables: 0% (0 temp sorts / 3K sorts) [!!] Joins performed without indexes: 2157 [OK] Temporary tables created on disk: 10% (933 on disk / 8K total) [OK] Thread cache hit rate: 98% (35 created / 2K connections) [!!] Table cache hit rate: 12% (1K open / 11K opened) [OK] Open file limit used: 0% (102/65K) [OK] Table locks acquired immediately: 98% (31K immediate / 31K locks) [OK] InnoDB data size / buffer pool: 1.2G/2.0G -------- Recommendations ----------------------------------------------------- General recommendations: Run OPTIMIZE TABLE to defragment tables for better performance MySQL started within last 24 hours - recommendations may be inaccurate Adjust your join queries to always utilize indexes Increase table_cache gradually to avoid file descriptor limits Agung Wicaksono Agung Handoko ToTo SugianTo Mohamad Irvan Faradian benerkan yang masalah di querynya... :D liat yang tanda seru... :))
Posted on: Thu, 03 Jul 2014 11:41:45 +0000
Trending Topics
Recently Viewed Topics
© 2015