[masterross]

Originally Posted by Xanlamin

Originally Posted by masterross

Hello,

Thanks for 3.7.x release but it still has the same not indexing joins:

this is only for 10min works!

This will be fixed in the next release.

The problem still exist....

[--] Up for: 16m 54s (56K q [55.506 qps], 2K conn, TX: 2B, RX: 14M)
[--] Reads / Writes: 83% / 17%
[--] Total buffers: 602.0M global + 5.7M per thread (250 max threads)
[OK] Maximum possible memory usage: 2.0G (49% of installed RAM)
[OK] Slow queries: 0% (0/56K)
[OK] Highest usage of available connections: 3% (8/250)
[OK] Key buffer size / total MyISAM indexes: 64.0M/178.0M
[OK] Key buffer hit rate: 99.5% (2M cached / 14K reads)
[OK] Query cache efficiency: 59.5% (28K cached / 47K selects)
[OK] Query cache prunes per day: 0
[OK] Sorts requiring temporary tables: 0% (0 temp sorts / 4K sorts)
[!!] Joins performed without indexes: 353
[OK] Temporary tables created on disk: 5% (98 on disk / 1K total)
[OK] Thread cache hit rate: 99% (8 created / 2K connections)
[OK] Table cache hit rate: 95% (238 open / 248 opened)
[OK] Open file limit used: 4% (431/10K)
[OK] Table locks acquired immediately: 99% (45K immediate / 45K locks)