Each Schema is a Subfolder under the datadir of the MySQL Instance However many folders an operating system permits is how many schemas can be created
----- Original Message ----- From: Dominik Klein <[EMAIL PROTECTED]> To: mysql@lists.mysql.com Sent: Wednesday, October 18, 2006 10:05:17 AM GMT-0500 US/Eastern Subject: Re: How many databases does MySQL 5 support? John M.Brown schrieb: > Thanks for the info, but my question is how many databases, not so much how > many rows per table or how big the database can be... I mean, how many > "create database ABC<insert # here>" can I do before MySQL says "sorry, you > can't have more than X databases". > > Say I create 1000 empty MySQL databases (meaning no tables, just the > schema)... would that work? what about 5000? ... make sense? I just test-created 10.000 dbs on a cheap celeron 2400 ide hdd testserver with 256 megs of ram and it was no problem at all. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]