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" <je...@gii.co.jp> 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: 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=mis...@poczta.fm > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org
