<br><br><div><span class="gmail_quote">On 7/10/07, <b class="gmail_sendername">Gerhard Killesreiter</b> <<a href="mailto:gerhard@killesreiter.de">gerhard@killesreiter.de</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;">
-----BEGIN PGP SIGNED MESSAGE-----<br>Hash: SHA1<br><br>Dries Buytaert schrieb:<br>><br>> On 10 Jul 2007, at 17:09, Dries Buytaert wrote:<br>>> The down time seriously hinders my patch reviewing -- I tried for 30
<br>>> minutes today, but I simply couldn't get two pages to load in a row<br>>> (two reviews were lost). Instead of reviewing patches the next couple<br>>> of days, I'm going to dedicate my time to help with the infrastructure
<br>>> instead.<br>><br>> Gerhard, I'd like to take a lead in managing a small team of people that<br>> are willing to help with code changes or other things that don't require<br>> shell access. It would be great if you could give us some starting
<br>> points. What are the steps required to tackle this, and what steps can<br>> we open up to more people?<br><br>Dries, it is very nice to offer some of your not so copious spare time<br>for this good cause. Sadly, there actually isn't that much you, I, or
<br>any OSUOSL outsider can do when it comes to our hardware and its setup.<br><br>After discussing your offer with Narayan, we agreed that it would be<br>best if you do that what you can do best: review patches. Especially
<br>patches which would help our infrastructure.<br><br>The number one patch to review is David's master-slave patch at:<br><br><a href="http://drupal.org/node/147160">http://drupal.org/node/147160</a><br><br>Since we can't move
<a href="http://drupal.org">drupal.org</a> to Drupal 6 right now, we'd actually need<br>a Drupal 5 version of this, thus there shouldn't be too much reworking.<br><br>It would probably be best if we'd just send specific queries to the
<br>slaves in a round-robin fashion.<br><br>Any resulting patch should be tested a lot especially for inserts and<br>updates when the server is under high load.</blockquote><div><br>Perhaps taking Johnathan up on his offer to support a mirror of
D.O. to test this patch would be prudent.<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;">There are also a number of other performance related patches in the
<br>patch queue. These won't help use immediately, but will in the long run. </blockquote><br><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
Of course, there's always the game of "review slow sql queries" to be<br>played. The project module has a lot on offer and we can provide slow<br>query logs.</blockquote><div><a href="http://www.mysqlperformanceblog.com/files/utils/mysql_slow_log_parser">
<br>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 somewhere regularly?<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;">
Cheers,<br> Gerhard<br>-----BEGIN PGP SIGNATURE-----<br>Version: GnuPG v1.4.6 (GNU/Linux)<br><br>iD8DBQFGk/vffg6TFvELooQRAr0oAKCSKy5mIDKMvo+Nz9gNeSm4WiA/awCgm1SU<br>ZaYWtwN3YL4/EXFhrcCtQ8A=<br>=oV5E<br>-----END PGP SIGNATURE-----
<br></blockquote></div><br><br clear="all"><br>-- <br>To strive, to seek, to find, and not to yield.<br>