MySQL keeps stopping!
Posted: 2011/12/07 04:40:52
I am running Centos 5.6 on a VPS, with MySQL 5.0.77, and while on this new VPS host, the MySQL just stops out of now where. It actually looks like it shuts down normally.
I look at the security logs, and it looks like there is constant attacks, but I can't tell if anyone is getting in.
The MySQL log looks like this
110905 21:49:16 [Note] /usr/libexec/mysqld: Shutdown complete
110905 21:49:16 mysqld ended
110905 21:49:16 mysqld started
110905 21:49:16 InnoDB: Started; log sequence number 0 43655
110905 21:49:16 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.0.77' socket: '/var/lib/mysql/mysql.sock' port: 3306 Source distribution
110905 23:54:56 [Note] /usr/libexec/mysqld: Normal shutdown
110905 23:54:56 InnoDB: Starting shutdown...
110905 23:54:56 InnoDB: Shutdown completed; log sequence number 0 43655
110905 23:54:56 [Note] /usr/libexec/mysqld: Shutdown complete
110905 23:54:56 mysqld ended
110905 23:54:57 mysqld started
110905 23:54:57 InnoDB: Started; log sequence number 0 43655
110905 23:54:57 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.0.77' socket: '/var/lib/mysql/mysql.sock' port: 3306 Source distribution
110905 23:57:56 [Note] /usr/libexec/mysqld: Normal shutdown
110905 23:57:56 InnoDB: Starting shutdown...
110905 23:57:57 InnoDB: Shutdown completed; log sequence number 0 43655
110905 23:57:57 [Note] /usr/libexec/mysqld: Shutdown complete
110905 23:57:57 mysqld ended
110905 23:57:58 mysqld started
110905 23:57:59 InnoDB: Started; log sequence number 0 43655
110905 23:57:59 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.0.77' socket: '/var/lib/mysql/mysql.sock' port: 3306 Source distribution
110906 0:18:15 [Note] /usr/libexec/mysqld: Normal shutdown
110906 0:18:15 InnoDB: Starting shutdown...
110906 0:18:16 InnoDB: Shutdown completed; log sequence number 0 43655
110906 0:18:16 [Note] /usr/libexec/mysqld: Shutdown complete
110906 00:18:16 mysqld ended
110906 00:18:17 mysqld started
110906 0:18:17 InnoDB: Started; log sequence number 0 43655
110906 0:18:17 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.0.77' socket: '/var/lib/mysql/mysql.sock' port: 3306 Source distribution
110906 0:34:25 [Note] /usr/libexec/mysqld: Normal shutdown
110906 0:34:25 InnoDB: Starting shutdown...
110906 0:34:26 InnoDB: Shutdown completed; log sequence number 0 43655
110906 0:34:26 [Note] /usr/libexec/mysqld: Shutdown complete
110906 00:34:26 mysqld ended
110906 00:34:27 mysqld started
110906 0:34:27 InnoDB: Started; log sequence number 0 43655
110906 0:34:27 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.0.77' socket: '/var/lib/mysql/mysql.sock' port: 3306 Source distribution
110906 0:41:26 [Note] /usr/libexec/mysqld: Normal shutdown
110906 0:41:26 InnoDB: Starting shutdown...
110906 0:41:27 InnoDB: Shutdown completed; log sequence number 0 43655
110906 0:41:27 [Note] /usr/libexec/mysqld: Shutdown complete
110906 00:41:27 mysqld ended
110906 00:41:28 mysqld started
110906 0:41:28 InnoDB: Started; log sequence number 0 43655
110906 0:41:28 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.0.77' socket: '/var/lib/mysql/mysql.sock' port: 3306 Source distribution
111016 02:14:37 mysqld started
111016 2:14:37 InnoDB: Started; log sequence number 0 43655
111016 2:14:37 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.0.77' socket: '/var/lib/mysql/mysql.sock' port: 3306 Source distribution
111121 15:52:19 mysqld started
111121 15:52:19 InnoDB: Started; log sequence number 0 43655
111121 15:52:19 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.0.77' socket: '/var/lib/mysql/mysql.sock' port: 3306 Source distribution
111130 02:07:48 mysqld started
111130 2:07:49 InnoDB: Started; log sequence number 0 43655
111130 2:07:49 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.0.77' socket: '/var/lib/mysql/mysql.sock' port: 3306 Source distribution
111203 04:16:50 mysqld started
111203 4:16:51 InnoDB: Started; log sequence number 0 43655
111203 4:16:51 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.0.77' socket: '/var/lib/mysql/mysql.sock' port: 3306 Source distribution
111206 14:41:31 mysqld started
111206 14:41:31 InnoDB: Started; log sequence number 0 43655
111206 14:41:31 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.0.77' socket: '/var/lib/mysql/mysql.sock' port: 3306 Source distribution
111207 07:06:38 mysqld started
111207 7:06:39 InnoDB: Started; log sequence number 0 43655
111207 7:06:39 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.0.77' socket: '/var/lib/mysql/mysql.sock' port: 3306 Source distribution
Do you have any hints for me? I am at a loss as to what to look for. Why would I get the normal shutdown all the time?
I look at the security logs, and it looks like there is constant attacks, but I can't tell if anyone is getting in.
The MySQL log looks like this
110905 21:49:16 [Note] /usr/libexec/mysqld: Shutdown complete
110905 21:49:16 mysqld ended
110905 21:49:16 mysqld started
110905 21:49:16 InnoDB: Started; log sequence number 0 43655
110905 21:49:16 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.0.77' socket: '/var/lib/mysql/mysql.sock' port: 3306 Source distribution
110905 23:54:56 [Note] /usr/libexec/mysqld: Normal shutdown
110905 23:54:56 InnoDB: Starting shutdown...
110905 23:54:56 InnoDB: Shutdown completed; log sequence number 0 43655
110905 23:54:56 [Note] /usr/libexec/mysqld: Shutdown complete
110905 23:54:56 mysqld ended
110905 23:54:57 mysqld started
110905 23:54:57 InnoDB: Started; log sequence number 0 43655
110905 23:54:57 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.0.77' socket: '/var/lib/mysql/mysql.sock' port: 3306 Source distribution
110905 23:57:56 [Note] /usr/libexec/mysqld: Normal shutdown
110905 23:57:56 InnoDB: Starting shutdown...
110905 23:57:57 InnoDB: Shutdown completed; log sequence number 0 43655
110905 23:57:57 [Note] /usr/libexec/mysqld: Shutdown complete
110905 23:57:57 mysqld ended
110905 23:57:58 mysqld started
110905 23:57:59 InnoDB: Started; log sequence number 0 43655
110905 23:57:59 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.0.77' socket: '/var/lib/mysql/mysql.sock' port: 3306 Source distribution
110906 0:18:15 [Note] /usr/libexec/mysqld: Normal shutdown
110906 0:18:15 InnoDB: Starting shutdown...
110906 0:18:16 InnoDB: Shutdown completed; log sequence number 0 43655
110906 0:18:16 [Note] /usr/libexec/mysqld: Shutdown complete
110906 00:18:16 mysqld ended
110906 00:18:17 mysqld started
110906 0:18:17 InnoDB: Started; log sequence number 0 43655
110906 0:18:17 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.0.77' socket: '/var/lib/mysql/mysql.sock' port: 3306 Source distribution
110906 0:34:25 [Note] /usr/libexec/mysqld: Normal shutdown
110906 0:34:25 InnoDB: Starting shutdown...
110906 0:34:26 InnoDB: Shutdown completed; log sequence number 0 43655
110906 0:34:26 [Note] /usr/libexec/mysqld: Shutdown complete
110906 00:34:26 mysqld ended
110906 00:34:27 mysqld started
110906 0:34:27 InnoDB: Started; log sequence number 0 43655
110906 0:34:27 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.0.77' socket: '/var/lib/mysql/mysql.sock' port: 3306 Source distribution
110906 0:41:26 [Note] /usr/libexec/mysqld: Normal shutdown
110906 0:41:26 InnoDB: Starting shutdown...
110906 0:41:27 InnoDB: Shutdown completed; log sequence number 0 43655
110906 0:41:27 [Note] /usr/libexec/mysqld: Shutdown complete
110906 00:41:27 mysqld ended
110906 00:41:28 mysqld started
110906 0:41:28 InnoDB: Started; log sequence number 0 43655
110906 0:41:28 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.0.77' socket: '/var/lib/mysql/mysql.sock' port: 3306 Source distribution
111016 02:14:37 mysqld started
111016 2:14:37 InnoDB: Started; log sequence number 0 43655
111016 2:14:37 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.0.77' socket: '/var/lib/mysql/mysql.sock' port: 3306 Source distribution
111121 15:52:19 mysqld started
111121 15:52:19 InnoDB: Started; log sequence number 0 43655
111121 15:52:19 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.0.77' socket: '/var/lib/mysql/mysql.sock' port: 3306 Source distribution
111130 02:07:48 mysqld started
111130 2:07:49 InnoDB: Started; log sequence number 0 43655
111130 2:07:49 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.0.77' socket: '/var/lib/mysql/mysql.sock' port: 3306 Source distribution
111203 04:16:50 mysqld started
111203 4:16:51 InnoDB: Started; log sequence number 0 43655
111203 4:16:51 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.0.77' socket: '/var/lib/mysql/mysql.sock' port: 3306 Source distribution
111206 14:41:31 mysqld started
111206 14:41:31 InnoDB: Started; log sequence number 0 43655
111206 14:41:31 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.0.77' socket: '/var/lib/mysql/mysql.sock' port: 3306 Source distribution
111207 07:06:38 mysqld started
111207 7:06:39 InnoDB: Started; log sequence number 0 43655
111207 7:06:39 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.0.77' socket: '/var/lib/mysql/mysql.sock' port: 3306 Source distribution
Do you have any hints for me? I am at a loss as to what to look for. Why would I get the normal shutdown all the time?