Rafal, the table cache size limit parameter in my.cnf affects also InnoDB. MySQL is not aware that InnoDB does not open any files when InnoDB creates a handle to a new table.
Hmm... I doubt that "opening tables" really takes much time. You can try empirically if the table cache size 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 2002 13:44:14 +0100 ---------------------------------------------------------------------------- ---- 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, query --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
