MySQL一直在Centos上崩溃[关闭]

Question

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

Any idea what that might be ? This is the issue so far, And somehow it keeps crashing.. is there anything obvious, cause i dont see any reason for it to crash. Does anyone have any idea how to solve that ?

Answer 1

Try to change the owner.

chown -R mysql.mysql /var/lib/mysql

and make sure that "/var" and "/var/lib" retain their root.root ownership and 755 chmod. Let me know if it solve your problem.

---

EDIT: Please, just add the following code line option to "my.cnf" file under the [mysqld] section:

ignore-db-dir = lost+found

then restart mysql service.