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: je...@gii.co.jp Web site: www.the-infoshop.com >-----Original Message----- >From: Brent Clark [mailto:brentgclarkl...@gmail.com] >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=je...@gii.co.jp -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org
