Jonathan,
http://dev.mysql.com/doc/refman/5.0/en/innodb-start.html
"
innodb_open_files
This option is relevant only if you use multiple tablespaces in InnoDB. It
specifies the maximum number of .ibd files that InnoDB can keep open at one
time. The minimum value is 10. The default is 300.
The file descriptors used for .ibd files are for InnoDB only. They are
independent of those specified by the --open-files-limit server option, and
do not affect the operation of the table cache.
"
That parameter is completely independent of the MySQL table cache.
Regards,
Heikki
Innobase/Oracle
----- Original Message -----
From: ""Jonathan Stockley"" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.myodbc
Sent: Thursday, October 13, 2005 10:49 PM
Subject: Innodb open files issue
------_=_NextPart_001_01C5D02F.2BE09467
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
Hi,
I have mysql 4.1.14 on solaris 9 and have just switched to using the
innodb_file_per_table option. Previously I was using MyISAM tables and
created about 700 tables.
The rlim_fd_cur and rlim_fd_max kernel paramteres are set to 256.
=20
I'm getting an error from innodb that it is running out of file
descriptors. I did not get this when using MyISAM tables.
=20
Does the innodb not use the table cache when innodb_file_per_table is
set? Where is this documented?
=20
thanks,
Jo
------_=_NextPart_001_01C5D02F.2BE09467--
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
