Hello,
Thanks for 3.7.x release but it still has the same not indexing joins:
Quote:
[OK] Maximum possible memory usage: 1.5G (38% of installed RAM)
[OK] Slow queries: 0% (0/183K)
[OK] Highest usage of available connections: 4% (8/200)
[OK] Key buffer size / total MyISAM indexes: 64.0M/160.0M
[OK] Key buffer hit rate: 99.7%
[OK] Query cache efficiency: 59.1%
[OK] Query cache prunes per day: 0
[OK] Sorts requiring temporary tables: 0%
[!!] Joins performed without indexes: 648
[OK] Temporary tables created on disk: 4%
[OK] Thread cache hit rate: 99%
[OK] Table cache hit rate: 86%
[OK] Open file limit used: 6%
[OK] Table locks acquired immediately: 99%
|
this is only for 10min works!