求大佬帮我看看为啥mysql老是停止运行

hldkepum

1. 2023-07-15 20:20:40 24448 [Note] Plugin 'FEDERATED' is disabled.2023-07-15 20:20:40 24448 [Note] InnoDB: Using atomics to ref count buffer pool pages2023-07-15 20:20:40 24448 [Note] InnoDB: The InnoDB memory heap is disabled2023-07-15 20:20:40 24448 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins2023-07-15 20:20:40 24448 [Note] InnoDB: Memory barrier is not used2023-07-15 20:20:40 24448 [Note] InnoDB: Compressed tables use zlib 1.2.112023-07-15 20:20:40 24448 [Note] InnoDB: Using Linux native AIO2023-07-15 20:20:40 24448 [Note] InnoDB: Using CPU crc32 instructions2023-07-15 20:20:40 24448 [Note] InnoDB: Initializing buffer pool, size = 16.0M2023-07-15 20:20:40 24448 [Note] InnoDB: Completed initialization of buffer pool2023-07-15 20:20:40 24448 [Note] InnoDB: Highest supported file format is Barracuda.2023-07-15 20:20:40 24448 [Note] InnoDB: The log sequence numbers 1626004 and 1626004 in ibdata files do not match the log sequence number 788234804 in the ib_logfiles!2023-07-15 20:20:40 24448 [Note] InnoDB: Database was not shutdown normally!2023-07-15 20:20:40 24448 [Note] InnoDB: Starting crash recovery.2023-07-15 20:20:40 24448 [Note] InnoDB: Reading tablespace information from the .ibd files...2023-07-15 20:20:42 24448 [Note] InnoDB: Restoring possible half-written data pages 2023-07-15 20:20:42 24448 [Note] InnoDB: from the doublewrite buffer...InnoDB: Last MySQL binlog file position 0 36093755, file name mysql-bin.0000122023-07-15 20:20:44 24448 [Note] InnoDB: 128 rollback segment(s) are active.2023-07-15 20:20:44 24448 [Note] InnoDB: Waiting for purge to start2023-07-15 20:20:44 24448 [Note] InnoDB: 5.6.50 started; log sequence number 7882348042023-07-15 20:20:44 24448 [Note] Recovering after a crash using mysql-bin2023-07-15 20:20:45 24448 [Note] Starting crash recovery...2023-07-15 20:20:45 24448 [Note] Crash recovery finished.2023-07-15 20:20:45 24448 [Note] RSA private key file not found: /www/server/data//private_key.pem. Some authentication plugins will not work.2023-07-15 20:20:45 24448 [Note] RSA public key file not found: /www/server/data//public_key.pem. Some authentication plugins will not work.2023-07-15 20:20:45 24448 [Note] Server hostname (bind-address): '*'; port: 33062023-07-15 20:20:45 24448 [Note] IPv6 is available.2023-07-15 20:20:45 24448 [Note]   - '::' resolves to '::';2023-07-15 20:20:45 24448 [Note] Server socket created on IP: '::'.2023-07-15 20:20:45 24448 [Note] Event Scheduler: Loaded 0 events2023-07-15 20:20:45 24448 [Note] /www/server/mysql/bin/mysqld: ready for connections.Version: '5.6.50-log'  socket: '/tmp/mysql.sock'  port: 3306  Source distribution2023-07-15 20:33:20 24560 [Note] Plugin 'FEDERATED' is disabled.2023-07-15 20:33:21 24560 [Note] InnoDB: Using atomics to ref count buffer pool pages2023-07-15 20:33:21 24560 [Note] InnoDB: The InnoDB memory heap is disabled2023-07-15 20:33:21 24560 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins2023-07-15 20:33:21 24560 [Note] InnoDB: Memory barrier is not used2023-07-15 20:33:21 24560 [Note] InnoDB: Compressed tables use zlib 1.2.112023-07-15 20:33:21 24560 [Note] InnoDB: Using Linux native AIO2023-07-15 20:33:21 24560 [Note] InnoDB: Using CPU crc32 instructions2023-07-15 21:29:48 26376 [Note] Plugin 'FEDERATED' is disabled.2023-07-15 21:29:48 26376 [Note] InnoDB: Using atomics to ref count buffer pool pages2023-07-15 21:29:48 26376 [Note] InnoDB: The InnoDB memory heap is disabled2023-07-15 21:29:48 26376 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins2023-07-15 21:29:48 26376 [Note] InnoDB: Memory barrier is not used2023-07-15 21:29:48 26376 [Note] InnoDB: Compressed tables use zlib 1.2.112023-07-15 21:29:48 26376 [Note] InnoDB: Using Linux native AIO2023-07-15 21:29:48 26376 [Note] InnoDB: Using CPU crc32 instructions2023-07-15 21:29:48 26376 [Note] InnoDB: Initializing buffer pool, size = 16.0M2023-07-15 21:29:48 26376 [Note] InnoDB: Completed initialization of buffer pool2023-07-15 21:29:48 26376 [Note] InnoDB: Highest supported file format is Barracuda.2023-07-15 21:29:48 26376 [Note] InnoDB: The log sequence numbers 1626004 and 1626004 in ibdata files do not match the log sequence number 788247601 in the ib_logfiles!2023-07-15 21:29:48 26376 [Note] InnoDB: Database was not shutdown normally!2023-07-15 21:29:48 26376 [Note] InnoDB: Starting crash recovery.2023-07-15 21:29:48 26376 [Note] InnoDB: Reading tablespace information from the .ibd files...2023-07-15 21:29:49 26376 [Note] InnoDB: Restoring possible half-written data pages 2023-07-15 21:29:49 26376 [Note] InnoDB: from the doublewrite buffer...InnoDB: Last MySQL binlog file position 0 6864, file name mysql-bin.0000132023-07-15 21:29:49 26376 [Note] InnoDB: 128 rollback segment(s) are active.2023-07-15 21:29:49 26376 [Note] InnoDB: Waiting for purge to start2023-07-15 21:29:49 26376 [Note] InnoDB: 5.6.50 started; log sequence number 7882476012023-07-15 21:29:49 26376 [Note] Recovering after a crash using mysql-bin2023-07-15 21:29:49 26376 [Note] Starting crash recovery...2023-07-15 21:29:49 26376 [Note] Crash recovery finished.2023-07-15 21:29:49 26376 [Note] RSA private key file not found: /www/server/data//private_key.pem. Some authentication plugins will not work.2023-07-15 21:29:49 26376 [Note] RSA public key file not found: /www/server/data//public_key.pem. Some authentication plugins will not work.2023-07-15 21:29:49 26376 [Note] Server hostname (bind-address): '*'; port: 33062023-07-15 21:29:49 26376 [Note] IPv6 is available.2023-07-15 21:29:49 26376 [Note]   - '::' resolves to '::';2023-07-15 21:29:49 26376 [Note] Server socket created on IP: '::'.2023-07-15 21:29:49 26376 [Note] Event Scheduler: Loaded 0 events2023-07-15 21:29:49 26376 [Note] /www/server/mysql/bin/mysqld: ready for connections.Version: '5.6.50-log'  socket: '/tmp/mysql.sock'  port: 3306  Source distribution

复制代码

宝塔面板里的mysql老是停止运行

冷白

看不出来 ，只看到crash