> But what about INNODB? And are there > table engine-independent implementation details which might cause > performance problems for a database with many tables?
This thread got me wondering how many file-handles are open for INNODB tables since it is only one large file on the file system. A quick look at our production server that is running approximately 50 tables within an INNODB instance, I see the number of open file handles is significantly less than 50. Which is what i would have expected. Looking at the other table formats, I do see a file handle open for every single table (more than one file handle since there is multiple files that describe a table under MyISAM). BTW on Linux systems you can check this using: % lsof -- Alan Williamson, Technology Evangelist SpikeSource Inc. Daily OS News @ http://compiledby.spikesource.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]