[masterross]

Originally Posted by Xanlamin

And what problem will that be? I have never experienced that with this mod.

You've never seen them cause you probably never see the MYSQL performance


this is the stats before enable the hack

-------- Performance Metrics -------------------------------------------------
[--] Up for: 2d 0h 11m 38s (10M q [63.379 qps], 525K conn, TX: 516M, RX: 2B)
[--] Reads / Writes: 80% / 20%
[--] Total buffers: 5.7M per thread and 346.0M global
[OK] Maximum possible memory usage: 1.4G (36% of installed RAM)
[OK] Slow queries: 0% (7/10M)
[OK] Highest usage of available connections: 40% (81/200)
[OK] Key buffer size / total MyISAM indexes: 64.0M/136.2M
[OK] Key buffer hit rate: 100.0%
[OK] Query cache efficiency: 60.5%
[OK] Query cache prunes per day: 0
[OK] Sorts requiring temporary tables: 0%
[OK] Temporary tables created on disk: 5%
[OK] Thread cache hit rate: 99%
[OK] Table cache hit rate: 52%
[OK] Open file limit used: 15%
[OK] Table locks acquired immediately: 99%

and this is 3 hours later:

-------- Performance Metrics -------------------------------------------------
[--] Up for: 2d 3h 26m 44s (12M q [64.988 qps], 573K conn, TX: 2B, RX: 3B)
[--] Reads / Writes: 80% / 20%
[--] Total buffers: 5.7M per thread and 346.0M global
[OK] Maximum possible memory usage: 1.4G (36% of installed RAM)
[OK] Slow queries: 0% (7/12M)
[OK] Highest usage of available connections: 40% (81/200)
[OK] Key buffer size / total MyISAM indexes: 64.0M/136.6M
[OK] Key buffer hit rate: 100.0%
[OK] Query cache efficiency: 60.4%
[OK] Query cache prunes per day: 0
[OK] Sorts requiring temporary tables: 0%
[!!] Joins performed without indexes: 9991
[OK] Temporary tables created on disk: 5%
[OK] Thread cache hit rate: 99%
[OK] Table cache hit rate: 51%
[OK] Open file limit used: 15%
[OK] Table locks acquired immediately: 99%