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..
mysql server down question
Moderator: General Moderators
-
malcolmboston
- DevNet Resident
- Posts: 1826
- Joined: Tue Nov 18, 2003 1:09 pm
- Location: Middlesbrough, UK
benchmarks between several databases
http://www.mysql.com/information/benchmarks-old.html
MySQL Testing
http://www.mysql.com/information/features.html
http://www.mysql.com/information/benchmarks-old.html
MySQL Testing
http://www.mysql.com/information/features.html
-
malcolmboston
- DevNet Resident
- Posts: 1826
- Joined: Tue Nov 18, 2003 1:09 pm
- Location: Middlesbrough, UK
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
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