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