logo       

Re: Increasing number of open_files -- no takers on this one?: msg#01110

db.mysql.general

Subject: Re: Increasing number of open_files -- no takers on this one?

In the last episode (Jun 28), Sam Taylor said:
> Greetings All --
>
> I sent this message to the list a couple of days ago... didn't
> receive any comments/feedback/suggestions...
>
> if no one knows the answer, can anyone throw me a lifeline and give
> me a suggestion as to how I can go about diagnosing the situation, or
> at least share some of your own experiences (is what I'm seeing
> normal for MySQL??)

open_files is simply the number of filehandles mysql has open. It'll
grow until it hits open_files_limit.

For more info, see http://www.mysql.com/doc/T/a/Table_cache.html

--
Dan Nelson
dnelson@xxxxxxxxxxxxxxx

---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)

To request this thread, e-mail <mysql-thread113359@xxxxxxxxxxxxxxx>
To unsubscribe, e-mail
<mysql-unsubscribe-gcdmg-mysql=m.gmane.org@xxxxxxxxxxxxxxx>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




<Prev in Thread] Current Thread [Next in Thread>
Google Custom Search

News | FAQ | advertise