On Wed, May 01, 2002 at 10:49:36AM -0400, Jason Yates wrote: > 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?
You'll be fine if your app is well designed and your tables are properly indexed. You should be able to easily pump out 500-1000 queries per second on that hardware. Jeremy -- Jeremy D. Zawodny, <[EMAIL PROTECTED]> Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.47-max: up 83 days, processed 2,169,815,560 queries (300/sec. avg) --------------------------------------------------------------------- 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
