hey,
i'm having a problem with scaling a mysql server. This is the situation... i have
a database with 5 tables containing user data. Except one, all the other tables have
only 2 fields. This data is queried often and needs to be accessed by multiple web
servers. Each table would contain something like 500,000 to 1,000,000 records. I'm
using PHP to access the mysql database. The system would be experiencing loads of
5000 concurrent users.
Tips on how to scale this database to handle such a load would be very helpful.
The H/W is pretty good - 2 gigs of RAM and a dual CPU.
Tx.
Vinod.
_____________________________________________________
Chat with your friends as soon as they come online. Get Rediff Bol at
http://bol.rediff.com
---------------------------------------------------------------------
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
