# mysql randomly killed **URL:** \ **Category:** Other MySQL® Questions\ **Created:** [December 6, 2015, 6:36am UTC](https://forums.percona.com/t/mysql-randomly-killed/4572 "2015-12-06T06:36:48Z")\ **Posts on this page:** 2\ **Page:** 1
**Author:** ![hebrew878](https://avatars.discourse-cdn.com/v4/letter/h/ebca7d/32.png) [@hebrew878](https://forums.percona.com/u/hebrew878)\ **Post date:** [December 6, 2015, 6:36am UTC](https://forums.percona.com/t/mysql-randomly-killed/4572/1 "2015-12-06T06:36:48Z")
my percona server randomly goes offline please help me to fix this problem. error log here Killed 151206 09:54:53 mysqld\_safe Number of processes running now: 0 151206 09:54:53 mysqld\_safe mysqld restarted 2015-12-06 09:54:54 0 [Warning] Using unique option prefix key\_buffer instead of key\_buffer\_size is deprecated and will be removed in a future release. Please use the full name instead. 2015-12-06 09:54:54 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit\_defaults\_for\_timestamp server option (see documentation for more details). 2015-12-06 09:54:54 0 [Note] /usr/sbin/mysqld (mysqld 5.6.27-75.0) starting as process 22779 … 2015-12-06 09:54:54 22779 [Warning] Using unique option prefix myisam-recover instead of myisam-recover-options is deprecated and will be removed in a future release. Please use the full name instead. 2015-12-06 09:54:54 22779 [Note] Plugin ‘FEDERATED’ is disabled. 2015-12-06 09:54:54 22779 [Note] InnoDB: Using atomics to ref count buffer pool pages 2015-12-06 09:54:54 22779 [Note] InnoDB: The InnoDB memory heap is disabled 2015-12-06 09:54:54 22779 [Note] InnoDB: Mutexes and rw\_locks use GCC atomic builtins 2015-12-06 09:54:54 22779 [Note] InnoDB: Memory barrier is not used 2015-12-06 09:54:54 22779 [Note] InnoDB: Compressed tables use zlib 1.2.8 2015-12-06 09:54:54 22779 [Note] InnoDB: Using Linux native AIO 2015-12-06 09:54:54 22779 [Note] InnoDB: Using CPU crc32 instructions 2015-12-06 09:54:54 22779 [Note] InnoDB: Initializing buffer pool, size = 128.0M 2015-12-06 09:54:54 22779 [Note] InnoDB: Completed initialization of buffer pool 2015-12-06 09:54:54 22779 [Note] InnoDB: Highest supported file format is Barracuda. 2015-12-06 09:54:54 22779 [Note] InnoDB: Log scan progressed past the checkpoint lsn 12993240227 2015-12-06 09:54:54 22779 [Note] InnoDB: Database was not shutdown normally! 2015-12-06 09:54:54 22779 [Note] InnoDB: Starting crash recovery. 2015-12-06 09:54:54 22779 [Note] InnoDB: Reading tablespace information from the .ibd files… 2015-12-06 09:54:54 22779 [Note] InnoDB: Restoring possible half-written data pages 2015-12-06 09:54:54 22779 [Note] InnoDB: from the doublewrite buffer… InnoDB: Doing recovery: scanned up to log sequence number 12993240326 2015-12-06 09:54:55 22779 [Note] InnoDB: 128 rollback segment(s) are active. 2015-12-06 09:54:55 22779 [Note] InnoDB: Waiting for purge to start 2015-12-06 09:54:55 22779 [Note] InnoDB: Percona XtraDB ([http://www.percona.com](http://www.percona.com)) 5.6.27-75.0 started; log sequence number 12993240326 2015-12-06 09:54:55 22779 [Note] RSA private key file not found: /var/lib/mysql//private\_key.pem. Some authentication plugins will not work. 2015-12-06 09:54:55 22779 [Note] RSA public key file not found: /var/lib/mysql//public\_key.pem. Some authentication plugins will not work. 2015-12-06 09:54:55 22779 [Note] Server hostname (bind-address): ‘127.0.0.1’; port: 3306 2015-12-06 09:54:55 22779 [Note] - ‘127.0.0.1’ resolves to ‘127.0.0.1’; 2015-12-06 09:54:55 22779 [Note] Server socket created on IP: ‘127.0.0.1’. 2015-12-06 09:54:55 22779 [Note] Event Scheduler: Loaded 0 events 2015-12-06 09:54:55 22779 [Note] /usr/sbin/mysqld: ready for connections. Version: ‘5.6.27-75.0’ socket: ‘/var/run/mysqld/mysqld.sock’ port: 3306 Percona Server (GPL), Release 75.0, Revision 8bb53b6 2015-12-06 09:54:57 22779 [ERROR] Can’t create thread to handle request (errno= 11) Killed 151206 09:54:59 mysqld\_safe Number of processes running now: 0 151206 09:54:59 mysqld\_safe mysqld restarted 2015-12-06 09:55:00 0 [Warning] Using unique option prefix key\_buffer instead of key\_buffer\_size is deprecated and will be removed in a future release. Please use the full name instead. 2015-12-06 09:55:00 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit\_defaults\_for\_timestamp server option (see documentation for more details). 2015-12-06 09:55:00 0 [Note] /usr/sbin/mysqld (mysqld 5.6.27-75.0) starting as process 22856 … 2015-12-06 09:55:00 22856 [Warning] Using unique option prefix myisam-recover instead of myisam-recover-options is deprecated and will be removed in a future release. Please use the full name instead. 2015-12-06 09:55:00 22856 [Note] Plugin ‘FEDERATED’ is disabled. 2015-12-06 09:55:00 22856 [Note] InnoDB: Using atomics to ref count buffer pool pages 2015-12-06 09:55:00 22856 [Note] InnoDB: The InnoDB memory heap is disabled 2015-12-06 09:55:00 22856 [Note] InnoDB: Mutexes and rw\_locks use GCC atomic builtins 2015-12-06 09:55:00 22856 [Note] InnoDB: Memory barrier is not used 2015-12-06 09:55:00 22856 [Note] InnoDB: Compressed tables use zlib 1.2.8 2015-12-06 09:55:00 22856 [Note] InnoDB: Using Linux native AIO 2015-12-06 09:55:00 22856 [Note] InnoDB: Using CPU crc32 instructions 2015-12-06 09:55:00 22856 [Note] InnoDB: Initializing buffer pool, size = 128.0M InnoDB: mmap(137363456 bytes) failed; errno 12 2015-12-06 09:55:00 22856 [ERROR] InnoDB: Cannot allocate memory for the buffer pool 2015-12-06 09:55:00 22856 [ERROR] Plugin ‘InnoDB’ init function returned error. 2015-12-06 09:55:00 22856 [ERROR] Plugin ‘InnoDB’ registration as a STORAGE ENGINE failed. 2015-12-06 09:55:00 22856 [ERROR] Unknown/unsupported storage engine: InnoDB 2015-12-06 09:55:00 22856 [ERROR] Aborting 2015-12-06 09:55:00 22856 [Note] Binlog end 2015-12-06 09:55:00 22856 [Note] Shutting down plugin ‘partition’ 2015-12-06 09:55:00 22856 [Note] Shutting down plugin ‘PERFORMANCE\_SCHEMA’ 2015-12-06 09:55:00 22856 [Note] Shutting down plugin ‘ARCHIVE’ 2015-12-06 09:55:00 22856 [Note] Shutting down plugin ‘BLACKHOLE’ 2015-12-06 09:55:00 22856 [Note] Shutting down plugin ‘INNODB\_CHANGED\_PAGES’ 2015-12-06 09:55:00 22856 [Note] Shutting down plugin ‘INNODB\_SYS\_DATAFILES’ 2015-12-06 09:55:00 22856 [Note] Shutting down plugin ‘INNODB\_SYS\_TABLESPACES’ 2015-12-06 09:55:00 22856 [Note] Shutting down plugin ‘INNODB\_SYS\_FOREIGN\_COLS’ 2015-12-06 09:55:00 22856 [Note] Shutting down plugin ‘INNODB\_SYS\_FOREIGN’ 2015-12-06 09:55:00 22856 [Note] Shutting down plugin ‘INNODB\_SYS\_FIELDS’ 2015-12-06 09:55:00 22856 [Note] Shutting down plugin ‘INNODB\_SYS\_COLUMNS’ 2015-12-06 09:55:00 22856 [Note] Shutting down plugin ‘INNODB\_SYS\_INDEXES’ 2015-12-06 09:55:00 22856 [Note] Shutting down plugin ‘INNODB\_SYS\_TABLESTATS’ 2015-12-06 09:55:00 22856 [Note] Shutting down plugin ‘INNODB\_SYS\_TABLES’ 2015-12-06 09:55:00 22856 [Note] Shutting down plugin ‘INNODB\_FT\_INDEX\_TABLE’ 2015-12-06 09:55:00 22856 [Note] Shutting down plugin ‘INNODB\_FT\_INDEX\_CACHE’ 2015-12-06 09:55:00 22856 [Note] Shutting down plugin ‘INNODB\_FT\_CONFIG’ 2015-12-06 09:55:00 22856 [Note] Shutting down plugin ‘INNODB\_FT\_BEING\_DELETED’ 2015-12-06 09:55:00 22856 [Note] Shutting down plugin ‘INNODB\_FT\_DELETED’ 2015-12-06 09:55:00 22856 [Note] Shutting down plugin ‘INNODB\_FT\_DEFAULT\_STOPWORD’ 2015-12-06 09:55:00 22856 [Note] Shutting down plugin ‘INNODB\_METRICS’ 2015-12-06 09:55:00 22856 [Note] Shutting down plugin ‘INNODB\_BUFFER\_POOL\_STATS’ 2015-12-06 09:55:00 22856 [Note] Shutting down plugin ‘INNODB\_BUFFER\_PAGE\_LRU’ 2015-12-06 09:55:00 22856 [Note] Shutting down plugin ‘INNODB\_BUFFER\_PAGE’ 2015-12-06 09:55:00 22856 [Note] Shutting down plugin ‘INNODB\_CMP\_PER\_INDEX\_RESET’ 2015-12-06 09:55:00 22856 [Note] Shutting down plugin ‘INNODB\_CMP\_PER\_INDEX’ 2015-12-06 09:55:00 22856 [Note] Shutting down plugin ‘INNODB\_CMPMEM\_RESET’ 2015-12-06 09:55:00 22856 [Note] Shutting down plugin ‘INNODB\_CMPMEM’ 2015-12-06 09:55:00 22856 [Note] Shutting down plugin ‘INNODB\_CMP\_RESET’ 2015-12-06 09:55:00 22856 [Note] Shutting down plugin ‘INNODB\_CMP’ 2015-12-06 09:55:00 22856 [Note] Shutting down plugin ‘INNODB\_LOCK\_WAITS’ 2015-12-06 09:55:00 22856 [Note] Shutting down plugin ‘INNODB\_LOCKS’ 2015-12-06 09:55:00 22856 [Note] Shutting down plugin ‘INNODB\_TRX’ 2015-12-06 09:55:00 22856 [Note] Shutting down plugin ‘XTRADB\_RSEG’ 2015-12-06 09:55:00 22856 [Note] Shutting down plugin ‘XTRADB\_INTERNAL\_HASH\_TABLES’ 2015-12-06 09:55:00 22856 [Note] Shutting down plugin ‘XTRADB\_READ\_VIEW’ 2015-12-06 09:55:00 22856 [Note] Shutting down plugin ‘MyISAM’ 2015-12-06 09:55:00 22856 [Note] Shutting down plugin ‘MRG\_MYISAM’ 2015-12-06 09:55:00 22856 [Note] Shutting down plugin ‘CSV’ 2015-12-06 09:55:00 22856 [Note] Shutting down plugin ‘MEMORY’ 2015-12-06 09:55:00 22856 [Note] Shutting down plugin ‘sha256\_password’ 2015-12-06 09:55:00 22856 [Note] Shutting down plugin ‘mysql\_old\_password’ 2015-12-06 09:55:00 22856 [Note] Shutting down plugin ‘mysql\_native\_password’ 2015-12-06 09:55:00 22856 [Note] Shutting down plugin ‘binlog’ 2015-12-06 09:55:00 22856 [Note] /usr/sbin/mysqld: Shutdown complete 151206 09:55:00 mysqld\_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended ---
**Author:** ![umarzuki](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/umarzuki/32/1064_2.png) [@umarzuki](https://forums.percona.com/u/umarzuki)\ **Post date:** [December 6, 2015, 6:26pm UTC](https://forums.percona.com/t/mysql-randomly-killed/4572/2 "2015-12-06T18:26:04Z")
try deleting ib\_logfile0 in datadir