Flasher, I did not exactly get your question. Also it is best to ask unrelated questions at forum.mysqlperformanceblog.com
Comment: What to tune in MySQL Server after installation
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.
Comment: About Vadim Tkachenko
Please ask such unrelated questions at forum.mysqlperformanceblog.com
Comment: About This Blog
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
Comment: Why MySQL could be slow with large tables ?
http://forum.mysqlperformanceblog.com/s/t/17/
Post: Google's user_statistics V2 port and changes
… | 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…
Comment: INSERT ON DUPLICATE KEY UPDATE and summary counters.
[...] References: forums.devshed.com dev.mysql.com dev.mysql.com www.mysqlperformanceblog.com [...]

