Home > database >  Mysql database connection is not often, after restart the database can be normal use!!!!!
Mysql database connection is not often, after restart the database can be normal use!!!!!

Time:10-07

Database work and normal work after a few days will be on the connection is not a cause, after restart the database can be normal use!!!!!



Mysql log


170720 10:25:08 [Note] Event Scheduler: Purging the queue. 0 events
170720 10:25:08 InnoDB: Starting shutdown...
170720 10:25:08 InnoDB: Shutdown completed; The log sequence number 1789395
170720 10:25:08 [Note]/usr/local/mysql/bin/mysqld: Shutdown complete

170720 10:25:09 [Note] the Plugin 'FEDERATED is disabled.
170720 10:25:09 InnoDB: The InnoDB heap memory is disabled
170720 10:25:09 InnoDB: Mutexes and rw_locks use GCC atomic builtins
170720 10:25:09 InnoDB: Compressed tables use zlib 1.2.7
170720 10:25:09 InnoDB: Initializing buffer pool, size=64.0 M
170720 10:25:09 InnoDB: Completed initialization of buffer pool
170720 10:25:09 InnoDB: highest supported file format is Barracuda.
170720 10:25:09 InnoDB: Waiting for the background threads to start
170720 10:25:10 InnoDB: 5.5.56 started; The log sequence number 1789395
170720 10:25:10 [Note] Server hostname (bind - address) : '0.0.0.0'; Port: 3306
170720 10:25:10 [Note] - '0.0.0.0 resolves to' 0.0.0.0 ';
170720 10:25:10 [Note] Server socket created on IP: '0.0.0.0.
170720 10:25:10 [Note] Event Scheduler: the Loaded 0 events
170720 10:25:10 [Note]/usr/local/mysql/bin/mysqld: ready for connections.
Version: '5.5.56 - log' socket: '/TMP/mysql. The sock' port: 3306 Source distribution
170722 15:30:47 [Note] the Plugin 'FEDERATED is disabled.
170722 15:30:47 InnoDB: The InnoDB heap memory is disabled
170722 15:30:47 InnoDB: Mutexes and rw_locks use GCC atomic builtins
170722 15:30:47 InnoDB: Compressed tables use zlib 1.2.7
170722 15:30:47 InnoDB: Initializing buffer pool, size=64.0 M
InnoDB: mmap (68681728 bytes) failed; Errno 12
170722 15:30:47 InnoDB: Completed initialization of buffer pool
170722 15:30:47 InnoDB: Fatal error: always the allocate memory for the buffer pool
170722 15:30:47 [ERROR] Plugin 'InnoDB' init function returned ERROR.
170722 15:30:47 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
170722 15:30:47 [ERROR] Unknown/unsupported storage engine: InnoDB
[ERROR] 170722 15:30:47 Aborting

170722 15:30:47 [Note]/usr/local/mysql/bin/mysqld: Shutdown complete

170722 23:07:32 [Note] the Plugin 'FEDERATED is disabled.
170722 23:07:32 InnoDB: The InnoDB heap memory is disabled
170722 23:07:32 InnoDB: Mutexes and rw_locks use GCC atomic builtins
170722 23:07:32 InnoDB: Compressed tables use zlib 1.2.7
170722 23:07:32 InnoDB: Initializing buffer pool, size=64.0 M
170722 23:07:32 InnoDB: Completed initialization of buffer pool
170722 23:07:32 InnoDB: highest supported file format is Barracuda.
170722 23:07:32 InnoDB: Waiting for the background threads to start
170722 23:07:33 InnoDB: 5.5.56 started; The log sequence number 1789395
170722 23:07:33 [Note] Recovering after a crash using mysql - bin
170722 23:07:33 [Note] Starting crash recovery...
170722 23:07:33 [Note] Crash recovery finished.
170722 23:07:33 [Note] Server hostname (bind - address) : '0.0.0.0'; Port: 3306
170722 23:07:33 [Note] - '0.0.0.0 resolves to' 0.0.0.0 ';
170722 23:07:33 [Note] Server socket created on IP: '0.0.0.0.
170722 23:07:33 [Note] Event Scheduler: the Loaded 0 events
170722 23:07:33 [Note]/usr/local/mysql/bin/mysqld: ready for connections.
Version: '5.5.56 - log' socket: '/TMP/mysql. The sock' port: 3306 Source distribution
170725 17:53:00 [Note] the Plugin 'FEDERATED is disabled.
170725 17:53:00 InnoDB: The InnoDB heap memory is disabled
170725 17:53:00 InnoDB: Mutexes and rw_locks use GCC atomic builtins
170725 17:53:00 InnoDB: Compressed tables use zlib 1.2.7
170725 17:53:00 InnoDB: Initializing buffer pool, size=64.0 M
170725 17:53:00 InnoDB: Completed initialization of buffer pool
170725 17:53:00 InnoDB: highest supported file format is Barracuda.
170725 17:53:01 InnoDB: Waiting for the background threads to start
170725 17:53:02 InnoDB: 5.5.56 started; The log sequence number 1789395
170725 17:53:02 [Note] Recovering after a crash using mysql - bin
170725 17:53:02 [Note] Starting crash recovery...
170725 17:53:02 [Note] Crash recovery finished.
170725 17:53:02 [Note] Server hostname (bind - address) : '0.0.0.0'; Port: 3306
170725 17:53:02 [Note] - '0.0.0.0 resolves to' 0.0.0.0 ';
170725 17:53:02 [Note] Server socket created on IP: '0.0.0.0.
170725 17:53:02 [Note] Event Scheduler: the Loaded 0 events
170725 17:53:02 [Note]/usr/local/mysql/bin/mysqld: ready for connections.
Version: '5.5.56 - log' socket: '/TMP/mysql. The sock' port: 3306 Source distribution
170725 17:53:05 [Note] the Plugin 'FEDERATED is disabled.
170725 17:53:05 InnoDB: The InnoDB heap memory is disabled
170725 17:53:05 InnoDB: Mutexes and rw_locks use GCC atomic builtins
nullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnull
  • Related