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=arch...@jab.org
