Can"t open file error number 24

------=_NextPart_000_0106_01CA92CC.4B834C00
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: 7bit

Hi,

We have been using MYSQL in our dedicated server for long time without
problem, Suddenly we noticed an error stating " Can't open file error
number 24".

When we rebooted the machine , MYSQL started working again fine. We have to
fix this problem not to happen again,

We have


Opened tables: 18,500

maximum connection :160
table_catche : 320

When I checked for open_files_limit in mysql administrator , it seems to be
disabled...Do I need to enable that and set the value? or Will it take
default value 0 and use max connetion* 5 or max connection+table_cache*2 ?

Please advise us,

Regards
Sathish

_____

I am using the Free version of SPAMfighter
..
We are a community of 6 million users fighting spam.
SPAMfighter has removed 757 of my spam emails to date.
The Professional version does not have this message.


------=_NextPart_000_0106_01CA92CC.4B834C00--

RE: Can"t open file error number 24

> problem, Suddenly we noticed an error stating " Can't open file error
> number 24".

If I recall correctly, error 24 means the disk partition is full.

Neil

--
Neil Aggarwal, (281)846-8957, http://UnmeteredVPS.net
MySQL pre-installed on a virtual private server for $25/mo
Unmetered bandwidth = no overage charges, 7 day free trial


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org

Re: Can"t open file error number 24

In the last episode (Jan 11), Sathish said:
> We have been using MYSQL in our dedicated server for long time without
> problem, Suddenly we noticed an error stating " Can't open file error
> number 24".
>
> When we rebooted the machine , MYSQL started working again fine. We have
> to fix this problem not to happen again,
>
> We have
>
> Opened tables: 18,500
>
> maximum connection :160
> table_catche : 320
>
> When I checked for open_files_limit in mysql administrator , it seems to
> be disabled...Do I need to enable that and set the value? or Will it take
> default value 0 and use max connetion* 5 or max connection+table_cache*2 ?

If open_files_limit is currently 0, then your OS won't let you change the
value, and you will have to lower the table_open_cache variable to stay
under whatever the OS limit is. Since Windows is the only OS where
open_files_limit is 0, you might want to try upgrading to MySQL 5.5 which
uses a different method of opening files (5.4 and older could only open 2048
files at once on Windows).

More reading:

http://dev.mysql.com/doc/refman/5.1/en/not-enough-file-handl es.html
http://dev.mysql.com/doc/refman/5.1/en/server-system-variabl es.html#sysvar_open_files_limit
http://dev.mysql.com/doc/refman/5.1/en/server-system-variabl es.html#sysvar_table_open_cache
http://dev.mysql.com/doc/refman/5.1/en/table-cache.html
http://bugs.mysql.com/bug.php?id=17646
http://bugs.mysql.com/bug.php?id=24509

--
Dan Nelson
dnelson@allantgroup.com

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org