Hello, The first thing that I would do would be to separate the DB and apache. Set the DB up so that it is on a box of it's own. The system cannot serve pages if it is crunching through the db tables looking for information (and vice versa).
Shaun ----- Original Message ----- From: "Jason Yates" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, May 01, 2002 10:49 AM Subject: mysql speed concerns > Currently our MySQL server runs around 20-30 queries per second. The > upper management decided they wanted to add about 4 times the customers > in the next two or three weeks. I'm worried that MySQL on this > particular box won't be able to handle the load of around 100-120 > queries per second. Not to mention the CGI scripts are also getting run > on the same box with apache. > > The system has 1gb of RAM, 1 Pentium III 700Mhz, and some ultrascsi HDs > (no raid), running Red Hat 7.1 and Linux 2.4.6. > > What are my options here? > > Replication? I not sure about that since the box is about 60-70% select > and the rest inserts and deletes. Won't I lose "real-time" data. > > I not familiar with any type of load balancing with MySQL? SQL Relay? > > I also thought of separating the Apache server and MySQL server. > > I'll take any ideas. I need them pretty bad. > > -Jason > > > --------------------------------------------------------------------- > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
