June 19, 2013

Comment: What to tune in MySQL Server after installation

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 [...]

Comment: MySQL, AIX5L and malloc()

hi, i’ve been asking about this setup all around with almost no answer..even in mysqlperformanceblog.com forums.. did you get any performance numbers?. how did this setup perform against intel platform?. which compiler did you use to compile mysql on aix? anyone has this kind of info?.