MySQL Locking up - To Many Open Files?

Kyle Moore

Registered
Oct 11, 2011
2
1
53
Worcester, Worcestershire, United Kingdom
cPanel Access Level
Root Administrator
Hi guys and girls,

I'm getting really annoyed at this issue now and I've never experienced a problem like this before so I'm a little confused. I've been in touch with support and they narrowed the issue down to "To many open files" error code 24.

I've pasted some logs below of what I can dig out of MySQL Logs. I've increased max files open on the server to 900,000 and the softlimit of for open files on MySQL is 24000 (was 4000) and hardlimit is 32000 (was 4000).

Any ideas? :(

Thank you!

120428 12:56:02 mysqld_safe mysqld from pid file /var/lib/mysql/neon.budgetserver.co.uk.pid ended
120428 12:56:44 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
120428 12:56:44 [Note] Plugin 'FEDERATED' is disabled.
120428 12:56:44 InnoDB: The InnoDB memory heap is disabled
120428 12:56:44 InnoDB: Mutexes and rw_locks use GCC atomic builtins
120428 12:56:44 InnoDB: Compressed tables use zlib 1.2.3
120428 12:56:44 InnoDB: Using Linux native AIO
120428 12:56:45 InnoDB: Initializing buffer pool, size = 128.0M
120428 12:56:45 InnoDB: Completed initialization of buffer pool
120428 12:56:45 InnoDB: highest supported file format is Barracuda.
120428 12:56:45 InnoDB: Waiting for the background threads to start
120428 12:56:46 InnoDB: 1.1.8 started; log sequence number 45241749
120428 12:56:46 [Note] Event Scheduler: Loaded 0 events
120428 12:56:46 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.5.22-cll' socket: '/var/lib/mysql/mysql.sock' port: 3306 MySQL Community Server (GPL)
120428 14:08:26 [Warning] IP address '112.65.229.191' could not be resolved: Temporary failure in name resolution
120428 14:08:26 [Warning] IP address '112.65.229.191' could not be resolved: Temporary failure in name resolution
120428 14:08:26 [Warning] IP address '112.65.229.191' could not be resolved: Temporary failure in name resolution
120428 20:30:01 [ERROR] /usr/sbin/mysqld: Can't open file: './djlabo_open/cart_layout.frm' (errno: 24)
120428 20:30:01 [ERROR] /usr/sbin/mysqld: Can't open file: './djlabo_open/cart_layout_route.frm' (errno: 24)
120428 20:30:01 [ERROR] /usr/sbin/mysqld: Can't open file: './djlabo_open/cart_length_class.frm' (errno: 24)
120428 20:30:01 [ERROR] /usr/sbin/mysqld: Can't open file: './djlabo_open/cart_length_class_description.frm' (errno: 24)
 

Kyle Moore

Registered
Oct 11, 2011
2
1
53
Worcester, Worcestershire, United Kingdom
cPanel Access Level
Root Administrator
  • Like
Reactions: StevenM.