Page 1 of 1

mysql server down question

Posted: Fri Dec 12, 2003 4:54 am
by valen53
what's reason to make the mysql server slowly ?
is it too many people access at the same time will make it slowly ?
any method can prevent server down ?
is it hardware problem ?
any software can test the mysql server like more than 1000 people access the database at the same time ?

I use standard PC P4 3.0G, 1024MB with win2000 server.
Apache as web server and mysql as database sever.

If i got 1000 member access my database at the same time, is it possible my server will down ? if yes , how to solve it ?

Thankx for any comment..

Posted: Fri Dec 12, 2003 6:57 am
by malcolmboston

Posted: Fri Dec 12, 2003 7:07 am
by malcolmboston
also there is a max_connections in the MySQL cfg (i believe) set this as high as you believe your PC can cope with, any people that exceed this limit will not be able to get in as the connections have already been taken up

Also if your a bit flush with cash, thesse will increase performance
64-bit CPU
CPU with HyperThreading (p4 3ghz has this i believe)
scsi/raid HD configuration

just some thoughts

please note: there is a hell of alot in the MySQL cfg and Apache cfg that will help your site be faster and more streamlined as always though, if your hosting it yourself, upload speed is extremely important