<[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
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
We are hosting a high volume site that gets about 1 million page views a day
on RedHat 7.3. We currently have 3 load balanced servers on the front end
accessing a MySQL server on the back end. The MySQL servers is dual P3 1ghz
with 1 GB of RAM and when the MySQL queries hit about 50 per second, t
