Hi,
IM>I'm not either sure if they're used during normal operation, but that way
you
IM>could get a file number like (x / 3) + [a few files] where x is the
number of
IM>files with MyISAM. Also, InnoDB should support .frm:less tables someday
in
IM>2003 (at least www.innodb.com says so). But if you
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 performan
Hi,
I'm not either sure if they're used during normal operation, but that way you
could get a file number like (x / 3) + [a few files] where x is the number of
files with MyISAM. Also, InnoDB should support .frm:less tables someday in
2003 (at least www.innodb.com says so). But if you bump into p
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 fi
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 kno
> 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/ext
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 pla
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 nu
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 tha
