6
回答
mysql无故崩溃,日志在此求问
百度AI开发者大赛带你边学边开发,赢100万奖金,加群:418589053   
140727 21:04:38 [Warning] 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.
140727 21:04:38 [Note] Plugin 'FEDERATED' is disabled.
140727 21:04:38 InnoDB: The InnoDB memory heap is disabled
140727 21:04:38 InnoDB: Mutexes and rw_locks use GCC atomic builtins
140727 21:04:38 InnoDB: Compressed tables use zlib 1.2.3.4
140727 21:04:38 InnoDB: Initializing buffer pool, size = 128.0M
140727 21:04:38 InnoDB: Completed initialization of buffer pool
140727 21:04:38 InnoDB: highest supported file format is Barracuda.
InnoDB: The log sequence number in ibdata files does not match
InnoDB: the log sequence number in the ib_logfiles!
140727 21:04:38  InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer...
140727 21:04:39  InnoDB: Waiting for the background threads to start
140727 21:04:40 InnoDB: 5.5.38 started; log sequence number 195543902
140727 21:04:40 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
140727 21:04:40 [Note]   - '0.0.0.0' resolves to '0.0.0.0';
140727 21:04:40 [Note] Server socket created on IP: '0.0.0.0'.
140727 21:04:41 [Note] Event Scheduler: Loaded 0 events
140727 21:04:41 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.5.38-0ubuntu0.12.04.1'  socket: '/var/run/mysqld/mysqld.sock'  port: 3306  (Ubuntu)
140727 21:05:16 [Warning] 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.
140727 21:05:16 [Note] Plugin 'FEDERATED' is disabled.
140727 21:05:16 InnoDB: The InnoDB memory heap is disabled
140727 21:05:16 InnoDB: Mutexes and rw_locks use GCC atomic builtins
140727 21:05:16 InnoDB: Compressed tables use zlib 1.2.3.4
140727 21:05:17 InnoDB: Initializing buffer pool, size = 128.0M
InnoDB: mmap(137363456 bytes) failed; errno 12
140727 21:05:21 InnoDB: Completed initialization of buffer pool
140727 21:05:21 InnoDB: Fatal error: cannot allocate memory for the buffer pool
140727 21:05:21 [ERROR] Plugin 'InnoDB' init function returned error.
140727 21:05:21 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
140727 21:05:21 [ERROR] Unknown/unsupported storage engine: InnoDB
140727 21:05:21 [ERROR] Aborting


140727 21:05:22 [Note] /usr/sbin/mysqld: Shutdown complete

140727 21:05:23 [Warning] 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.
140727 21:05:23 [Note] Plugin 'FEDERATED' is disabled.
140727 21:05:23 InnoDB: The InnoDB memory heap is disabled
140727 21:05:23 InnoDB: Mutexes and rw_locks use GCC atomic builtins
140727 21:05:23 InnoDB: Compressed tables use zlib 1.2.3.4
140727 21:05:23 InnoDB: Initializing buffer pool, size = 128.0M
140727 21:05:23 InnoDB: Completed initialization of buffer pool
140727 21:05:23 InnoDB: highest supported file format is Barracuda.
InnoDB: The log sequence number in ibdata files does not match
InnoDB: the log sequence number in the ib_logfiles!
140727 21:05:23  InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer...
140727 21:05:23  InnoDB: Waiting for the background threads to start
140727 21:05:24 InnoDB: 5.5.38 started; log sequence number 195543912
140727 21:05:24 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
140727 21:05:24 [Note]   - '0.0.0.0' resolves to '0.0.0.0';
140727 21:05:24 [Note] Server socket created on IP: '0.0.0.0'.
140727 21:05:24 [Note] Event Scheduler: Loaded 0 events
140727 21:05:24 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.5.38-0ubuntu0.12.04.1'  socket: '/var/run/mysqld/mysqld.sock'  port: 3306  (Ubuntu)
140727 21:06:07 [Warning] 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.
140727 21:06:07 [Note] Plugin 'FEDERATED' is disabled.
140727 21:06:07 InnoDB: The InnoDB memory heap is disabled
140727 21:06:07 InnoDB: Mutexes and rw_locks use GCC atomic builtins
140727 21:06:07 InnoDB: Compressed tables use zlib 1.2.3.4
140727 21:06:07 InnoDB: Initializing buffer pool, size = 128.0M
InnoDB: mmap(137363456 bytes) failed; errno 12
140727 21:06:07 InnoDB: Completed initialization of buffer pool
140727 21:06:07 InnoDB: Fatal error: cannot allocate memory for the buffer pool
140727 21:06:07 [ERROR] Plugin 'InnoDB' init function returned error.



这些都是从日志里面扒出来的……没有mysql报错调试的经验,请大家指正。

举报
王政
发帖于4年前 6回/4K+阅
顶部