From: Dan Nelson
Date: September 25 2002 5:15pm
Subject: Re: Max NB of MyISAM tables / DB ( Ext3 & linux )
List-Archive: http://lists.mysql.com/mysql/120603
Message-Id: <20020925171557.GF16302@dan.emsphone.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii

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