Re: innodb and table_cache

2002-11-20 Thread Heikki Tuuri
ze has any effect. Best regards, Heikki Tuuri Innobase Oy --- InnoDB - transactions, row level locking, and foreign key support for MySQL See http://www.innodb.com, download MySQL-Max from http://www.mysql.com .. Subject: innodb and table_cache From: Rafal Jank Date: Fri, 15 Nov 200

innodb and table_cache

2002-11-15 Thread Rafal Jank
Is table_cache parameter still important when using innodb table types? I thought it's not, because there is no separate files for each table in InnoDB But now I see a lot of queries in "opening tables" and "closing tables" state. Does increasing table_cache parameter may help? Rafal P.S. sql, q