Flasher, I did not exactly get your question. Also it is best to ask unrelated questions at forum.mysqlperformanceblog.com
Rohan, Please use forum.mysqlperformanceblog.com for such questions. In general I’m surprised it works at all, your sort_buffer_size and read_buffer_size are way off. Slaves can get behind master ether because write load is high or if you load slaves with reads too much.
Please ask such unrelated questions at forum.mysqlperformanceblog.com
Murtaza, Please ask unrelated questions on forum.mysqlperformanceblog.com But basically you’re right. Some subqueries are poorly optimized in MySQL as of version 5.0
… | 4160 | | art117 | img_out117 | from_message_id | 3324 | | art119 | article119 | forum_id_3 | 1855 | | art84 | img_out84 | from_message_id | 8363… is link to patch for 5.0.67. http://www.mysqlperformanceblog.com/mysql/experimental/userstatv2.patch. When we consider it stable we…
[...] References: forums.devshed.com dev.mysql.com dev.mysql.com www.mysqlperformanceblog.com [...]