List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:April 2 2003 10:09pm
Subject:Re: Open_files drops fast. Why?
View as plain text  
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

Or do you mean Opened_files?  That can be reset with FLUSH STATUS.

>mike


-- 
Paul DuBois
http://www.kitebird.com/
sql, query
Thread
Open_files drops fast. Why?Mike South2 Apr
  • Re: Open_files drops fast. Why?Paul DuBois3 Apr
  • Re: Open_files drops fast. Why?Dan Nelson3 Apr
Re: Open_files drops fast. Why?Mike South4 Apr
  • Pre parsingJerry4 Apr
    • RE: Pre parsingNick Arnett4 Apr
    • RE: Pre parsingMichael Shulman4 Apr
Re: Open_files drops fast. Why?Mike South4 Apr