Re: MySQL Server Crashes under heavy load

2003-01-17 Thread Philipp
<[EMAIL PROTECTED]> Sent: Friday, January 17, 2003 6:45 PM Subject: Re: MySQL Server Crashes under heavy load > We have a site with a similar architecture: > - 6 load balanced front-ends > - 1 dedicated database server (Dual P3 1.4GHz, 2GbRAM, RH7.2) > we serve around 3 mill

Re: MySQL Server Crashes under heavy load

2003-01-17 Thread Joseph Bueno
We have a site with a similar architecture: - 6 load balanced front-ends - 1 dedicated database server (Dual P3 1.4GHz, 2GbRAM, RH7.2) we serve around 3 million pages/day (all pages are dynamiquely generated, each page needs an average of 15 SQL queries). What we have done: - audit ALL SQL queries