天天看點

看不懂mysql_mysql自動關閉,日志看不懂,希望大神解讀下

Version: ‘5.5.48’ socket: ‘/tmp/mysql.sock’ port: 3306 Source distribution

160515 14:15:17 mysqld_safe Number of processes running now: 0

160515 14:15:17 mysqld_safe mysqld restarted

160515 14:15:17 [Warning] ‘THREAD_CONCURRENCY’ is deprecated and will be removed in a future release.

160515 14:15:17 [Warning] ‘THREAD_CONCURRENCY’ is deprecated and will be removed in a future release.

160515 14:15:17 [Note] /www/wdlinux/mysql-5.5.48/bin/mysqld (mysqld 5.5.48) starting as process 23912 …

160515 14:15:18 [Note] Plugin ‘FEDERATED’ is disabled.

160515 14:15:18 InnoDB: The InnoDB memory heap is disabled

160515 14:15:18 InnoDB: Mutexes and rw_locks use GCC atomic builtins

160515 14:15:18 InnoDB: Compressed tables use zlib 1.2.7

160515 14:15:18 InnoDB: Initializing buffer pool, size = 128.0M

160515 14:15:18 InnoDB: Completed initialization of buffer pool

160515 14:15:18 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!

160515 14:15:18 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…

160515 14:15:18 InnoDB: Waiting for the background threads to start

160515 14:15:19 InnoDB: 5.5.48 started; log sequence number 1667632

160515 14:15:19 [Note] Server hostname (bind-address): ‘0.0.0.0’; port: 3306

160515 14:15:19 [Note] – ‘0.0.0.0’ resolves to ‘0.0.0.0’;

160515 14:15:19 [Note] Server socket created on IP: ‘0.0.0.0’.

160515 14:15:19 [Note] Event Scheduler: Loaded 0 events

160515 14:15:19 [Note] /www/wdlinux/mysql-5.5.48/bin/mysqld: ready for connections.

Version: ‘5.5.48’ socket: ‘/tmp/mysql.sock’ port: 3306 Source distribution

160515 14:35:28 mysqld_safe Number of processes running now: 0

160515 14:35:28 mysqld_safe mysqld restarted

160515 14:35:29 [Warning] ‘THREAD_CONCURRENCY’ is deprecated and will be removed in a future release.

160515 14:35:29 [Warning] ‘THREAD_CONCURRENCY’ is deprecated and will be removed in a future release.

160515 14:35:29 [Note] /www/wdlinux/mysql-5.5.48/bin/mysqld (mysqld 5.5.48) starting as process 24389 …

160515 14:35:29 [Note] Plugin ‘FEDERATED’ is disabled.

160515 14:35:29 InnoDB: The InnoDB memory heap is disabled

160515 14:35:29 InnoDB: Mutexes and rw_locks use GCC atomic builtins

160515 14:35:29 InnoDB: Compressed tables use zlib 1.2.7

160515 14:35:29 InnoDB: Initializing buffer pool, size = 128.0M

InnoDB: mmap(137363456 bytes) failed; errno 12

160515 14:35:29 InnoDB: Completed initialization of buffer pool

160515 14:35:29 InnoDB: Fatal error: cannot allocate memory for the buffer pool

160515 14:35:29 [ERROR] Plugin ‘InnoDB’ init function returned error.

160515 14:35:29 [ERROR] Plugin ‘InnoDB’ registration as a STORAGE ENGINE failed.

160515 14:35:29 [ERROR] Unknown/unsupported storage engine: InnoDB

160515 14:35:29 [ERROR] Aborting

160515 14:35:29 [Note] /www/wdlinux/mysql-5.5.48/bin/mysqld: Shutdown complete

160515 14:35:29 mysqld_safe mysqld from pid file /www/wdlinux/mysql-5.5.48/data/iZ236zu4tgyZ.pid ended

160515 14:58:19 mysqld_safe Starting mysqld daemon with databases from /www/wdlinux/mysql-5.5.48/data

160515 14:58:19 [Warning] ‘THREAD_CONCURRENCY’ is deprecated and will be removed in a future release.

160515 14:58:19 [Warning] ‘THREAD_CONCURRENCY’ is deprecated and will be removed in a future release.

160515 14:58:19 [Note] /www/wdlinux/mysql-5.5.48/bin/mysqld (mysqld 5.5.48) starting as process 25030 …

160515 14:58:19 [Note] Plugin ‘FEDERATED’ is disabled.

160515 14:58:19 InnoDB: The InnoDB memory heap is disabled

160515 14:58:19 InnoDB: Mutexes and rw_locks use GCC atomic builtins

160515 14:58:19 InnoDB: Compressed tables use zlib 1.2.7

160515 14:58:19 InnoDB: Initializing buffer pool, size = 128.0M

160515 14:58:19 InnoDB: Completed initialization of buffer pool

160515 14:58:19 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!

160515 14:58:19 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…

160515 14:58:19 InnoDB: Waiting for the background threads to start

160515 14:58:20 InnoDB: 5.5.48 started; log sequence number 1667642

160515 14:58:20 [Note] Server hostname (bind-address): ‘0.0.0.0’; port: 3306

160515 14:58:20 [Note] – ‘0.0.0.0’ resolves to ‘0.0.0.0’;

160515 14:58:20 [Note] Server socket created on IP: ‘0.0.0.0’.

160515 14:58:20 [Note] Event Scheduler: Loaded 0 events

160515 14:58:20 [Note] /www/wdlinux/mysql-5.5.48/bin/mysqld: ready for connections.

Version: ‘5.5.48’ socket: ‘/tmp/mysql.sock’ port: 3306 Source distribution

上面的關閉這段時間的錯誤日志内容,大概是怎麼一回事額

160515 14:35:29 InnoDB: Fatal error: cannot allocate memory for the buffer pool

看這個是機器記憶體太小,innodb的的buffer pool配置設定記憶體失敗