军哥:误删了/usr/local/mysql/var下的.pid文件 重启不生成怎么办?
由于手动删mysql-bin.0000*日志文件误删了/usr/local/mysql/var下的vultr.guest.pid文件
论坛搜索到一个相关帖子说这个是重启下就能自动生成
结果我重启了vps 一直生成不了那个.pid文件
数据库重启一直提示：
/etc/init.d/mysql start
Starting MySQL.. ERROR! The server quit without updating PID file (/usr/local/mysql/var/vultr.guest.pid).
请问军哥有啥办法 处理这个问题 pid是自动创建删除的，不存在误删启动不了
mysql启动不了按置顶帖提供日志
回复 2# 的帖子
141205 18:21:06 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var141205 18:21:06 InnoDB: The InnoDB memory heap is disabled
141205 18:21:06 InnoDB: Mutexes and rw_locks use GCC atomic builtins
141205 18:21:06 InnoDB: Compressed tables use zlib 1.2.3
141205 18:21:06 InnoDB: Initializing buffer pool, size = 16.0M
141205 18:21:06 InnoDB: Completed initialization of buffer pool
141205 18:21:06 InnoDB: highest supported file format is Barracuda.
141205 18:21:06InnoDB: Waiting for the background threads to start
141205 18:21:07 InnoDB: 5.5.37 started; log sequence number 6242574630
/usr/local/mysql/bin/mysqld: File './mysql-bin.000010' not found (Errcode: 2)
141205 18:21:07 Failed to open log (file './mysql-bin.000010', errno 2)
141205 18:21:07 Could not open log file
141205 18:21:07 Can't init tc log
141205 18:21:07 Aborting
141205 18:21:07InnoDB: Starting shutdown...
141205 18:21:07InnoDB: Shutdown completed; log sequence number 6242574630
141205 18:21:07 /usr/local/mysql/bin/mysqld: Shutdown complete
141205 18:21:07 mysqld_safe mysqld from pid file /usr/local/mysql/var/vultr.guest.pid ended
141205 18:21:16 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
141205 18:21:16 InnoDB: The InnoDB memory heap is disabled
141205 18:21:16 InnoDB: Mutexes and rw_locks use GCC atomic builtins
141205 18:21:16 InnoDB: Compressed tables use zlib 1.2.3
141205 18:21:16 InnoDB: Initializing buffer pool, size = 16.0M
141205 18:21:16 InnoDB: Completed initialization of buffer pool
141205 18:21:16 InnoDB: highest supported file format is Barracuda.
141205 18:21:16InnoDB: Waiting for the background threads to start
141205 18:21:17 InnoDB: 5.5.37 started; log sequence number 6242574630
/usr/local/mysql/bin/mysqld: File './mysql-bin.000010' not found (Errcode: 2)
141205 18:21:17 Failed to open log (file './mysql-bin.000010', errno 2)
141205 18:21:17 Could not open log file
141205 18:21:17 Can't init tc log
141205 18:21:17 Aborting
141205 18:21:17InnoDB: Starting shutdown...
141205 18:21:18InnoDB: Shutdown completed; log sequence number 6242574630
141205 18:21:18 /usr/local/mysql/bin/mysqld: Shutdown complete
141205 18:21:18 mysqld_safe mysqld from pid file /usr/local/mysql/var/vultr.guest.pid ended
141205 18:23:43 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
141205 18:23:43 InnoDB: The InnoDB memory heap is disabled
141205 18:23:43 InnoDB: Mutexes and rw_locks use GCC atomic builtins
141205 18:23:43 InnoDB: Compressed tables use zlib 1.2.3
141205 18:23:43 InnoDB: Initializing buffer pool, size = 16.0M
141205 18:23:43 InnoDB: Completed initialization of buffer pool
141205 18:23:43 InnoDB: highest supported file format is Barracuda.
141205 18:23:43InnoDB: Waiting for the background threads to start
141205 18:23:44 InnoDB: 5.5.37 started; log sequence number 6242574630
/usr/local/mysql/bin/mysqld: File './mysql-bin.000010' not found (Errcode: 2)
141205 18:23:44 Failed to open log (file './mysql-bin.000010', errno 2)
141205 18:23:44 Could not open log file
141205 18:23:44 Can't init tc log
141205 18:23:44 Aborting
141205 18:23:44InnoDB: Starting shutdown...
141205 18:23:45InnoDB: Shutdown completed; log sequence number 6242574630
141205 18:23:45 /usr/local/mysql/bin/mysqld: Shutdown complete
141205 18:23:45 mysqld_safe mysqld from pid file /usr/local/mysql/var/vultr.guest.pid ended
141205 18:23:55 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
141205 18:23:55 InnoDB: The InnoDB memory heap is disabled
141205 18:23:55 InnoDB: Mutexes and rw_locks use GCC atomic builtins
141205 18:23:55 InnoDB: Compressed tables use zlib 1.2.3
141205 18:23:55 InnoDB: Initializing buffer pool, size = 16.0M
141205 18:23:55 InnoDB: Completed initialization of buffer pool
141205 18:23:55 InnoDB: highest supported file format is Barracuda.
141205 18:23:55InnoDB: Waiting for the background threads to start
141205 18:23:56 InnoDB: 5.5.37 started; log sequence number 6242574630
/usr/local/mysql/bin/mysqld: File './mysql-bin.000010' not found (Errcode: 2)
141205 18:23:56 Failed to open log (file './mysql-bin.000010', errno 2)
141205 18:23:56 Could not open log file
141205 18:23:56 Can't init tc log
141205 18:23:56 Aborting
141205 18:23:56InnoDB: Starting shutdown...
141205 18:23:57InnoDB: Shutdown completed; log sequence number 6242574630
141205 18:23:57 /usr/local/mysql/bin/mysqld: Shutdown complete
141205 18:23:57 mysqld_safe mysqld from pid file /usr/local/mysql/var/vultr.guest.pid ended
141205 18:24:53 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
141205 18:24:53 InnoDB: The InnoDB memory heap is disabled
141205 18:24:53 InnoDB: Mutexes and rw_locks use GCC atomic builtins
141205 18:24:53 InnoDB: Compressed tables use zlib 1.2.3
141205 18:24:53 InnoDB: Initializing buffer pool, size = 16.0M
141205 18:24:53 InnoDB: Completed initialization of buffer pool
141205 18:24:53 InnoDB: highest supported file format is Barracuda.
141205 18:24:53InnoDB: Waiting for the background threads to start
141205 18:24:54 InnoDB: 5.5.37 started; log sequence number 6242574630
/usr/local/mysql/bin/mysqld: File './mysql-bin.000010' not found (Errcode: 2)
141205 18:24:54 Failed to open log (file './mysql-bin.000010', errno 2)
141205 18:24:54 Could not open log file
141205 18:24:54 Can't init tc log
141205 18:24:54 Aborting
141205 18:24:54InnoDB: Starting shutdown...
141205 18:24:54InnoDB: Shutdown completed; log sequence number 6242574630
141205 18:24:54 /usr/local/mysql/bin/mysqld: Shutdown complete
141205 18:24:54 mysqld_safe mysqld from pid file /usr/local/mysql/var/vultr.guest.pid ended
141205 18:25:08 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
141205 18:25:08 InnoDB: The InnoDB memory heap is disabled
141205 18:25:08 InnoDB: Mutexes and rw_locks use GCC atomic builtins
141205 18:25:08 InnoDB: Compressed tables use zlib 1.2.3
141205 18:25:08 InnoDB: Initializing buffer pool, size = 16.0M
141205 18:25:08 InnoDB: Completed initialization of buffer pool
141205 18:25:08 InnoDB: highest supported file format is Barracuda.
141205 18:25:08InnoDB: Waiting for the background threads to start
141205 18:25:09 InnoDB: 5.5.37 started; log sequence number 6242574630
/usr/local/mysql/bin/mysqld: File './mysql-bin.000010' not found (Errcode: 2)
141205 18:25:09 Failed to open log (file './mysql-bin.000010', errno 2)
141205 18:25:09 Could not open log file
141205 18:25:09 Can't init tc log
141205 18:25:09 Aborting
141205 18:25:09InnoDB: Starting shutdown...
141205 18:25:10InnoDB: Shutdown completed; log sequence number 6242574630
141205 18:25:10 /usr/local/mysql/bin/mysqld: Shutdown complete
141205 18:25:10 mysqld_safe mysqld from pid file /usr/local/mysql/var/vultr.guest.pid ended
141205 18:31:57 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
141205 18:31:57 InnoDB: The InnoDB memory heap is disabled
141205 18:31:57 InnoDB: Mutexes and rw_locks use GCC atomic builtins
141205 18:31:57 InnoDB: Compressed tables use zlib 1.2.3
141205 18:31:57 InnoDB: Initializing buffer pool, size = 16.0M
141205 18:31:57 InnoDB: Completed initialization of buffer pool
141205 18:31:57 InnoDB: highest supported file format is Barracuda.
141205 18:31:57InnoDB: Waiting for the background threads to start
141205 18:31:58 InnoDB: 5.5.37 started; log sequence number 6242574630
/usr/local/mysql/bin/mysqld: File './mysql-bin.000010' not found (Errcode: 2)
141205 18:31:58 Failed to open log (file './mysql-bin.000010', errno 2)
141205 18:31:58 Could not open log file
141205 18:31:58 Can't init tc log
141205 18:31:58 Aborting
141205 18:31:58InnoDB: Starting shutdown...
141205 18:31:58InnoDB: Shutdown completed; log sequence number 6242574630
141205 18:31:58 /usr/local/mysql/bin/mysqld: Shutdown complete 141205 18:31:58 mysqld_safe mysqld from pid file /usr/local/mysql/var/vultr.guest.pid ended
141205 18:35:18 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
141205 18:35:18 InnoDB: The InnoDB memory heap is disabled
141205 18:35:18 InnoDB: Mutexes and rw_locks use GCC atomic builtins
141205 18:35:18 InnoDB: Compressed tables use zlib 1.2.3
141205 18:35:18 InnoDB: Initializing buffer pool, size = 16.0M
141205 18:35:18 InnoDB: Completed initialization of buffer pool
141205 18:35:18 InnoDB: highest supported file format is Barracuda.
141205 18:35:18InnoDB: Waiting for the background threads to start
141205 18:35:19 InnoDB: 5.5.37 started; log sequence number 6242574630
/usr/local/mysql/bin/mysqld: File './mysql-bin.000010' not found (Errcode: 2)
141205 18:35:19 Failed to open log (file './mysql-bin.000010', errno 2)
141205 18:35:19 Could not open log file
141205 18:35:19 Can't init tc log
141205 18:35:19 Aborting
141205 18:35:19InnoDB: Starting shutdown...
141205 18:35:19InnoDB: Shutdown completed; log sequence number 6242574630
141205 18:35:19 /usr/local/mysql/bin/mysqld: Shutdown complete
141205 18:35:19 mysqld_safe mysqld from pid file /usr/local/mysql/var/vultr.guest.pid ended
141205 18:37:22 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
141205 18:37:22 InnoDB: The InnoDB memory heap is disabled
141205 18:37:22 InnoDB: Mutexes and rw_locks use GCC atomic builtins
141205 18:37:22 InnoDB: Compressed tables use zlib 1.2.3
141205 18:37:22 InnoDB: Initializing buffer pool, size = 16.0M
141205 18:37:22 InnoDB: Completed initialization of buffer pool
141205 18:37:22 InnoDB: highest supported file format is Barracuda.
141205 18:37:22InnoDB: Waiting for the background threads to start
141205 18:37:23 InnoDB: 5.5.37 started; log sequence number 6242574630
/usr/local/mysql/bin/mysqld: File './mysql-bin.000010' not found (Errcode: 2)
141205 18:37:23 Failed to open log (file './mysql-bin.000010', errno 2)
141205 18:37:23 Could not open log file
141205 18:37:23 Can't init tc log
141205 18:37:23 Aborting
141205 18:37:23InnoDB: Starting shutdown...
141205 18:37:24InnoDB: Shutdown completed; log sequence number 6242574630
141205 18:37:24 /usr/local/mysql/bin/mysqld: Shutdown complete
141205 18:37:24 mysqld_safe mysqld from pid file /usr/local/mysql/var/vultr.guest.pid ended
141205 18:38:07 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
141205 18:38:07 InnoDB: The InnoDB memory heap is disabled
141205 18:38:07 InnoDB: Mutexes and rw_locks use GCC atomic builtins
141205 18:38:07 InnoDB: Compressed tables use zlib 1.2.3
141205 18:38:07 InnoDB: Initializing buffer pool, size = 16.0M
141205 18:38:07 InnoDB: Completed initialization of buffer pool
141205 18:38:07 InnoDB: highest supported file format is Barracuda.
141205 18:38:07InnoDB: Waiting for the background threads to start
141205 18:38:08 InnoDB: 5.5.37 started; log sequence number 6242574630
/usr/local/mysql/bin/mysqld: File './mysql-bin.000010' not found (Errcode: 2)
141205 18:38:08 Failed to open log (file './mysql-bin.000010', errno 2)
141205 18:38:08 Could not open log file
141205 18:38:08 Can't init tc log
141205 18:38:08 Aborting
141205 18:38:08InnoDB: Starting shutdown...
141205 18:38:08InnoDB: Shutdown completed; log sequence number 6242574630
141205 18:38:08 /usr/local/mysql/bin/mysqld: Shutdown complete
141205 18:38:08 mysqld_safe mysqld from pid file /usr/local/mysql/var/vultr.guest.pid ended
141205 18:38:17 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
141205 18:38:17 InnoDB: The InnoDB memory heap is disabled
141205 18:38:17 InnoDB: Mutexes and rw_locks use GCC atomic builtins
141205 18:38:17 InnoDB: Compressed tables use zlib 1.2.3
141205 18:38:17 InnoDB: Initializing buffer pool, size = 16.0M
141205 18:38:17 InnoDB: Completed initialization of buffer pool
141205 18:38:17 InnoDB: highest supported file format is Barracuda.
141205 18:38:17InnoDB: Waiting for the background threads to start
141205 18:38:18 InnoDB: 5.5.37 started; log sequence number 6242574630
/usr/local/mysql/bin/mysqld: File './mysql-bin.000010' not found (Errcode: 2)
141205 18:38:18 Failed to open log (file './mysql-bin.000010', errno 2)
141205 18:38:18 Could not open log file
141205 18:38:18 Can't init tc log
141205 18:38:18 Aborting
141205 18:38:18InnoDB: Starting shutdown...
141205 18:38:19InnoDB: Shutdown completed; log sequence number 6242574630
141205 18:38:19 /usr/local/mysql/bin/mysqld: Shutdown complete
141205 18:38:19 mysqld_safe mysqld from pid file /usr/local/mysql/var/vultr.guest.pid ended
141205 18:41:48 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
141205 18:41:48 InnoDB: The InnoDB memory heap is disabled
141205 18:41:48 InnoDB: Mutexes and rw_locks use GCC atomic builtins
141205 18:41:48 InnoDB: Compressed tables use zlib 1.2.3
141205 18:41:48 InnoDB: Initializing buffer pool, size = 16.0M
141205 18:41:48 InnoDB: Completed initialization of buffer pool
141205 18:41:48 InnoDB: highest supported file format is Barracuda.
141205 18:41:48InnoDB: Waiting for the background threads to start
141205 18:41:49 InnoDB: 5.5.37 started; log sequence number 6242574630
/usr/local/mysql/bin/mysqld: File './mysql-bin.000010' not found (Errcode: 2)
141205 18:41:49 Failed to open log (file './mysql-bin.000010', errno 2)
141205 18:41:49 Could not open log file
141205 18:41:49 Can't init tc log
141205 18:41:49 Aborting
141205 18:41:49InnoDB: Starting shutdown...
141205 18:41:50InnoDB: Shutdown completed; log sequence number 6242574630
141205 18:41:50 /usr/local/mysql/bin/mysqld: Shutdown complete
141205 18:41:50 mysqld_safe mysqld from pid file /usr/local/mysql/var/vultr.guest.pid ended
141205 18:45:46 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
141205 18:45:46 InnoDB: The InnoDB memory heap is disabled
141205 18:45:46 InnoDB: Mutexes and rw_locks use GCC atomic builtins
141205 18:45:46 InnoDB: Compressed tables use zlib 1.2.3
141205 18:45:46 InnoDB: Initializing buffer pool, size = 16.0M
141205 18:45:46 InnoDB: Completed initialization of buffer pool
141205 18:45:46 InnoDB: highest supported file format is Barracuda.
141205 18:45:46InnoDB: Waiting for the background threads to start
141205 18:45:47 InnoDB: 5.5.37 started; log sequence number 6242574630
/usr/local/mysql/bin/mysqld: File './mysql-bin.000010' not found (Errcode: 2)
141205 18:45:47 Failed to open log (file './mysql-bin.000010', errno 2)
141205 18:45:47 Could not open log file
141205 18:45:47 Can't init tc log
141205 18:45:47 Aborting
141205 18:45:47InnoDB: Starting shutdown...
141205 18:45:48InnoDB: Shutdown completed; log sequence number 6242574630
141205 18:45:48 /usr/local/mysql/bin/mysqld: Shutdown complete
141205 18:45:48 mysqld_safe mysqld from pid file /usr/local/mysql/var/vultr.guest.pid ended
141205 19:07:30 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
141205 19:07:30 InnoDB: The InnoDB memory heap is disabled
141205 19:07:30 InnoDB: Mutexes and rw_locks use GCC atomic builtins
141205 19:07:30 InnoDB: Compressed tables use zlib 1.2.3
141205 19:07:30 InnoDB: Initializing buffer pool, size = 16.0M
141205 19:07:30 InnoDB: Completed initialization of buffer pool
141205 19:07:30 InnoDB: highest supported file format is Barracuda.
141205 19:07:30InnoDB: Waiting for the background threads to start
141205 19:07:31 InnoDB: 5.5.37 started; log sequence number 6242574630
/usr/local/mysql/bin/mysqld: File './mysql-bin.000010' not found (Errcode: 2)
141205 19:07:31 Failed to open log (file './mysql-bin.000010', errno 2)
141205 19:07:31 Could not open log file
141205 19:07:31 Can't init tc log
141205 19:07:31 Aborting 141205 19:07:31InnoDB: Starting shutdown...
141205 19:07:31InnoDB: Shutdown completed; log sequence number 6242574630
141205 19:07:31 /usr/local/mysql/bin/mysqld: Shutdown complete
141205 19:07:31 mysqld_safe mysqld from pid file /usr/local/mysql/var/vultr.guest.pid ended
141205 19:10:04 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
141205 19:10:04 InnoDB: The InnoDB memory heap is disabled
141205 19:10:04 InnoDB: Mutexes and rw_locks use GCC atomic builtins
141205 19:10:04 InnoDB: Compressed tables use zlib 1.2.3
141205 19:10:04 InnoDB: Initializing buffer pool, size = 16.0M
141205 19:10:04 InnoDB: Completed initialization of buffer pool
141205 19:10:04 InnoDB: highest supported file format is Barracuda.
141205 19:10:04InnoDB: Waiting for the background threads to start
141205 19:10:05 InnoDB: 5.5.37 started; log sequence number 6242574630
/usr/local/mysql/bin/mysqld: File './mysql-bin.000010' not found (Errcode: 2)
141205 19:10:05 Failed to open log (file './mysql-bin.000010', errno 2)
141205 19:10:05 Could not open log file
141205 19:10:05 Can't init tc log
141205 19:10:05 Aborting
141205 19:10:05InnoDB: Starting shutdown...
141205 19:10:06InnoDB: Shutdown completed; log sequence number 6242574630
141205 19:10:06 /usr/local/mysql/bin/mysqld: Shutdown complete
141205 19:10:06 mysqld_safe mysqld from pid file /usr/local/mysql/var/vultr.guest.pid ended
141205 19:14:40 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
141205 19:14:40 InnoDB: The InnoDB memory heap is disabled
141205 19:14:40 InnoDB: Mutexes and rw_locks use GCC atomic builtins
141205 19:14:40 InnoDB: Compressed tables use zlib 1.2.3
141205 19:14:40 InnoDB: Initializing buffer pool, size = 16.0M
141205 19:14:40 InnoDB: Completed initialization of buffer pool
141205 19:14:40 InnoDB: highest supported file format is Barracuda.
141205 19:14:40InnoDB: Waiting for the background threads to start
141205 19:14:41 InnoDB: 5.5.37 started; log sequence number 6242574630
/usr/local/mysql/bin/mysqld: File './mysql-bin.000010' not found (Errcode: 2)
141205 19:14:41 Failed to open log (file './mysql-bin.000010', errno 2)
141205 19:14:41 Could not open log file
141205 19:14:41 Can't init tc log
141205 19:14:41 Aborting
141205 19:14:41InnoDB: Starting shutdown...
141205 19:14:41InnoDB: Shutdown completed; log sequence number 6242574630
141205 19:14:41 /usr/local/mysql/bin/mysqld: Shutdown complete
141205 19:14:41 mysqld_safe mysqld from pid file /usr/local/mysql/var/vultr.guest.pid ended
141205 19:18:21 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
141205 19:18:21 InnoDB: The InnoDB memory heap is disabled
141205 19:18:21 InnoDB: Mutexes and rw_locks use GCC atomic builtins
141205 19:18:21 InnoDB: Compressed tables use zlib 1.2.3
141205 19:18:21 InnoDB: Initializing buffer pool, size = 16.0M
141205 19:18:21 InnoDB: Completed initialization of buffer pool
141205 19:18:21 InnoDB: highest supported file format is Barracuda.
141205 19:18:21InnoDB: Waiting for the background threads to start
141205 19:18:22 InnoDB: 5.5.37 started; log sequence number 6242574630
/usr/local/mysql/bin/mysqld: File './mysql-bin.000010' not found (Errcode: 2)
141205 19:18:22 Failed to open log (file './mysql-bin.000010', errno 2)
141205 19:18:22 Could not open log file
141205 19:18:22 Can't init tc log
141205 19:18:22 Aborting
141205 19:18:22InnoDB: Starting shutdown...
141205 19:18:23InnoDB: Shutdown completed; log sequence number 6242574630
141205 19:18:23 /usr/local/mysql/bin/mysqld: Shutdown complete
141205 19:18:23 mysqld_safe mysqld from pid file /usr/local/mysql/var/vultr.guest.pid ended
141205 19:18:52 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
141205 19:18:53 InnoDB: The InnoDB memory heap is disabled
141205 19:18:53 InnoDB: Mutexes and rw_locks use GCC atomic builtins
141205 19:18:53 InnoDB: Compressed tables use zlib 1.2.3
141205 19:18:53 InnoDB: Initializing buffer pool, size = 16.0M
141205 19:18:53 InnoDB: Completed initialization of buffer pool
141205 19:18:53 InnoDB: highest supported file format is Barracuda.
141205 19:18:53InnoDB: Waiting for the background threads to start
141205 19:18:54 InnoDB: 5.5.37 started; log sequence number 6242574630
/usr/local/mysql/bin/mysqld: File './mysql-bin.000010' not found (Errcode: 2)
141205 19:18:54 Failed to open log (file './mysql-bin.000010', errno 2)
141205 19:18:54 Could not open log file
141205 19:18:54 Can't init tc log
141205 19:18:54 Aborting
141205 19:18:54InnoDB: Starting shutdown...
141205 19:18:54InnoDB: Shutdown completed; log sequence number 6242574630
141205 19:18:54 /usr/local/mysql/bin/mysqld: Shutdown complete
141205 19:18:54 mysqld_safe mysqld from pid file /usr/local/mysql/var/vultr.guest.pid ended
141205 19:27:03 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
141205 19:27:03 InnoDB: The InnoDB memory heap is disabled
141205 19:27:03 InnoDB: Mutexes and rw_locks use GCC atomic builtins
141205 19:27:03 InnoDB: Compressed tables use zlib 1.2.3
141205 19:27:03 InnoDB: Initializing buffer pool, size = 16.0M
141205 19:27:03 InnoDB: Completed initialization of buffer pool
141205 19:27:03 InnoDB: highest supported file format is Barracuda.
141205 19:27:03InnoDB: Waiting for the background threads to start
141205 19:27:04 InnoDB: 5.5.37 started; log sequence number 6242574630
/usr/local/mysql/bin/mysqld: File './mysql-bin.000010' not found (Errcode: 2)
141205 19:27:04 Failed to open log (file './mysql-bin.000010', errno 2)
141205 19:27:04 Could not open log file
141205 19:27:04 Can't init tc log
141205 19:27:04 Aborting
141205 19:27:04InnoDB: Starting shutdown...
141205 19:27:04InnoDB: Shutdown completed; log sequence number 6242574630
141205 19:27:04 /usr/local/mysql/bin/mysqld: Shutdown complete
141205 19:27:04 mysqld_safe mysqld from pid file /usr/local/mysql/var/vultr.guest.pid ended
141205 19:27:54 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
141205 19:27:54 InnoDB: The InnoDB memory heap is disabled
141205 19:27:54 InnoDB: Mutexes and rw_locks use GCC atomic builtins
141205 19:27:54 InnoDB: Compressed tables use zlib 1.2.3
141205 19:27:54 InnoDB: Initializing buffer pool, size = 16.0M
141205 19:27:54 InnoDB: Completed initialization of buffer pool
141205 19:27:54 InnoDB: highest supported file format is Barracuda.
141205 19:27:54InnoDB: Waiting for the background threads to start
141205 19:27:55 InnoDB: 5.5.37 started; log sequence number 6242574630
/usr/local/mysql/bin/mysqld: File './mysql-bin.000010' not found (Errcode: 2)
141205 19:27:55 Failed to open log (file './mysql-bin.000010', errno 2)
141205 19:27:55 Could not open log file
141205 19:27:55 Can't init tc log
141205 19:27:55 Aborting
141205 19:27:55InnoDB: Starting shutdown...
141205 19:27:56InnoDB: Shutdown completed; log sequence number 6242574630
141205 19:27:56 /usr/local/mysql/bin/mysqld: Shutdown complete
141205 19:27:56 mysqld_safe mysqld from pid file /usr/local/mysql/var/vultr.guest.pid ended
141205 19:28:18 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
141205 19:28:18 InnoDB: The InnoDB memory heap is disabled
141205 19:28:18 InnoDB: Mutexes and rw_locks use GCC atomic builtins
141205 19:28:18 InnoDB: Compressed tables use zlib 1.2.3
141205 19:28:18 InnoDB: Initializing buffer pool, size = 16.0M
141205 19:28:18 InnoDB: Completed initialization of buffer pool
141205 19:28:18 InnoDB: highest supported file format is Barracuda.
141205 19:28:18InnoDB: Waiting for the background threads to start
141205 19:28:19 InnoDB: 5.5.37 started; log sequence number 6242574630
/usr/local/mysql/bin/mysqld: File './mysql-bin.000010' not found (Errcode: 2)
141205 19:28:19 Failed to open log (file './mysql-bin.000010', errno 2)
141205 19:28:19 Could not open log file
141205 19:28:19 Can't init tc log
141205 19:28:19 Aborting 141205 19:28:19InnoDB: Starting shutdown...
141205 19:28:20InnoDB: Shutdown completed; log sequence number 6242574630
141205 19:28:20 /usr/local/mysql/bin/mysqld: Shutdown complete
141205 19:28:20 mysqld_safe mysqld from pid file /usr/local/mysql/var/vultr.guest.pid ended
141205 19:29:59 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
141205 19:29:59 InnoDB: The InnoDB memory heap is disabled
141205 19:29:59 InnoDB: Mutexes and rw_locks use GCC atomic builtins
141205 19:29:59 InnoDB: Compressed tables use zlib 1.2.3
141205 19:29:59 InnoDB: Initializing buffer pool, size = 16.0M
141205 19:29:59 InnoDB: Completed initialization of buffer pool
141205 19:29:59 InnoDB: highest supported file format is Barracuda.
141205 19:29:59InnoDB: Waiting for the background threads to start
141205 19:30:00 InnoDB: 5.5.37 started; log sequence number 6242574630
/usr/local/mysql/bin/mysqld: File './mysql-bin.000010' not found (Errcode: 2)
141205 19:30:00 Failed to open log (file './mysql-bin.000010', errno 2)
141205 19:30:00 Could not open log file
141205 19:30:00 Can't init tc log
141205 19:30:00 Aborting
141205 19:30:00InnoDB: Starting shutdown...
141205 19:30:01InnoDB: Shutdown completed; log sequence number 6242574630
141205 19:30:01 /usr/local/mysql/bin/mysqld: Shutdown complete
141205 19:30:01 mysqld_safe mysqld from pid file /usr/local/mysql/var/vultr.guest.pid ended
141205 19:52:03 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
141205 19:52:03 InnoDB: The InnoDB memory heap is disabled
141205 19:52:03 InnoDB: Mutexes and rw_locks use GCC atomic builtins
141205 19:52:03 InnoDB: Compressed tables use zlib 1.2.3
141205 19:52:03 InnoDB: Initializing buffer pool, size = 16.0M
141205 19:52:03 InnoDB: Completed initialization of buffer pool
141205 19:52:03 InnoDB: highest supported file format is Barracuda.
141205 19:52:03InnoDB: Waiting for the background threads to start
141205 19:52:04 InnoDB: 5.5.37 started; log sequence number 6242574630
/usr/local/mysql/bin/mysqld: File './mysql-bin.000010' not found (Errcode: 2)
141205 19:52:04 Failed to open log (file './mysql-bin.000010', errno 2)
141205 19:52:04 Could not open log file
141205 19:52:04 Can't init tc log
141205 19:52:04 Aborting
141205 19:52:04InnoDB: Starting shutdown...
141205 19:52:05InnoDB: Shutdown completed; log sequence number 6242574630
141205 19:52:05 /usr/local/mysql/bin/mysqld: Shutdown complete
141205 19:52:05 mysqld_safe mysqld from pid file /usr/local/mysql/var/vultr.guest.pid ended
141205 19:52:31 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
141205 19:52:31 InnoDB: The InnoDB memory heap is disabled
141205 19:52:31 InnoDB: Mutexes and rw_locks use GCC atomic builtins
141205 19:52:31 InnoDB: Compressed tables use zlib 1.2.3
141205 19:52:31 InnoDB: Initializing buffer pool, size = 16.0M
141205 19:52:31 InnoDB: Completed initialization of buffer pool
141205 19:52:31 InnoDB: highest supported file format is Barracuda.
141205 19:52:31InnoDB: Waiting for the background threads to start
141205 19:52:32 InnoDB: 5.5.37 started; log sequence number 6242574630
/usr/local/mysql/bin/mysqld: File './mysql-bin.000010' not found (Errcode: 2)
141205 19:52:32 Failed to open log (file './mysql-bin.000010', errno 2)
141205 19:52:32 Could not open log file
141205 19:52:32 Can't init tc log
141205 19:52:32 Aborting
141205 19:52:32InnoDB: Starting shutdown...
141205 19:52:32InnoDB: Shutdown completed; log sequence number 6242574630
141205 19:52:32 /usr/local/mysql/bin/mysqld: Shutdown complete
141205 19:52:32 mysqld_safe mysqld from pid file /usr/local/mysql/var/vultr.guest.pid ended
141205 19:58:59 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
141205 19:58:59 InnoDB: The InnoDB memory heap is disabled
141205 19:58:59 InnoDB: Mutexes and rw_locks use GCC atomic builtins
141205 19:58:59 InnoDB: Compressed tables use zlib 1.2.3
141205 19:58:59 InnoDB: Initializing buffer pool, size = 16.0M
141205 19:58:59 InnoDB: Completed initialization of buffer pool
141205 19:58:59 InnoDB: highest supported file format is Barracuda.
141205 19:58:59InnoDB: Waiting for the background threads to start
141205 19:59:00 InnoDB: 5.5.37 started; log sequence number 6242574630
/usr/local/mysql/bin/mysqld: File './mysql-bin.000010' not found (Errcode: 2)
141205 19:59:00 Failed to open log (file './mysql-bin.000010', errno 2)
141205 19:59:00 Could not open log file
141205 19:59:00 Can't init tc log
141205 19:59:00 Aborting
141205 19:59:00InnoDB: Starting shutdown...
141205 19:59:01InnoDB: Shutdown completed; log sequence number 6242574630
141205 19:59:01 /usr/local/mysql/bin/mysqld: Shutdown complete
141205 19:59:01 mysqld_safe mysqld from pid file /usr/local/mysql/var/vultr.guest.pid ended
141205 20:04:32 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
141205 20:04:32 InnoDB: The InnoDB memory heap is disabled
141205 20:04:32 InnoDB: Mutexes and rw_locks use GCC atomic builtins
141205 20:04:32 InnoDB: Compressed tables use zlib 1.2.3
141205 20:04:32 InnoDB: Initializing buffer pool, size = 16.0M
141205 20:04:32 InnoDB: Completed initialization of buffer pool
141205 20:04:32 InnoDB: highest supported file format is Barracuda.
141205 20:04:32InnoDB: Waiting for the background threads to start
141205 20:04:33 InnoDB: 5.5.37 started; log sequence number 6242574630
/usr/local/mysql/bin/mysqld: File './mysql-bin.000010' not found (Errcode: 2)
141205 20:04:33 Failed to open log (file './mysql-bin.000010', errno 2)
141205 20:04:33 Could not open log file
141205 20:04:33 Can't init tc log
141205 20:04:33 Aborting
141205 20:04:33InnoDB: Starting shutdown...
141205 20:04:33InnoDB: Shutdown completed; log sequence number 6242574630
141205 20:04:33 /usr/local/mysql/bin/mysqld: Shutdown complete
141205 20:04:33 mysqld_safe mysqld from pid file /usr/local/mysql/var/vultr.guest.pid ended
141205 20:23:12 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
141205 20:23:12 InnoDB: The InnoDB memory heap is disabled
141205 20:23:12 InnoDB: Mutexes and rw_locks use GCC atomic builtins
141205 20:23:12 InnoDB: Compressed tables use zlib 1.2.3
141205 20:23:12 InnoDB: Initializing buffer pool, size = 16.0M
141205 20:23:12 InnoDB: Completed initialization of buffer pool
141205 20:23:12 InnoDB: highest supported file format is Barracuda.
141205 20:23:12InnoDB: Waiting for the background threads to start
141205 20:23:13 InnoDB: 5.5.37 started; log sequence number 6242574630
/usr/local/mysql/bin/mysqld: File './mysql-bin.000010' not found (Errcode: 2)
141205 20:23:13 Failed to open log (file './mysql-bin.000010', errno 2)
141205 20:23:13 Could not open log file
141205 20:23:13 Can't init tc log
141205 20:23:13 Aborting
141205 20:23:13InnoDB: Starting shutdown...
141205 20:23:13InnoDB: Shutdown completed; log sequence number 6242574630
141205 20:23:13 /usr/local/mysql/bin/mysqld: Shutdown complete
141205 20:23:13 mysqld_safe mysqld from pid file /usr/local/mysql/var/vultr.guest.pid ended
141205 20:23:44 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
141205 20:23:44 InnoDB: The InnoDB memory heap is disabled
141205 20:23:44 InnoDB: Mutexes and rw_locks use GCC atomic builtins
141205 20:23:44 InnoDB: Compressed tables use zlib 1.2.3
141205 20:23:44 InnoDB: Initializing buffer pool, size = 16.0M
141205 20:23:44 InnoDB: Completed initialization of buffer pool
InnoDB: The first specified data file /usr/local/mysql/var/ibdata1 did not exist:
InnoDB: a new database to be created!
141205 20:23:44InnoDB: Setting file /usr/local/mysql/var/ibdata1 size to 10 MB
InnoDB: Database physically writes the file full: wait...
141205 20:23:44 InnoDB: Error: all log files must be created at the same time.
141205 20:23:44 InnoDB: All log files must be created also in database creation.
141205 20:23:44 InnoDB: If you want bigger or smaller log files, shut down the
141205 20:23:44 InnoDB: database and make sure there were no errors in shutdown.
141205 20:23:44 InnoDB: Then delete the existing log files. Edit the .cnf file
141205 20:23:44 InnoDB: and start the database again.
141205 20:23:44 Plugin 'InnoDB' init function returned error.
141205 20:23:44 Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
141205 20:23:44 Unknown/unsupported storage engine: InnoDB
141205 20:23:44 Aborting
141205 20:23:44 /usr/local/mysql/bin/mysqld: Shutdown complete
141205 20:23:44 mysqld_safe mysqld from pid file /usr/local/mysql/var/vultr.guest.pid ended 抱歉 尝试次数太多 日志有点大 /usr/local/mysql/bin/mysqld: File './mysql-bin.000010' not found (Errcode: 2)
141205 19:59:00 Failed to open log (file './mysql-bin.000010', errno 2)
141205 19:59:00 Could not open log file
这个错误是未按正常途径删除日志造成的，正常删除方法：https://www.vpser.net/manage/delete-mysql-mysql-bin-0000-logs.html
目前需要将/usr/local/mysql/var 下面的mysql-bin-index.index 清空再启动就可以了
可以在/etc/my.cnf里加上 expire_logs_days = 7 来设置为7天自动清理日志
141205 20:23:44 Plugin 'InnoDB' init function returned error.
141205 20:23:44 Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
141205 20:23:44 Unknown/unsupported storage engine: InnoDB
141205 20:23:44 Aborting
这个错误应该安装是没选择innodb，配置文件里启用了innodb，配置文件里禁用就可以了 非常感谢
页:
[1]