mysql server down question

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
valen53
Forum Contributor
Posts: 137
Joined: Tue Aug 27, 2002 9:29 am

mysql server down question

Post 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..
malcolmboston
DevNet Resident
Posts: 1826
Joined: Tue Nov 18, 2003 1:09 pm
Location: Middlesbrough, UK

Post by malcolmboston »

malcolmboston
DevNet Resident
Posts: 1826
Joined: Tue Nov 18, 2003 1:09 pm
Location: Middlesbrough, UK

Post 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
Post Reply