Since my previous post has been archived to may posts I will post again. Would mysql server be able to handle about 2000 databases per server. disregard space issues since thats not the case what im trying to see are the capabitilities of the mysql server for a future project. In average my dbs take about 300 queries/sec where about 85% of them are selects , 12% updates and about 1% are inserts all other queries are either select db or others. machines it would be running un are Dual p4 with 2 gigs of ram and and plenty HD space. So my questions are. can i have one instance of mysql running 2000 dbs with about 25 tables in each of them? or could i have one massive DB server with replication to several other machines with 100000 dbs with 25 tables each and would mysql be able to handle that. some dbs may be bigger than others but they all have same structure only different data.

Jose E. Avila


-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]



Reply via email to