>From [EMAIL PROTECTED] Wed Apr 2 17:12:36 2003 > >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.
I am reasonably sure that Open_files does not reflect how many threads are accessing each table. Just from observation, I see that Open_files remains pretty constant (except for the drop I mentioned above, after which it remains constant, just at a lower level), even though the number of threads connected/running jumps up and down. I assume that the server is keeping references to the files open and handing them off to threads as needed, or something along those lines. mike -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]