>From [EMAIL PROTECTED] Wed Apr 2 17:09:15 2003 > >At 16:53 -0500 4/2/03, Mike South wrote: >>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? > >FLUSH TABLES
Does mysql issue that itself? I am (reasonably) sure that no FLUSH TABLES was explicitly issued in this case. > >Or do you mean Opened_files? That can be reset with FLUSH STATUS. No, I mean Open_files, although shortly after the one-time-drop in Open_files that Im am referring to, Opened_files starts climbing more rapidly. And Open_files does not go back up: http://www.fulcrum.org/gsg/with_sar/db01p/testdata/3.20.21.34/graphs/combined/open_files_tables.png I am wondering if the fact that these files are being closed shows that mysql is running out of some resource, causing it to dump some file descriptors that it is not using at the moment. (This happens shortly before things lock up completely, so I'm wondering if I can fix what is causing this, and see if that might stop it from gettting locked up. Or even if I just understood what it was doing then and why would be nice.) mike -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
