Re: Open_files drops fast. Why?

2003-04-04 Thread Mike South
>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 (f

Re: Open_files drops fast. Why?

2003-04-04 Thread Mike South
>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

Open_files drops fast. Why?

2003-04-02 Thread Mike South
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? mike -- MySQL General Mailing List For list archi

need help determining cause of lockup

2003-03-21 Thread Mike South
. The show variables output is at http://www.fulcrum.org/gsg/with_sar/db01p/testdata/3.20.21.34/show_variables mike south - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/