2005/9/1, Chris Cutler <[EMAIL PROTECTED]>: > Hello, > > My apologies for repeating a question asked earlier[1] but the > question and the answer were a little vague: > > Does the number of tables in a database affect MySQL's performance? > Specifically, if I have a database with 1,000 tables in it, will it > be slower than usual due to the number of tables? What about a > database with 10,000 or 100,000 tables? > > As one section of the MySQL manual points out[2]: "If you have many > MyISAM or ISAM tables in a database directory, open, close, and > create operations are slow".
they are slow due to the underlying filesystems (AFAIK) > But what about INNODB? And are there > table engine-independent implementation details which might cause > performance problems for a database with many tables? il you only have one innoDB tablespace, it should not be a problem, but for the option to have one file per innodb table, that's the same conclusion. > > Thanks, > Chris > > [1] http://lists.mysql.com/mysql/174461 > [2] http://dev.mysql.com/doc/mysql/en/creating-many-tables.html > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > -- Pooly Webzine Rock : http://www.w-fenec.org/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]