大家好，小弟用的google cloud+寶塔面板+LNMP+wordpress， 但是MYSQL會隔三差五的關閉，非常耽誤事，百思不得其解，求各位幫助，謝謝大家。
2020-03-27 07:39:43 28003 [Note] Server hostname (bind-address): '*'; port: 3306
2020-03-27 07:39:43 28003 [Note] IPv6 is available.
2020-03-27 07:39:43 28003 [Note] - '::' resolves to '::';
2020-03-27 07:39:43 28003 [Note] Server socket created on IP: '::'.
2020-03-27 07:39:43 28003 [Note] Event Scheduler: Loaded 0 events
2020-03-27 07:39:43 28003 [Note] /www/server/mysql/bin/mysqld: ready for connections.
Version: '5.6.47-log' socket: '/tmp/mysql.sock' port: 3306 Source distribution
2020-03-29 02:34:59 13661 [Note] Plugin 'FEDERATED' is disabled.
2020-03-29 02:35:28 13661 [Note] InnoDB: Using atomics to ref count buffer pool pages
2020-03-29 02:35:30 13661 [Note] InnoDB: The InnoDB memory heap is disabled
2020-03-29 02:35:30 13661 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2020-03-29 02:35:30 13661 [Note] InnoDB: Memory barrier is not used
2020-03-29 02:35:30 13661 [Note] InnoDB: Compressed tables use zlib 1.2.11
2020-03-29 02:35:30 13661 [Note] InnoDB: Using Linux native AIO
2020-03-29 02:35:30 13661 [Note] InnoDB: Using CPU crc32 instructions
2020-03-29 02:35:40 13661 [Note] InnoDB: Initializing buffer pool, size = 384.0M
2020-03-29 08:04:20 20521 [Note] Plugin 'FEDERATED' is disabled.
2020-03-29 08:04:20 20521 [Note] InnoDB: Using atomics to ref count buffer pool pages
2020-03-29 08:04:20 20521 [Note] InnoDB: The InnoDB memory heap is disabled
2020-03-29 08:04:20 20521 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2020-03-29 08:04:20 20521 [Note] InnoDB: Memory barrier is not used
2020-03-29 08:04:20 20521 [Note] InnoDB: Compressed tables use zlib 1.2.11
2020-03-29 08:04:20 20521 [Note] InnoDB: Using Linux native AIO
2020-03-29 08:04:20 20521 [Note] InnoDB: Using CPU crc32 instructions
2020-03-29 08:04:20 20521 [Note] InnoDB: Initializing buffer pool, size = 384.0M
2020-03-29 08:04:20 20521 [Note] InnoDB: Completed initialization of buffer pool
2020-03-29 08:04:20 20521 [Note] InnoDB: Highest supported file format is Barracuda.
2020-03-29 08:04:20 20521 [Note] InnoDB: The log sequence numbers 1626180 and 1626180 in ibdata files do not match the log sequence number 1626190 in the ib_logfiles!
2020-03-29 08:04:20 20521 [Note] InnoDB: Database was not shutdown normally!
2020-03-29 08:04:20 20521 [Note] InnoDB: Starting crash recovery.
2020-03-29 08:04:20 20521 [Note] InnoDB: Reading tablespace information from the .ibd files...
2020-03-29 08:04:20 20521 [Note] InnoDB: Restoring possible half-written data pages
2020-03-29 08:04:20 20521 [Note] InnoDB: from the doublewrite buffer...
2020-03-29 08:04:21 20521 [Note] InnoDB: 128 rollback segment(s) are active.
2020-03-29 08:04:21 20521 [Note] InnoDB: Waiting for purge to start
2020-03-29 08:04:21 20521 [Note] InnoDB: 5.6.47 started; log sequence number 1626190
2020-03-29 08:04:21 20521 [Note] RSA private key file not found: /www/server/data//private_key.pem. Some authentication plugins will not work.
2020-03-29 08:04:21 20521 [Note] RSA public key file not found: /www/server/data//public_key.pem. Some authentication plugins will not work.
2020-03-29 08:04:21 20521 [Note] Server hostname (bind-address): '*'; port: 3306
2020-03-29 08:04:21 20521 [Note] IPv6 is available.
2020-03-29 08:04:21 20521 [Note] - '::' resolves to '::';
2020-03-29 08:04:21 20521 [Note] Server socket created on IP: '::'.
2020-03-29 08:04:21 20521 [Note] Event Scheduler: Loaded 0 events
2020-03-29 08:04:21 20521 [Note] /www/server/mysql/bin/mysqld: ready for connections.
Version: '5.6.47-log' socket: '/tmp/mysql.sock' port: 3306 Source distribution
uj5u.com熱心網友回復：
這種得看下mysql的error.log，你貼出的沒有自動關閉的資訊。轉載請註明出處，本文鏈接：https://www.uj5u.com/shujuku/24938.html
標籤：MySQL
上一篇：初學資料庫原理