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=gcdmg-mysql-2@m.gmane.org

Re: Error in accept: Too many open files

300 is pretty low - MySQL counts every instance of a table in any query as an "open file". A query that uses the same table twice (with an alias, for example) thus counts for two open files.

This may also be outside of MySQL, the ulimit for the user running the daemon may have open files restrictions, too.


----- Original Message -----
> From: "Brent Clark"
> To: "mysql mailing list"
> Sent: Tuesday, 26 April, 2011 9:44:16 AM
> 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
>

--
Bier met grenadyn
Is als mosterd by den wyn
Sy die't drinkt, is eene kwezel
Hy die't drinkt, is ras een ezel

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org

RE: Error in accept: Too many open files

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@gii.co.jp
Web site: www.the-infoshop.com

>-----Original Message-----
>From: Brent Clark [mailto:brentgclarklist@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=jerry@gii.co.jp





--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org

RE: Error in accept: Too many open files

Hi,

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

Regards,
m

"Jerry Schwartz" pisze:
> You are seeing *NIX error messages. You need to increase the operating sy=
stem=20
> settings that control the number of files that a process can open.
>=20
> I'm very rusty, and never really used Linux, so I can't tell you the exac=
t=20
> parameters. There are probably two: total number of open files, and files=
per=20
> process.
>=20
> Regards,
>=20
> Jerry Schwartz
> Global Information Incorporated
> 195 Farmington Ave.
> Farmington, CT 06032
>=20
> 860.674.8796 / FAX: 860.674.8341
> E-mail: jerry@gii.co.jp
> Web site: www.the-infoshop.com
>=20
> >-----Original Message-----
> >From: Brent Clark [mailto:brentgclarklist@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=3Djerry@gii.co.jp
>=20
>=20
>=20
>=20
>=20
> --=20
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/mysql?unsub=3Dmisiaq@poczta.fm
>=20
>=20


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=3Dgcdmg-mysql-2@m.gmane.o rg