This is all dependent on your OS's unlimit sizes, FS INODE limit, and mySQL table type. Generally is about 64K for databases and tables if you use myISAM / LINUX / EXT3
-- DVP > -----Original Message----- > From: Mark.he [mailto:[EMAIL PROTECTED] > Sent: Wednesday, March 31, 2004 9:42 PM > To: [EMAIL PROTECTED] > Subject: Qustions about MySQL capability > > Hi All, > > I have some questions about MySQL capability. > > 1. What's the max number of databases can be created in one MySQL server? > 2. What's the max number of tables can be created in one database? > 3. What's the best number of databases in one MySQL server? > 4. What's the best number of tables in one database? > > All questions are based on RedHat 8 OS. > If you are not sure of your answers, could you please tell me where I can > get the answers? > > Thanks a lot for your concern. > > Mark.Ho -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]