* Jean-Pierre Georgin > I saw in the MySQL documentation that the myISAM tables maximal size was 8 > millions TB. But I couldn't find any information about the > maximum number of tables it can support. Can you give me this information ?
There is no limit in mysql, but there may be one in the OS you are using. Mysql tables are stored as files, and your file system may have a limit on how many files can exist in a single directory. If we call this number X...: - You can have X databases on a single server - You can have X tables in each database if you use InnoDB tables - You can have X/3 tables in each database if you use MyIsam tables So, the theoretic maximum number of tables on a single server is X * X if you use InnoDB and X * (X/3) if you use MyIsam. -- Roger --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
