2021-05-11 8:07:51 0 [Note] bin/mysqld: Shutdown complete 2021-09-22 9:26:12 0 [Note] InnoDB: Using Linux native AIO 2021-09-22 9:26:12 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2021-09-22 9:26:12 0 [Note] InnoDB: Uses event mutexes 2021-09-22 9:26:12 0 [Note] InnoDB: Compressed tables use zlib 1.2.11 2021-09-22 9:26:12 0 [Note] InnoDB: Number of pools: 1 2021-09-22 9:26:12 0 [Note] InnoDB: Using SSE2 crc32 instructions 2021-09-22 9:26:12 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M 2021-09-22 9:26:13 0 [Note] InnoDB: Completed initialization of buffer pool 2021-09-22 9:26:13 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). 2021-09-22 9:26:13 0 [Note] InnoDB: 128 out of 128 rollback segments are active. 2021-09-22 9:26:13 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2021-09-22 9:26:13 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2021-09-22 9:26:13 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB. 2021-09-22 9:26:13 0 [Note] InnoDB: Waiting for purge to start 2021-09-22 9:26:13 0 [Note] InnoDB: 10.3.20 started; log sequence number 35138392652; transaction id 78933 2021-09-22 9:26:13 0 [Note] InnoDB: Loading buffer pool(s) from /home/mysql/database/mariadb-103/data/ib_buffer_pool 2021-09-22 9:26:13 0 [Note] Plugin 'FEEDBACK' is disabled. 2021-09-22 9:26:13 0 [Note] Server socket created on IP: '::'. 2021-09-22 9:26:13 0 [Note] InnoDB: Buffer pool(s) load completed at 210922 9:26:13 2021-09-22 9:26:13 0 [Note] Reading of all Master_info entries succeeded 2021-09-22 9:26:13 0 [Note] Added new Master_info '' to hash table 2021-09-22 9:26:13 0 [Note] bin/mysqld: ready for connections. Version: '10.3.20-MariaDB' socket: '/var/run/mysqld/mysql-3318.sock' port: 3318 MariaDB Server Status information: Current dir: /home/mysql/database_slow/mariadb-103/data/ Running threads: 5 Cached threads: 1 Stack size: 299008 Key caches: default Buffer_size: 134217728 Block_size: 1024 Division_limit: 100 Age_threshold: 300 Partitions: 0 blocks used: 0 not flushed: 0 w_requests: 0 writes: 0 r_requests: 0 reads: 0 handler status: read_key: 0 read_next: 0 read_rnd 0 read_first: 3 write: 0 delete 0 update: 0 Table status: Opened tables: 17 Open tables: 11 Open files: 25 Open streams: 0 Alarm status: Active alarms: 0 Max used alarms: 0 Next alarm time: 0 Memory status: Non-mmapped space allocated from system: 16969728 Number of free chunks: 41 Number of fastbin blocks: 0 Number of mmapped regions: 40 Space in mmapped regions: -1895837696 Maximum total allocated space: 0 Space available in freed fastbin blocks: 0 Total allocated space: 11961504 Total free space: 5008224 Top-most, releasable space: 12720 Estimated memory (with thread stack): -1877073920 Global memory allocated by server: 2286238096 Memory allocated by threads: 128880 Events status: LLA = Last Locked At LUA = Last Unlocked At WOC = Waiting On Condition DL = Data Locked Event scheduler status: State : INITIALIZED Thread id : 0 LLA : n/a:0 LUA : n/a:0 WOC : NO Workers : 0 Executed : 0 Data locked: NO Event queue status: Element count : 0 Data locked : NO Attempting lock : NO LLA : init_queue:140 LUA : init_queue:150 WOC : NO Next activation : never 2021-09-22 9:27:54 0 [Note] bin/mysqld (initiated by: unknown): Normal shutdown 2021-09-22 9:27:54 0 [Note] Event Scheduler: Purging the queue. 0 events 2021-09-22 9:27:54 0 [Note] InnoDB: FTS optimize thread exiting. 2021-09-22 9:27:54 0 [Note] InnoDB: Starting shutdown... 2021-09-22 9:27:54 0 [Note] InnoDB: Dumping buffer pool(s) to /home/mysql/database/mariadb-103/data/ib_buffer_pool 2021-09-22 9:27:54 0 [Note] InnoDB: Buffer pool(s) dump completed at 210922 9:27:54 2021-09-22 9:27:55 0 [Note] InnoDB: Shutdown completed; log sequence number 35138392661; transaction id 78934 2021-09-22 9:27:55 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" 2021-09-22 9:27:55 0 [Note] bin/mysqld: Shutdown complete 2021-09-22 9:27:56 0 [Note] InnoDB: Using Linux native AIO 2021-09-22 9:27:56 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2021-09-22 9:27:56 0 [Note] InnoDB: Uses event mutexes 2021-09-22 9:27:56 0 [Note] InnoDB: Compressed tables use zlib 1.2.11 2021-09-22 9:27:56 0 [Note] InnoDB: Number of pools: 1 2021-09-22 9:27:56 0 [Note] InnoDB: Using SSE2 crc32 instructions 2021-09-22 9:27:56 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M 2021-09-22 9:27:56 0 [Note] InnoDB: Completed initialization of buffer pool 2021-09-22 9:27:56 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). 2021-09-22 9:27:56 0 [Note] InnoDB: 128 out of 128 rollback segments are active. 2021-09-22 9:27:56 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2021-09-22 9:27:56 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2021-09-22 9:27:56 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB. 2021-09-22 9:27:56 0 [Note] InnoDB: 10.3.20 started; log sequence number 35138392661; transaction id 78933 2021-09-22 9:27:56 0 [Note] InnoDB: Loading buffer pool(s) from /home/mysql/database/mariadb-103/data/ib_buffer_pool 2021-09-22 9:27:56 0 [Note] Plugin 'FEEDBACK' is disabled. 2021-09-22 9:27:56 0 [Note] InnoDB: Buffer pool(s) load completed at 210922 9:27:56 2021-09-22 9:27:56 0 [Note] Server socket created on IP: '::'. 2021-09-22 9:27:56 0 [Note] Reading of all Master_info entries succeeded 2021-09-22 9:27:56 0 [Note] Added new Master_info '' to hash table 2021-09-22 9:27:56 0 [Note] bin/mysqld: ready for connections. Version: '10.3.20-MariaDB-log' socket: '/var/run/mysqld/mysql-3318.sock' port: 3318 MariaDB Server 2021-09-22 9:30:09 10 [ERROR] MYSQL_BIN_LOG::purge_logs was called with file /home/mysql/database_slow/mariadb-103/binlog/binlog.000450 not listed in the index. 2021-09-22 9:39:18 62 [ERROR] MYSQL_BIN_LOG::purge_logs was called with file /home/mysql/database_slow/mariadb-103/binlog/binlog.000394 not listed in the index. 2021-09-22 10:09:45 68659 [Note] Start binlog_dump to slave_server(3352), pos(binlog.000481, 1571509) 2021-09-22 10:10:45 73384 [Note] Start binlog_dump to slave_server(3352), pos(binlog.000483, 4) 2021-09-22 10:29:03 153660 [Warning] Aborted connection 153660 to db: 'unconnected' user: 'brman' host: 'localhost' (Got an error reading communication packets) 2021-09-23 8:06:30 73384 [Warning] Aborted connection 73384 to db: 'unconnected' user: 'replication' host: 'localhost' (Got an error writing communication packets) 2021-09-23 8:17:25 503510 [Note] Start binlog_dump to slave_server(3352), pos(binlog.000688, 14672061) 2021-09-23 8:18:57 510625 [Note] Start binlog_dump to slave_server(3352), pos(binlog.000769, 4) 2021-09-23 8:26:06 510625 [Warning] Aborted connection 510625 to db: 'unconnected' user: 'replication' host: 'localhost' (Got an error writing communication packets) 2021-09-23 8:26:11 535754 [Note] Start binlog_dump to slave_server(3352), pos(binlog.000812, 78694) 2021-09-23 8:38:00 535754 [Warning] Aborted connection 535754 to db: 'unconnected' user: 'replication' host: 'localhost' (Got an error writing communication packets) 2021-09-23 16:34:44 64835 [Warning] Aborted connection 64835 to db: 'unconnected' user: 'root' host: 'localhost' (Got timeout reading communication packets)