MySQL Forums
Forum List  »  Performance

Re: Number of tables in a DB
Posted by: James Day
Date: March 27, 2005 09:30PM

The limit is "big". For MyISAM, you might think about table opening and closing overhead, since the 3 files for each table are stored in one directory. Easy to end up with lots of file opening overhead on some operating systems and/or file systems.

Why do you want lots of tables?

Are you thinking of more than 100,000 per database? More than 10,000? If only 100 or 1,000 then don't even think of worrying about it, except with Windows FAT partitions. Even there, setting the table cache value large enough will make it insignificant.

Options: ReplyQuote

Written By
March 23, 2005 04:30AM
Re: Number of tables in a DB
March 27, 2005 09:30PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.