急！MySQL server PID file could not be found! ...论坛里的方法都不行啊
今天早上重启了一下服务器，之后数据库就无法启动了。top后找不到mysql进程，但是用网上ps aux |grep mysq*的方法可以列出一项，然而kill时又显示找不到进程。host.err：
170215 05:16:11 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
1702155:16:11 /usr/local/mysql/bin/mysqld (mysqld 5.5.48-log) starting as process 499 ...
1702155:16:11 Plugin 'FEDERATED' is disabled.
1702155:16:11 InnoDB: The InnoDB memory heap is disabled
1702155:16:11 InnoDB: Mutexes and rw_locks use GCC atomic builtins
1702155:16:11 InnoDB: Compressed tables use zlib 1.2.7
1702155:16:11 InnoDB: Initializing buffer pool, size = 16.0M
1702155:16:11 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!
1702155:16:11InnoDB: Setting file /usr/local/mysql/var/ibdata1 size to 10 MB
InnoDB: Database physically writes the file full: wait...
1702155:16:12InnoDB: Log file /usr/local/mysql/var/ib_logfile0 did not exist: new to be created
InnoDB: Setting log file /usr/local/mysql/var/ib_logfile0 size to 5 MB
InnoDB: Database physically writes the file full: wait...
接上面
170215 5:16:12 InnoDB: Log file /usr/local/mysql/var/ib_logfile1 did not exist: new to be createdInnoDB: Setting log file /usr/local/mysql/var/ib_logfile1 size to 5 MB
InnoDB: Database physically writes the file full: wait...
InnoDB: Doublewrite buffer not found: creating new
InnoDB: Doublewrite buffer created
InnoDB: 127 rollback segment(s) active.
InnoDB: Creating foreign key constraint system tables
InnoDB: Foreign key constraint system tables created
170215 5:16:12 InnoDB: Waiting for the background threads to start
170215 5:16:13 InnoDB: 5.5.48 started; log sequence number 0
170215 5:16:13 Server hostname (bind-address): '0.0.0.0'; port: 3306
170215 5:16:13 - '0.0.0.0' resolves to '0.0.0.0';
170215 5:16:13 Server socket created on IP: '0.0.0.0'.
170215 5:16:13 Event Scheduler: Loaded 0 events
170215 5:16:13 /usr/local/mysql/bin/mysqld: ready for connections.
Version: '5.5.48-log' socket: '/tmp/mysql.sock' port: 3306 Source distribution
170215 5:16:14 /usr/local/mysql/bin/mysqld: Normal shutdown
170215 5:16:14 Event Scheduler: Purging the queue. 0 events
170215 5:16:14 InnoDB: Starting shutdown...
170215 5:16:14 InnoDB: Shutdown completed; log sequence number 1595675
170215 5:16:14 /usr/local/mysql/bin/mysqld: Shutdown complete
170215 05:16:14 mysqld_safe mysqld from pid file /usr/local/mysql/var/host.pid ended
170215 05:16:15 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
170215 5:16:15 /usr/local/mysql/bin/mysqld (mysqld 5.5.48-log) starting as process 1048 ...
170215 5:16:15 Plugin 'FEDERATED' is disabled.
170215 5:16:15 InnoDB: The InnoDB memory heap is disabled
170215 5:16:15 InnoDB: Mutexes and rw_locks use GCC atomic builtins
170215 5:16:15 InnoDB: Compressed tables use zlib 1.2.7
170215 5:16:15 InnoDB: Initializing buffer pool, size = 16.0M
170215 5:16:15 InnoDB: Completed initialization of buffer pool
170215 5:16:15 InnoDB: highest supported file format is Barracuda.
170215 5:16:15 InnoDB: Waiting for the background threads to start
170215 5:16:16 InnoDB: 5.5.48 started; log sequence number 1595675
170215 5:16:16 Server hostname (bind-address): '0.0.0.0'; port: 3306
170215 5:16:16 - '0.0.0.0' resolves to '0.0.0.0';
170215 5:16:16 Server socket created on IP: '0.0.0.0'.
170215 5:16:16 Event Scheduler: Loaded 0 events
170215 5:16:16 /usr/local/mysql/bin/mysqld: ready for connections.
Version: '5.5.48-log' socket: '/tmp/mysql.sock' port: 3306 Source distribution
170215 5:16:17 /usr/local/mysql/bin/mysqld: Normal shutdown
170215 5:16:17 Event Scheduler: Purging the queue. 0 events
170215 5:16:17 InnoDB: Starting shutdown...
170215 5:16:18 InnoDB: Shutdown completed; log sequence number 1595685
170215 5:16:18 /usr/local/mysql/bin/mysqld: Shutdown complete
170215 05:16:18 mysqld_safe mysqld from pid file /usr/local/mysql/var/host.pid ended
170215 05:16:19 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
170215 5:16:19 /usr/local/mysql/bin/mysqld (mysqld 5.5.48-log) starting as process 1621 ...
170215 5:16:19 Plugin 'FEDERATED' is disabled.
170215 5:16:19 InnoDB: The InnoDB memory heap is disabled
170215 5:16:19 InnoDB: Mutexes and rw_locks use GCC atomic builtins
170215 5:16:19 InnoDB: Compressed tables use zlib 1.2.7
170215 5:16:19 InnoDB: Initializing buffer pool, size = 16.0M
170215 5:16:19 InnoDB: Completed initialization of buffer pool
170215 5:16:19 InnoDB: highest supported file format is Barracuda.
170215 5:16:19 InnoDB: Waiting for the background threads to start
170215 5:16:20 InnoDB: 5.5.48 started; log sequence number 1595685
170215 5:16:20 Server hostname (bind-address): '0.0.0.0'; port: 3306
170215 5:16:20 - '0.0.0.0' resolves to '0.0.0.0';
170215 5:16:20 Server socket created on IP: '0.0.0.0'.
170215 5:16:20 Event Scheduler: Loaded 0 events
170215 5:16:20 /usr/local/mysql/bin/mysqld: ready for connections.
Version: '5.5.48-log' socket: '/tmp/mysql.sock' port: 3306 Source distribution
170215 5:16:21 /usr/local/mysql/bin/mysqld: Normal shutdown
170215 5:16:21 Event Scheduler: Purging the queue. 0 events
170215 5:16:21 InnoDB: Starting shutdown...
170215 5:16:21 InnoDB: Shutdown completed; log sequence number 1595685
170215 5:16:21 /usr/local/mysql/bin/mysqld: Shutdown complete
170215 05:16:21 mysqld_safe mysqld from pid file /usr/local/mysql/var/host.pid ended
170215 05:22:07 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
170215 5:22:07 /usr/local/mysql/bin/mysqld (mysqld 5.5.48-log) starting as process 1762 ...
170215 5:22:07 Plugin 'FEDERATED' is disabled.
170215 5:22:07 InnoDB: The InnoDB memory heap is disabled
170215 5:22:07 InnoDB: Mutexes and rw_locks use GCC atomic builtins
170215 5:22:07 InnoDB: Compressed tables use zlib 1.2.7
170215 5:22:07 InnoDB: Initializing buffer pool, size = 16.0M
170215 5:22:07 InnoDB: Completed initialization of buffer pool
170215 5:22:07 InnoDB: highest supported file format is Barracuda.
170215 5:22:07 InnoDB: Waiting for the background threads to start
170215 5:22:08 InnoDB: 5.5.48 started; log sequence number 1595685
170215 5:22:08 Server hostname (bind-address): '0.0.0.0'; port: 3306
170215 5:22:08 - '0.0.0.0' resolves to '0.0.0.0';
170215 5:22:08 Server socket created on IP: '0.0.0.0'.
170215 5:22:08 Event Scheduler: Loaded 0 events
170215 5:22:08 /usr/local/mysql/bin/mysqld: ready for connections.
Version: '5.5.48-log' socket: '/tmp/mysql.sock' port: 3306 Source distribution
170215 23:48:35 /usr/local/mysql/bin/mysqld: Normal shutdown
170215 23:48:35 Event Scheduler: Purging the queue. 0 events
170215 23:48:35 InnoDB: Starting shutdown...
170215 23:48:36 InnoDB: Shutdown completed; log sequence number 3831310
170215 23:48:36 /usr/local/mysql/bin/mysqld: Shutdown complete
170215 23:48:36 mysqld_safe mysqld from pid file /usr/local/mysql/var/host.pid ended
170215 23:48:44 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
170215 23:48:44 Using unique option prefix key_buffer instead of key_buffer_size is deprecated and will be removed in a future release. Please use the full name instead.
170215 23:48:44 /usr/local/mysql/bin/mysqld (mysqld 5.5.48-log) starting as process 2682 ...
170215 23:48:44 Can't find messagefile '/usr/share/mysql/errmsg.sys'
170215 23:48:44 Using unique option prefix myisam-recover instead of myisam-recover-options is deprecated and will be removed in a future release. Please use the full name instead.
170215 23:48:44 Plugin 'FEDERATED' is disabled.
170215 23:48:44 InnoDB: The InnoDB memory heap is disabled
170215 23:48:44 InnoDB: Mutexes and rw_locks use GCC atomic builtins
170215 23:48:44 InnoDB: Compressed tables use zlib 1.2.7
170215 23:48:44 InnoDB: Initializing buffer pool, size = 16.0M
170215 23:48:44 InnoDB: Completed initialization of buffer pool
170215 23:48:44 InnoDB: highest supported file format is Barracuda.
170215 23:48:44 InnoDB: Waiting for the background threads to start
170215 23:48:45 InnoDB: 5.5.48 started; log sequence number 3831310
170215 23:48:45 Aborting
170215 23:48:45 InnoDB: Starting shutdown...
170215 23:48:46 InnoDB: Shutdown completed; log sequence number 3831310
170215 23:48:46
170215 23:48:46 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
170215 23:54:50 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
170215 23:54:50 Using unique option prefix key_buffer instead of key_buffer_size is deprecated and will be removed in a future release. Please use the full name instead.
170215 23:54:50 /usr/local/mysql/bin/mysqld (mysqld 5.5.48-log) starting as process 2677 ...
170215 23:54:50 Can't find messagefile '/usr/share/mysql/errmsg.sys'
170215 23:54:51 Using unique option prefix myisam-recover instead of myisam-recover-options is deprecated and will be removed in a future release. Please use the full name instead.
170215 23:54:51 Plugin 'FEDERATED' is disabled.
170215 23:54:51 InnoDB: The InnoDB memory heap is disabled
170215 23:54:51 InnoDB: Mutexes and rw_locks use GCC atomic builtins
170215 23:54:51 InnoDB: Compressed tables use zlib 1.2.7
170215 23:54:51 InnoDB: Initializing buffer pool, size = 16.0M
170215 23:54:51 InnoDB: Completed initialization of buffer pool
170215 23:54:51 InnoDB: highest supported file format is Barracuda.
170215 23:54:51 InnoDB: Waiting for the background threads to start
170215 23:54:52 InnoDB: 5.5.48 started; log sequence number 3831310
170215 23:54:52 Aborting
170215 23:54:52 InnoDB: Starting shutdown...
170215 23:54:52 InnoDB: Shutdown completed; log sequence number 3831310
170215 23:54:52
170215 23:54:52 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
170216 09:36:08 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
170216 9:36:08 Using unique option prefix key_buffer instead of key_buffer_size is deprecated and will be removed in a future release. Please use the full name instead.
170216 9:36:08 /usr/local/mysql/bin/mysqld (mysqld 5.5.48-log) starting as process 2408 ...
170216 9:36:08 Can't find messagefile '/usr/share/mysql/errmsg.sys'
接上面
170216 9:36:08 Using unique option prefix myisam-recover instead of myisam-recover-options is deprecated and will be removed in a future release. Please use the full name instead.170216 9:36:08 Plugin 'FEDERATED' is disabled.
170216 9:36:08 InnoDB: The InnoDB memory heap is disabled
170216 9:36:08 InnoDB: Mutexes and rw_locks use GCC atomic builtins
170216 9:36:08 InnoDB: Compressed tables use zlib 1.2.7
170216 9:36:08 InnoDB: Initializing buffer pool, size = 16.0M
170216 9:36:08 InnoDB: Completed initialization of buffer pool
170216 9:36:08 InnoDB: highest supported file format is Barracuda.
170216 9:36:08 InnoDB: Waiting for the background threads to start
170216 9:36:09 InnoDB: 5.5.48 started; log sequence number 3831310
170216 9:36:09 Aborting
170216 9:36:09 InnoDB: Starting shutdown...
170216 9:36:10 InnoDB: Shutdown completed; log sequence number 3831310
170216 9:36:10
170216 09:36:10 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
170216 09:40:54 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
170216 9:40:54 Using unique option prefix key_buffer instead of key_buffer_size is deprecated and will be removed in a future release. Please use the full name instead.
170216 9:40:54 /usr/local/mysql/bin/mysqld (mysqld 5.5.48-log) starting as process 3352 ...
170216 9:40:54 Can't find messagefile '/usr/share/mysql/errmsg.sys'
170216 9:40:54 Using unique option prefix myisam-recover instead of myisam-recover-options is deprecated and will be removed in a future release. Please use the full name instead.
170216 9:40:54 Plugin 'FEDERATED' is disabled.
170216 9:40:54 InnoDB: The InnoDB memory heap is disabled
170216 9:40:54 InnoDB: Mutexes and rw_locks use GCC atomic builtins
170216 9:40:54 InnoDB: Compressed tables use zlib 1.2.7
170216 9:40:54 InnoDB: Initializing buffer pool, size = 16.0M
170216 9:40:54 InnoDB: Completed initialization of buffer pool
170216 9:40:54 InnoDB: highest supported file format is Barracuda.
170216 9:40:54 InnoDB: Waiting for the background threads to start
170216 9:40:55 InnoDB: 5.5.48 started; log sequence number 3831310
170216 9:40:55 Aborting
170216 9:40:55 InnoDB: Starting shutdown...
170216 9:40:55 InnoDB: Shutdown completed; log sequence number 3831310
170216 9:40:55
170216 09:40:55 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
170216 09:43:31 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
170216 9:43:31 Using unique option prefix key_buffer instead of key_buffer_size is deprecated and will be removed in a future release. Please use the full name instead.
170216 9:43:31 /usr/local/mysql/bin/mysqld (mysqld 5.5.48-log) starting as process 4155 ...
170216 9:43:31 Can't find messagefile '/usr/share/mysql/errmsg.sys'
170216 9:43:31 Using unique option prefix myisam-recover instead of myisam-recover-options is deprecated and will be removed in a future release. Please use the full name instead.
170216 9:43:31 Plugin 'FEDERATED' is disabled.
170216 9:43:31 InnoDB: The InnoDB memory heap is disabled
170216 9:43:31 InnoDB: Mutexes and rw_locks use GCC atomic builtins
170216 9:43:31 InnoDB: Compressed tables use zlib 1.2.7
170216 9:43:31 InnoDB: Initializing buffer pool, size = 16.0M
170216 9:43:31 InnoDB: Completed initialization of buffer pool
170216 9:43:31 InnoDB: highest supported file format is Barracuda.
170216 9:43:31 InnoDB: Waiting for the background threads to start
170216 9:43:32 InnoDB: 5.5.48 started; log sequence number 3831310
170216 9:43:32 Aborting
170216 9:43:32 InnoDB: Starting shutdown...
170216 9:43:33 InnoDB: Shutdown completed; log sequence number 3831310
170216 9:43:33
170216 09:43:33 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
170216 09:48:04 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
170216 9:48:04 Using unique option prefix key_buffer instead of key_buffer_size is deprecated and will be removed in a future release. Please use the full name instead.
170216 9:48:04 /usr/local/mysql/bin/mysqld (mysqld 5.5.48-log) starting as process 5030 ...
170216 9:48:04 Can't find messagefile '/usr/share/mysql/errmsg.sys'
170216 9:48:04 Using unique option prefix myisam-recover instead of myisam-recover-options is deprecated and will be removed in a future release. Please use the full name instead.
170216 9:48:04 Plugin 'FEDERATED' is disabled.
170216 9:48:04 InnoDB: The InnoDB memory heap is disabled
170216 9:48:04 InnoDB: Mutexes and rw_locks use GCC atomic builtins
170216 9:48:04 InnoDB: Compressed tables use zlib 1.2.7
170216 9:48:04 InnoDB: Initializing buffer pool, size = 16.0M
170216 9:48:04 InnoDB: Completed initialization of buffer pool
170216 9:48:04 InnoDB: highest supported file format is Barracuda.
170216 9:48:04 InnoDB: Waiting for the background threads to start
170216 9:48:05 InnoDB: 5.5.48 started; log sequence number 3831310
170216 9:48:05 Aborting
170216 9:48:05 InnoDB: Starting shutdown...
170216 9:48:05 InnoDB: Shutdown completed; log sequence number 3831310
170216 9:48:05
170216 09:48:05 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
170216 09:48:47 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
170216 9:48:47 Using unique option prefix key_buffer instead of key_buffer_size is deprecated and will be removed in a future release. Please use the full name instead.
170216 9:48:47 /usr/local/mysql/bin/mysqld (mysqld 5.5.48-log) starting as process 5888 ...
170216 9:48:47 Can't find messagefile '/usr/share/mysql/errmsg.sys'
170216 9:48:47 Using unique option prefix myisam-recover instead of myisam-recover-options is deprecated and will be removed in a future release. Please use the full name instead.
170216 9:48:47 Plugin 'FEDERATED' is disabled.
170216 9:48:47 InnoDB: The InnoDB memory heap is disabled
170216 9:48:47 InnoDB: Mutexes and rw_locks use GCC atomic builtins
170216 9:48:47 InnoDB: Compressed tables use zlib 1.2.7
170216 9:48:47 InnoDB: Initializing buffer pool, size = 16.0M
170216 9:48:47 InnoDB: Completed initialization of buffer pool
170216 9:48:47 InnoDB: highest supported file format is Barracuda.
170216 9:48:47 InnoDB: Waiting for the background threads to start
170216 9:48:48 InnoDB: 5.5.48 started; log sequence number 3831310
170216 9:48:48 Aborting
170216 9:48:48 InnoDB: Starting shutdown...
170216 9:48:49 InnoDB: Shutdown completed; log sequence number 3831310
170216 9:48:49
170216 09:48:49 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
170216 09:54:06 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
170216 9:54:06 Using unique option prefix key_buffer instead of key_buffer_size is deprecated and will be removed in a future release. Please use the full name instead.
170216 9:54:06 /usr/local/mysql/bin/mysqld (mysqld 5.5.48-log) starting as process 6771 ...
170216 9:54:06 Can't find messagefile '/usr/share/mysql/errmsg.sys'
170216 9:54:06 Using unique option prefix myisam-recover instead of myisam-recover-options is deprecated and will be removed in a future release. Please use the full name instead.
170216 9:54:06 Plugin 'FEDERATED' is disabled.
170216 9:54:06 InnoDB: The InnoDB memory heap is disabled
170216 9:54:06 InnoDB: Mutexes and rw_locks use GCC atomic builtins
170216 9:54:06 InnoDB: Compressed tables use zlib 1.2.7
170216 9:54:06 InnoDB: Initializing buffer pool, size = 16.0M
170216 9:54:06 InnoDB: Completed initialization of buffer pool
170216 9:54:06 InnoDB: highest supported file format is Barracuda.
170216 9:54:06 InnoDB: Waiting for the background threads to start
170216 9:54:07 InnoDB: 5.5.48 started; log sequence number 3831310
170216 9:54:07 Aborting
170216 9:54:07 InnoDB: Starting shutdown...
170216 9:54:08 InnoDB: Shutdown completed; log sequence number 3831310
170216 9:54:08
170216 09:54:08 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended 先看一下硬盘或分区是否满了，检查一下mysql数据库目录权限
再看https://bbs.vpser.net/thread-14937-1-1.html
页:
[1]