List:General Discussion« Previous MessageNext Message »
From:Thomas Seifert Date:August 6 2002 5:08pm
Subject:InnoDB vs. MyISAM on large number of tables?
View as plain text  
Hi Folks,

maybe a stupid question but I've got a problem with the number of tables on my
MySQL-System.

I am running a boardhosting-service which uses a board-software that needs 2 tables for
each board and so the number of tables increases fast.

There are already more than 5000 tables in the database, all as MyISAM-tables.
The number of messages is around 1.000.000 already, if this gives any help.
The load on the db increases in high steps so I think that the number of tables may be the
bottleneck.

As the table-cache can't be set too high (fd on linux are not that many ;)) MySQL needs to
open and close tables in a really fast manner but there
is still this large number of files in the filesystem.

Would a switch to InnoDB solve this problem with the large-number of tables as innodb has
all its tables in a large tablespace?
Or how does InnoDB simply handle the open and close of tables?

Yeah I've read the features and manuals at innodb.com but afaik these questions were not
answered there.


Thanks in advance for any answers or hints about this problem.


Thomas
Thread
InnoDB vs. MyISAM on large number of tables?Thomas Seifert6 Aug
  • Re: InnoDB vs. MyISAM on large number of tables?Jeremy Zawodny7 Aug
  • Re: InnoDB vs. MyISAM on large number of tables?Thomas Spahni7 Aug
    • Re: InnoDB vs. MyISAM on large number of tables?Thomas Seifert7 Aug
      • Re: InnoDB vs. MyISAM on large number of tables?Jeremy Zawodny8 Aug
        • How stable is v4? (was: Re: InnoDB vs. MyISAM on large number of tables?)Thomas Seifert9 Aug
          • Re: How stable is v4? (was: Re: InnoDB vs. MyISAM on large number of tables?)Jeremy Zawodny9 Aug
          • Re: How stable is v4? (was: Re: InnoDB vs. MyISAM on large numberof tables?)Thomas Spahni10 Aug