Skip to main content

mysql failed issue

pespatchs
Hello, I getting this error email twice in a day. mysql failed @ Wed Jul 16 13:07:07 2014. A restart was attempted automagically. mysql check was successful after restart. What can i do for solve this problem. :confused: And this is my space: df -h Filesystem Size Used Avail Use% Mounted on /dev/xvda 47G 18G 30G 38% / tmpfs 997M 0 997M 0% /dev/shm tmpfs 1.0G 44K 1.0G 1% /tmp tmpfs 1.0G 0 1.0G 0% /var/tmp InnoDB: mmap(137363456 bytes) failed; errno 12 2014-07-16 13:03:59 20859 [ERROR] InnoDB: Cannot allocate memory for the buffer pool 2014-07-16 13:03:59 20859 [ERROR] Plugin 'InnoDB' init function returned error. 2014-07-16 13:03:59 20859 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed. 2014-07-16 13:03:59 20859 [ERROR] Unknown/unsupported storage engine: InnoDB 2014-07-16 13:03:59 20859 [ERROR] Aborting 2014-07-16 13:03:59 20859 [Note] Binlog end 2014-07-16 13:03:59 20859 [Note] Shutting down plugin 'partition' 2014-07-16 13:03:59 20859 [Note] Shutting down plugin 'ARCHIVE' 2014-07-16 13:03:59 20859 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES' 2014-07-16 13:03:59 20859 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES' 2014-07-16 13:03:59 20859 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS' 2014-07-16 13:03:59 20859 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN' 2014-07-16 13:03:59 20859 [Note] Shutting down plugin 'INNODB_SYS_FIELDS' 2014-07-16 13:03:59 20859 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS' 2014-07-16 13:03:59 20859 [Note] Shutting down plugin 'INNODB_SYS_INDEXES' 2014-07-16 13:03:59 20859 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS' 2014-07-16 13:03:59 20859 [Note] Shutting down plugin 'INNODB_SYS_TABLES' 2014-07-16 13:03:59 20859 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE' 2014-07-16 13:03:59 20859 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE' 2014-07-16 13:03:59 20859 [Note] Shutting down plugin 'INNODB_FT_CONFIG' 2014-07-16 13:03:59 20859 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED' 2014-07-16 13:03:59 20859 [Note] Shutting down plugin 'INNODB_FT_DELETED' 2014-07-16 13:03:59 20859 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD' 2014-07-16 13:03:59 20859 [Note] Shutting down plugin 'INNODB_METRICS' 2014-07-16 13:03:59 20859 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS' 2014-07-16 13:03:59 20859 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU' 2014-07-16 13:03:59 20859 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE' 2014-07-16 13:03:59 20859 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET' 2014-07-16 13:03:59 20859 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX' 2014-07-16 13:03:59 20859 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET' 2014-07-16 13:03:59 20859 [Note] Shutting down plugin 'INNODB_CMPMEM' 2014-07-16 13:03:59 20859 [Note] Shutting down plugin 'INNODB_CMP_RESET' 2014-07-16 13:03:59 20859 [Note] Shutting down plugin 'INNODB_CMP' 2014-07-16 13:03:59 20859 [Note] Shutting down plugin 'INNODB_LOCK_WAITS' 2014-07-16 13:03:59 20859 [Note] Shutting down plugin 'INNODB_LOCKS' 2014-07-16 13:03:59 20859 [Note] Shutting down plugin 'INNODB_TRX' 2014-07-16 13:03:59 20859 [Note] Shutting down plugin 'BLACKHOLE' 2014-07-16 13:03:59 20859 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA' 2014-07-16 13:03:59 20859 [Note] Shutting down plugin 'MRG_MYISAM' 2014-07-16 13:03:59 20859 [Note] Shutting down plugin 'CSV' 2014-07-16 13:03:59 20859 [Note] Shutting down plugin 'MEMORY' 2014-07-16 13:03:59 20859 [Note] Shutting down plugin 'MyISAM' 2014-07-16 13:03:59 20859 [Note] Shutting down plugin 'sha256_password' 2014-07-16 13:03:59 20859 [Note] Shutting down plugin 'mysql_old_password' 2014-07-16 13:03:59 20859 [Note] Shutting down plugin 'mysql_native_password' 2014-07-16 13:03:59 20859 [Note] Shutting down plugin 'binlog' 2014-07-16 13:03:59 20859 [Note] /usr/sbin/mysqld: Shutdown complete 140716 13:03:59 mysqld_safe mysqld from pid file /var/lib/mysql/server.***.com.pid ended 140716 13:07:08 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql 2014-07-16 13:07:08 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2014-07-16 13:07:08 21534 [Note] Plugin 'FEDERATED' is disabled. 2014-07-16 13:07:08 7f9063f8e720 InnoDB: Warning: Using innodb_additional_mem_pool_size is DEPRECATED. This option may be removed in future releases, together with the option innodb_use_sys_malloc and with the InnoDB's internal memory allocator. 2014-07-16 13:07:08 21534 [Note] InnoDB: Using atomics to ref count buffer pool pages 2014-07-16 13:07:08 21534 [Note] InnoDB: The InnoDB memory heap is disabled 2014-07-16 13:07:08 21534 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2014-07-16 13:07:08 21534 [Note] InnoDB: Compressed tables use zlib 1.2.3 2014-07-16 13:07:08 21534 [Note] InnoDB: Using Linux native AIO 2014-07-16 13:07:08 21534 [Note] InnoDB: Using CPU crc32 instructions 2014-07-16 13:07:08 21534 [Note] InnoDB: Initializing buffer pool, size = 128.0M 2014-07-16 13:07:08 21534 [Note] InnoDB: Completed initialization of buffer pool 2014-07-16 13:07:09 21534 [Note] InnoDB: Highest supported file format is Barracuda. 2014-07-16 13:07:09 21534 [Note] InnoDB: The log sequence numbers 1237888075 and 1237888075 in ibdata files do not match the log sequence number 1263792999 in the ib_logfiles! 2014-07-16 13:07:09 21534 [Note] InnoDB: Database was not shutdown normally! 2014-07-16 13:07:09 21534 [Note] InnoDB: Starting crash recovery. 2014-07-16 13:07:09 21534 [Note] InnoDB: Reading tablespace information from the .ibd files... 2014-07-16 13:07:09 21534 [Note] InnoDB: Restoring possible half-written data pages 2014-07-16 13:07:09 21534 [Note] InnoDB: from the doublewrite buffer... 2014-07-16 13:07:09 21534 [Note] InnoDB: 128 rollback segment(s) are active. 2014-07-16 13:07:09 21534 [Note] InnoDB: Waiting for purge to start 2014-07-16 13:07:09 21534 [Note] InnoDB: 5.6.17 started; log sequence number 1263792999 2014-07-16 13:07:09 21534 [Note] Event Scheduler: Loaded 0 events 2014-07-16 13:07:09 21534 [Note] /usr/sbin/mysqld: ready for connections. Version: '5.6.17' socket: '/var/lib/mysql/mysql.sock' port: 0 MySQL Community Server (GPL) 140716 19:52:54 mysqld_safe Number of processes running now: 0 140716 19:52:54 mysqld_safe mysqld restarted 2014-07-16 19:52:54 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2014-07-16 19:52:55 32590 [Note] Plugin 'FEDERATED' is disabled. 2014-07-16 19:52:55 7f04a6c61720 InnoDB: Warning: Using innodb_additional_mem_pool_size is DEPRECATED. This option may be removed in future releases, together with the option innodb_use_sys_malloc and with the InnoDB's internal memory allocator. 2014-07-16 19:52:55 32590 [Note] InnoDB: Using atomics to ref count buffer pool pages 2014-07-16 19:52:55 32590 [Note] InnoDB: The InnoDB memory heap is disabled 2014-07-16 19:52:55 32590 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2014-07-16 19:52:55 32590 [Note] InnoDB: Compressed tables use zlib 1.2.3 2014-07-16 19:52:55 32590 [Note] InnoDB: Using Linux native AIO 2014-07-16 19:52:55 32590 [Note] InnoDB: Using CPU crc32 instructions 2014-07-16 19:52:55 32590 [Note] InnoDB: Initializing buffer pool, size = 128.0M 2014-07-16 19:52:55 32590 [Note] InnoDB: Completed initialization of buffer pool 2014-07-16 19:52:55 32590 [Note] InnoDB: Highest supported file format is Barracuda. 2014-07-16 19:52:55 32590 [Note] InnoDB: The log sequence numbers 1237888075 and 1237888075 in ibdata files do not match the log sequence number 1267043894 in the ib_logfiles! 2014-07-16 19:52:55 32590 [Note] InnoDB: Database was not shutdown normally! 2014-07-16 19:52:55 32590 [Note] InnoDB: Starting crash recovery. 2014-07-16 19:52:55 32590 [Note] InnoDB: Reading tablespace information from the .ibd files... 2014-07-16 19:52:55 32590 [Note] InnoDB: Restoring possible half-written data pages 2014-07-16 19:52:55 32590 [Note] InnoDB: from the doublewrite buffer... 2014-07-16 19:52:55 32590 [Note] InnoDB: 128 rollback segment(s) are active. 2014-07-16 19:52:55 32590 [Note] InnoDB: Waiting for purge to start 2014-07-16 19:52:55 32590 [Note] InnoDB: 5.6.17 started; log sequence number 1267043894 2014-07-16 19:52:55 32590 [Note] Event Scheduler: Loaded 0 events 2014-07-16 19:52:55 32590 [Note] /usr/sbin/mysqld: ready for connections. Version: '5.6.17' socket: '/var/lib/mysql/mysql.sock' port: 0 MySQL Community Server (GPL) 140716 20:56:31 mysqld_safe Number of processes running now: 0 140716 20:56:31 mysqld_safe mysqld restarted 2014-07-16 20:56:32 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2014-07-16 20:56:32 1848 [Note] Plugin 'FEDERATED' is disabled. 2014-07-16 20:56:32 7f42f58f3720 InnoDB: Warning: Using innodb_additional_mem_pool_size is DEPRECATED. This option may be removed in future releases, together with the option innodb_use_sys_malloc and with the InnoDB's internal memory allocator. 2014-07-16 20:56:32 1848 [Note] InnoDB: Using atomics to ref count buffer pool pages 2014-07-16 20:56:32 1848 [Note] InnoDB: The InnoDB memory heap is disabled 2014-07-16 20:56:32 1848 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2014-07-16 20:56:32 1848 [Note] InnoDB: Compressed tables use zlib 1.2.3 2014-07-16 20:56:32 1848 [Note] InnoDB: Using Linux native AIO 2014-07-16 20:56:32 1848 [Note] InnoDB: Using CPU crc32 instructions 2014-07-16 20:56:32 1848 [Note] InnoDB: Initializing buffer pool, size = 128.0M 2014-07-16 20:56:32 1848 [Note] InnoDB: Completed initialization of buffer pool 2014-07-16 20:56:32 1848 [Note] InnoDB: Highest supported file format is Barracuda. 2014-07-16 20:56:32 1848 [Note] InnoDB: The log sequence numbers 1237888075 and 1237888075 in ibdata files do not match the log sequence number 1267618723 in the ib_logfiles! 2014-07-16 20:56:32 1848 [Note] InnoDB: Database was not shutdown normally! 2014-07-16 20:56:32 1848 [Note] InnoDB: Starting crash recovery. 2014-07-16 20:56:32 1848 [Note] InnoDB: Reading tablespace information from the .ibd files... 2014-07-16 20:56:32 1848 [Note] InnoDB: Restoring possible half-written data pages 2014-07-16 20:56:32 1848 [Note] InnoDB: from the doublewrite buffer... 2014-07-16 20:56:32 1848 [Note] InnoDB: 128 rollback segment(s) are active. 2014-07-16 20:56:32 1848 [Note] InnoDB: Waiting for purge to start 2014-07-16 20:56:32 1848 [Note] InnoDB: 5.6.17 started; log sequence number 1267618723 2014-07-16 20:56:32 1848 [Note] Event Scheduler: Loaded 0 events 2014-07-16 20:56:32 1848 [Note] /usr/sbin/mysqld: ready for connections. Version: '5.6.17' socket: '/var/lib/mysql/mysql.sock' port: 0 MySQL Community Server (GPL) 140716 23:31:57 mysqld_safe Number of processes running now: 0 140716 23:31:58 mysqld_safe mysqld restarted 2014-07-16 23:31:59 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2014-07-16 23:31:59 6052 [Note] Plugin 'FEDERATED' is disabled. 2014-07-16 23:31:59 7f724733a720 InnoDB: Warning: Using innodb_additional_mem_pool_size is DEPRECATED. This option may be removed in future releases, together with the option innodb_use_sys_malloc and with the InnoDB's internal memory allocator. 2014-07-16 23:31:59 6052 [Note] InnoDB: Using atomics to ref count buffer pool pages 2014-07-16 23:31:59 6052 [Note] InnoDB: The InnoDB memory heap is disabled 2014-07-16 23:31:59 6052 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2014-07-16 23:31:59 6052 [Note] InnoDB: Compressed tables use zlib 1.2.3 2014-07-16 23:31:59 6052 [Note] InnoDB: Using Linux native AIO 2014-07-16 23:31:59 6052 [Note] InnoDB: Using CPU crc32 instructions 2014-07-16 23:32:00 6052 [Note] InnoDB: Initializing buffer pool, size = 128.0M 2014-07-16 23:32:00 6052 [Note] InnoDB: Completed initialization of buffer pool 2014-07-16 23:32:00 6052 [Note] InnoDB: Highest supported file format is Barracuda. 2014-07-16 23:32:00 6052 [Note] InnoDB: The log sequence numbers 1237888075 and 1237888075 in ibdata files do not match the log sequence number 1268656336 in the ib_logfiles! 2014-07-16 23:32:00 6052 [Note] InnoDB: Database was not shutdown normally! 2014-07-16 23:32:00 6052 [Note] InnoDB: Starting crash recovery. 2014-07-16 23:32:00 6052 [Note] InnoDB: Reading tablespace information from the .ibd files... 2014-07-16 23:32:00 6052 [Note] InnoDB: Restoring possible half-written data pages 2014-07-16 23:32:00 6052 [Note] InnoDB: from the doublewrite buffer... 2014-07-16 23:32:00 6052 [Note] InnoDB: 128 rollback segment(s) are active. 2014-07-16 23:32:00 6052 [Note] InnoDB: Waiting for purge to start 2014-07-16 23:32:00 6052 [Note] InnoDB: 5.6.17 started; log sequence number 1268656336 2014-07-16 23:32:00 6052 [Note] Event Scheduler: Loaded 0 events 2014-07-16 23:32:00 6052 [Note] /usr/sbin/mysqld: ready for connections. Version: '5.6.17' socket: '/var/lib/mysql/mysql.sock' port: 0 MySQL Community Server (GPL) 140716 23:32:10 mysqld_safe Number of processes running now: 0 140716 23:32:10 mysqld_safe mysqld restarted 2014-07-16 23:32:11 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2014-07-16 23:32:11 6116 [Note] Plugin 'FEDERATED' is disabled. 2014-07-16 23:32:11 7f3f60eec720 InnoDB: Warning: Using innodb_additional_mem_pool_size is DEPRECATED. This option may be removed in future releases, together with the option innodb_use_sys_malloc and with the InnoDB's internal memory allocator. 2014-07-16 23:32:11 6116 [Note] InnoDB: Using atomics to ref count buffer pool pages 2014-07-16 23:32:11 6116 [Note] InnoDB: The InnoDB memory heap is disabled 2014-07-16 23:32:11 6116 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2014-07-16 23:32:11 6116 [Note] InnoDB: Compressed tables use zlib 1.2.3 2014-07-16 23:32:11 6116 [Note] InnoDB: Using Linux native AIO 2014-07-16 23:32:11 6116 [Note] InnoDB: Using CPU crc32 instructions 2014-07-16 23:32:11 6116 [Note] InnoDB: Initializing buffer pool, size = 128.0M InnoDB: mmap(137363456 bytes) failed; errno 12 2014-07-16 23:32:17 6116 [ERROR] InnoDB: Cannot allocate memory for the buffer pool 2014-07-16 23:32:17 6116 [ERROR] Plugin 'InnoDB' init function returned error. 2014-07-16 23:32:17 6116 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed. 2014-07-16 23:32:17 6116 [ERROR] Unknown/unsupported storage engine: InnoDB 2014-07-16 23:32:17 6116 [ERROR] Aborting 2014-07-16 23:32:17 6116 [Note] Binlog end 2014-07-16 23:32:17 6116 [Note] Shutting down plugin 'partition' 2014-07-16 23:32:17 6116 [Note] Shutting down plugin 'ARCHIVE' 2014-07-16 23:32:17 6116 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES' 2014-07-16 23:32:17 6116 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES' 2014-07-16 23:32:17 6116 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS' 2014-07-16 23:32:17 6116 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN' 2014-07-16 23:32:17 6116 [Note] Shutting down plugin 'INNODB_SYS_FIELDS' 2014-07-16 23:32:17 6116 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS' 2014-07-16 23:32:17 6116 [Note] Shutting down plugin 'INNODB_SYS_INDEXES' 2014-07-16 23:32:17 6116 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS' 2014-07-16 23:32:17 6116 [Note] Shutting down plugin 'INNODB_SYS_TABLES' 2014-07-16 23:32:17 6116 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE' 2014-07-16 23:32:17 6116 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE' 2014-07-16 23:32:17 6116 [Note] Shutting down plugin 'INNODB_FT_CONFIG' 2014-07-16 23:32:17 6116 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED' 2014-07-16 23:32:17 6116 [Note] Shutting down plugin 'INNODB_FT_DELETED' 2014-07-16 23:32:17 6116 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD' 2014-07-16 23:32:17 6116 [Note] Shutting down plugin 'INNODB_METRICS' 2014-07-16 23:32:17 6116 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS' 2014-07-16 23:32:17 6116 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU' 2014-07-16 23:32:17 6116 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE' 2014-07-16 23:32:17 6116 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET' 2014-07-16 23:32:17 6116 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX' 2014-07-16 23:32:17 6116 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET' 2014-07-16 23:32:17 6116 [Note] Shutting down plugin 'INNODB_CMPMEM' 2014-07-16 23:32:17 6116 [Note] Shutting down plugin 'INNODB_CMP_RESET' 2014-07-16 23:32:17 6116 [Note] Shutting down plugin 'INNODB_CMP' 2014-07-16 23:32:17 6116 [Note] Shutting down plugin 'INNODB_LOCK_WAITS' 2014-07-16 23:32:17 6116 [Note] Shutting down plugin 'INNODB_LOCKS' 2014-07-16 23:32:17 6116 [Note] Shutting down plugin 'INNODB_TRX' 2014-07-16 23:32:17 6116 [Note] Shutting down plugin 'BLACKHOLE' 2014-07-16 23:32:17 6116 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA' 2014-07-16 23:32:17 6116 [Note] Shutting down plugin 'MRG_MYISAM' 2014-07-16 23:32:17 6116 [Note] Shutting down plugin 'CSV' 2014-07-16 23:32:17 6116 [Note] Shutting down plugin 'MEMORY' 2014-07-16 23:32:17 6116 [Note] Shutting down plugin 'MyISAM' 2014-07-16 23:32:17 6116 [Note] Shutting down plugin 'sha256_password' 2014-07-16 23:32:17 6116 [Note] Shutting down plugin 'mysql_old_password' 2014-07-16 23:32:17 6116 [Note] Shutting down plugin 'mysql_native_password' 2014-07-16 23:32:17 6116 [Note] Shutting down plugin 'binlog' 2014-07-16 23:32:17 6116 [Note] /usr/sbin/mysqld: Shutdown complete 140716 23:32:17 mysqld_safe mysqld from pid file /var/lib/mysql/server.***.com.pid ended 140716 23:34:15 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql 2014-07-16 23:34:15 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2014-07-16 23:34:15 6689 [Note] Plugin 'FEDERATED' is disabled. 2014-07-16 23:34:16 7f8627e8f720 InnoDB: Warning: Using innodb_additional_mem_pool_size is DEPRECATED. This option may be removed in future releases, together with the option innodb_use_sys_malloc and with the InnoDB's internal memory allocator. 2014-07-16 23:34:16 6689 [Note] InnoDB: Using atomics to ref count buffer pool pages 2014-07-16 23:34:16 6689 [Note] InnoDB: The InnoDB memory heap is disabled 2014-07-16 23:34:16 6689 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2014-07-16 23:34:16 6689 [Note] InnoDB: Compressed tables use zlib 1.2.3 2014-07-16 23:34:16 6689 [Note] InnoDB: Using Linux native AIO 2014-07-16 23:34:16 6689 [Note] InnoDB: Using CPU crc32 instructions 2014-07-16 23:34:16 6689 [Note] InnoDB: Initializing buffer pool, size = 128.0M 2014-07-16 23:34:16 6689 [Note] InnoDB: Completed initialization of buffer pool 2014-07-16 23:34:16 6689 [Note] InnoDB: Highest supported file format is Barracuda. 2014-07-16 23:34:16 6689 [Note] InnoDB: Log scan progressed past the checkpoint lsn 1268656346 2014-07-16 23:34:16 6689 [Note] InnoDB: Database was not shutdown normally! 2014-07-16 23:34:16 6689 [Note] InnoDB: Starting crash recovery. 2014-07-16 23:34:16 6689 [Note] InnoDB: Reading tablespace information from the .ibd files... 2014-07-16 23:34:16 6689 [Note] InnoDB: Restoring possible half-written data pages 2014-07-16 23:34:16 6689 [Note] InnoDB: from the doublewrite buffer... InnoDB: Doing recovery: scanned up to log sequence number 1268658608 2014-07-16 23:34:16 6689 [Note] InnoDB: Starting an apply batch of log records to the database... InnoDB: Progress in percent: 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 InnoDB: Apply batch completed 2014-07-16 23:34:16 6689 [Note] InnoDB: 128 rollback segment(s) are active. 2014-07-16 23:34:16 6689 [Note] InnoDB: Waiting for purge to start 2014-07-16 23:34:16 6689 [Note] InnoDB: 5.6.17 started; log sequence number 1268658608 2014-07-16 23:34:16 6689 [Note] Event Scheduler: Loaded 0 events 2014-07-16 23:34:16 6689 [Note] /usr/sbin/mysqld: ready for connections. Version: '5.6.17' socket: '/var/lib/mysql/mysql.sock' port: 0 MySQL Community Server (GPL) 140716 23:39:54 mysqld_safe Number of processes running now: 0 140716 23:39:54 mysqld_safe mysqld restarted 2014-07-16 23:39:54 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2014-07-16 23:39:54 7066 [Note] Plugin 'FEDERATED' is disabled. 2014-07-16 23:39:54 7fb5174fb720 InnoDB: Warning: Using innodb_additional_mem_pool_size is DEPRECATED. This option may be removed in future releases, together with the option innodb_use_sys_malloc and with the InnoDB's internal memory allocator. 2014-07-16 23:39:54 7066 [Note] InnoDB: Using atomics to ref count buffer pool pages 2014-07-16 23:39:54 7066 [Note] InnoDB: The InnoDB memory heap is disabled 2014-07-16 23:39:54 7066 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2014-07-16 23:39:54 7066 [Note] InnoDB: Compressed tables use zlib 1.2.3 2014-07-16 23:39:54 7066 [Note] InnoDB: Using Linux native AIO 2014-07-16 23:39:54 7066 [Note] InnoDB: Using CPU crc32 instructions 2014-07-16 23:39:54 7066 [Note] InnoDB: Initializing buffer pool, size = 128.0M 2014-07-16 23:39:54 7066 [Note] InnoDB: Completed initialization of buffer pool 2014-07-16 23:39:54 7066 [Note] InnoDB: Highest supported file format is Barracuda. 2014-07-16 23:39:54 7066 [Note] InnoDB: The log sequence numbers 1237888075 and 1237888075 in ibdata files do not match the log sequence number 1268702548 in the ib_logfiles! 2014-07-16 23:39:54 7066 [Note] InnoDB: Database was not shutdown normally! 2014-07-16 23:39:54 7066 [Note] InnoDB: Starting crash recovery. 2014-07-16 23:39:54 7066 [Note] InnoDB: Reading tablespace information from the .ibd files... 2014-07-16 23:39:54 7066 [Note] InnoDB: Restoring possible half-written data pages 2014-07-16 23:39:54 7066 [Note] InnoDB: from the doublewrite buffer... 2014-07-16 23:39:55 7066 [Note] InnoDB: 128 rollback segment(s) are active. 2014-07-16 23:39:55 7066 [Note] InnoDB: Waiting for purge to start 2014-07-16 23:39:55 7066 [Note] InnoDB: 5.6.17 started; log sequence number 1268702548 2014-07-16 23:39:55 7066 [Note] Event Scheduler: Loaded 0 events 2014-07-16 23:39:55 7066 [Note] /usr/sbin/mysqld: ready for connections.

