MySQL 在 Centos 上不断崩溃


MySQL keeps crashing on Centos

141210 14:04:28 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
141210 14:04:28 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
141210 14:04:29 [Note] libgovernor.so not found
141210 14:04:29 [Warning] 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.
141210 14:04:29 [Warning] The syntax '--log-slow-queries' is deprecated and will be removed in a  future release. Please use '--slow-query-log'/'--slow-query-log-file' instead.
141210 14:04:29 [Note] Plugin 'FEDERATED' is disabled.
141210 14:04:29 InnoDB: The InnoDB memory heap is disabled
141210 14:04:29 InnoDB: Mutexes and rw_locks use GCC atomic builtins
141210 14:04:29 InnoDB: Compressed tables use zlib 1.2.3
141210 14:04:29 InnoDB: Using Linux native AIO
141210 14:04:29 InnoDB: Initializing buffer pool, size = 4.0G
141210 14:04:29 InnoDB: Completed initialization of buffer pool
141210 14:04:29 InnoDB: highest supported file format is Barracuda.
141210 14:04:37  InnoDB: Waiting for the background threads to start
141210 14:04:38 InnoDB: 5.5.36 started; log sequence number 1528598520104
141210 14:04:38 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
141210 14:04:38 [Note]   - '0.0.0.0' resolves to '0.0.0.0';
141210 14:04:38 [Note] Server socket created on IP: '0.0.0.0'.
141210 14:04:38 [Warning] 'proxies_priv' entry '@ ' ignored in --skip-name-resolve mode.
141210 14:04:38 [Note] Event Scheduler: Loaded 0 events
141210 14:04:38 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.5.36-cll-lve'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  MySQL Community Server  (GPL) by Atomicorp
141210 14:06:33 [Note] /usr/libexec/mysqld: Normal shutdown

知道那可能是什么吗?这是到目前为止的问题,不知何故它不断崩溃..有什么明显的东西,因为我看不出它崩溃的任何原因。有没有人知道如何解决这个问题?

尝试更改所有者。

chown -R mysql.mysql /var/lib/mysql
并确保"/var"和

"/var/lib"保留其root.root所有权和755 chmod。让我知道它是否解决了您的问题。


编辑:请将以下代码行选项添加到 [mysqld] 部分下的"my.cnf"文件中:

ignore-db-dir = lost+found

然后重新启动 MySQL 服务。