MySQL Forums
Forum List  »  Router & Proxy

Re: RW-splitting partitionning, ERROR 24
Posted by: nabil babaci
Date: February 08, 2010 02:06AM

i fixed the problem of perror 24, by controlling the " ulimit ".
By default ulimit -n, which is the variable for "open file " in Linux ,is set to 1024. The trick is to configure it in the "limits.conf" file like this:
At the end of file:

* soft nofile 1000001
* hard nofile 1000001

then restart.
Then you need to configure the "my.cnf" by setting the "open_files_limit= #".
the restart.

it's is important to monitor it with mysqltuner, the open files limit, because when it is reached, you've got the perror24. For avoiding this error you can run the command ' mysqladmin flush-table' which reset the variable to zero by a cron job.

Options: ReplyQuote


Subject
Views
Written By
Posted
3921
February 01, 2010 09:35AM
Re: RW-splitting partitionning, ERROR 24
2187
February 08, 2010 02:06AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.