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