In the last episode (Apr 02), Mike South said: > In load testing I noticed that, even though all the queries in the > tests are for the exact same tables, at some point in the test > the Open_files variable (from SHOW STATUS) drops very quickly. Does > anyone have any idea what would cause that?
Each thread opens its own filedescriptors for the tables it uses. 10 threads accessing 4 tables uses (10 threads * (4 table files + 4 index files)) = 80 fds; 100 threads uses 800. -- Dan Nelson [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]