The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

mysql failed issue

Discussion in 'Database Discussions' started by pespatchs, Jul 17, 2014.

  1. pespatchs

    pespatchs Member

    Joined:
    Jul 17, 2014
    Messages:
    6
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    Ä°stanbul, Turkey
    cPanel Access Level:
    Website Owner
    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


    Code:
    
    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.
     
  2. soja92

    soja92 Member

    Joined:
    Jul 12, 2014
    Messages:
    5
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Root Administrator
    How much memory does your virtual server have? Are you running out?
     
  3. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,854
    Likes Received:
    676
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
  4. pespatchs

    pespatchs Member

    Joined:
    Jul 17, 2014
    Messages:
    6
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    Ä°stanbul, Turkey
    cPanel Access Level:
    Website Owner
    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.

    Code:
    [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
    
     
    #4 pespatchs, Jul 17, 2014
    Last edited by a moderator: Jul 17, 2014
  5. SS-Maddy

    SS-Maddy Well-Known Member

    Joined:
    Mar 28, 2009
    Messages:
    83
    Likes Received:
    0
    Trophy Points:
    6
    cPanel Access Level:
    Root Administrator
    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"
     
  6. pespatchs

    pespatchs Member

    Joined:
    Jul 17, 2014
    Messages:
    6
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    Ä°stanbul, Turkey
    cPanel Access Level:
    Website Owner
    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:

    Code:
    # 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:
    Code:
    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
     
  7. pespatchs

    pespatchs Member

    Joined:
    Jul 17, 2014
    Messages:
    6
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    Ä°stanbul, Turkey
    cPanel Access Level:
    Website Owner
    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 :)
     
  8. pespatchs

    pespatchs Member

    Joined:
    Jul 17, 2014
    Messages:
    6
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    Ä°stanbul, Turkey
    cPanel Access Level:
    Website Owner
    my problems started again :(

    Code:
    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)
     
  9. pespatchs

    pespatchs Member

    Joined:
    Jul 17, 2014
    Messages:
    6
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    Ä°stanbul, Turkey
    cPanel Access Level:
    Website Owner
    Nobody help to me ?
     
  10. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,854
    Likes Received:
    676
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
    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.
     
  11. SS-Maddy

    SS-Maddy Well-Known Member

    Joined:
    Mar 28, 2009
    Messages:
    83
    Likes Received:
    0
    Trophy Points:
    6
    cPanel Access Level:
    Root Administrator
    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.
    =========
     
Loading...

Share This Page