Re: Max NB of MyISAM tables / DB ( Ext3 & linux )

[Dan Nelson]

In the last episode (Sep 25), David Bordas said:
> I've just a little question for the end. I planned to have around 10K
> tables under a DB and this number surelly grow up to 20K. I know that
> a database is a directory and a table is 3 files. I just want to know
> is mysql have a limit in the number of table per database.
> 
> If not, i know that ext3 can have ten of thousands files in a
> directory. But commande like 'ls' will become slower and slower ...
> Is this also slowing mysql ?

"show tables" will be slow, for the same reason ls is slow: it has to
fetch the names of all 20k files.  Direct access via mysql should be
fine.

-- 
	Dan Nelson
	dnelson@stripped