msg Mittwoch, 25. September 2002 21:07 by Pete Harlan:
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 ?
I believe it would have to. There is a patch somewhere (I don't know
if
On Wed, Sep 25, 2002 at 08:49:43PM +0300, Iikka Meril?inen wrote:
Hello,
If the number of files is your concern, have you considered using InnoDB? It
spans tables across any number of data files you want. The performance is
great, too.
The .frm files are still there, though, one per file.
On Thu, Sep 26, 2002 at 11:52:52AM -0500, Pete Harlan wrote:
On Wed, Sep 25, 2002 at 08:49:43PM +0300, Iikka Meril?inen wrote:
Hello,
If the number of files is your concern, have you considered using InnoDB? It
spans tables across any number of data files you want. The performance is
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
Hello,
If the number of files is your concern, have you considered using InnoDB? It
spans tables across any number of data files you want. The performance is
great, too.
Best regards,
Iikka
On Wed, 25 Sep 2002, David Bordas wrote:
Hi list,
I've just a little question for the end.
I
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 ?
I believe it would have to. There is a patch somewhere (I don't know
if it's maintained) for adding indexed directories to ext2/ext3
Hi list,
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