Yes, you can. Whether there are disadvantages depends mainly on how you are using mysql.
When there are many databases (an order of magnitude or more than what you propose), some people report that "show databases" can be slow. Otherwise, the disadvantages are mainly administrative. For example, do you find permissions and accounts too messy for that many databases? When you are trying to troubleshoot activity in one database by examining the client log, is it too noisy due to the other databases? Do you find it too burdensome to upgrade that many databases from one version to the next? Since mysql is threaded, sometimes it makes sense to run multiple mysqld processes on the same machine. But again, this is more an administrative decision than a technical one. 200+ databases is certainly well within practical mysqld limits. Regards, Paul -----Original Message----- From: 古雷 [mailto:[EMAIL PROTECTED] Sent: Sunday, July 09, 2006 8:27 PM To: mysql@lists.mysql.com Subject: May I create more than 200 databases for one mysqld? May I create more than 200 databases for one mysqld? And is there any disadvantage when there're many databases on one mysqld? Thanks. Regards, Gu Lei -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
