<br><br><div><span class="gmail_quote">On 7/11/07, <b class="gmail_sendername">Dries Buytaert</b> <<a href="mailto:dries@buytaert.net">dries@buytaert.net</a>> wrote:</span><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<br>On 11 Jul 2007, at 02:04, Kieran Lal wrote:<br>> Perhaps taking Johnathan up on his offer to support a mirror of<br>> D.O. to test this patch would be prudent.<br><br>But how would that work? Would it just a 2 week old copy of
<br><a href="http://drupal.org">drupal.org</a> with nodes and comments closed? That doesn't help me with<br>patch reviewing.</blockquote><div><br>I would assume you would want some bench marks. I assume you would also want to lots and lots of comments and nodes created. If there is any test we could do make a write happen against the slave we would want to do that. I would assume that could be captured in MySQL logging some how.
<br></div><br><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">> <a href="http://www.mysqlperformanceblog.com/files/utils/mysql_slow_log_parser">
http://www.mysqlperformanceblog.com/files/utils/mysql_slow_log_parser</a><br>><br>> Any chance that could get set up to run on a cron job and output<br>> somewhere regularly?<br><br>Maybe these logs periodically available (in an automated way) would
<br>be really useful.</blockquote><div><br>That's what I was hoping. We know several of the worst queries already and we don't have fixes, but having consistent reporting of the problem could allow us to continue to track down more advanced solutions.
<br><br>Cheers,<br>Kieran<br> </div><br><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">--<br>Dries Buytaert :: <a href="http://www.buytaert.net/">
http://www.buytaert.net/</a><br><br></blockquote></div><br><br clear="all"><br>-- <br>To strive, to seek, to find, and not to yield.<br>