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. I'm getting an error from innodb that it is running out of file descriptors. I did not get this when using MyISAM tables. Does the innodb not use the table cache when innodb_file_per_table is set? Where is this documented? thanks, Jo