List:General Discussion« Previous MessageNext Message »
From:Jerry Schwartz Date:April 26 2011 1:51pm
Subject:RE: Error in accept: Too many open files
View as plain text  
You are seeing *NIX error messages. You need to increase the operating system 
settings that control the number of files that a process can open.

I'm very rusty, and never really used Linux, so I can't tell you the exact 
parameters. There are probably two: total number of open files, and files per 
process.

Regards,

Jerry Schwartz
Global Information Incorporated
195 Farmington Ave.
Farmington, CT 06032

860.674.8796 / FAX: 860.674.8341
E-mail: jerry@stripped
Web site: www.the-infoshop.com

>-----Original Message-----
>From: Brent Clark [mailto:brentgclarklist@stripped]
>Sent: Tuesday, April 26, 2011 3:44 AM
>To: mysql mailing list
>Subject: Error in accept: Too many open files
>
>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
>
>
>--
>MySQL General Mailing List
>For list archives: http://lists.mysql.com/mysql
>To unsubscribe:    http://lists.mysql.com/mysql?unsub=1




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