Oct 13 16:12:37 mail-galera-b mysqld[3870]: 2020-10-13 16:12:37 26893630 [Note] InnoDB: Number of pools: 2 Oct 13 16:14:33 mail-galera-b mysqld[3870]: 2020-10-13 16:14:33 1729 [Note] InnoDB: Number of pools: 3 Oct 13 16:14:40 mail-galera-b mysqld[3870]: 2020-10-13 16:14:40 0 [Warning] InnoDB: A long semaphore wait: Oct 13 16:14:40 mail-galera-b mysqld[3870]: --Thread 140691926611712 has waited at lock0lock.cc line 3898 for 241.00 seconds the semaphore: Oct 13 16:14:40 mail-galera-b mysqld[3870]: Mutex at 0x564fc9ebfb00, Mutex LOCK_SYS created lock0lock.cc:461, lock var 2 Oct 13 16:14:40 mail-galera-b mysqld[3870]: 2020-10-13 16:14:40 0 [Warning] InnoDB: A long semaphore wait: Oct 13 16:14:40 mail-galera-b mysqld[3870]: --Thread 140691925997312 has waited at lock0lock.cc line 3898 for 241.00 seconds the semaphore: Oct 13 16:14:40 mail-galera-b mysqld[3870]: Mutex at 0x564fc9ebfb00, Mutex LOCK_SYS created lock0lock.cc:461, lock var 2 Oct 13 16:14:40 mail-galera-b mysqld[3870]: 2020-10-13 16:14:40 0 [Note] InnoDB: A semaphore wait: ... Oct 13 16:16:00 mail-galera-b mysqld[3870]: 2020-10-13 16:16:00 0x7ff2a3e60700 INNODB MONITOR OUTPUT Oct 13 16:16:00 mail-galera-b mysqld[3870]: ===================================== Oct 13 16:16:00 mail-galera-b mysqld[3870]: Per second averages calculated from the last 20 seconds Oct 13 16:16:00 mail-galera-b mysqld[3870]: ----------------- Oct 13 16:16:00 mail-galera-b mysqld[3870]: BACKGROUND THREAD Oct 13 16:16:00 mail-galera-b mysqld[3870]: ----------------- Oct 13 16:16:00 mail-galera-b mysqld[3870]: srv_master_thread loops: 2219 srv_active, 0 srv_shutdown, 1009298 srv_idle Oct 13 16:16:00 mail-galera-b mysqld[3870]: srv_master_thread log flush and writes: 1011515 Oct 13 16:16:00 mail-galera-b mysqld[3870]: ---------- Oct 13 16:16:00 mail-galera-b mysqld[3870]: SEMAPHORES Oct 13 16:16:00 mail-galera-b mysqld[3870]: ---------- Oct 13 16:16:00 mail-galera-b mysqld[3870]: OS WAIT ARRAY INFO: reservation count 3654466 Oct 13 16:16:00 mail-galera-b mysqld[3870]: --Thread 140678945888000 has waited at lock0lock.cc line 3898 for 319.00 seconds the semaphore: ... Oct 13 16:16:56 mail-galera-b mysqld[3870]: --Thread 140670930626304 has waited at lock0lock.cc line 3898 for 33.00 seconds the semaphore: Oct 13 16:16:56 mail-galera-b mysqld[3870]: Mutex at 0x564fc9ebfb00, Mutex LOCK_SYS created lock0lock.cc:461, lock var 2 Oct 13 16:16:56 mail-galera-b mysqld[3870]: OS WAIT ARRAY INFO: signal count 3431176 Oct 13 16:16:56 mail-galera-b mysqld[3870]: RW-shared spins 2454822, rounds 35201655, OS waits 1085274 Oct 13 16:16:56 mail-galera-b mysqld[3870]: RW-excl spins 10821872, rounds 47868535, OS waits 163437 Oct 13 16:16:56 mail-galera-b mysqld[3870]: RW-sx spins 5238, rounds 124137, OS waits 3618 Oct 13 16:16:56 mail-galera-b mysqld[3870]: Spin rounds per wait: 14.34 RW-shared, 4.42 RW-excl, 23.70 RW-sx Oct 13 16:16:56 mail-galera-b mysqld[3870]: FAIL TO OBTAIN LOCK MUTEX, SKIP LOCK INFO PRINTING Oct 13 16:16:56 mail-galera-b mysqld[3870]: -------- Oct 13 16:16:56 mail-galera-b mysqld[3870]: FILE I/O Oct 13 16:16:56 mail-galera-b mysqld[3870]: -------- Oct 13 16:16:56 mail-galera-b mysqld[3870]: I/O thread 0 state: waiting for completed aio requests (insert buffer thread) Oct 13 16:16:56 mail-galera-b mysqld[3870]: I/O thread 1 state: waiting for completed aio requests (log thread) Oct 13 16:16:56 mail-galera-b mysqld[3870]: I/O thread 2 state: waiting for completed aio requests (read thread) Oct 13 16:16:56 mail-galera-b mysqld[3870]: I/O thread 3 state: waiting for completed aio requests (read thread) Oct 13 16:16:56 mail-galera-b mysqld[3870]: I/O thread 4 state: waiting for completed aio requests (read thread) Oct 13 16:16:56 mail-galera-b mysqld[3870]: I/O thread 5 state: waiting for completed aio requests (read thread) Oct 13 16:16:56 mail-galera-b mysqld[3870]: I/O thread 6 state: waiting for completed aio requests (read thread) Oct 13 16:16:56 mail-galera-b mysqld[3870]: I/O thread 7 state: waiting for completed aio requests (read thread) Oct 13 16:16:56 mail-galera-b mysqld[3870]: I/O thread 8 state: waiting for completed aio requests (read thread) Oct 13 16:16:56 mail-galera-b mysqld[3870]: I/O thread 9 state: waiting for completed aio requests (read thread) Oct 13 16:16:56 mail-galera-b mysqld[3870]: I/O thread 10 state: waiting for completed aio requests (write thread) Oct 13 16:16:56 mail-galera-b mysqld[3870]: I/O thread 11 state: waiting for completed aio requests (write thread) Oct 13 16:16:56 mail-galera-b mysqld[3870]: I/O thread 12 state: waiting for completed aio requests (write thread) Oct 13 16:16:56 mail-galera-b mysqld[3870]: I/O thread 13 state: waiting for completed aio requests (write thread) Oct 13 16:16:56 mail-galera-b mysqld[3870]: Pending normal aio reads: [0, 0, 0, 0, 0, 0, 0, 0] , aio writes: [0, 0, 0, 0] , Oct 13 16:16:56 mail-galera-b mysqld[3870]: ibuf aio reads:, log i/o's:, sync i/o's: Oct 13 16:16:56 mail-galera-b mysqld[3870]: Pending flushes (fsync) log: 0; buffer pool: 0 Oct 13 16:16:56 mail-galera-b mysqld[3870]: 21779 OS file reads, 95306133 OS file writes, 23762006 OS fsyncs Oct 13 16:16:56 mail-galera-b mysqld[3870]: 0.00 reads/s, 0 avg bytes/read, 0.00 writes/s, 0.00 fsyncs/s Oct 13 16:16:56 mail-galera-b mysqld[3870]: ------------------------------------- Oct 13 16:16:56 mail-galera-b mysqld[3870]: INSERT BUFFER AND ADAPTIVE HASH INDEX Oct 13 16:16:56 mail-galera-b mysqld[3870]: ------------------------------------- Oct 13 16:16:56 mail-galera-b mysqld[3870]: Ibuf: size 1, free list len 0, seg size 2, 1 merges Oct 13 16:16:56 mail-galera-b mysqld[3870]: merged operations: Oct 13 16:16:56 mail-galera-b mysqld[3870]: insert 0, delete mark 5, delete 4 Oct 13 16:16:56 mail-galera-b mysqld[3870]: discarded operations: Oct 13 16:16:56 mail-galera-b mysqld[3870]: insert 0, delete mark 0, delete 0 Oct 13 16:16:56 mail-galera-b mysqld[3870]: Hash table size 2656321, node heap has 681 buffer(s) Oct 13 16:16:56 mail-galera-b mysqld[3870]: Hash table size 2656321, node heap has 3 buffer(s) Oct 13 16:16:56 mail-galera-b mysqld[3870]: Hash table size 2656321, node heap has 568 buffer(s) Oct 13 16:16:56 mail-galera-b mysqld[3870]: Hash table size 2656321, node heap has 308 buffer(s) Oct 13 16:16:56 mail-galera-b mysqld[3870]: Hash table size 2656321, node heap has 33 buffer(s) Oct 13 16:16:56 mail-galera-b mysqld[3870]: Hash table size 2656321, node heap has 26 buffer(s) Oct 13 16:16:56 mail-galera-b mysqld[3870]: Hash table size 2656321, node heap has 304 buffer(s) Oct 13 16:16:56 mail-galera-b mysqld[3870]: Hash table size 2656321, node heap has 57 buffer(s) Oct 13 16:16:56 mail-galera-b mysqld[3870]: 1503.22 hash searches/s, 83.49 non-hash searches/s Oct 13 16:16:56 mail-galera-b mysqld[3870]: --- Oct 13 16:16:56 mail-galera-b mysqld[3870]: LOG Oct 13 16:16:56 mail-galera-b mysqld[3870]: --- Oct 13 16:16:56 mail-galera-b mysqld[3870]: Log sequence number 215594486398 Oct 13 16:16:56 mail-galera-b mysqld[3870]: Log flushed up to 215594486398 Oct 13 16:16:56 mail-galera-b mysqld[3870]: Pages flushed up to 215594486398 Oct 13 16:16:56 mail-galera-b mysqld[3870]: Last checkpoint at 215594486389 Oct 13 16:16:56 mail-galera-b mysqld[3870]: 0 pending log flushes, 0 pending chkp writes Oct 13 16:16:56 mail-galera-b mysqld[3870]: 23026557 log i/o's done, 0.00 log i/o's/second Oct 13 16:16:56 mail-galera-b mysqld[3870]: ---------------------- Oct 13 16:16:56 mail-galera-b mysqld[3870]: BUFFER POOL AND MEMORY Oct 13 16:16:56 mail-galera-b mysqld[3870]: ---------------------- Oct 13 16:16:56 mail-galera-b mysqld[3870]: Total large memory allocated 11274289152 Oct 13 16:16:56 mail-galera-b mysqld[3870]: Dictionary memory allocated 76080 Oct 13 16:16:56 mail-galera-b mysqld[3870]: Buffer pool size 641840 Oct 13 16:16:56 mail-galera-b mysqld[3870]: Free buffers 617466 Oct 13 16:16:56 mail-galera-b mysqld[3870]: Database pages 22394 Oct 13 16:16:56 mail-galera-b mysqld[3870]: Old database pages 8215 Oct 13 16:16:56 mail-galera-b mysqld[3870]: Modified db pages 0 Oct 13 16:16:56 mail-galera-b mysqld[3870]: Percent of dirty pages(LRU & free pages): 0.000 Oct 13 16:16:56 mail-galera-b mysqld[3870]: Max dirty pages percent: 75.000 Oct 13 16:16:56 mail-galera-b mysqld[3870]: Pending reads 0 Oct 13 16:16:56 mail-galera-b mysqld[3870]: Pending writes: LRU 0, flush list 0, single page 0 Oct 13 16:16:56 mail-galera-b mysqld[3870]: Pages made young 70, not young 0 Oct 13 16:16:56 mail-galera-b mysqld[3870]: 0.00 youngs/s, 0.00 non-youngs/s Oct 13 16:16:56 mail-galera-b mysqld[3870]: Pages read 21745, created 649, written 64071753 Oct 13 16:16:56 mail-galera-b mysqld[3870]: 0.00 reads/s, 0.00 creates/s, 0.00 writes/s Oct 13 16:16:56 mail-galera-b mysqld[3870]: Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000 Oct 13 16:16:56 mail-galera-b mysqld[3870]: Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s Oct 13 16:16:56 mail-galera-b mysqld[3870]: LRU len: 22394, unzip_LRU len: 0 Oct 13 16:16:56 mail-galera-b mysqld[3870]: I/O sum[0]:cur[0], unzip sum[0]:cur[0] Oct 13 16:16:56 mail-galera-b mysqld[3870]: ---------------------- Oct 13 16:16:56 mail-galera-b mysqld[3870]: INDIVIDUAL BUFFER POOL INFO Oct 13 16:16:56 mail-galera-b mysqld[3870]: ---------------------- Oct 13 16:16:56 mail-galera-b mysqld[3870]: ---BUFFER POOL 0 Oct 13 16:16:56 mail-galera-b mysqld[3870]: Buffer pool size 64184 Oct 13 16:16:56 mail-galera-b mysqld[3870]: Free buffers 61655 Oct 13 16:16:56 mail-galera-b mysqld[3870]: Database pages 2345 Oct 13 16:16:56 mail-galera-b mysqld[3870]: Old database pages 857 Oct 13 16:16:56 mail-galera-b mysqld[3870]: Modified db pages 0 Oct 13 16:16:56 mail-galera-b mysqld[3870]: Percent of dirty pages(LRU & free pages): 0.000 Oct 13 16:16:56 mail-galera-b mysqld[3870]: Max dirty pages percent: 75.000 Oct 13 16:16:56 mail-galera-b mysqld[3870]: Pending reads 0 Oct 13 16:16:56 mail-galera-b mysqld[3870]: Pending writes: LRU 0, flush list 0, single page 0 Oct 13 16:16:56 mail-galera-b mysqld[3870]: Pages made young 7, not young 0 Oct 13 16:16:56 mail-galera-b mysqld[3870]: 0.00 youngs/s, 0.00 non-youngs/s Oct 13 16:16:56 mail-galera-b mysqld[3870]: Pages read 2288, created 57, written 6334042 Oct 13 16:16:56 mail-galera-b mysqld[3870]: 0.00 reads/s, 0.00 creates/s, 0.00 writes/s Oct 13 16:16:56 mail-galera-b mysqld[3870]: Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000 Oct 13 16:16:56 mail-galera-b mysqld[3870]: Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s Oct 13 16:16:56 mail-galera-b mysqld[3870]: LRU len: 2345, unzip_LRU len: 0 Oct 13 16:16:56 mail-galera-b mysqld[3870]: I/O sum[0]:cur[0], unzip sum[0]:cur[0] Oct 13 16:16:56 mail-galera-b mysqld[3870]: ---BUFFER POOL 1 Oct 13 16:16:56 mail-galera-b mysqld[3870]: Buffer pool size 64184 Oct 13 16:16:56 mail-galera-b mysqld[3870]: Free buffers 61682 Oct 13 16:16:56 mail-galera-b mysqld[3870]: Database pages 2296 Oct 13 16:16:56 mail-galera-b mysqld[3870]: Old database pages 832 Oct 13 16:16:56 mail-galera-b mysqld[3870]: Modified db pages 0 Oct 13 16:16:56 mail-galera-b mysqld[3870]: Percent of dirty pages(LRU & free pages): 0.000 Oct 13 16:16:56 mail-galera-b mysqld[3870]: Max dirty pages percent: 75.000 Oct 13 16:16:56 mail-galera-b mysqld[3870]: Pending reads 0 Oct 13 16:16:56 mail-galera-b mysqld[3870]: Pending writes: LRU 0, flush list 0, single page 0 Oct 13 16:16:56 mail-galera-b mysqld[3870]: Pages made young 12, not young 0 Oct 13 16:16:56 mail-galera-b mysqld[3870]: 0.00 youngs/s, 0.00 non-youngs/s Oct 13 16:16:56 mail-galera-b mysqld[3870]: Pages read 2234, created 62, written 1920184 Oct 13 16:16:56 mail-galera-b mysqld[3870]: 0.00 reads/s, 0.00 creates/s, 0.00 writes/s Oct 13 16:16:56 mail-galera-b mysqld[3870]: Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000 Oct 13 16:16:56 mail-galera-b mysqld[3870]: Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s Oct 13 16:16:56 mail-galera-b mysqld[3870]: LRU len: 2296, unzip_LRU len: 0 Oct 13 16:16:56 mail-galera-b mysqld[3870]: I/O sum[0]:cur[0], unzip sum[0]:cur[0] Oct 13 16:16:56 mail-galera-b mysqld[3870]: ---BUFFER POOL 2 Oct 13 16:16:56 mail-galera-b mysqld[3870]: Buffer pool size 64184 Oct 13 16:16:56 mail-galera-b mysqld[3870]: Free buffers 61714 Oct 13 16:16:56 mail-galera-b mysqld[3870]: Database pages 2282 Oct 13 16:16:56 mail-galera-b mysqld[3870]: Old database pages 836 Oct 13 16:16:56 mail-galera-b mysqld[3870]: Modified db pages 0 Oct 13 16:16:56 mail-galera-b mysqld[3870]: Percent of dirty pages(LRU & free pages): 0.000 Oct 13 16:16:56 mail-galera-b mysqld[3870]: Max dirty pages percent: 75.000 Oct 13 16:16:56 mail-galera-b mysqld[3870]: Pending reads 0 Oct 13 16:16:56 mail-galera-b mysqld[3870]: Pending writes: LRU 0, flush list 0, single page 0 Oct 13 16:16:56 mail-galera-b mysqld[3870]: Pages made young 11, not young 0 Oct 13 16:16:56 mail-galera-b mysqld[3870]: 0.00 youngs/s, 0.00 non-youngs/s Oct 13 16:16:56 mail-galera-b mysqld[3870]: Pages read 2179, created 103, written 12171362 Oct 13 16:16:56 mail-galera-b mysqld[3870]: 0.00 reads/s, 0.00 creates/s, 0.00 writes/s Oct 13 16:16:56 mail-galera-b mysqld[3870]: Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000 Oct 13 16:16:56 mail-galera-b mysqld[3870]: Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s Oct 13 16:16:56 mail-galera-b mysqld[3870]: LRU len: 2282, unzip_LRU len: 0 Oct 13 16:16:56 mail-galera-b mysqld[3870]: I/O sum[0]:cur[0], unzip sum[0]:cur[0] Oct 13 16:16:56 mail-galera-b mysqld[3870]: ---BUFFER POOL 3 Oct 13 16:16:56 mail-galera-b mysqld[3870]: Buffer pool size 64184 Oct 13 16:16:56 mail-galera-b mysqld[3870]: Free buffers 61673 Oct 13 16:16:56 mail-galera-b mysqld[3870]: Database pages 2299 Oct 13 16:16:56 mail-galera-b mysqld[3870]: Old database pages 854 Oct 13 16:16:56 mail-galera-b mysqld[3870]: Modified db pages 0 Oct 13 16:16:56 mail-galera-b mysqld[3870]: Percent of dirty pages(LRU & free pages): 0.000 Oct 13 16:16:56 mail-galera-b mysqld[3870]: Max dirty pages percent: 75.000 Oct 13 16:16:56 mail-galera-b mysqld[3870]: Pending reads 0 Oct 13 16:16:56 mail-galera-b mysqld[3870]: Pending writes: LRU 0, flush list 0, single page 0 Oct 13 16:16:56 mail-galera-b mysqld[3870]: Pages made young 13, not young 0 Oct 13 16:16:56 mail-galera-b mysqld[3870]: 0.00 youngs/s, 0.00 non-youngs/s Oct 13 16:16:56 mail-galera-b mysqld[3870]: Pages read 2232, created 67, written 12870847 Oct 13 16:16:56 mail-galera-b mysqld[3870]: 0.00 reads/s, 0.00 creates/s, 0.00 writes/s Oct 13 16:16:56 mail-galera-b mysqld[3870]: Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000 Oct 13 16:16:56 mail-galera-b mysqld[3870]: Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s Oct 13 16:16:56 mail-galera-b mysqld[3870]: LRU len: 2299, unzip_LRU len: 0 Oct 13 16:16:56 mail-galera-b mysqld[3870]: I/O sum[0]:cur[0], unzip sum[0]:cur[0] Oct 13 16:16:56 mail-galera-b mysqld[3870]: ---BUFFER POOL 4 Oct 13 16:16:56 mail-galera-b mysqld[3870]: Buffer pool size 64184 Oct 13 16:16:56 mail-galera-b mysqld[3870]: Free buffers 61697 Oct 13 16:16:56 mail-galera-b mysqld[3870]: Database pages 2308 Oct 13 16:16:56 mail-galera-b mysqld[3870]: Old database pages 860 Oct 13 16:16:56 mail-galera-b mysqld[3870]: Modified db pages 0 Oct 13 16:16:56 mail-galera-b mysqld[3870]: Percent of dirty pages(LRU & free pages): 0.000 Oct 13 16:16:56 mail-galera-b mysqld[3870]: Max dirty pages percent: 75.000 Oct 13 16:16:56 mail-galera-b mysqld[3870]: Pending reads 0 Oct 13 16:16:56 mail-galera-b mysqld[3870]: Pending writes: LRU 0, flush list 0, single page 0 Oct 13 16:16:56 mail-galera-b mysqld[3870]: Pages made young 6, not young 0 Oct 13 16:16:56 mail-galera-b mysqld[3870]: 0.00 youngs/s, 0.00 non-youngs/s Oct 13 16:16:56 mail-galera-b mysqld[3870]: Pages read 2291, created 17, written 12752504 Oct 13 16:16:56 mail-galera-b mysqld[3870]: 0.00 reads/s, 0.00 creates/s, 0.00 writes/s Oct 13 16:16:56 mail-galera-b mysqld[3870]: Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000 Oct 13 16:16:56 mail-galera-b mysqld[3870]: Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s Oct 13 16:16:56 mail-galera-b mysqld[3870]: LRU len: 2308, unzip_LRU len: 0 Oct 13 16:16:56 mail-galera-b mysqld[3870]: I/O sum[0]:cur[0], unzip sum[0]:cur[0] Oct 13 16:16:56 mail-galera-b mysqld[3870]: ---BUFFER POOL 5 Oct 13 16:16:56 mail-galera-b mysqld[3870]: Buffer pool size 64184 Oct 13 16:16:56 mail-galera-b mysqld[3870]: Free buffers 61760 Oct 13 16:16:56 mail-galera-b mysqld[3870]: Database pages 2226 Oct 13 16:16:56 mail-galera-b mysqld[3870]: Old database pages 820 Oct 13 16:16:56 mail-galera-b mysqld[3870]: Modified db pages 0 Oct 13 16:16:56 mail-galera-b mysqld[3870]: Percent of dirty pages(LRU & free pages): 0.000 Oct 13 16:16:56 mail-galera-b mysqld[3870]: Max dirty pages percent: 75.000 Oct 13 16:16:56 mail-galera-b mysqld[3870]: Pending reads 0 Oct 13 16:16:56 mail-galera-b mysqld[3870]: Pending writes: LRU 0, flush list 0, single page 0 Oct 13 16:16:56 mail-galera-b mysqld[3870]: Pages made young 1, not young 0 Oct 13 16:16:56 mail-galera-b mysqld[3870]: 0.00 youngs/s, 0.00 non-youngs/s Oct 13 16:16:56 mail-galera-b mysqld[3870]: Pages read 2171, created 55, written 1395438 Oct 13 16:16:56 mail-galera-b mysqld[3870]: 0.00 reads/s, 0.00 creates/s, 0.00 writes/s Oct 13 16:16:56 mail-galera-b mysqld[3870]: Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000 Oct 13 16:16:56 mail-galera-b mysqld[3870]: Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s Oct 13 16:16:56 mail-galera-b mysqld[3870]: LRU len: 2226, unzip_LRU len: 0 Oct 13 16:16:56 mail-galera-b mysqld[3870]: I/O sum[0]:cur[0], unzip sum[0]:cur[0] Oct 13 16:16:56 mail-galera-b mysqld[3870]: ---BUFFER POOL 6 Oct 13 16:16:56 mail-galera-b mysqld[3870]: Buffer pool size 64184 Oct 13 16:16:56 mail-galera-b mysqld[3870]: Free buffers 61816 Oct 13 16:16:56 mail-galera-b mysqld[3870]: Database pages 2179 Oct 13 16:16:56 mail-galera-b mysqld[3870]: Old database pages 784 Oct 13 16:16:56 mail-galera-b mysqld[3870]: Modified db pages 0 Oct 13 16:16:56 mail-galera-b mysqld[3870]: Percent of dirty pages(LRU & free pages): 0.000 Oct 13 16:16:56 mail-galera-b mysqld[3870]: Max dirty pages percent: 75.000 Oct 13 16:16:56 mail-galera-b mysqld[3870]: Pending reads 0 Oct 13 16:16:56 mail-galera-b mysqld[3870]: Pending writes: LRU 0, flush list 0, single page 0 Oct 13 16:16:56 mail-galera-b mysqld[3870]: Pages made young 5, not young 0 Oct 13 16:16:56 mail-galera-b mysqld[3870]: 0.00 youngs/s, 0.00 non-youngs/s Oct 13 16:16:56 mail-galera-b mysqld[3870]: Pages read 2042, created 137, written 11707729 Oct 13 16:16:56 mail-galera-b mysqld[3870]: 0.00 reads/s, 0.00 creates/s, 0.00 writes/s Oct 13 16:16:56 mail-galera-b mysqld[3870]: Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000 Oct 13 16:16:56 mail-galera-b mysqld[3870]: Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s Oct 13 16:16:56 mail-galera-b mysqld[3870]: LRU len: 2179, unzip_LRU len: 0 Oct 13 16:16:56 mail-galera-b mysqld[3870]: I/O sum[0]:cur[0], unzip sum[0]:cur[0] Oct 13 16:16:56 mail-galera-b mysqld[3870]: ---BUFFER POOL 7 Oct 13 16:16:56 mail-galera-b mysqld[3870]: Buffer pool size 64184 Oct 13 16:16:56 mail-galera-b mysqld[3870]: Free buffers 61690 Oct 13 16:16:56 mail-galera-b mysqld[3870]: Database pages 2280 Oct 13 16:16:56 mail-galera-b mysqld[3870]: Old database pages 839 Oct 13 16:16:56 mail-galera-b mysqld[3870]: Modified db pages 0 Oct 13 16:16:56 mail-galera-b mysqld[3870]: Percent of dirty pages(LRU & free pages): 0.000 Oct 13 16:16:56 mail-galera-b mysqld[3870]: Max dirty pages percent: 75.000 Oct 13 16:16:56 mail-galera-b mysqld[3870]: Pending reads 0 Oct 13 16:16:56 mail-galera-b mysqld[3870]: Pending writes: LRU 0, flush list 0, single page 0 Oct 13 16:16:56 mail-galera-b mysqld[3870]: Pages made young 6, not young 0 Oct 13 16:16:56 mail-galera-b mysqld[3870]: 0.00 youngs/s, 0.00 non-youngs/s Oct 13 16:16:56 mail-galera-b mysqld[3870]: Pages read 2236, created 44, written 2564124 Oct 13 16:16:56 mail-galera-b mysqld[3870]: 0.00 reads/s, 0.00 creates/s, 0.00 writes/s Oct 13 16:16:56 mail-galera-b mysqld[3870]: Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000 Oct 13 16:16:56 mail-galera-b mysqld[3870]: Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s Oct 13 16:16:56 mail-galera-b mysqld[3870]: LRU len: 2280, unzip_LRU len: 0 Oct 13 16:16:56 mail-galera-b mysqld[3870]: I/O sum[0]:cur[0], unzip sum[0]:cur[0] Oct 13 16:16:56 mail-galera-b mysqld[3870]: ---BUFFER POOL 8 Oct 13 16:16:56 mail-galera-b mysqld[3870]: Buffer pool size 64184 Oct 13 16:16:56 mail-galera-b mysqld[3870]: Free buffers 61964 Oct 13 16:16:56 mail-galera-b mysqld[3870]: Database pages 2038 Oct 13 16:16:56 mail-galera-b mysqld[3870]: Old database pages 759 Oct 13 16:16:56 mail-galera-b mysqld[3870]: Modified db pages 0 Oct 13 16:16:56 mail-galera-b mysqld[3870]: Percent of dirty pages(LRU & free pages): 0.000 Oct 13 16:16:56 mail-galera-b mysqld[3870]: Max dirty pages percent: 75.000 Oct 13 16:16:56 mail-galera-b mysqld[3870]: Pending reads 0 Oct 13 16:16:56 mail-galera-b mysqld[3870]: Pending writes: LRU 0, flush list 0, single page 0 Oct 13 16:16:56 mail-galera-b mysqld[3870]: Pages made young 4, not young 0 Oct 13 16:16:56 mail-galera-b mysqld[3870]: 0.00 youngs/s, 0.00 non-youngs/s Oct 13 16:16:56 mail-galera-b mysqld[3870]: Pages read 2014, created 24, written 1223995 Oct 13 16:16:56 mail-galera-b mysqld[3870]: 0.00 reads/s, 0.00 creates/s, 0.00 writes/s Oct 13 16:16:56 mail-galera-b mysqld[3870]: Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000 Oct 13 16:16:56 mail-galera-b mysqld[3870]: Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s Oct 13 16:16:56 mail-galera-b mysqld[3870]: LRU len: 2038, unzip_LRU len: 0 Oct 13 16:16:56 mail-galera-b mysqld[3870]: I/O sum[0]:cur[0], unzip sum[0]:cur[0] Oct 13 16:16:56 mail-galera-b mysqld[3870]: ---BUFFER POOL 9 Oct 13 16:16:56 mail-galera-b mysqld[3870]: Buffer pool size 64184 Oct 13 16:16:56 mail-galera-b mysqld[3870]: Free buffers 61815 Oct 13 16:16:56 mail-galera-b mysqld[3870]: Database pages 2141 Oct 13 16:16:56 mail-galera-b mysqld[3870]: Old database pages 774 Oct 13 16:16:56 mail-galera-b mysqld[3870]: Modified db pages 0 Oct 13 16:16:56 mail-galera-b mysqld[3870]: Percent of dirty pages(LRU & free pages): 0.000 Oct 13 16:16:56 mail-galera-b mysqld[3870]: Max dirty pages percent: 75.000 Oct 13 16:16:56 mail-galera-b mysqld[3870]: Pending reads 0 Oct 13 16:16:56 mail-galera-b mysqld[3870]: Pending writes: LRU 0, flush list 0, single page 0 Oct 13 16:16:56 mail-galera-b mysqld[3870]: Pages made young 5, not young 0 Oct 13 16:16:56 mail-galera-b mysqld[3870]: 0.00 youngs/s, 0.00 non-youngs/s Oct 13 16:16:56 mail-galera-b mysqld[3870]: Pages read 2058, created 83, written 1131528 Oct 13 16:16:56 mail-galera-b mysqld[3870]: 0.00 reads/s, 0.00 creates/s, 0.00 writes/s Oct 13 16:16:56 mail-galera-b mysqld[3870]: Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000 Oct 13 16:16:56 mail-galera-b mysqld[3870]: Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s Oct 13 16:16:56 mail-galera-b mysqld[3870]: LRU len: 2141, unzip_LRU len: 0 Oct 13 16:16:56 mail-galera-b mysqld[3870]: I/O sum[0]:cur[0], unzip sum[0]:cur[0] Oct 13 16:16:56 mail-galera-b mysqld[3870]: -------------- Oct 13 16:16:56 mail-galera-b mysqld[3870]: ROW OPERATIONS Oct 13 16:16:56 mail-galera-b mysqld[3870]: -------------- Oct 13 16:16:56 mail-galera-b mysqld[3870]: 0 queries inside InnoDB, 0 queries in queue Oct 13 16:16:56 mail-galera-b mysqld[3870]: 0 read views open inside InnoDB Oct 13 16:16:56 mail-galera-b mysqld[3870]: Process ID=3870, Main thread ID=140680083396352, state: sleeping Oct 13 16:16:56 mail-galera-b mysqld[3870]: Number of rows inserted 32869857, updated 9888305, deleted 32820685, read 373747683 Oct 13 16:16:56 mail-galera-b mysqld[3870]: 0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 637.15 reads/s Oct 13 16:16:56 mail-galera-b mysqld[3870]: Number of system rows inserted 7, updated 0, deleted 7, read 3451 Oct 13 16:16:56 mail-galera-b mysqld[3870]: 0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s Oct 13 16:16:56 mail-galera-b mysqld[3870]: ---------------------------- Oct 13 16:16:56 mail-galera-b mysqld[3870]: END OF INNODB MONITOR OUTPUT Oct 13 16:16:56 mail-galera-b mysqld[3870]: ============================ Oct 13 16:17:15 mail-galera-b mysqld[3870]: InnoDB: ###### Diagnostic info printed to the standard error stream Oct 13 16:17:16 mail-galera-b mysqld[3870]: 2020-10-13 16:17:16 0 [Warning] InnoDB: A long semaphore wait: Oct 13 16:17:16 mail-galera-b mysqld[3870]: --Thread 140678945888000 has waited at lock0lock.cc line 3898 for 395.00 seconds the semaphore: Oct 13 16:17:16 mail-galera-b mysqld[3870]: Mutex at 0x564fc9ebfb00, Mutex LOCK_SYS created lock0lock.cc:461, lock var 2 ... Oct 13 16:17:56 mail-galera-b mysqld[3870]: --Thread 140670992066304 has waited at lock0lock.cc line 3898 for 39.00 seconds the semaphore: Oct 13 16:17:56 mail-galera-b mysqld[3870]: Mutex at 0x564fc9ebfb00, Mutex LOCK_SYS created lock0lock.cc:461, lock var 2 Oct 13 16:17:56 mail-galera-b mysqld[3870]: OS WAIT ARRAY INFO: signal count 3431410 Oct 13 16:17:56 mail-galera-b mysqld[3870]: RW-shared spins 2454822, rounds 35201655, OS waits 1085274 Oct 13 16:17:56 mail-galera-b mysqld[3870]: RW-excl spins 10821872, rounds 47868535, OS waits 163437 Oct 13 16:17:56 mail-galera-b mysqld[3870]: RW-sx spins 5238, rounds 124137, OS waits 3618 Oct 13 16:17:56 mail-galera-b mysqld[3870]: Spin rounds per wait: 14.34 RW-shared, 4.42 RW-excl, 23.70 RW-sx Oct 13 16:17:56 mail-galera-b mysqld[3870]: FAIL TO OBTAIN LOCK MUTEX, SKIP LOCK INFO PRINTING Oct 13 16:17:56 mail-galera-b mysqld[3870]: -------- Oct 13 16:17:56 mail-galera-b mysqld[3870]: FILE I/O Oct 13 16:17:56 mail-galera-b mysqld[3870]: -------- Oct 13 16:17:56 mail-galera-b mysqld[3870]: I/O thread 0 state: waiting for completed aio requests (insert buffer thread) Oct 13 16:17:56 mail-galera-b mysqld[3870]: I/O thread 1 state: waiting for completed aio requests (log thread) Oct 13 16:17:56 mail-galera-b mysqld[3870]: I/O thread 2 state: waiting for completed aio requests (read thread) Oct 13 16:17:56 mail-galera-b mysqld[3870]: I/O thread 3 state: waiting for completed aio requests (read thread) Oct 13 16:17:56 mail-galera-b mysqld[3870]: I/O thread 4 state: waiting for completed aio requests (read thread) Oct 13 16:17:56 mail-galera-b mysqld[3870]: I/O thread 5 state: waiting for completed aio requests (read thread) Oct 13 16:17:56 mail-galera-b mysqld[3870]: I/O thread 6 state: waiting for completed aio requests (read thread) Oct 13 16:17:56 mail-galera-b mysqld[3870]: I/O thread 7 state: waiting for completed aio requests (read thread) Oct 13 16:17:56 mail-galera-b mysqld[3870]: I/O thread 8 state: waiting for completed aio requests (read thread) Oct 13 16:17:56 mail-galera-b mysqld[3870]: I/O thread 9 state: waiting for completed aio requests (read thread) Oct 13 16:17:56 mail-galera-b mysqld[3870]: I/O thread 10 state: waiting for completed aio requests (write thread) Oct 13 16:17:56 mail-galera-b mysqld[3870]: I/O thread 11 state: waiting for completed aio requests (write thread) Oct 13 16:17:56 mail-galera-b mysqld[3870]: I/O thread 12 state: waiting for completed aio requests (write thread) Oct 13 16:17:56 mail-galera-b mysqld[3870]: I/O thread 13 state: waiting for completed aio requests (write thread) Oct 13 16:17:56 mail-galera-b mysqld[3870]: Pending normal aio reads: [0, 0, 0, 0, 0, 0, 0, 0] , aio writes: [0, 0, 0, 0] , Oct 13 16:17:56 mail-galera-b mysqld[3870]: ibuf aio reads:, log i/o's:, sync i/o's: Oct 13 16:17:56 mail-galera-b mysqld[3870]: Pending flushes (fsync) log: 0; buffer pool: 0 Oct 13 16:17:56 mail-galera-b mysqld[3870]: 21779 OS file reads, 95306133 OS file writes, 23762006 OS fsyncs Oct 13 16:17:56 mail-galera-b mysqld[3870]: 0.00 reads/s, 0 avg bytes/read, 0.00 writes/s, 0.00 fsyncs/s Oct 13 16:17:56 mail-galera-b mysqld[3870]: ------------------------------------- Oct 13 16:17:56 mail-galera-b mysqld[3870]: INSERT BUFFER AND ADAPTIVE HASH INDEX Oct 13 16:17:56 mail-galera-b mysqld[3870]: ------------------------------------- Oct 13 16:17:56 mail-galera-b mysqld[3870]: Ibuf: size 1, free list len 0, seg size 2, 1 merges Oct 13 16:17:56 mail-galera-b mysqld[3870]: merged operations: Oct 13 16:17:56 mail-galera-b mysqld[3870]: insert 0, delete mark 5, delete 4 Oct 13 16:17:56 mail-galera-b mysqld[3870]: discarded operations: Oct 13 16:17:56 mail-galera-b mysqld[3870]: insert 0, delete mark 0, delete 0 Oct 13 16:17:56 mail-galera-b mysqld[3870]: Hash table size 2656321, node heap has 681 buffer(s) Oct 13 16:17:56 mail-galera-b mysqld[3870]: Hash table size 2656321, node heap has 3 buffer(s) Oct 13 16:17:56 mail-galera-b mysqld[3870]: Hash table size 2656321, node heap has 568 buffer(s) Oct 13 16:17:56 mail-galera-b mysqld[3870]: Hash table size 2656321, node heap has 309 buffer(s) Oct 13 16:17:56 mail-galera-b mysqld[3870]: Hash table size 2656321, node heap has 33 buffer(s) Oct 13 16:17:56 mail-galera-b mysqld[3870]: Hash table size 2656321, node heap has 26 buffer(s) Oct 13 16:17:56 mail-galera-b mysqld[3870]: Hash table size 2656321, node heap has 304 buffer(s) Oct 13 16:17:56 mail-galera-b mysqld[3870]: Hash table size 2656321, node heap has 57 buffer(s) Oct 13 16:17:56 mail-galera-b mysqld[3870]: 1490.88 hash searches/s, 87.10 non-hash searches/s Oct 13 16:17:56 mail-galera-b mysqld[3870]: --- Oct 13 16:17:56 mail-galera-b mysqld[3870]: LOG Oct 13 16:17:56 mail-galera-b mysqld[3870]: --- Oct 13 16:17:56 mail-galera-b mysqld[3870]: Log sequence number 215594486398 Oct 13 16:17:56 mail-galera-b mysqld[3870]: Log flushed up to 215594486398 Oct 13 16:17:56 mail-galera-b mysqld[3870]: Pages flushed up to 215594486398 Oct 13 16:17:56 mail-galera-b mysqld[3870]: Last checkpoint at 215594486389 Oct 13 16:17:56 mail-galera-b mysqld[3870]: 0 pending log flushes, 0 pending chkp writes Oct 13 16:17:56 mail-galera-b mysqld[3870]: 23026557 log i/o's done, 0.00 log i/o's/second Oct 13 16:17:56 mail-galera-b mysqld[3870]: ---------------------- Oct 13 16:17:56 mail-galera-b mysqld[3870]: BUFFER POOL AND MEMORY Oct 13 16:17:56 mail-galera-b mysqld[3870]: ---------------------- Oct 13 16:17:56 mail-galera-b mysqld[3870]: Total large memory allocated 11274289152 Oct 13 16:17:56 mail-galera-b mysqld[3870]: Dictionary memory allocated 76080 Oct 13 16:17:56 mail-galera-b mysqld[3870]: Buffer pool size 641840 Oct 13 16:17:56 mail-galera-b mysqld[3870]: Free buffers 617465 Oct 13 16:17:56 mail-galera-b mysqld[3870]: Database pages 22394 Oct 13 16:17:56 mail-galera-b mysqld[3870]: Old database pages 8215 Oct 13 16:17:56 mail-galera-b mysqld[3870]: Modified db pages 0 Oct 13 16:17:56 mail-galera-b mysqld[3870]: Percent of dirty pages(LRU & free pages): 0.000 Oct 13 16:17:56 mail-galera-b mysqld[3870]: Max dirty pages percent: 75.000 Oct 13 16:17:56 mail-galera-b mysqld[3870]: Pending reads 0 Oct 13 16:17:56 mail-galera-b mysqld[3870]: Pending writes: LRU 0, flush list 0, single page 0 Oct 13 16:17:56 mail-galera-b mysqld[3870]: Pages made young 70, not young 0 Oct 13 16:17:56 mail-galera-b mysqld[3870]: 0.00 youngs/s, 0.00 non-youngs/s Oct 13 16:17:56 mail-galera-b mysqld[3870]: Pages read 21745, created 649, written 64071753 Oct 13 16:17:56 mail-galera-b mysqld[3870]: 0.00 reads/s, 0.00 creates/s, 0.00 writes/s Oct 13 16:17:56 mail-galera-b mysqld[3870]: Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000 Oct 13 16:17:56 mail-galera-b mysqld[3870]: Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s Oct 13 16:17:56 mail-galera-b mysqld[3870]: LRU len: 22394, unzip_LRU len: 0 Oct 13 16:17:56 mail-galera-b mysqld[3870]: I/O sum[0]:cur[0], unzip sum[0]:cur[0] Oct 13 16:17:56 mail-galera-b mysqld[3870]: ---------------------- Oct 13 16:17:56 mail-galera-b mysqld[3870]: INDIVIDUAL BUFFER POOL INFO Oct 13 16:17:56 mail-galera-b mysqld[3870]: ---------------------- Oct 13 16:17:56 mail-galera-b mysqld[3870]: ---BUFFER POOL 0 Oct 13 16:17:56 mail-galera-b mysqld[3870]: Buffer pool size 64184 Oct 13 16:17:56 mail-galera-b mysqld[3870]: Free buffers 61655 Oct 13 16:17:56 mail-galera-b mysqld[3870]: Database pages 2345 Oct 13 16:17:56 mail-galera-b mysqld[3870]: Old database pages 857 Oct 13 16:17:56 mail-galera-b mysqld[3870]: Modified db pages 0 Oct 13 16:17:56 mail-galera-b mysqld[3870]: Percent of dirty pages(LRU & free pages): 0.000 Oct 13 16:17:56 mail-galera-b mysqld[3870]: Max dirty pages percent: 75.000 Oct 13 16:17:56 mail-galera-b mysqld[3870]: Pending reads 0 Oct 13 16:17:56 mail-galera-b mysqld[3870]: Pending writes: LRU 0, flush list 0, single page 0 Oct 13 16:17:56 mail-galera-b mysqld[3870]: Pages made young 7, not young 0 Oct 13 16:17:56 mail-galera-b mysqld[3870]: 0.00 youngs/s, 0.00 non-youngs/s Oct 13 16:17:56 mail-galera-b mysqld[3870]: Pages read 2288, created 57, written 6334042 Oct 13 16:17:56 mail-galera-b mysqld[3870]: 0.00 reads/s, 0.00 creates/s, 0.00 writes/s Oct 13 16:17:56 mail-galera-b mysqld[3870]: Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000 Oct 13 16:17:56 mail-galera-b mysqld[3870]: Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s Oct 13 16:17:56 mail-galera-b mysqld[3870]: LRU len: 2345, unzip_LRU len: 0 Oct 13 16:17:56 mail-galera-b mysqld[3870]: I/O sum[0]:cur[0], unzip sum[0]:cur[0] Oct 13 16:17:56 mail-galera-b mysqld[3870]: ---BUFFER POOL 1 Oct 13 16:17:56 mail-galera-b mysqld[3870]: Buffer pool size 64184 Oct 13 16:17:56 mail-galera-b mysqld[3870]: Free buffers 61682 Oct 13 16:17:56 mail-galera-b mysqld[3870]: Database pages 2296 Oct 13 16:17:56 mail-galera-b mysqld[3870]: Old database pages 832 Oct 13 16:17:56 mail-galera-b mysqld[3870]: Modified db pages 0 Oct 13 16:17:56 mail-galera-b mysqld[3870]: Percent of dirty pages(LRU & free pages): 0.000 Oct 13 16:17:56 mail-galera-b mysqld[3870]: Max dirty pages percent: 75.000 Oct 13 16:17:56 mail-galera-b mysqld[3870]: Pending reads 0 Oct 13 16:17:56 mail-galera-b mysqld[3870]: Pending writes: LRU 0, flush list 0, single page 0 Oct 13 16:17:56 mail-galera-b mysqld[3870]: Pages made young 12, not young 0 Oct 13 16:17:56 mail-galera-b mysqld[3870]: 0.00 youngs/s, 0.00 non-youngs/s Oct 13 16:17:56 mail-galera-b mysqld[3870]: Pages read 2234, created 62, written 1920184 Oct 13 16:17:56 mail-galera-b mysqld[3870]: 0.00 reads/s, 0.00 creates/s, 0.00 writes/s Oct 13 16:17:56 mail-galera-b mysqld[3870]: Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000 Oct 13 16:17:56 mail-galera-b mysqld[3870]: Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s Oct 13 16:17:56 mail-galera-b mysqld[3870]: LRU len: 2296, unzip_LRU len: 0 Oct 13 16:17:56 mail-galera-b mysqld[3870]: I/O sum[0]:cur[0], unzip sum[0]:cur[0] Oct 13 16:17:56 mail-galera-b mysqld[3870]: ---BUFFER POOL 2 Oct 13 16:17:56 mail-galera-b mysqld[3870]: Buffer pool size 64184 Oct 13 16:17:56 mail-galera-b mysqld[3870]: Free buffers 61714 Oct 13 16:17:56 mail-galera-b mysqld[3870]: Database pages 2282 Oct 13 16:17:56 mail-galera-b mysqld[3870]: Old database pages 836 Oct 13 16:17:56 mail-galera-b mysqld[3870]: Modified db pages 0 Oct 13 16:17:56 mail-galera-b mysqld[3870]: Percent of dirty pages(LRU & free pages): 0.000 Oct 13 16:17:56 mail-galera-b mysqld[3870]: Max dirty pages percent: 75.000 Oct 13 16:17:56 mail-galera-b mysqld[3870]: Pending reads 0 Oct 13 16:17:56 mail-galera-b mysqld[3870]: Pending writes: LRU 0, flush list 0, single page 0 Oct 13 16:17:56 mail-galera-b mysqld[3870]: Pages made young 11, not young 0 Oct 13 16:17:56 mail-galera-b mysqld[3870]: 0.00 youngs/s, 0.00 non-youngs/s Oct 13 16:17:56 mail-galera-b mysqld[3870]: Pages read 2179, created 103, written 12171362 Oct 13 16:17:56 mail-galera-b mysqld[3870]: 0.00 reads/s, 0.00 creates/s, 0.00 writes/s Oct 13 16:17:56 mail-galera-b mysqld[3870]: Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000 Oct 13 16:17:56 mail-galera-b mysqld[3870]: Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s Oct 13 16:17:56 mail-galera-b mysqld[3870]: LRU len: 2282, unzip_LRU len: 0 Oct 13 16:17:56 mail-galera-b mysqld[3870]: I/O sum[0]:cur[0], unzip sum[0]:cur[0] Oct 13 16:17:56 mail-galera-b mysqld[3870]: ---BUFFER POOL 3 Oct 13 16:17:56 mail-galera-b mysqld[3870]: Buffer pool size 64184 Oct 13 16:17:56 mail-galera-b mysqld[3870]: Free buffers 61672 Oct 13 16:17:56 mail-galera-b mysqld[3870]: Database pages 2299 Oct 13 16:17:56 mail-galera-b mysqld[3870]: Old database pages 854 Oct 13 16:17:56 mail-galera-b mysqld[3870]: Modified db pages 0 Oct 13 16:17:56 mail-galera-b mysqld[3870]: Percent of dirty pages(LRU & free pages): 0.000 Oct 13 16:17:56 mail-galera-b mysqld[3870]: Max dirty pages percent: 75.000 Oct 13 16:17:56 mail-galera-b mysqld[3870]: Pending reads 0 Oct 13 16:17:56 mail-galera-b mysqld[3870]: Pending writes: LRU 0, flush list 0, single page 0 Oct 13 16:17:56 mail-galera-b mysqld[3870]: Pages made young 13, not young 0 Oct 13 16:17:56 mail-galera-b mysqld[3870]: 0.00 youngs/s, 0.00 non-youngs/s Oct 13 16:17:56 mail-galera-b mysqld[3870]: Pages read 2232, created 67, written 12870847 Oct 13 16:17:56 mail-galera-b mysqld[3870]: 0.00 reads/s, 0.00 creates/s, 0.00 writes/s Oct 13 16:17:56 mail-galera-b mysqld[3870]: Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000 Oct 13 16:17:56 mail-galera-b mysqld[3870]: Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s Oct 13 16:17:56 mail-galera-b mysqld[3870]: LRU len: 2299, unzip_LRU len: 0 Oct 13 16:17:56 mail-galera-b mysqld[3870]: I/O sum[0]:cur[0], unzip sum[0]:cur[0] Oct 13 16:17:56 mail-galera-b mysqld[3870]: ---BUFFER POOL 4 Oct 13 16:17:56 mail-galera-b mysqld[3870]: Buffer pool size 64184 Oct 13 16:17:56 mail-galera-b mysqld[3870]: Free buffers 61697 Oct 13 16:17:56 mail-galera-b mysqld[3870]: Database pages 2308 Oct 13 16:17:56 mail-galera-b mysqld[3870]: Old database pages 860 Oct 13 16:17:56 mail-galera-b mysqld[3870]: Modified db pages 0 Oct 13 16:17:56 mail-galera-b mysqld[3870]: Percent of dirty pages(LRU & free pages): 0.000 Oct 13 16:17:56 mail-galera-b mysqld[3870]: Max dirty pages percent: 75.000 Oct 13 16:17:56 mail-galera-b mysqld[3870]: Pending reads 0 Oct 13 16:17:56 mail-galera-b mysqld[3870]: Pending writes: LRU 0, flush list 0, single page 0 Oct 13 16:17:56 mail-galera-b mysqld[3870]: Pages made young 6, not young 0 Oct 13 16:17:56 mail-galera-b mysqld[3870]: 0.00 youngs/s, 0.00 non-youngs/s Oct 13 16:17:56 mail-galera-b mysqld[3870]: Pages read 2291, created 17, written 12752504 Oct 13 16:17:56 mail-galera-b mysqld[3870]: 0.00 reads/s, 0.00 creates/s, 0.00 writes/s Oct 13 16:17:56 mail-galera-b mysqld[3870]: Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000 Oct 13 16:17:56 mail-galera-b mysqld[3870]: Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s Oct 13 16:17:56 mail-galera-b mysqld[3870]: LRU len: 2308, unzip_LRU len: 0 Oct 13 16:17:56 mail-galera-b mysqld[3870]: I/O sum[0]:cur[0], unzip sum[0]:cur[0] Oct 13 16:17:56 mail-galera-b mysqld[3870]: ---BUFFER POOL 5 Oct 13 16:17:56 mail-galera-b mysqld[3870]: Buffer pool size 64184 Oct 13 16:17:56 mail-galera-b mysqld[3870]: Free buffers 61760 Oct 13 16:17:56 mail-galera-b mysqld[3870]: Database pages 2226 Oct 13 16:17:56 mail-galera-b mysqld[3870]: Old database pages 820 Oct 13 16:17:56 mail-galera-b mysqld[3870]: Modified db pages 0 Oct 13 16:17:56 mail-galera-b mysqld[3870]: Percent of dirty pages(LRU & free pages): 0.000 Oct 13 16:17:56 mail-galera-b mysqld[3870]: Max dirty pages percent: 75.000 Oct 13 16:17:56 mail-galera-b mysqld[3870]: Pending reads 0 Oct 13 16:17:56 mail-galera-b mysqld[3870]: Pending writes: LRU 0, flush list 0, single page 0 Oct 13 16:17:56 mail-galera-b mysqld[3870]: Pages made young 1, not young 0 Oct 13 16:17:56 mail-galera-b mysqld[3870]: 0.00 youngs/s, 0.00 non-youngs/s Oct 13 16:17:56 mail-galera-b mysqld[3870]: Pages read 2171, created 55, written 1395438 Oct 13 16:17:56 mail-galera-b mysqld[3870]: 0.00 reads/s, 0.00 creates/s, 0.00 writes/s Oct 13 16:17:56 mail-galera-b mysqld[3870]: Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000 Oct 13 16:17:56 mail-galera-b mysqld[3870]: Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s Oct 13 16:17:56 mail-galera-b mysqld[3870]: LRU len: 2226, unzip_LRU len: 0 Oct 13 16:17:56 mail-galera-b mysqld[3870]: I/O sum[0]:cur[0], unzip sum[0]:cur[0] Oct 13 16:17:56 mail-galera-b mysqld[3870]: ---BUFFER POOL 6 Oct 13 16:17:56 mail-galera-b mysqld[3870]: Buffer pool size 64184 Oct 13 16:17:56 mail-galera-b mysqld[3870]: Free buffers 61816 Oct 13 16:17:56 mail-galera-b mysqld[3870]: Database pages 2179 Oct 13 16:17:56 mail-galera-b mysqld[3870]: Old database pages 784 Oct 13 16:17:56 mail-galera-b mysqld[3870]: Modified db pages 0 Oct 13 16:17:56 mail-galera-b mysqld[3870]: Percent of dirty pages(LRU & free pages): 0.000 Oct 13 16:17:56 mail-galera-b mysqld[3870]: Max dirty pages percent: 75.000 Oct 13 16:17:56 mail-galera-b mysqld[3870]: Pending reads 0 Oct 13 16:17:56 mail-galera-b mysqld[3870]: Pending writes: LRU 0, flush list 0, single page 0 Oct 13 16:17:56 mail-galera-b mysqld[3870]: Pages made young 5, not young 0 Oct 13 16:17:56 mail-galera-b mysqld[3870]: 0.00 youngs/s, 0.00 non-youngs/s Oct 13 16:17:56 mail-galera-b mysqld[3870]: Pages read 2042, created 137, written 11707729 Oct 13 16:17:56 mail-galera-b mysqld[3870]: 0.00 reads/s, 0.00 creates/s, 0.00 writes/s Oct 13 16:17:56 mail-galera-b mysqld[3870]: Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000 Oct 13 16:17:56 mail-galera-b mysqld[3870]: Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s Oct 13 16:17:56 mail-galera-b mysqld[3870]: LRU len: 2179, unzip_LRU len: 0 Oct 13 16:17:56 mail-galera-b mysqld[3870]: I/O sum[0]:cur[0], unzip sum[0]:cur[0] Oct 13 16:17:56 mail-galera-b mysqld[3870]: ---BUFFER POOL 7 Oct 13 16:17:56 mail-galera-b mysqld[3870]: Buffer pool size 64184 Oct 13 16:17:56 mail-galera-b mysqld[3870]: Free buffers 61690 Oct 13 16:17:56 mail-galera-b mysqld[3870]: Database pages 2280 Oct 13 16:17:56 mail-galera-b mysqld[3870]: Old database pages 839 Oct 13 16:17:56 mail-galera-b mysqld[3870]: Modified db pages 0 Oct 13 16:17:56 mail-galera-b mysqld[3870]: Percent of dirty pages(LRU & free pages): 0.000 Oct 13 16:17:56 mail-galera-b mysqld[3870]: Max dirty pages percent: 75.000 Oct 13 16:17:56 mail-galera-b mysqld[3870]: Pending reads 0 Oct 13 16:17:56 mail-galera-b mysqld[3870]: Pending writes: LRU 0, flush list 0, single page 0 Oct 13 16:17:56 mail-galera-b mysqld[3870]: Pages made young 6, not young 0 Oct 13 16:17:56 mail-galera-b mysqld[3870]: 0.00 youngs/s, 0.00 non-youngs/s Oct 13 16:17:56 mail-galera-b mysqld[3870]: Pages read 2236, created 44, written 2564124 Oct 13 16:17:56 mail-galera-b mysqld[3870]: 0.00 reads/s, 0.00 creates/s, 0.00 writes/s Oct 13 16:17:56 mail-galera-b mysqld[3870]: Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000 Oct 13 16:17:56 mail-galera-b mysqld[3870]: Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s Oct 13 16:17:56 mail-galera-b mysqld[3870]: LRU len: 2280, unzip_LRU len: 0 Oct 13 16:17:56 mail-galera-b mysqld[3870]: I/O sum[0]:cur[0], unzip sum[0]:cur[0] Oct 13 16:17:56 mail-galera-b mysqld[3870]: ---BUFFER POOL 8 Oct 13 16:17:56 mail-galera-b mysqld[3870]: Buffer pool size 64184 Oct 13 16:17:56 mail-galera-b mysqld[3870]: Free buffers 61964 Oct 13 16:17:56 mail-galera-b mysqld[3870]: Database pages 2038 Oct 13 16:17:56 mail-galera-b mysqld[3870]: Old database pages 759 Oct 13 16:17:56 mail-galera-b mysqld[3870]: Modified db pages 0 Oct 13 16:17:56 mail-galera-b mysqld[3870]: Percent of dirty pages(LRU & free pages): 0.000 Oct 13 16:17:56 mail-galera-b mysqld[3870]: Max dirty pages percent: 75.000 Oct 13 16:17:56 mail-galera-b mysqld[3870]: Pending reads 0 Oct 13 16:17:56 mail-galera-b mysqld[3870]: Pending writes: LRU 0, flush list 0, single page 0 Oct 13 16:17:56 mail-galera-b mysqld[3870]: Pages made young 4, not young 0 Oct 13 16:17:56 mail-galera-b mysqld[3870]: 0.00 youngs/s, 0.00 non-youngs/s Oct 13 16:17:56 mail-galera-b mysqld[3870]: Pages read 2014, created 24, written 1223995 Oct 13 16:17:56 mail-galera-b mysqld[3870]: 0.00 reads/s, 0.00 creates/s, 0.00 writes/s Oct 13 16:17:56 mail-galera-b mysqld[3870]: Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000 Oct 13 16:17:56 mail-galera-b mysqld[3870]: Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s Oct 13 16:17:56 mail-galera-b mysqld[3870]: LRU len: 2038, unzip_LRU len: 0 Oct 13 16:17:56 mail-galera-b mysqld[3870]: I/O sum[0]:cur[0], unzip sum[0]:cur[0] Oct 13 16:17:56 mail-galera-b mysqld[3870]: ---BUFFER POOL 9 Oct 13 16:17:56 mail-galera-b mysqld[3870]: Buffer pool size 64184 Oct 13 16:17:56 mail-galera-b mysqld[3870]: Free buffers 61815 Oct 13 16:17:56 mail-galera-b mysqld[3870]: Database pages 2141 Oct 13 16:17:56 mail-galera-b mysqld[3870]: Old database pages 774 Oct 13 16:17:56 mail-galera-b mysqld[3870]: Modified db pages 0 Oct 13 16:17:56 mail-galera-b mysqld[3870]: Percent of dirty pages(LRU & free pages): 0.000 Oct 13 16:17:56 mail-galera-b mysqld[3870]: Max dirty pages percent: 75.000 Oct 13 16:17:56 mail-galera-b mysqld[3870]: Pending reads 0 Oct 13 16:17:56 mail-galera-b mysqld[3870]: Pending writes: LRU 0, flush list 0, single page 0 Oct 13 16:17:56 mail-galera-b mysqld[3870]: Pages made young 5, not young 0 Oct 13 16:17:56 mail-galera-b mysqld[3870]: 0.00 youngs/s, 0.00 non-youngs/s Oct 13 16:17:56 mail-galera-b mysqld[3870]: Pages read 2058, created 83, written 1131528 Oct 13 16:17:56 mail-galera-b mysqld[3870]: 0.00 reads/s, 0.00 creates/s, 0.00 writes/s Oct 13 16:17:56 mail-galera-b mysqld[3870]: Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000 Oct 13 16:17:56 mail-galera-b mysqld[3870]: Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s Oct 13 16:17:56 mail-galera-b mysqld[3870]: LRU len: 2141, unzip_LRU len: 0 Oct 13 16:17:56 mail-galera-b mysqld[3870]: I/O sum[0]:cur[0], unzip sum[0]:cur[0] Oct 13 16:17:56 mail-galera-b mysqld[3870]: -------------- Oct 13 16:17:56 mail-galera-b mysqld[3870]: ROW OPERATIONS Oct 13 16:17:56 mail-galera-b mysqld[3870]: -------------- Oct 13 16:17:56 mail-galera-b mysqld[3870]: 0 queries inside InnoDB, 0 queries in queue Oct 13 16:17:56 mail-galera-b mysqld[3870]: 0 read views open inside InnoDB Oct 13 16:17:56 mail-galera-b mysqld[3870]: Process ID=3870, Main thread ID=140680083396352, state: sleeping Oct 13 16:17:56 mail-galera-b mysqld[3870]: Number of rows inserted 32869857, updated 9888305, deleted 32820685, read 373787241 Oct 13 16:17:56 mail-galera-b mysqld[3870]: 0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 633.82 reads/s Oct 13 16:17:56 mail-galera-b mysqld[3870]: Number of system rows inserted 7, updated 0, deleted 7, read 3451 Oct 13 16:17:56 mail-galera-b mysqld[3870]: 0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s Oct 13 16:17:56 mail-galera-b mysqld[3870]: ---------------------------- Oct 13 16:17:56 mail-galera-b mysqld[3870]: END OF INNODB MONITOR OUTPUT Oct 13 16:17:56 mail-galera-b mysqld[3870]: ============================ Oct 13 16:18:16 mail-galera-b mysqld[3870]: ===================================== Oct 13 16:18:16 mail-galera-b mysqld[3870]: 2020-10-13 16:18:16 0x7ff2a3e60700 INNODB MONITOR OUTPUT Oct 13 16:18:16 mail-galera-b mysqld[3870]: ===================================== Oct 13 16:18:16 mail-galera-b mysqld[3870]: Per second averages calculated from the last 20 seconds Oct 13 16:18:16 mail-galera-b mysqld[3870]: ----------------- Oct 13 16:18:16 mail-galera-b mysqld[3870]: BACKGROUND THREAD Oct 13 16:18:16 mail-galera-b mysqld[3870]: ----------------- Oct 13 16:18:16 mail-galera-b mysqld[3870]: srv_master_thread loops: 2219 srv_active, 0 srv_shutdown, 1009434 srv_idle Oct 13 16:18:16 mail-galera-b mysqld[3870]: srv_master_thread log flush and writes: 1011651 Oct 13 16:18:16 mail-galera-b mysqld[3870]: ---------- Oct 13 16:18:16 mail-galera-b mysqld[3870]: SEMAPHORES Oct 13 16:18:16 mail-galera-b mysqld[3870]: ---------- Oct 13 16:18:16 mail-galera-b mysqld[3870]: OS WAIT ARRAY INFO: reservation count 3655531 Oct 13 16:18:16 mail-galera-b mysqld[3870]: --Thread 140678945888000 has waited at lock0lock.cc line 3898 for 455.00 seconds the semaphore: Oct 13 16:18:16 mail-galera-b mysqld[3870]: Mutex at 0x564fc9ebfb00, Mutex LOCK_SYS created lock0lock.cc:461, lock var 2 ... Oct 13 16:26:06 mail-galera-b mysqld[3870]: --Thread 140671006504704 has waited at lock0lock.cc line 3898 for 90.00 seconds the semaphore: Oct 13 16:26:06 mail-galera-b mysqld[3870]: Mutex at 0x564fc9ebfb00, Mutex LOCK_SYS created lock0lock.cc:461, lock var 2 Oct 13 16:26:06 mail-galera-b mysqld[3870]: InnoDB: ###### Starts InnoDB Monitor for 30 secs to print diagnostic info: Oct 13 16:26:06 mail-galera-b mysqld[3870]: InnoDB: Pending reads 0, writes 0 Oct 13 16:26:35 mail-galera-b mysqld[3870]: InnoDB: ###### Diagnostic info printed to the standard error stream Oct 13 16:26:35 mail-galera-b mysqld[3870]: 2020-10-13 16:26:35 0 [ERROR] [FATAL] InnoDB: Semaphore wait has lasted > 600 seconds. We intentionally crash the server because it appears to be hung. Oct 13 16:26:35 mail-galera-b mysqld[3870]: 201013 16:26:35 [ERROR] mysqld got signal 6 ; Oct 13 16:26:35 mail-galera-b mysqld[3870]: This could be because you hit a bug. It is also possible that this binary Oct 13 16:26:35 mail-galera-b mysqld[3870]: or one of the libraries it was linked against is corrupt, improperly built, Oct 13 16:26:35 mail-galera-b mysqld[3870]: or misconfigured. This error can also be caused by malfunctioning hardware. Oct 13 16:26:35 mail-galera-b mysqld[3870]: To report this bug, see https://mariadb.com/kb/en/reporting-bugs Oct 13 16:26:35 mail-galera-b mysqld[3870]: We will try our best to scrape up some info that will hopefully help Oct 13 16:26:35 mail-galera-b mysqld[3870]: diagnose the problem, but since we have already crashed, Oct 13 16:26:35 mail-galera-b mysqld[3870]: something is definitely wrong and this may fail. Oct 13 16:26:35 mail-galera-b mysqld[3870]: Server version: 10.4.14-MariaDB-log Oct 13 16:26:35 mail-galera-b mysqld[3870]: key_buffer_size=134217728 Oct 13 16:26:35 mail-galera-b mysqld[3870]: read_buffer_size=131072 Oct 13 16:26:35 mail-galera-b mysqld[3870]: max_used_connections=3001 Oct 13 16:26:35 mail-galera-b mysqld[3870]: max_threads=3011 Oct 13 16:26:35 mail-galera-b mysqld[3870]: thread_count=3015 Oct 13 16:26:35 mail-galera-b mysqld[3870]: It is possible that mysqld could use up to Oct 13 16:26:35 mail-galera-b mysqld[3870]: key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 6757411 K bytes of memory Oct 13 16:26:35 mail-galera-b mysqld[3870]: Hope that's ok; if not, decrease some variables in the equation. Oct 13 16:26:35 mail-galera-b mysqld[3870]: Thread pointer: 0x0 Oct 13 16:26:35 mail-galera-b mysqld[3870]: Attempting backtrace. You can use the following information to find out Oct 13 16:26:35 mail-galera-b mysqld[3870]: where mysqld died. If you see no messages after this, something went Oct 13 16:26:35 mail-galera-b mysqld[3870]: terribly wrong... Oct 13 16:26:35 mail-galera-b mysqld[3870]: stack_bottom = 0x0 thread_stack 0x49000 Oct 13 16:26:35 mail-galera-b mysqld[3870]: *** buffer overflow detected ***: /usr/sbin/mysqld terminated Oct 13 16:26:35 mail-galera-b systemd[1]: Created slice system-systemd\x2dcoredump.slice. Oct 13 16:26:35 mail-galera-b systemd[1]: Started Process Core Dump (PID 555980/UID 0). Oct 13 16:26:38 mail-galera-b systemd-coredump[555981]: Core file was truncated to 2147483648 bytes. Oct 13 16:26:40 mail-galera-b systemd-coredump[555981]: Process 3870 (mysqld) of user 995 dumped core.#012#012Stack trace of thread 5182:#012#0 0x00007ff5dd27070f n/a (n/a)#012#1 0x00007ff5dd346905 n/a (n/a)