mysqldump | mysql too many open files
Ive noticed recently that when i do my nightly mysqldump, im getting lots of problems. Namely that a lot of services stop responding. Most of my services do rely on mysql, so im thinking its mysql related at the moment, but im willing to consider other things..
Looking through the logs arround that time i have this
May 27 08:19:44 broken mysqld[4109]: 090527 8:19:44 [ERROR] Error in accept: Too many open files
May 28 08:10:04 broken mysqld[4109]: 090528 8:10:02 [ERROR] Error in accept: Too many open files
May 28 08:10:18 broken mysqld[4109]: 090528 8:10:18 [ERROR] /usr/sbin/mysqld: Can't open file: './xanarchynet/phpbb3_sessions.frm' (errno: 24)
May 28 08:10:18 broken mysqld[4109]: 090528 8:10:18 [ERROR] /usr/sbin/mysqld: Can't open file: './xanarchynet/phpbb3_sessions.frm' (errno: 24)
May 28 08:10:20 broken mysqld[4109]: 090528 8:10:20 [ERROR] /usr/sbin/mysqld: Can't open file: './xanarchynet/phpbb3_config.frm' (errno: 24)
May 28 08:10:20 broken mysqld[4109]: 090528 8:10:20 [ERROR] /usr/sbin/mysqld: Can't open file: './xanarchynet/phpbb3_sessions.frm' (errno: 24)
May 28 08:10:21 broken mysqld[4109]: 090528 8:10:21 [ERROR] /usr/sbin/mysqld: Can't open file: './xanarchynet/phpbb3_sessions.frm' (errno: 24)
May 28 08:10:21 broken mysqld[4109]: 090528 8:10:21 [ERROR] /usr/sbin/mysqld: Can't open file: './xanarchynet/phpbb3_sessions.frm' (errno: 24)
May 28 08:10:22 broken mysqld[4109]: 090528 8:10:22 [ERROR] /usr/sbin/mysqld: Can't open file: './xanarchynet/phpbb3_sessions.frm' (errno: 24)
May 28 08:10:22 broken mysqld[4109]: 090528 8:10:22 [ERROR] /usr/sbin/mysqld: Can't open file: './xanarchynet/phpbb3_sessions.frm' (errno: 24)
May 28 08:10:23 broken mysqld[4109]: 090528 8:10:23 [ERROR] /usr/sbin/mysqld: Can't open file: './xanarchynet/phpbb3_sessions.frm' (errno: 24)
May 28 08:10:23 broken mysqld[4109]: 090528 8:10:23 [ERROR] /usr/sbin/mysqld: Can't open file: './xanarchynet/phpbb3_sessions.frm' (errno: 24)
May 28 08:10:24 broken mysqld[4109]: 090528 8:10:24 [ERROR] /usr/sbin/mysqld: Can't open file: './xanarchynet/phpbb3_sessions.frm' (errno: 24)
May 28 08:10:24 broken mysqld[4109]: 090528 8:10:24 [ERROR] /usr/sbin/mysqld: Can't open file: './xanarchynet/phpbb3_sessions.frm' (errno: 24)
May 28 08:10:25 broken mysqld[4109]: 090528 8:10:25 [ERROR] /usr/sbin/mysqld: Can't open file: './xanarchynet/phpbb3_sessions.frm' (errno: 24)
May 28 08:10:25 broken mysqld[4109]: 090528 8:10:25 [ERROR] /usr/sbin/mysqld: Can't open file: './xanarchynet/phpbb3_sessions.frm' (errno: 24)
May 28 08:10:26 broken mysqld[4109]: 090528 8:10:26 [ERROR] /usr/sbin/mysqld: Can't open file: './xanarchynet/phpbb3_sessions.frm' (errno: 24)
May 28 08:10:26 broken mysqld[4109]: 090528 8:10:26 [ERROR] /usr/sbin/mysqld: Can't open file: './xanarchynet/phpbb3_sessions.frm' (errno: 24)
May 28 08:10:27 broken mysqld[4109]: 090528 8:10:27 [ERROR] /usr/sbin/mysqld: Can't open file: './xanarchynet/phpbb3_sessions.frm' (errno: 24)
May 28 08:10:27 broken mysqld[4109]: 090528 8:10:27 [ERROR] /usr/sbin/mysqld: Can't open file: './xanarchynet/phpbb3_sessions.frm' (errno: 24)
May 28 08:10:28 broken mysqld[4109]: 090528 8:10:28 [ERROR] /usr/sbin/mysqld: Can't open file: './xanarchynet/phpbb3_sessions.frm' (errno: 24)
May 28 08:10:28 broken mysqld[4109]: 090528 8:10:28 [ERROR] /usr/sbin/mysqld: Can't open file: './xanarchynet/phpbb3_sessions.frm' (errno: 24)
May 28 08:10:29 broken mysqld[4109]: 090528 8:10:29 [ERROR] /usr/sbin/mysqld: Can't open file: './xanarchynet/phpbb3_sessions.frm' (errno: 24)
May 28 08:10:29 broken mysqld[4109]: 090528 8:10:29 [ERROR] /usr/sbin/mysqld: Can't open file: './xanarchynet/phpbb3_sessions.frm' (errno: 24)
May 28 08:10:30 broken mysqld[4109]: 090528 8:10:30 [ERROR] /usr/sbin/mysqld: Can't open file: './xanarchynet/phpbb3_sessions.frm' (errno: 24)
May 28 08:10:30 broken mysqld[4109]: 090528 8:10:30 [ERROR] /usr/sbin/mysqld: Can't open file: './xanarchynet/phpbb3_sessions.frm' (errno: 24)
May 28 08:10:31 broken mysqld[4109]: 090528 8:10:31 [ERROR] /usr/sbin/mysqld: Can't open file: './xanarchynet/phpbb3_sessions.frm' (errno: 24)
May 28 08:10:31 broken mysqld[4109]: 090528 8:10:31 [ERROR] /usr/sbin/mysqld: Can't open file: './xanarchynet/phpbb3_sessions.frm' (errno: 24)
May 28 08:10:37 broken mysqld[4109]: 090528 8:10:37 [ERROR] /usr/sbin/mysqld: Can't open file: './xanarchynet/phpbb3_sessions.frm' (errno: 24)
May 28 08:10:37 broken mysqld[4109]: 090528 8:10:37 [ERROR] /usr/sbin/mysqld: Can't open file: './xanarchynet/phpbb3_sessions.frm' (errno: 24)
May 28 08:10:41 broken mysqld[4109]: 090528 8:10:41 [ERROR] /usr/sbin/mysqld: Can't open file: './xanarchynet/phpbb3_sessions.frm' (errno: 24)
May 28 08:10:41 broken mysqld[4109]: 090528 8:10:41 [ERROR] /usr/sbin/mysqld: Can't open file: './xanarchynet/phpbb3_sessions.frm' (errno: 24)
May 28 08:10:43 broken mysqld[4109]: 090528 8:10:43 [ERROR] /usr/sbin/mysqld: Can't open file: './xanarchynet/phpbb3_sessions.frm' (errno: 24)
May 28 08:10:43 broken mysqld[4109]: 090528 8:10:43 [ERROR] /usr/sbin/mysqld: Can't open file: './xanarchynet/phpbb3_sessions.frm' (errno: 24)
May 28 08:11:09 broken mysqld[4109]: 090528 8:11:09 [ERROR] /usr/sbin/mysqld: Can't open file: './xanarchynet/phpbb3_config.frm' (errno: 24)
May 28 08:11:09 broken mysqld[4109]: 090528 8:11:09 [ERROR] /usr/sbin/mysqld: Can't open file: './xanarchynet/phpbb3_sessions.frm' (errno: 24)
May 28 08:11:27 broken mysqld[4109]: 090528 8:11:27 [ERROR] /usr/sbin/mysqld: Can't open file: './xanarchynet/phpbb3_users.frm' (errno: 24)
May 28 08:11:39 broken mysqld[4109]: 090528 8:11:39 [ERROR] /usr/sbin/mysqld: Can't open file: './xanarchynet/phpbb3_config.frm' (errno: 24)
May 28 08:11:39 broken mysqld[4109]: 090528 8:11:39 [ERROR] /usr/sbin/mysqld: Can't open file: './xanarchynet/phpbb3_sessions.frm' (errno: 24)
May 28 08:11:41 broken mysqld[4109]: 090528 8:11:41 [ERROR] /usr/sbin/mysqld: Can't open file: './xanarchynet/phpbb3_config.frm' (errno: 24)
May 28 08:11:41 broken mysqld[4109]: 090528 8:11:41 [ERROR] /usr/sbin/mysqld: Can't open file: './xanarchynet/phpbb3_sessions.frm' (errno: 24)
May 28 08:11:56 broken mysqld[4109]: 090528 8:11:56 [ERROR] /usr/sbin/mysqld: Can't open file: './xanarchynet/phpbb3_users.frm' (errno: 24)
May 28 08:11:56 broken mysqld[4109]: 090528 8:11:56 [ERROR] /usr/sbin/mysqld: Can't open file: './xanarchynet/phpbb3_users.frm' (errno: 24)
May 28 08:12:33 broken mysqld[4109]: 090528 8:12:33 [ERROR] /usr/sbin/mysqld: Can't open file: './xanarchynet/phpbb3_config.frm' (errno: 24)
May 28 08:12:33 broken mysqld[4109]: 090528 8:12:33 [ERROR] /usr/sbin/mysqld: Can't open file: './xanarchynet/phpbb3_sessions.frm' (errno: 24)
May 28 08:12:43 broken mysqld[4109]: 090528 8:12:43 [ERROR] /usr/sbin/mysqld: Can't open file: './xanarchynet/phpbb3_config.frm' (errno: 24)
May 28 08:12:43 broken mysqld[4109]: 090528 8:12:43 [ERROR] /usr/sbin/mysqld: Can't open file: './xanarchynet/phpbb3_sessions.frm' (errno: 24)
May 28 08:13:28 broken mysqld[4109]: 090528 8:13:28 [ERROR] /usr/sbin/mysqld: Can't open file: './xanarchynet/phpbb3_config.frm' (errno: 24)
May 28 08:13:28 broken mysqld[4109]: 090528 8:13:28 [ERROR] /usr/sbin/mysqld: Can't open file: './xanarchynet/phpbb3_sessions.frm' (errno: 24)
May 28 08:13:39 broken mysqld[4109]: 090528 8:13:39 [ERROR] /usr/sbin/mysqld: Can't open file: './xanarchynet/phpbb3_config.frm' (errno: 24)
May 28 08:13:39 broken mysqld[4109]: 090528 8:13:39 [ERROR] /usr/sbin/mysqld: Can't open file: './xanarchynet/phpbb3_sessions.frm' (errno: 24)
May 28 08:14:59 broken mysqld[4109]: 090528 8:14:59 [ERROR] /usr/sbin/mysqld: Can't open file: './xanarchynet/phpbb3_config.frm' (errno: 24)
May 28 08:14:59 broken mysqld[4109]: 090528 8:14:59 [ERROR] /usr/sbin/mysqld: Can't open file: './xanarchynet/phpbb3_sessions.frm' (errno: 24)
May 28 08:15:10 broken mysqld[4109]: 090528 8:15:10 [ERROR] /usr/sbin/mysqld: Can't open file: './xanarchynet/phpbb3_users.frm' (errno: 24)
May 28 08:17:49 broken mysqld[4109]: 090528 8:17:48 [ERROR] /usr/sbin/mysqld: Can't open file: './xanarchynet/phpbb3_users.frm' (errno: 24)
May 28 08:17:49 broken mysqld[4109]: 090528 8:17:48 [ERROR] /usr/sbin/mysqld: Can't open file: './xanarchynet/phpbb3_users.frm' (errno: 24)
May 28 08:17:49 broken mysqld[4109]: 090528 8:17:49 [ERROR] /usr/sbin/mysqld: Can't open file: './xanarchynet/phpbb3_config.frm' (errno: 24)
May 28 08:17:49 broken mysqld[4109]: 090528 8:17:49 [ERROR] /usr/sbin/mysqld: Can't open file: './xanarchynet/phpbb3_sessions.frm' (errno: 24)
May 28 08:17:49 broken mysqld[4109]: 090528 8:17:49 [ERROR] /usr/sbin/mysqld: Can't open file: './xanarchynet/phpbb3_config.frm' (errno: 24)
May 28 08:17:49 broken mysqld[4109]: 090528 8:17:49 [ERROR] /usr/sbin/mysqld: Can't open file: './xanarchynet/phpbb3_sessions.frm' (errno: 24)
May 28 08:17:50 broken mysqld[4109]: 090528 8:17:50 [ERROR] /usr/sbin/mysqld: Can't open file: './xanarchynet/phpbb3_config.frm' (errno: 24)
May 28 08:17:50 broken mysqld[4109]: 090528 8:17:50 [ERROR] /usr/sbin/mysqld: Can't open file: './xanarchynet/phpbb3_sessions.frm' (errno: 24)
May 28 08:17:59 broken mysqld[4109]: 090528 8:17:59 [ERROR] /usr/sbin/mysqld: Can't open file: './xanarchynet/phpbb3_config.frm' (errno: 24)
May 28 08:17:59 broken mysqld[4109]: 090528 8:17:59 [ERROR] /usr/sbin/mysqld: Can't open file: './xanarchynet/phpbb3_sessions.frm' (errno: 24)
May 28 08:18:00 broken mysqld[4109]: 090528 8:18:00 [ERROR] /usr/sbin/mysqld: Can't open file: './xanarchynet/phpbb3_sessions.frm' (errno: 24)
May 28 08:18:01 broken mysqld[4109]: 090528 8:18:01 [ERROR] /usr/sbin/mysqld: Can't open file: './xanarchynet/phpbb3_sessions.frm' (errno: 24)
May 28 08:18:01 broken mysqld[4109]: 090528 8:18:01 [ERROR] /usr/sbin/mysqld: Can't open file: './xanarchynet/phpbb3_sessions.frm' (errno: 24)
May 28 08:18:09 broken mysqld[4109]: 090528 8:18:09 [ERROR] /usr/sbin/mysqld: Can't open file: './xanarchynet/phpbb3_config.frm' (errno: 24)
May 28 08:18:09 broken mysqld[4109]: 090528 8:18:09 [ERROR] /usr/sbin/mysqld: Can't open file: './xanarchynet/phpbb3_sessions.frm' (errno: 24)
May 28 08:18:09 broken mysqld[4109]: 090528 8:18:09 [ERROR] /usr/sbin/mysqld: Can't open file: './xanarchynet/phpbb3_config.frm' (errno: 24)
May 28 08:18:09 broken mysqld[4109]: 090528 8:18:09 [ERROR] /usr/sbin/mysqld: Can't open file: './xanarchynet/phpbb3_sessions.frm' (errno: 24)
May 28 08:19:01 broken mysqld[4109]: 090528 8:19:01 [ERROR] /usr/sbin/mysqld: Can't open file: './xanarchynet/phpbb3_config.frm' (errno: 24)
May 28 08:19:01 broken mysqld[4109]: 090528 8:19:01 [ERROR] /usr/sbin/mysqld: Can't open file: './xanarchynet/phpbb3_sessions.frm' (errno: 24)
May 28 08:19:08 broken mysqld[4109]: 090528 8:19:08 [ERROR] /usr/sbin/mysqld: Can't open file: './xanarchynet/phpbb3_config.frm' (errno: 24)
May 28 08:19:08 broken mysqld[4109]: 090528 8:19:08 [ERROR] /usr/sbin/mysqld: Can't open file: './xanarchynet/phpbb3_sessions.frm' (errno: 24)
May 28 08:20:06 broken mysqld[4109]: 090528 8:20:06 [ERROR] /usr/sbin/mysqld: Can't open file: './xanarchynet/phpbb3_config.frm' (errno: 24)
May 28 08:20:06 broken mysqld[4109]: 090528 8:20:06 [ERROR] /usr/sbin/mysqld: Can't open file: './xanarchynet/phpbb3_sessions.frm' (errno: 24)
May 28 08:22:00 broken mysqld[4109]: 090528 8:22:00 [ERROR] /usr/sbin/mysqld: Can't open file: './xanarchynet/phpbb3_config.frm' (errno: 24)
May 28 08:22:00 broken mysqld[4109]: 090528 8:22:00 [ERROR] /usr/sbin/mysqld: Can't open file: './xanarchynet/phpbb3_sessions.frm' (errno: 24)
May 28 08:22:15 broken mysqld[4109]: 090528 8:22:15 [ERROR] /usr/sbin/mysqld: Can't open file: './xanarchynet/phpbb3_config.frm' (errno: 24)
May 28 08:22:15 broken mysqld[4109]: 090528 8:22:15 [ERROR] /usr/sbin/mysqld: Can't open file: './xanarchynet/phpbb3_sessions.frm' (errno: 24)
May 28 08:22:16 broken mysqld[4109]: 090528 8:22:16 [ERROR] /usr/sbin/mysqld: Can't open file: './xanarchynet/phpbb3_sessions.frm' (errno: 24)
May 28 08:22:17 broken mysqld[4109]: 090528 8:22:17 [ERROR] /usr/sbin/mysqld: Can't open file: './xanarchynet/phpbb3_sessions.frm' (errno: 24)
May 28 08:22:18 broken mysqld[4109]: 090528 8:22:18 [ERROR] /usr/sbin/mysqld: Can't open file: './xanarchynet/phpbb3_sessions.frm' (errno: 24)
May 28 08:22:18 broken mysqld[4109]: 090528 8:22:18 [ERROR] /usr/sbin/mysqld: Can't open file: './xanarchynet/phpbb3_sessions.frm' (errno: 24)
May 28 08:22:24 broken mysqld[4109]: 090528 8:22:24 [ERROR] /usr/sbin/mysqld: Can't open file: './xanarchynet/phpbb3_config.frm' (errno: 24)
May 28 08:22:24 broken mysqld[4109]: 090528 8:22:24 [ERROR] /usr/sbin/mysqld: Can't open file: './xanarchynet/phpbb3_sessions.frm' (errno: 24)
May 28 08:22:38 broken mysqld[4109]: 090528 8:22:38 [ERROR] /usr/sbin/mysqld: Can't open file: './xanarchynet/phpbb3_users.frm' (errno: 24)
May 28 08:22:38 broken mysqld[4109]: 090528 8:22:38 [ERROR] /usr/sbin/mysqld: Can't open file: './xanarchynet/phpbb3_users.frm' (errno: 24)
May 28 08:22:39 broken mysqld[4109]: 090528 8:22:39 [ERROR] /usr/sbin/mysqld: Can't open file: './xanarchynet/phpbb3_users.frm' (errno: 24)
May 28 08:22:39 broken mysqld[4109]: 090528 8:22:39 [ERROR] /usr/sbin/mysqld: Can't open file: './xanarchynet/phpbb3_users.frm' (errno: 24)
May 28 08:22:40 broken mysqld[4109]: 090528 8:22:40 [ERROR] /usr/sbin/mysqld: Can't open file: './xanarchynet/phpbb3_users.frm' (errno: 24)
May 28 22:09:33 broken mysqld[4109]: 090528 22:09:33 [ERROR] /usr/sbin/mysqld: Can't open file: './xanarchynet/phpbb3_users.frm' (errno: 24)
May 28 22:09:33 broken mysqld[4109]: 090528 22:09:33 [ERROR] /usr/sbin/mysqld: Can't open file: './xanarchynet/phpbb3_users.frm' (errno: 24)
May 28 22:09:54 broken mysqld[4109]: 090528 22:09:54 [ERROR] /usr/sbin/mysqld: Can't open file: './xanarchynet/phpbb3_sessions.frm' (errno: 24)
May 28 22:09:54 broken mysqld[4109]: 090528 22:09:54 [ERROR] /usr/sbin/mysqld: Can't open file: './xanarchynet/phpbb3_sessions.frm' (errno: 24)
May 28 22:09:54 broken mysqld[4109]: 090528 22:09:54 [ERROR] /usr/sbin/mysqld: Can't open file: './xanarchynet/phpbb3_config.frm' (errno: 24)
May 28 22:09:54 broken mysqld[4109]: 090528 22:09:54 [ERROR] /usr/sbin/mysqld: Can't open file: './xanarchynet/phpbb3_sessions.frm' (errno: 24)
May 28 22:10:17 broken mysqld[4109]: 090528 22:10:17 [ERROR] /usr/sbin/mysqld: Can't open file: './xanarchynet/phpbb3_config.frm' (errno: 24)
May 28 22:10:17 broken mysqld[4109]: 090528 22:10:17 [ERROR] /usr/sbin/mysqld: Can't open file: './xanarchynet/phpbb3_sessions.frm' (errno: 24)
May 28 22:14:28 broken mysqld[4109]: 090528 22:14:28 [ERROR] /usr/sbin/mysqld: Can't open file: './xanarchynet/phpbb3_config.frm' (errno: 24)
May 28 22:14:28 broken mysqld[4109]: 090528 22:14:28 [ERROR] /usr/sbin/mysqld: Can't open file: './xanarchynet/phpbb3_sessions.frm' (errno: 24)
May 28 22:14:33 broken mysqld[4109]: 090528 22:14:33 [ERROR] /usr/sbin/mysqld: Can't open file: './xanarchynet/phpbb3_config.frm' (errno: 24)
May 28 22:14:33 broken mysqld[4109]: 090528 22:14:33 [ERROR] /usr/sbin/mysqld: Can't open file: './xanarchynet/phpbb3_sessions.frm' (errno: 24)
May 28 22:14:43 broken mysqld[4109]: 090528 22:14:43 [ERROR] /usr/sbin/mysqld: Can't open file: './xanarchynet/phpbb3_users.frm' (errno: 24)
May 28 22:14:43 broken mysqld[4109]: 090528 22:14:43 [ERROR] /usr/sbin/mysqld: Can't open file: './xanarchynet/phpbb3_users.frm' (errno: 24)
May 28 22:17:23 broken mysqld[4109]: 090528 22:17:23 [ERROR] /usr/sbin/mysqld: Can't open file: './xanarchynet/phpbb3_config.frm' (errno: 24)
May 28 22:17:23 broken mysqld[4109]: 090528 22:17:23 [ERROR] /usr/sbin/mysqld: Can't open file: './xanarchynet/phpbb3_sessions.frm' (errno: 24)
May 28 22:17:23 broken mysqld[4109]: 090528 22:17:23 [ERROR] /usr/sbin/mysqld: Can't open file: './xanarchynet/phpbb3_config.frm' (errno: 24)
May 28 22:17:23 broken mysqld[4109]: 090528 22:17:23 [ERROR] /usr/sbin/mysqld: Can't open file: './xanarchynet/phpbb3_sessions.frm' (errno: 24)
May 28 22:17:42 broken mysqld[4109]: 090528 22:17:42 [ERROR] /usr/sbin/mysqld: Can't open file: './xanarchynet/phpbb3_config.frm' (errno: 24)
May 28 22:17:42 broken mysqld[4109]: 090528 22:17:42 [ERROR] /usr/sbin/mysqld: Can't open file: './xanarchynet/phpbb3_sessions.frm' (errno: 24)
May 28 22:17:45 broken mysqld[4109]: 090528 22:17:45 [ERROR] /usr/sbin/mysqld: Can't open file: './xanarchynet/phpbb3_config.frm' (errno: 24)
May 28 22:17:45 broken mysqld[4109]: 090528 22:17:45 [ERROR] /usr/sbin/mysqld: Can't open file: './xanarchynet/phpbb3_sessions.frm' (errno: 24)
May 28 22:19:55 broken mysqld[4109]: 090528 22:19:55 [ERROR] Error in accept: Too many open files
broken:/var/log#
basicly mysql ranting that it has too many open files.. but i dont know why, nor how to fix it.. Any thoughts? I dont know weather its related but a mysql update did come down the other day aarround the same time it happened.
For reference, running Debian Etch.
Any help/ideas would be muchly appreciated.
