[snip] 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? [/snip] Before I'd panic I would run some of the bench-marking available on MySQL; http://www.mysql.com/doc/M/y/MySQL_Benchmarks.html And look at the results. I have a customer service tool that runs over 100 queries per second from support personnel on a P3 with 512Mb RAM, Slackware Linux, Apache, PHP. There are millions of records per table (good indexing helps) with the top tables containing 40 million records. We are running a RAID (because of disk space concerns) and regularly run archiving scripts. Thus far we have not noticed a degredation in performance. (BUT, that is why I moved another large database set to another server, the one I had been having problems with the past couple of days. All is well now.) Once our data & data requests starts to get really out of hand (which, according to Murphy's Laws, it will) we will be upgrading to much larger servers. But until that day.... Jay Blanchard --------------------------------------------------------------------- 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
