Thanks a lot! ----- Original Message ----- From: "paul rivers" <[EMAIL PROTECTED]> To: "'古雷'" <[EMAIL PROTECTED]>; <mysql@lists.mysql.com> Sent: Monday, July 10, 2006 11:41 AM Subject: RE: May I create more than 200 databases for one mysqld?
> 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 >