* Victoria Reznichenko > MG = Meruzhan Grigoryan > MG> I have one question apropos of Mysql database version 3.23. > MG> What greatest quantity of tables may store Mysql a database. > > The number of tables in database is limited by the number of files > your operation system allows in a single directory.
...divided by three, if you use MyIsam tables. (each table use three files.) If you use InnoDB tables there is no specific limit, except the maximum tablespace is 4 billion pages, each page beeing 8k-64k, default 16k. -- Roger query --------------------------------------------------------------------- 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
