List:General Discussion« Previous MessageNext Message »
From:misiaq Date:April 27 2011 12:02pm
Subject:RE: Error in accept: Too many open files
View as plain text  
Hi,

It's quite simple and quick change in *nix. But would recommend to check your server
performance first (processlist, tmp tables, slow query log etc).

Regards,
m

"Jerry Schwartz" <jerry@stripped> pisze:
> 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
> 
> 
> 
> 
> 
> -- 
> 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