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]