Comments

10 comments

Date Votes
  • soja92
    How much memory does your virtual server have? Are you running out?
    0
  • cPanelMichael
    Hello :) Please post the contents of your /etc/my.cnf file. Also, have you verified that InnoDB is not corrupt? Thank you.
    0
  • pespatchs
    i have second plan - Removed - . it has 2 GB RAM 2 CPU Cores 48 GB SSD Storage 3 TB Transfer 40 Gbit Network In 250 Mbit Network Out i have 9 wordpress blog in server and has totaly around 7-8k visitors per day. Also i dont know anythin about innodb. how can i check it. [mysqld] performance_schema=off skip-networking innodb_file_per_table=1 tmpdir=/tmp max_connections=500 max_user_connections=500 key_buffer_size=512M myisam_sort_buffer_size=192M join_buffer_size=1M read_buffer_size=128K sort_buffer_size=128K table_open_cache=3072 thread_cache_size=1024 table_definition_cache=2048 open_files_limit=52000 wait_timeout=60 connect_timeout=60 tmp_table_size=128M max_heap_table_size=128M max_allowed_packet=268435456 thread_concurrency=8 query_cache_limit=4M query_cache_size=128M query_cache_type=1 interactive_timeout=60 max_connect_errors=15 local-infile=0 innodb_buffer_pool_size=128M innodb_additional_mem_pool_size=64M innodb_thread_concurrency=4 innodb_flush_method=O_DIRECT low_priority_updates=1 [isamchk] key_buffer=512M sort_buffer_size=2M read_buffer=2M write_buffer=2M [myisamchk] tmpdir=/tmp key_buffer=512M sort_buffer=2M read_buffer=2M write_buffer=2M
    0
  • SS-Maddy
    looks like an issue with the primary memory allocation. You may try it after reducing innodb_buffer_pool_size. Though recommended values for this variable can be upto 50% of RAM available, lower values rarely affects the performance for less busy sites as it flushes at regular intervals. If the issue persists, please provide the RAM availability using the command "free -m"
    0
  • pespatchs
    I changed innodb like this: innodb_buffer_pool_size=64M innodb_additional_mem_pool_size=32M innodb_thread_concurrency=8 innodb_flush_method=O_DIRECT low_priority_updates=1 i replaced it correct ? :confused: # free -m total used free shared buffers cached Mem: 1992 1647 345 0 63 978 -/+ buffers/cache: 604 1388 Swap: 255 106 149
    and this is top: top - 02:38:55 up 3 days, 15:37, 1 user, load average: 0.07, 0.10, 0.15 Tasks: 118 total, 1 running, 117 sleeping, 0 stopped, 0 zombie Cpu(s): 1.5%us, 0.2%sy, 0.0%ni, 98.3%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st Mem: 2040784k total, 1726696k used, 314088k free, 65428k buffers Swap: 262140k total, 109536k used, 152604k free, 1032460k cached
    0
  • pespatchs
    innodb_buffer_pool_size=64M innodb_additional_mem_pool_size=32M innodb_thread_concurrency=8 innodb_flush_method=O_DIRECT low_priority_updates=1 This is worked. Thanks ! I dont get any email from cpanel anymore :)
    0
  • pespatchs
    my problems started again :( 2014-07-24 20:38:00 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2014-07-24 20:38:00 2340 [Note] Plugin 'FEDERATED' is disabled. 2014-07-24 20:38:00 7f3e79681720 InnoDB: Warning: Using innodb_additional_mem_pool_size is DEPRECATED. This option may be removed in future releases, together with the option innodb_use_sys_malloc and with the InnoDB's internal memory allocator. 2014-07-24 20:38:00 2340 [Note] InnoDB: Using atomics to ref count buffer pool pages 2014-07-24 20:38:00 2340 [Note] InnoDB: The InnoDB memory heap is disabled 2014-07-24 20:38:00 2340 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2014-07-24 20:38:00 2340 [Note] InnoDB: Compressed tables use zlib 1.2.3 2014-07-24 20:38:00 2340 [Note] InnoDB: Using Linux native AIO 2014-07-24 20:38:00 2340 [Note] InnoDB: Using CPU crc32 instructions 2014-07-24 20:38:00 2340 [Note] InnoDB: Initializing buffer pool, size = 64.0M 2014-07-24 20:38:00 2340 [Note] InnoDB: Completed initialization of buffer pool 2014-07-24 20:38:00 2340 [Note] InnoDB: Highest supported file format is Barracuda. 2014-07-24 20:38:00 2340 [Note] InnoDB: The log sequence numbers 1280623333 and 1280623333 in ibdata files do not match the log sequence number 1353690681 in the ib_logfiles! 2014-07-24 20:38:00 2340 [Note] InnoDB: Database was not shutdown normally! 2014-07-24 20:38:00 2340 [Note] InnoDB: Starting crash recovery. 2014-07-24 20:38:00 2340 [Note] InnoDB: Reading tablespace information from the .ibd files... 2014-07-24 20:38:00 2340 [Note] InnoDB: Restoring possible half-written data pages 2014-07-24 20:38:00 2340 [Note] InnoDB: from the doublewrite buffer... 2014-07-24 20:38:01 2340 [Note] InnoDB: 128 rollback segment(s) are active. 2014-07-24 20:38:01 2340 [Note] InnoDB: Waiting for purge to start 2014-07-24 20:38:01 2340 [Note] InnoDB: 5.6.17 started; log sequence number 1353690681 2014-07-24 20:38:01 2340 [Note] Event Scheduler: Loaded 0 events 2014-07-24 20:38:01 2340 [Note] /usr/sbin/mysqld: ready for connections. Version: '5.6.17' socket: '/var/lib/mysql/mysql.sock' port: 0 MySQL Community Server (GPL) 140724 23:15:35 mysqld_safe Number of processes running now: 0 140724 23:15:35 mysqld_safe mysqld restarted 2014-07-24 23:15:36 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2014-07-24 23:15:36 11761 [Note] Plugin 'FEDERATED' is disabled. 2014-07-24 23:15:36 7f562449a720 InnoDB: Warning: Using innodb_additional_mem_pool_size is DEPRECATED. This option may be removed in future releases, together with the option innodb_use_sys_malloc and with the InnoDB's internal memory allocator. 2014-07-24 23:15:36 11761 [Note] InnoDB: Using atomics to ref count buffer pool pages 2014-07-24 23:15:36 11761 [Note] InnoDB: The InnoDB memory heap is disabled 2014-07-24 23:15:36 11761 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2014-07-24 23:15:36 11761 [Note] InnoDB: Compressed tables use zlib 1.2.3 2014-07-24 23:15:36 11761 [Note] InnoDB: Using Linux native AIO 2014-07-24 23:15:36 11761 [Note] InnoDB: Using CPU crc32 instructions 2014-07-24 23:15:36 11761 [Note] InnoDB: Initializing buffer pool, size = 64.0M 2014-07-24 23:15:36 11761 [Note] InnoDB: Completed initialization of buffer pool 2014-07-24 23:15:36 11761 [Note] InnoDB: Highest supported file format is Barracuda. 2014-07-24 23:15:36 11761 [Note] InnoDB: The log sequence numbers 1280623333 and 1280623333 in ibdata files do not match the log sequence number 1354940900 in the ib_logfiles! 2014-07-24 23:15:36 11761 [Note] InnoDB: Database was not shutdown normally! 2014-07-24 23:15:36 11761 [Note] InnoDB: Starting crash recovery. 2014-07-24 23:15:36 11761 [Note] InnoDB: Reading tablespace information from the .ibd files... 2014-07-24 23:15:36 11761 [Note] InnoDB: Restoring possible half-written data pages 2014-07-24 23:15:36 11761 [Note] InnoDB: from the doublewrite buffer... 2014-07-24 23:15:36 11761 [Note] InnoDB: 128 rollback segment(s) are active. 2014-07-24 23:15:36 11761 [Note] InnoDB: Waiting for purge to start 2014-07-24 23:15:36 11761 [Note] InnoDB: 5.6.17 started; log sequence number 1354940900 2014-07-24 23:15:36 11761 [Note] Event Scheduler: Loaded 0 events 2014-07-24 23:15:36 11761 [Note] /usr/sbin/mysqld: ready for connections. Version: '5.6.17' socket: '/var/lib/mysql/mysql.sock' port: 0 MySQL Community Server (GPL) 140725 00:10:27 mysqld_safe Number of processes running now: 0 140725 00:10:27 mysqld_safe mysqld restarted 2014-07-25 00:10:27 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2014-07-25 00:10:27 16014 [Note] Plugin 'FEDERATED' is disabled. 2014-07-25 00:10:27 7fca49b5d720 InnoDB: Warning: Using innodb_additional_mem_pool_size is DEPRECATED. This option may be removed in future releases, together with the option innodb_use_sys_malloc and with the InnoDB's internal memory allocator. 2014-07-25 00:10:27 16014 [Note] InnoDB: Using atomics to ref count buffer pool pages 2014-07-25 00:10:27 16014 [Note] InnoDB: The InnoDB memory heap is disabled 2014-07-25 00:10:27 16014 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2014-07-25 00:10:27 16014 [Note] InnoDB: Compressed tables use zlib 1.2.3 2014-07-25 00:10:27 16014 [Note] InnoDB: Using Linux native AIO 2014-07-25 00:10:27 16014 [Note] InnoDB: Using CPU crc32 instructions 2014-07-25 00:10:28 16014 [Note] InnoDB: Initializing buffer pool, size = 64.0M 2014-07-25 00:10:28 16014 [Note] InnoDB: Completed initialization of buffer pool 2014-07-25 00:10:28 16014 [Note] InnoDB: Highest supported file format is Barracuda. 2014-07-25 00:10:28 16014 [Note] InnoDB: Log scan progressed past the checkpoint lsn 1355380512 2014-07-25 00:10:28 16014 [Note] InnoDB: Database was not shutdown normally! 2014-07-25 00:10:28 16014 [Note] InnoDB: Starting crash recovery. 2014-07-25 00:10:28 16014 [Note] InnoDB: Reading tablespace information from the .ibd files... 2014-07-25 00:10:28 16014 [Note] InnoDB: Restoring possible half-written data pages 2014-07-25 00:10:28 16014 [Note] InnoDB: from the doublewrite buffer... InnoDB: Doing recovery: scanned up to log sequence number 1355389371 2014-07-25 00:10:28 16014 [Note] InnoDB: Starting an apply batch of log records to the database... InnoDB: Progress in percent: 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 InnoDB: Apply batch completed 2014-07-25 00:10:29 16014 [Note] InnoDB: 128 rollback segment(s) are active. 2014-07-25 00:10:29 16014 [Note] InnoDB: Waiting for purge to start 2014-07-25 00:10:29 16014 [Note] InnoDB: 5.6.17 started; log sequence number 1355389371 2014-07-25 00:10:29 16014 [Note] Event Scheduler: Loaded 0 events 2014-07-25 00:10:29 16014 [Note] /usr/sbin/mysqld: ready for connections. Version: '5.6.17' socket: '/var/lib/mysql/mysql.sock' port: 0 MySQL Community Server (GPL) 140725 12:03:56 mysqld_safe Number of processes running now: 0 140725 12:03:56 mysqld_safe mysqld restarted 2014-07-25 12:03:56 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2014-07-25 12:03:56 5641 [Note] Plugin 'FEDERATED' is disabled. 2014-07-25 12:03:56 7f5514d15720 InnoDB: Warning: Using innodb_additional_mem_pool_size is DEPRECATED. This option may be removed in future releases, together with the option innodb_use_sys_malloc and with the InnoDB's internal memory allocator. 2014-07-25 12:03:56 5641 [Note] InnoDB: Using atomics to ref count buffer pool pages 2014-07-25 12:03:56 5641 [Note] InnoDB: The InnoDB memory heap is disabled 2014-07-25 12:03:56 5641 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2014-07-25 12:03:56 5641 [Note] InnoDB: Compressed tables use zlib 1.2.3 2014-07-25 12:03:56 5641 [Note] InnoDB: Using Linux native AIO 2014-07-25 12:03:57 5641 [Note] InnoDB: Using CPU crc32 instructions 2014-07-25 12:03:57 5641 [Note] InnoDB: Initializing buffer pool, size = 64.0M 2014-07-25 12:03:57 5641 [Note] InnoDB: Completed initialization of buffer pool 2014-07-25 12:03:57 5641 [Note] InnoDB: Highest supported file format is Barracuda. 2014-07-25 12:03:57 5641 [Note] InnoDB: The log sequence numbers 1280623333 and 1280623333 in ibdata files do not match the log sequence number 1361756052 in the ib_logfiles! 2014-07-25 12:03:57 5641 [Note] InnoDB: Database was not shutdown normally! 2014-07-25 12:03:57 5641 [Note] InnoDB: Starting crash recovery. 2014-07-25 12:03:57 5641 [Note] InnoDB: Reading tablespace information from the .ibd files... 2014-07-25 12:03:57 5641 [Note] InnoDB: Restoring possible half-written data pages 2014-07-25 12:03:57 5641 [Note] InnoDB: from the doublewrite buffer... 2014-07-25 12:03:57 5641 [Note] InnoDB: 128 rollback segment(s) are active. 2014-07-25 12:03:57 5641 [Note] InnoDB: Waiting for purge to start 2014-07-25 12:03:57 5641 [Note] InnoDB: 5.6.17 started; log sequence number 1361756052 2014-07-25 12:03:57 5641 [Note] Event Scheduler: Loaded 0 events 2014-07-25 12:03:57 5641 [Note] /usr/sbin/mysqld: ready for connections. Version: '5.6.17' socket: '/var/lib/mysql/mysql.sock' port: 0 MySQL Community Server (GPL) 140725 20:11:38 mysqld_safe Number of processes running now: 0 140725 20:11:38 mysqld_safe mysqld restarted 2014-07-25 20:11:38 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2014-07-25 20:11:39 14366 [Note] Plugin 'FEDERATED' is disabled. 2014-07-25 20:11:39 7f31faae9720 InnoDB: Warning: Using innodb_additional_mem_pool_size is DEPRECATED. This option may be removed in future releases, together with the option innodb_use_sys_malloc and with the InnoDB's internal memory allocator. 2014-07-25 20:11:39 14366 [Note] InnoDB: Using atomics to ref count buffer pool pages 2014-07-25 20:11:39 14366 [Note] InnoDB: The InnoDB memory heap is disabled 2014-07-25 20:11:39 14366 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2014-07-25 20:11:39 14366 [Note] InnoDB: Compressed tables use zlib 1.2.3 2014-07-25 20:11:39 14366 [Note] InnoDB: Using Linux native AIO 2014-07-25 20:11:39 14366 [Note] InnoDB: Using CPU crc32 instructions 2014-07-25 20:11:39 14366 [Note] InnoDB: Initializing buffer pool, size = 64.0M 2014-07-25 20:11:39 14366 [Note] InnoDB: Completed initialization of buffer pool 2014-07-25 20:11:39 14366 [Note] InnoDB: Highest supported file format is Barracuda. 2014-07-25 20:11:39 14366 [Note] InnoDB: The log sequence numbers 1280623333 and 1280623333 in ibdata files do not match the log sequence number 1366223808 in the ib_logfiles! 2014-07-25 20:11:39 14366 [Note] InnoDB: Database was not shutdown normally! 2014-07-25 20:11:39 14366 [Note] InnoDB: Starting crash recovery. 2014-07-25 20:11:39 14366 [Note] InnoDB: Reading tablespace information from the .ibd files... 2014-07-25 20:11:39 14366 [Note] InnoDB: Restoring possible half-written data pages 2014-07-25 20:11:39 14366 [Note] InnoDB: from the doublewrite buffer... 2014-07-25 20:11:39 14366 [Note] InnoDB: 128 rollback segment(s) are active. 2014-07-25 20:11:39 14366 [Note] InnoDB: Waiting for purge to start 2014-07-25 20:11:39 14366 [Note] InnoDB: 5.6.17 started; log sequence number 1366223808 2014-07-25 20:11:39 14366 [Note] Event Scheduler: Loaded 0 events 2014-07-25 20:11:39 14366 [Note] /usr/sbin/mysqld: ready for connections. Version: '5.6.17' socket: '/var/lib/mysql/mysql.sock' port: 0 MySQL Community Server (GPL) 140725 20:11:45 mysqld_safe Number of processes running now: 0 140725 20:11:45 mysqld_safe mysqld restarted 2014-07-25 20:11:45 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2014-07-25 20:11:45 14410 [Note] Plugin 'FEDERATED' is disabled. 2014-07-25 20:11:45 7f23e3b94720 InnoDB: Warning: Using innodb_additional_mem_pool_size is DEPRECATED. This option may be removed in future releases, together with the option innodb_use_sys_malloc and with the InnoDB's internal memory allocator. 2014-07-25 20:11:45 14410 [Note] InnoDB: Using atomics to ref count buffer pool pages 2014-07-25 20:11:45 14410 [Note] InnoDB: The InnoDB memory heap is disabled 2014-07-25 20:11:45 14410 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2014-07-25 20:11:45 14410 [Note] InnoDB: Compressed tables use zlib 1.2.3 2014-07-25 20:11:45 14410 [Note] InnoDB: Using Linux native AIO 2014-07-25 20:11:45 14410 [Note] InnoDB: Using CPU crc32 instructions 2014-07-25 20:11:45 14410 [Note] InnoDB: Initializing buffer pool, size = 64.0M InnoDB: mmap(68681728 bytes) failed; errno 12 2014-07-25 20:11:45 14410 [ERROR] InnoDB: Cannot allocate memory for the buffer pool 2014-07-25 20:11:45 14410 [ERROR] Plugin 'InnoDB' init function returned error. 2014-07-25 20:11:45 14410 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed. 2014-07-25 20:11:45 14410 [ERROR] Unknown/unsupported storage engine: InnoDB 2014-07-25 20:11:45 14410 [ERROR] Aborting 2014-07-25 20:11:45 14410 [Note] Binlog end 2014-07-25 20:11:46 14410 [Note] Shutting down plugin 'partition' 2014-07-25 20:11:46 14410 [Note] Shutting down plugin 'ARCHIVE' 2014-07-25 20:11:46 14410 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES' 2014-07-25 20:11:46 14410 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES' 2014-07-25 20:11:46 14410 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS' 2014-07-25 20:11:46 14410 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN' 2014-07-25 20:11:46 14410 [Note] Shutting down plugin 'INNODB_SYS_FIELDS' 2014-07-25 20:11:46 14410 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS' 2014-07-25 20:11:46 14410 [Note] Shutting down plugin 'INNODB_SYS_INDEXES' 2014-07-25 20:11:46 14410 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS' 2014-07-25 20:11:46 14410 [Note] Shutting down plugin 'INNODB_SYS_TABLES' 2014-07-25 20:11:46 14410 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE' 2014-07-25 20:11:46 14410 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE' 2014-07-25 20:11:46 14410 [Note] Shutting down plugin 'INNODB_FT_CONFIG' 2014-07-25 20:11:46 14410 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED' 2014-07-25 20:11:46 14410 [Note] Shutting down plugin 'INNODB_FT_DELETED' 2014-07-25 20:11:46 14410 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD' 2014-07-25 20:11:46 14410 [Note] Shutting down plugin 'INNODB_METRICS' 2014-07-25 20:11:46 14410 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS' 2014-07-25 20:11:46 14410 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU' 2014-07-25 20:11:46 14410 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE' 2014-07-25 20:11:46 14410 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET' 2014-07-25 20:11:46 14410 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX' 2014-07-25 20:11:46 14410 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET' 2014-07-25 20:11:46 14410 [Note] Shutting down plugin 'INNODB_CMPMEM' 2014-07-25 20:11:46 14410 [Note] Shutting down plugin 'INNODB_CMP_RESET' 2014-07-25 20:11:46 14410 [Note] Shutting down plugin 'INNODB_CMP' 2014-07-25 20:11:46 14410 [Note] Shutting down plugin 'INNODB_LOCK_WAITS' 2014-07-25 20:11:46 14410 [Note] Shutting down plugin 'INNODB_LOCKS' 2014-07-25 20:11:46 14410 [Note] Shutting down plugin 'INNODB_TRX' 2014-07-25 20:11:46 14410 [Note] Shutting down plugin 'BLACKHOLE' 2014-07-25 20:11:46 14410 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA' 2014-07-25 20:11:46 14410 [Note] Shutting down plugin 'MRG_MYISAM' 2014-07-25 20:11:46 14410 [Note] Shutting down plugin 'CSV' 2014-07-25 20:11:46 14410 [Note] Shutting down plugin 'MEMORY' 2014-07-25 20:11:46 14410 [Note] Shutting down plugin 'MyISAM' 2014-07-25 20:11:46 14410 [Note] Shutting down plugin 'sha256_password' 2014-07-25 20:11:46 14410 [Note] Shutting down plugin 'mysql_old_password' 2014-07-25 20:11:46 14410 [Note] Shutting down plugin 'mysql_native_password' 2014-07-25 20:11:46 14410 [Note] Shutting down plugin 'binlog' 2014-07-25 20:11:46 14410 [Note] /usr/sbin/mysqld: Shutdown complete 140725 20:11:46 mysqld_safe mysqld from pid file /var/lib/mysql/server.swankyrecipes.com.pid ended 140725 20:16:14 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql 2014-07-25 20:16:14 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2014-07-25 20:16:15 15067 [Note] Plugin 'FEDERATED' is disabled. 2014-07-25 20:16:15 7f1db3ef6720 InnoDB: Warning: Using innodb_additional_mem_pool_size is DEPRECATED. This option may be removed in future releases, together with the option innodb_use_sys_malloc and with the InnoDB's internal memory allocator. 2014-07-25 20:16:15 15067 [Note] InnoDB: Using atomics to ref count buffer pool pages 2014-07-25 20:16:15 15067 [Note] InnoDB: The InnoDB memory heap is disabled 2014-07-25 20:16:15 15067 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2014-07-25 20:16:15 15067 [Note] InnoDB: Compressed tables use zlib 1.2.3 2014-07-25 20:16:15 15067 [Note] InnoDB: Using Linux native AIO 2014-07-25 20:16:15 15067 [Note] InnoDB: Using CPU crc32 instructions 2014-07-25 20:16:15 15067 [Note] InnoDB: Initializing buffer pool, size = 64.0M 2014-07-25 20:16:15 15067 [Note] InnoDB: Completed initialization of buffer pool 2014-07-25 20:16:15 15067 [Note] InnoDB: Highest supported file format is Barracuda. 2014-07-25 20:16:15 15067 [Note] InnoDB: Log scan progressed past the checkpoint lsn 1366223818 2014-07-25 20:16:15 15067 [Note] InnoDB: Database was not shutdown normally! 2014-07-25 20:16:15 15067 [Note] InnoDB: Starting crash recovery. 2014-07-25 20:16:15 15067 [Note] InnoDB: Reading tablespace information from the .ibd files... 2014-07-25 20:16:15 15067 [Note] InnoDB: Restoring possible half-written data pages 2014-07-25 20:16:15 15067 [Note] InnoDB: from the doublewrite buffer... InnoDB: Doing recovery: scanned up to log sequence number 1366227215 2014-07-25 20:16:15 15067 [Note] InnoDB: 128 rollback segment(s) are active. 2014-07-25 20:16:15 15067 [Note] InnoDB: Waiting for purge to start 2014-07-25 20:16:15 15067 [Note] InnoDB: 5.6.17 started; log sequence number 1366227215 2014-07-25 20:16:15 15067 [Note] Event Scheduler: Loaded 0 events 2014-07-25 20:16:15 15067 [Note] /usr/sbin/mysqld: ready for connections. Version: '5.6.17' socket: '/var/lib/mysql/mysql.sock' port: 0 MySQL Community Server (GPL)
    0
  • pespatchs
    Nobody help to me ?
    0
  • cPanelMichael
    You may want to consult with a qualified system administrator or a database specialist if the issue continues and the user-feedback is not helpful. While our forums are a great resource, the issue you are experiencing is outside the scope of support as it's not directly related to the cPanel/WHM software. Thank you.
    0
  • SS-Maddy
    Please try creating a swap space. You are running out of memory as per the log you posted. ========= 2014-07-25 20:11:45 14410 [Note] InnoDB: Initializing buffer pool, size = 64.0M InnoDB: mmap(68681728 bytes) failed; errno 12 2014-07-25 20:11:45 14410 [ERROR] InnoDB: Cannot allocate memory for the buffer pool 2014-07-25 20:11:45 14410 [ERROR] Plugin 'InnoDB' init function returned error. =========
    0

Please sign in to leave a comment.

Didn't find what you were looking for?

New post