List:General Discussion« Previous MessageNext Message »
From:Brent Clark Date:April 26 2011 7:44am
Subject:Error in accept: Too many open files
View as plain text  
Hiya

I recently imported data on a new server (5.1). But before the importing 
I added the feature 'innodb_file_per_table'.

I now want to enable Master - Master replication, but the problem is, im 
seeing the following

----------------------------------------------------------------------------------------------------------------------------------------------------------------------
Apr 24 23:32:50 maj-web01 mysqld: 110424 23:32:50 [ERROR] Error in 
accept: Too many open files
Apr 24 23:35:03 maj-web01 mysqld: 110424 23:35:03 [ERROR] 
/usr/sbin/mysqld: Can't open file: './maj_fs2/sites.frm' (errno: 24)
----------------------------------------------------------------------------------------------------------------------------------------------------------------------

Ive been going through High Performance MySQL, and a key area the book 
address is the config option 'innodb_open_files'.

If I do a file count for *.ibd files, I only have 147 files, and I see 
the limit is 300

mysql> show global variables like 'innodb_open_files'\G;
*************************** 1. row ***************************
Variable_name: innodb_open_files
         Value: 300
1 row in set (0.00 sec)

Could the other option to look at be 'open_files_limit'?

The database is a mixture of innodb and Myiasm.

I really need to get replication working, if someone could help my 
understand this issue, it would be appreciated.

Regards
Brent Clark

Thread
Error in accept: Too many open filesBrent Clark26 Apr
  • Re: Error in accept: Too many open filesJohan De Meersman26 Apr
  • RE: Error in accept: Too many open filesJerry Schwartz26 Apr
RE: Error in accept: Too many open filesmisiaq27 Apr