Hello, Sorry, I wasn't free the days. lorraine.pocklington -> I have some customers on my DB and so I have to plan when to do a large restore db. So last time the crash happen was 2 month ago and I have log rotation on 15 days. I will perform a crash test soon. przemek -> I host an application for which editor wants 'pxc_strict_mode=DISABLED' so not a personnal choice. [QUOTE]In this state I can't do any operation, all server are down[/QUOTE] When cluster freeze I can't perform any mysql operation on (even SELECT). IO capacity has been benched and I take 30% less maximum value in RW mode with large samples, according with my engineer. I have SSD + NVMe. Here the basics output on each nodes : NODE 1 > SHOW PROCESSLIST; [CODE]+-----+-------------+---------------------+------+---------+------+--------------------------------------+------------------+-----------+---------------+ | Id | User | Host | db | Command | Time | State | Info | Rows_sent | Rows_examined | +-----+-------------+---------------------+------+---------+------+--------------------------------------+------------------+-----------+---------------+ | 1 | system user | | NULL | Sleep | 32 | wsrep: committed write set (3933532) | NULL | 0 | 0 | | 2 | system user | | NULL | Sleep | 86 | wsrep: aborter idle | NULL | 0 | 0 | | 3 | system user | | NULL | Sleep | 33 | wsrep: committed write set (3933529) | NULL | 0 | 0 | | 4 | system user | | NULL | Sleep | 32 | wsrep: committed write set (3933531) | NULL | 0 | 0 | | 5 | system user | | NULL | Sleep | 32 | wsrep: committed write set (3933530) | NULL | 0 | 0 | | 6 | system user | | NULL | Sleep | 32 | wsrep: committed write set (3933533) | NULL | 0 | 0 | | 8 | system user | | NULL | Sleep | 32 | wsrep: committed write set (3933534) | NULL | 0 | 0 | | 9 | system user | | NULL | Sleep | 32 | wsrep: committed write set (3933535) | NULL | 0 | 0 | | 10 | system user | | NULL | Sleep | 33 | wsrep: committed write set (3933528) | NULL | 0 | 0 | | 24 | monitor | 192.168.100.2:42802 | NULL | Sleep | 1 | | NULL | 0 | 0 | | 29 | monitor | 192.168.100.1:43654 | NULL | Sleep | 7 | | NULL | 0 | 0 | | 80 | root | localhost | NULL | Sleep | 0 | | NULL | 238 | 238 | | 81 | root | localhost | NULL | Sleep | 0 | | NULL | 487 | 974 | | 87 | root | localhost | NULL | Sleep | 0 | | NULL | 1 | 0 | | 100 | admin-pxc | localhost | NULL | Query | 0 | starting | SHOW PROCESSLIST | 0 | 0 | +-----+-------------+---------------------+------+---------+------+--------------------------------------+------------------+-----------+---------------+ [/CODE] node 1: SHOW ENGINE INNODB STATUS\G [CODE] *************************** 1. row *************************** Type: InnoDB Name: Status: ===================================== 2019-08-02 11:13:10 0x7f34c4081700 INNODB MONITOR OUTPUT ===================================== Per second averages calculated from the last 23 seconds ----------------- BACKGROUND THREAD ----------------- srv_master_thread loops: 24 srv_active, 0 srv_shutdown, 58 srv_idle srv_master_thread log flush and writes: 82 ---------- SEMAPHORES ---------- OS WAIT ARRAY INFO: reservation count 31 OS WAIT ARRAY INFO: signal count 29 RW-shared spins 0, rounds 16, OS waits 8 RW-excl spins 0, rounds 0, OS waits 0 RW-sx spins 0, rounds 0, OS waits 0 Spin rounds per wait: 16.00 RW-shared, 0.00 RW-excl, 0.00 RW-sx ------------ TRANSACTIONS ------------ Trx id counter 36535331 Purge done for trx's n:o < 36535318 undo n:o < 0 state: running but idle History list length 2 LIST OF TRANSACTIONS FOR EACH SESSION: ---TRANSACTION 421339868702352, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421339868701192, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421339868690752, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421339868700032, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421339868698872, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421339868697712, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421339868696552, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421339868695392, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421339868694232, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421339868693072, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421339868691912, not started 0 lock struct(s), heap size 1136, 0 row lock(s) -------- FILE I/O -------- I/O thread 0 state: waiting for completed aio requests (insert buffer thread) I/O thread 1 state: waiting for completed aio requests (log thread) I/O thread 2 state: waiting for completed aio requests (read thread) I/O thread 3 state: waiting for completed aio requests (read thread) I/O thread 4 state: waiting for completed aio requests (read thread) I/O thread 5 state: waiting for completed aio requests (read thread) I/O thread 6 state: waiting for completed aio requests (read thread) I/O thread 7 state: waiting for completed aio requests (read thread) I/O thread 8 state: waiting for completed aio requests (read thread) I/O thread 9 state: waiting for completed aio requests (read thread) I/O thread 10 state: waiting for completed aio requests (write thread) I/O thread 11 state: waiting for completed aio requests (write thread) I/O thread 12 state: waiting for completed aio requests (write thread) I/O thread 13 state: waiting for completed aio requests (write thread) I/O thread 14 state: waiting for completed aio requests (write thread) I/O thread 15 state: waiting for completed aio requests (write thread) I/O thread 16 state: waiting for completed aio requests (write thread) I/O thread 17 state: waiting for completed aio requests (write thread) Pending normal aio reads: [0, 0, 0, 0, 0, 0, 0, 0] , aio writes: [0, 0, 0, 0, 0, 0, 0, 0] , ibuf aio reads:, log i/o's:, sync i/o's: Pending flushes (fsync) log: 0; buffer pool: 0 76435 OS file reads, 245 OS file writes, 51 OS fsyncs 0.00 reads/s, 0 avg bytes/read, 0.52 writes/s, 0.00 fsyncs/s ------------------------------------- INSERT BUFFER AND ADAPTIVE HASH INDEX ------------------------------------- Ibuf: size 1, free list len 0, seg size 2, 0 merges merged operations: insert 0, delete mark 0, delete 0 discarded operations: insert 0, delete mark 0, delete 0 Hash table size 2365241, node heap has 0 buffer(s) Hash table size 2365241, node heap has 0 buffer(s) Hash table size 2365241, node heap has 0 buffer(s) Hash table size 2365241, node heap has 0 buffer(s) Hash table size 2365241, node heap has 0 buffer(s) Hash table size 2365241, node heap has 0 buffer(s) Hash table size 2365241, node heap has 0 buffer(s) Hash table size 2365241, node heap has 0 buffer(s) 0.00 hash searches/s, 0.00 non-hash searches/s --- LOG --- Log sequence number 359995104004 Log flushed up to 359995104004 Pages flushed up to 359995104004 Last checkpoint at 359995103995 Max checkpoint age 1738632684 Checkpoint age target 1684300413 Modified age 0 Checkpoint age 9 0 pending log flushes, 0 pending chkp writes 55 log i/o's done, 0.00 log i/o's/second ---------------------- BUFFER POOL AND MEMORY ---------------------- Total large memory allocated 8942256128 Dictionary memory allocated 170373 Internal hash tables (constant factor + variable factor) Adaptive hash index 151409088 (151375424 + 33664) Page hash 1107112 (buffer pool 0 only) Dictionary cache 38014229 (37843856 + 170373) File system 3049456 (812272 + 2237184) Lock system 21263064 (21250568 + 12496) Recovery system 0 (0 + 0) Buffer pool size 524224 Buffer pool size, bytes 8588886016 Free buffers 448517 Database pages 75852 Old database pages 28156 Modified db pages 0 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 0, not young 0 0.00 youngs/s, 0.00 non-youngs/s Pages read 75812, created 40, written 139 0.00 reads/s, 0.00 creates/s, 0.52 writes/s Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000 Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 75852, unzip_LRU len: 0 I/O sum[0]:cur[0], unzip sum[0]:cur[0] ---------------------- INDIVIDUAL BUFFER POOL INFO ---------------------- ---BUFFER POOL 0 Buffer pool size 65528 Buffer pool size, bytes 1073610752 Free buffers 56040 Database pages 9520 Old database pages 3534 Modified db pages 0 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 0, not young 0 0.00 youngs/s, 0.00 non-youngs/s Pages read 9520, created 0, written 15 0.00 reads/s, 0.00 creates/s, 0.00 writes/s Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000 Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 9520, unzip_LRU len: 0 I/O sum[0]:cur[0], unzip sum[0]:cur[0] ---BUFFER POOL 1 Buffer pool size 65528 Buffer pool size, bytes 1073610752 Free buffers 56002 Database pages 9526 Old database pages 3536 Modified db pages 0 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 0, not young 0 0.00 youngs/s, 0.00 non-youngs/s Pages read 9526, created 0, written 0 0.00 reads/s, 0.00 creates/s, 0.00 writes/s No buffer pool page gets since the last printout Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 9526, unzip_LRU len: 0 I/O sum[0]:cur[0], unzip sum[0]:cur[0] ---BUFFER POOL 2 Buffer pool size 65528 Buffer pool size, bytes 1073610752 Free buffers 56446 Database pages 9082 Old database pages 3372 Modified db pages 0 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 0, not young 0 0.00 youngs/s, 0.00 non-youngs/s Pages read 9082, created 0, written 2 0.00 reads/s, 0.00 creates/s, 0.00 writes/s No buffer pool page gets since the last printout Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 9082, unzip_LRU len: 0 I/O sum[0]:cur[0], unzip sum[0]:cur[0] ---BUFFER POOL 3 Buffer pool size 65528 Buffer pool size, bytes 1073610752 Free buffers 56213 Database pages 9315 Old database pages 3458 Modified db pages 0 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 0, not young 0 0.00 youngs/s, 0.00 non-youngs/s Pages read 9310, created 5, written 11 0.00 reads/s, 0.00 creates/s, 0.00 writes/s No buffer pool page gets since the last printout Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 9315, unzip_LRU len: 0 I/O sum[0]:cur[0], unzip sum[0]:cur[0] ---BUFFER POOL 4 Buffer pool size 65528 Buffer pool size, bytes 1073610752 Free buffers 55808 Database pages 9747 Old database pages 3618 Modified db pages 0 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 0, not young 0 0.00 youngs/s, 0.00 non-youngs/s Pages read 9747, created 0, written 1 0.00 reads/s, 0.00 creates/s, 0.00 writes/s No buffer pool page gets since the last printout Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 9747, unzip_LRU len: 0 I/O sum[0]:cur[0], unzip sum[0]:cur[0] ---BUFFER POOL 5 Buffer pool size 65528 Buffer pool size, bytes 1073610752 Free buffers 56041 Database pages 9500 Old database pages 3526 Modified db pages 0 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 0, not young 0 0.00 youngs/s, 0.00 non-youngs/s Pages read 9500, created 0, written 16 0.00 reads/s, 0.00 creates/s, 0.00 writes/s No buffer pool page gets since the last printout Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 9500, unzip_LRU len: 0 I/O sum[0]:cur[0], unzip sum[0]:cur[0] ---BUFFER POOL 6 Buffer pool size 65528 Buffer pool size, bytes 1073610752 Free buffers 56035 Database pages 9524 Old database pages 3535 Modified db pages 0 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 0, not young 0 0.00 youngs/s, 0.00 non-youngs/s Pages read 9489, created 35, written 89 0.00 reads/s, 0.00 creates/s, 0.52 writes/s Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000 Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 9524, unzip_LRU len: 0 I/O sum[0]:cur[0], unzip sum[0]:cur[0] ---BUFFER POOL 7 Buffer pool size 65528 Buffer pool size, bytes 1073610752 Free buffers 55932 Database pages 9638 Old database pages 3577 Modified db pages 0 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 0, not young 0 0.00 youngs/s, 0.00 non-youngs/s Pages read 9638, created 0, written 5 0.00 reads/s, 0.00 creates/s, 0.00 writes/s No buffer pool page gets since the last printout Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 9638, unzip_LRU len: 0 I/O sum[0]:cur[0], unzip sum[0]:cur[0] -------------- ROW OPERATIONS -------------- 0 queries inside InnoDB, 0 queries in queue 0 read views open inside InnoDB 0 RW transactions active inside InnoDB Process ID=9171, Main thread ID=139855449016064, state: sleeping Number of rows inserted 245, updated 2, deleted 0, read 233 2.43 inserts/s, 0.00 updates/s, 0.00 deletes/s, 2.43 reads/s ---------------------------- END OF INNODB MONITOR OUTPUT ============================ [/CODE] node 1 : SHOW STATUS LIKE 'ws%'; [CODE] +----------------------------------+-------------------------------------------------------------+ | Variable_name | Value | +----------------------------------+-------------------------------------------------------------+ | wsrep_local_state_uuid | 62a52d06-60f4-11e9-8cf6-176abbd3c45e | | wsrep_protocol_version | 9 | | wsrep_last_applied | 3933535 | | wsrep_last_committed | 3933535 | | wsrep_replicated | 0 | | wsrep_replicated_bytes | 0 | | wsrep_repl_keys | 0 | | wsrep_repl_keys_bytes | 0 | | wsrep_repl_data_bytes | 0 | | wsrep_repl_other_bytes | 0 | | wsrep_received | 30 | | wsrep_received_bytes | 75418 | | wsrep_local_commits | 0 | | wsrep_local_cert_failures | 0 | | wsrep_local_replays | 0 | | wsrep_local_send_queue | 0 | | wsrep_local_send_queue_max | 1 | | wsrep_local_send_queue_min | 0 | | wsrep_local_send_queue_avg | 0.000000 | | wsrep_local_recv_queue | 0 | | wsrep_local_recv_queue_max | 1 | | wsrep_local_recv_queue_min | 0 | | wsrep_local_recv_queue_avg | 0.000000 | | wsrep_local_cached_downto | 3933508 | | wsrep_flow_control_paused_ns | 0 | | wsrep_flow_control_paused | 0.000000 | | wsrep_flow_control_sent | 0 | | wsrep_flow_control_recv | 0 | | wsrep_flow_control_interval | [ 500, 500 ] | | wsrep_flow_control_interval_low | 500 | | wsrep_flow_control_interval_high | 500 | | wsrep_flow_control_status | OFF | | wsrep_cert_deps_distance | 1.535714 | | wsrep_apply_oooe | 0.035714 | | wsrep_apply_oool | 0.000000 | | wsrep_apply_window | 1.035714 | | wsrep_commit_oooe | 0.000000 | | wsrep_commit_oool | 0.000000 | | wsrep_commit_window | 1.000000 | | wsrep_local_state | 4 | | wsrep_local_state_comment | Synced | | wsrep_cert_index_size | 37 | | wsrep_cert_bucket_count | 58 | | wsrep_gcache_pool_size | 77576 | | wsrep_causal_reads | 0 | | wsrep_cert_interval | 0.000000 | | wsrep_open_transactions | 0 | | wsrep_open_connections | 0 | | wsrep_ist_receive_status | | | wsrep_ist_receive_seqno_start | 0 | | wsrep_ist_receive_seqno_current | 0 | | wsrep_ist_receive_seqno_end | 0 | | wsrep_incoming_addresses | 192.168.100.11:3306,192.168.100.10:3306,192.168.100.12:3306 | | wsrep_cluster_weight | 3 | | wsrep_desync_count | 0 | | wsrep_evs_delayed | | | wsrep_evs_evict_list | | | wsrep_evs_repl_latency | 0/0/0/0/0 | | wsrep_evs_state | OPERATIONAL | | wsrep_gcomm_uuid | 8bf6ade5-b505-11e9-94ee-ea7a93d56ff5 | | wsrep_cluster_conf_id | 74 | | wsrep_cluster_size | 3 | | wsrep_cluster_state_uuid | 62a52d06-60f4-11e9-8cf6-176abbd3c45e | | wsrep_cluster_status | Primary | | wsrep_connected | ON | | wsrep_local_bf_aborts | 0 | | wsrep_local_index | 1 | | wsrep_provider_name | Galera | | wsrep_provider_vendor | Codership Oy | | wsrep_provider_version | 3.37(rff05089) | | wsrep_ready | ON | +----------------------------------+-------------------------------------------------------------+ [/CODE] ~~~~~~~~~~~ NODE 2 > SHOW PROCESSLIST; [CODE] +--------+------------------------+---------------------+------------------------+---------+--------+--------------------------------------+------------------+-----------+---------------+ | Id | User | Host | db | Command | Time | State | Info | Rows_sent | Rows_examined | +--------+------------------------+---------------------+------------------------+---------+--------+--------------------------------------+------------------+-----------+---------------+ | 1 | system user | | NULL | Sleep | 589914 | wsrep: aborter idle | NULL | 0 | 0 | | 2 | system user | | NULL | Sleep | 1591 | wsrep: committed write set (3933503) | NULL | 0 | 0 | | 3 | system user | | NULL | Sleep | 1538 | wsrep: committed write set (3933504) | NULL | 0 | 0 | | 4 | system user | | NULL | Sleep | 1271 | wsrep: committed write set (3933505) | NULL | 0 | 0 | | 5 | system user | | NULL | Sleep | 1265 | wsrep: committed write set (3933506) | NULL | 0 | 0 | | 6 | system user | | NULL | Sleep | 1608 | wsrep: committed write set (3933500) | NULL | 0 | 0 | | 8 | system user | | NULL | Sleep | 1102 | wsrep: committed write set (3933507) | NULL | 0 | 0 | | 9 | system user | | NULL | Sleep | 1591 | wsrep: committed write set (3933501) | NULL | 0 | 0 | | 10 | system user | | NULL | Sleep | 1591 | wsrep: committed write set (3933502) | NULL | 0 | 0 | | 384713 | monitor | 192.168.100.1:40334 | NULL | Sleep | 1 | | NULL | 0 | 0 | | 571267 | monitor | 192.168.100.2:32958 | NULL | Sleep | 5 | | NULL | 0 | 0 | | 619842 | fffgfeg | 192.168.100.1:42572 | rhrehreh | Sleep | 11 | | NULL | 0 | 0 | | 619913 | fgfegregreg | 192.168.100.1:42894 | erherherh | Sleep | 24 | | NULL | 0 | 0 | | 619938 | rgregregreg | 192.168.100.1:42990 | erherherh | Sleep | 165 | | NULL | 0 | 0 | | 619940 | rgregregre-pxc | 192.168.100.1:43000 | erherherh | Sleep | 21 | | NULL | 0 | 0 | | 619941 | htehththt-pxc | 192.168.100.1:43002 | erherherh | Sleep | 21 | | NULL | 0 | 0 | | 619943 | htegrevrgre | 192.168.100.1:43008 | erherherh | Sleep | 405 | | NULL | 5 | 5 | | 619948 | fgfegregreg | 192.168.100.1:43030 | erherherh | Sleep | 45 | | NULL | 0 | 0 | | 619951 | fgfegregreg | 192.168.100.1:43044 | erherherh | Sleep | 165 | | NULL | 0 | 0 | | 619953 | fgfegregreg | 192.168.100.1:43046 | erherherh | Sleep | 1006 | | NULL | 0 | 0 | | 619954 | fgfegregreg | 192.168.100.1:43048 | erherherh | Sleep | 45 | | NULL | 0 | 0 | | 619955 | fgfegregreg | 192.168.100.1:43050 | erherherh | Sleep | 165 | | NULL | 0 | 0 | | 619956 | fgfegregreg | 192.168.100.1:43052 | erherherh | Sleep | 45 | | NULL | 0 | 0 | | 619957 | fgfegregreg | 192.168.100.1:43054 | erherherh | Sleep | 165 | | NULL | 0 | 0 | | 619958 | fgfegregreg | 192.168.100.1:43056 | erherherh | Sleep | 45 | | NULL | 0 | 0 | | 620039 | fgfegregreg | 192.168.100.1:43394 | erherherh | Sleep | 24 | | NULL | 0 | 0 | | 620067 | fgfegregreg-pxc | 192.168.100.1:43508 | erherherh | Sleep | 12 | | NULL | 0 | 0 | | 620068 | fgfegregreg | 192.168.100.1:43510 | erherherh | Sleep | 12 | | NULL | 0 | 0 | | 620070 | fgfegregreg-pxc | 192.168.100.1:43512 | erherherh | Sleep | 12 | | NULL | 0 | 0 | | 620071 | fgfegregreg | 192.168.100.1:43514 | erherherh | Sleep | 12 | | NULL | 0 | 0 | | 620076 | fgfegregreg | 192.168.100.1:43544 | erherherh | Sleep | 12 | | NULL | 0 | 0 | | 620077 | fgfegregreg | 192.168.100.1:43550 | erherherh | Sleep | 972 | | NULL | 0 | 0 | | 620078 | fgfegregreg | 192.168.100.1:43552 | erherherh | Sleep | 12 | | NULL | 0 | 0 | | 620091 | fgfegregreg | 192.168.100.1:43606 | erherherh | Sleep | 972 | | NULL | 0 | 0 | | 620092 | fgfegregreg | 192.168.100.1:43608 | erherherh | Sleep | 12 | | NULL | 0 | 0 | | 620093 | fgfegregreg | 192.168.100.1:43610 | erherherh | Sleep | 12 | | NULL | 0 | 0 | | 620094 | fgfegregreg | 192.168.100.1:43620 | erherherh | Sleep | 12 | | NULL | 0 | 0 | | 620095 | fgfegregreg | 192.168.100.1:43622 | erherherh | Sleep | 12 | | NULL | 0 | 0 | | 620096 | fgfegregreg | 192.168.100.1:43624 | erherherh | Sleep | 12 | | NULL | 0 | 0 | | 620226 | fgfegregreg | 192.168.100.1:44144 | erherherh | Sleep | 51 | | NULL | 0 | 0 | | 620384 | fgfegregreg | 192.168.100.1:44828 | erherherh | Sleep | 24 | | NULL | 0 | 0 | | 620406 | fgfegregreg | 192.168.100.1:44926 | erherherh | Sleep | 51 | | NULL | 0 | 0 | | 620407 | fgfegregreg | 192.168.100.1:44928 | erherherh | Sleep | 39 | | NULL | 0 | 0 | | 620430 | fgfegregreg | 192.168.100.1:45038 | erherherh | Sleep | 165 | | NULL | 0 | 0 | | 620431 | fgfegregreg | 192.168.100.1:45040 | erherherh | Sleep | 45 | | NULL | 0 | 0 | | 620511 | fgfegregreg | 192.168.100.1:45378 | erherherh | Sleep | 24 | | NULL | 0 | 0 | | 620512 | fgfegregreg | 192.168.100.1:45380 | erherherh | Sleep | 24 | | NULL | 0 | 0 | | 620514 | fgfegregreg | 192.168.100.1:45382 | erherherh | Sleep | 24 | | NULL | 0 | 0 | | 620561 | fgfegregreg | 192.168.100.1:45604 | erherherh | Sleep | 109 | | NULL | 1 | 857462 | | 620567 | fgfegregreg | 192.168.100.1:45634 | erherherh | Sleep | 108 | | NULL | 1 | 616640 | | 620574 | fgfegregreg | 192.168.100.1:45644 | erherherh | Sleep | 109 | | NULL | 1 | 454919 | | 620581 | fgfegregreg | 192.168.100.1:45666 | erherherh | Sleep | 112 | | NULL | 1 | 41201 | | 620586 | fgfegregreg | 192.168.100.1:45686 | erherherh | Sleep | 111 | | NULL | 1 | 66839 | | 620591 | fgfegregreg | 192.168.100.1:45728 | erherherh | Sleep | 45 | | NULL | 1 | 92 | | 620596 | fgfegregreg | 192.168.100.1:45746 | erherherh | Sleep | 115 | | NULL | 1 | 168554 | | 620601 | fgfegregreg | 192.168.100.1:45768 | erherherh | Sleep | 110 | | NULL | 1 | 31224 | | 620606 | fgfegregreg | 192.168.100.1:45786 | erherherh | Sleep | 111 | | NULL | 1 | 282574 | | 620614 | fgfegregreg | 192.168.100.1:45804 | erherherh | Sleep | 112 | | NULL | 1 | 68979 | | 620620 | fgfegregreg | 192.168.100.1:45822 | erherherh | Sleep | 112 | | NULL | 1 | 6374 | | 620622 | fgfegregreg | 192.168.100.1:45840 | erherherh | Sleep | 109 | | NULL | 1 | 120647 | | 620628 | fgfegregreg | 192.168.100.1:45870 | erherherh | Sleep | 153 | | NULL | 1 | 259397 | | 620635 | fgfegregreg | 192.168.100.1:45888 | erherherh | Sleep | 113 | | NULL | 1 | 237126 | | 620641 | fgfegregreg | 192.168.100.1:45922 | pxc_mairie_lille | Sleep | 110 | | NULL | 1 | 210294 | | 620647 | fgfegregreg | 192.168.100.1:45940 | erherherh | Sleep | 112 | | NULL | 1 | 7227 | | 620658 | fgfegregreg | 192.168.100.1:45972 | erherherh | Sleep | 109 | | NULL | 1 | 54663 | | 620662 | fgfegregreg | 192.168.100.1:46002 | erherherh | Sleep | 111 | | NULL | 1 | 123820 | | 620668 | fgfegregreg | 192.168.100.1:46020 | erherherh | Sleep | 112 | | NULL | 1 | 49699 | | 620673 | fgfegregreg | 192.168.100.1:46038 | erherherh | Sleep | 108 | | NULL | 1 | 11770 | | 620678 | fgfegregreg | 192.168.100.1:46056 | erherherh | Sleep | 110 | | NULL | 1 | 184467 | | 620683 | fgfegregreg | 192.168.100.1:46090 | erherherh | Sleep | 110 | | NULL | 1 | 768413 | | 620693 | fgfegregreg | 192.168.100.1:46120 | erherherh | Sleep | 142 | | NULL | 1 | 1276 | | 620698 | fgfegregreg | 192.168.100.1:46138 | erherherh | Sleep | 114 | | NULL | 1 | 57187 | | 620703 | fgfegregreg | 192.168.100.1:46160 | erherherh | Sleep | 112 | | NULL | 1 | 31814 | | 620708 | fgfegregreg | 192.168.100.1:46178 | erherherh | Sleep | 110 | | NULL | 1 | 679959 | | 620714 | fgfegregreg | 192.168.100.1:46208 | erherherh | Sleep | 114 | | NULL | 1 | 158571 | | 620717 | fgfegregreg | 192.168.100.1:46210 | erherherh | Sleep | 100 | | NULL | 0 | 0 | | 620904 | fgfegregreg | 192.168.100.1:47026 | erherherh | Sleep | 51 | | NULL | 0 | 0 | | 620926 | fgfegregreg | 192.168.100.1:47124 | erherherh | Sleep | 45 | | NULL | 0 | 0 | | 621003 | fgfegregreg | 192.168.100.1:47486 | erherherh | Sleep | 24 | | NULL | 0 | 0 | | 621004 | fgfegregreg | 192.168.100.1:47488 | erherherh | Sleep | 24 | | NULL | 0 | 0 | | 621005 | fgfegregreg | 192.168.100.1:47490 | erherherh | Sleep | 24 | | NULL | 0 | 0 | | 621006 | fgfegregreg | 192.168.100.1:47492 | erherherh | Sleep | 24 | | NULL | 0 | 0 | | 621055 | fgfegregreg | 192.168.100.1:47674 | erherherh | Sleep | 12 | | NULL | 0 | 0 | | 621180 | fgfegregreg | 192.168.100.1:48210 | erherherh | Sleep | 100 | | NULL | 0 | 0 | | 621181 | fgfegregreg | 192.168.100.1:48212 | erherherh | Sleep | 51 | | NULL | 0 | 0 | | 621182 | fgfegregreg | 192.168.100.1:48214 | erherherh | Sleep | 700 | | NULL | 0 | 0 | | 621183 | fgfegregreg | 192.168.100.1:48216 | erherherh | Sleep | 51 | | NULL | 0 | 0 | | 621250 | fgfegregreg | 192.168.100.1:48502 | erherherh | Sleep | 116 | | NULL | 1 | 481078 | | 621258 | fgfegregreg | 192.168.100.1:48520 | erherherh | Sleep | 115 | | NULL | 1 | 155064 | | 621264 | fgfegregreg | 192.168.100.1:48538 | erherherh | Sleep | 114 | | NULL | 1 | 496409 | | 621266 | fgfegregreg | 192.168.100.1:48556 | erherherh | Sleep | 113 | | NULL | 1 | 46598 | | 621270 | fgfegregreg | 192.168.100.1:48566 | erherherh | Sleep | 113 | | NULL | 1 | 334689 | | 621275 | fgfegregreg | 192.168.100.1:48592 | erherherh | Sleep | 111 | | NULL | 1 | 18927 | | 621281 | fgfegregreg | 192.168.100.1:48610 | erherherh | Sleep | 110 | | NULL | 1 | 646791 | | 621285 | fgfegregreg | 192.168.100.1:48620 | erherherh | Sleep | 109 | | NULL | 1 | 5497 | | 621290 | fgfegregreg | 192.168.100.1:48658 | erherherh | Sleep | 108 | | NULL | 1 | 93176 | | 621292 | fgfegregreg | 192.168.100.1:48664 | erherherh | Sleep | 108 | | NULL | 1 | 175129 | | 621474 | fgfegregreg | 192.168.100.1:49468 | erherherh | Sleep | 24 | | NULL | 0 | 0 | | 621505 | fgfegregreg | 192.168.100.1:49614 | erherherh | Sleep | 83 | | NULL | 0 | 0 | | 621964 | fgfegregreg | 192.168.100.1:51706 | erherherh | Sleep | 252 | | NULL | 0 | 0 | | 621967 | fgfegregreg | 192.168.100.1:51712 | erherherh | Sleep | 12 | | NULL | 0 | 0 | | 622092 | fgfegregreg | 192.168.100.1:52244 | erherherh | Sleep | 100 | | NULL | 0 | 0 | | 622298 | fgfegregreg | 192.168.100.1:53144 | erherherh | Sleep | 165 | | NULL | 0 | 0 | | 622379 | fgfegregreg | 192.168.100.1:53490 | erherherh | Sleep | 24 | | NULL | 0 | 0 | | 623314 | fgfegregreg | 192.168.100.1:57432 | erherherh | Sleep | 24 | | NULL | 0 | 0 | | 623362 | fgfegregreg | 192.168.100.1:57666 | erherherh | Sleep | 12 | | NULL | 0 | 0 | | 623453 | fgfegregreg | 192.168.100.1:58082 | erherherh | Sleep | 107 | | NULL | 1 | 1 | | 623486 | fgfegregreg | 192.168.100.1:58212 | erherherh | Sleep | 51 | | NULL | 0 | 0 | | 623666 | fgfegregreg | localhost | NULL | Sleep | 0 | | NULL | 47 | 47 | | 623772 | fgfegregreg | 192.168.100.1:59460 | erherherh | Sleep | 24 | | NULL | 0 | 0 | | 623799 | fgfegregreg | localhost | NULL | Sleep | 0 | | NULL | 619 | 1238 | | 623852 | fgfegregreg | localhost | NULL | Query | 0 | starting | SHOW PROCESSLIST | 0 | 0 | +--------+------------------------+---------------------+------------------------+---------+--------+--------------------------------------+------------------+-----------+---------------+ [/CODE] > SHOW ENGINE INNODB STATUS\G [CODE] *************************** 1. row *************************** Type: InnoDB Name: Status: ===================================== 2019-08-02 11:34:25 0x7f9aaf6f9700 INNODB MONITOR OUTPUT ===================================== Per second averages calculated from the last 32 seconds ----------------- BACKGROUND THREAD ----------------- srv_master_thread loops: 123793 srv_active, 0 srv_shutdown, 465939 srv_idle srv_master_thread log flush and writes: 589468 ---------- SEMAPHORES ---------- OS WAIT ARRAY INFO: reservation count 285499 OS WAIT ARRAY INFO: signal count 194883 RW-shared spins 0, rounds 273523, OS waits 30265 RW-excl spins 0, rounds 1031762, OS waits 4385 RW-sx spins 40002, rounds 578857, OS waits 4619 Spin rounds per wait: 273523.00 RW-shared, 1031762.00 RW-excl, 14.47 RW-sx ------------ TRANSACTIONS ------------ Trx id counter 36297113 Purge done for trx's n:o < 36297110 undo n:o < 0 state: running but idle History list length 47 LIST OF TRANSACTIONS FOR EACH SESSION: ---TRANSACTION 421787906667784, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421787906674744, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421787906673584, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421787906670104, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421787906660824, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421787906672424, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421787906671264, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421787906646904, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421787906668944, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421787906666624, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421787906664304, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421787906665464, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421787906635304, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421787906663144, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421787906661984, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421787906658504, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421787906659664, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421787906657344, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421787906656184, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421787906655024, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421787906653864, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421787906652704, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421787906651544, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421787906650384, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421787906649224, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421787906648064, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421787906602824, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421787906645744, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421787906644584, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421787906643424, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421787906636464, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421787906642264, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421787906641104, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421787906639944, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421787906638784, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421787906637624, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421787906634144, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421787906598184, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421787906632984, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421787906631824, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421787906630664, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421787906629504, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421787906628344, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421787906627184, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421787906626024, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421787906624864, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421787906623704, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421787906622544, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421787906621384, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421787906620224, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421787906619064, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421787906617904, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421787906616744, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421787906615584, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421787906614424, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421787906613264, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421787906612104, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421787906610944, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421787906609784, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421787906608624, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421787906559904, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421787906607464, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421787906606304, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421787906605144, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421787906603984, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421787906601664, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421787906600504, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421787906599344, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421787906592384, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421787906597024, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421787906561064, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421787906595864, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421787906594704, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421787906593544, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421787906576144, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421787906591224, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421787906590064, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421787906588904, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421787906587744, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421787906586584, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421787906585424, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421787906584264, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421787906583104, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421787906581944, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421787906580784, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421787906579624, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421787906578464, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421787906577304, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421787906555264, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421787906574984, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421787906573824, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421787906572664, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421787906571504, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421787906570344, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421787906569184, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421787906568024, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421787906566864, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421787906565704, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421787906564544, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421787906563384, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421787906562224, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421787906550624, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421787906558744, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421787906545984, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421787906557584, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421787906556424, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421787906551784, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421787906554104, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421787906552944, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421787906547144, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421787906548304, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421787906549464, not started 0 lock struct(s), heap size 1136, 0 row lock(s) -------- FILE I/O -------- I/O thread 0 state: waiting for completed aio requests (insert buffer thread) I/O thread 1 state: waiting for completed aio requests (log thread) I/O thread 2 state: waiting for completed aio requests (read thread) I/O thread 3 state: waiting for completed aio requests (read thread) I/O thread 4 state: waiting for completed aio requests (read thread) I/O thread 5 state: waiting for completed aio requests (read thread) I/O thread 6 state: waiting for completed aio requests (read thread) I/O thread 7 state: waiting for completed aio requests (read thread) I/O thread 8 state: waiting for completed aio requests (read thread) I/O thread 9 state: waiting for completed aio requests (read thread) I/O thread 10 state: waiting for completed aio requests (write thread) I/O thread 11 state: waiting for completed aio requests (write thread) I/O thread 12 state: waiting for completed aio requests (write thread) I/O thread 13 state: waiting for completed aio requests (write thread) I/O thread 14 state: waiting for completed aio requests (write thread) I/O thread 15 state: waiting for completed aio requests (write thread) I/O thread 16 state: waiting for completed aio requests (write thread) I/O thread 17 state: waiting for completed aio requests (write thread) Pending normal aio reads: [0, 0, 0, 0, 0, 0, 0, 0] , aio writes: [0, 0, 0, 0, 0, 0, 0, 0] , ibuf aio reads:, log i/o's:, sync i/o's: Pending flushes (fsync) log: 0; buffer pool: 0 70209 OS file reads, 628415 OS file writes, 58274 OS fsyncs 16.59 reads/s, 16384 avg bytes/read, 2.28 writes/s, 0.56 fsyncs/s ------------------------------------- INSERT BUFFER AND ADAPTIVE HASH INDEX ------------------------------------- Ibuf: size 1, free list len 0, seg size 2, 1252 merges merged operations: insert 0, delete mark 0, delete 0 discarded operations: insert 0, delete mark 0, delete 0 Hash table size 2365241, node heap has 0 buffer(s) Hash table size 2365241, node heap has 0 buffer(s) Hash table size 2365241, node heap has 0 buffer(s) Hash table size 2365241, node heap has 0 buffer(s) Hash table size 2365241, node heap has 0 buffer(s) Hash table size 2365241, node heap has 0 buffer(s) Hash table size 2365241, node heap has 0 buffer(s) Hash table size 2365241, node heap has 0 buffer(s) 0.00 hash searches/s, 4126.46 non-hash searches/s --- LOG --- Log sequence number 359997639329 Log flushed up to 359997639329 Pages flushed up to 359997639329 Last checkpoint at 359997639320 Max checkpoint age 1738750649 Checkpoint age target 1684414692 Modified age 0 Checkpoint age 9 0 pending log flushes, 0 pending chkp writes 55032 log i/o's done, 0.56 log i/o's/second ---------------------- BUFFER POOL AND MEMORY ---------------------- Total large memory allocated 8942256128 Dictionary memory allocated 14441438 Internal hash tables (constant factor + variable factor) Adaptive hash index 151409088 (151375424 + 33664) Page hash 1107112 (buffer pool 0 only) Dictionary cache 52285294 (37843856 + 14441438) File system 3049456 (812272 + 2237184) Lock system 21377800 (21250568 + 127232) Recovery system 0 (0 + 0) Buffer pool size 524224 Buffer pool size, bytes 8588886016 Free buffers 439432 Database pages 84560 Old database pages 31189 Modified db pages 0 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 44627, not young 2714472 14.34 youngs/s, 2711.01 non-youngs/s Pages read 69442, created 18680, written 540530 16.44 reads/s, 0.00 creates/s, 1.28 writes/s Buffer pool hit rate 999 / 1000, young-making rate 1 / 1000 not 220 / 1000 Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 84560, unzip_LRU len: 473 I/O sum[5960]:cur[0], unzip sum[0]:cur[0] ---------------------- INDIVIDUAL BUFFER POOL INFO ---------------------- ---BUFFER POOL 0 Buffer pool size 65528 Buffer pool size, bytes 1073610752 Free buffers 54714 Database pages 10782 Old database pages 3974 Modified db pages 0 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 5566, not young 342392 1.00 youngs/s, 140.53 non-youngs/s Pages read 8619, created 2616, written 38061 1.00 reads/s, 0.00 creates/s, 0.12 writes/s Buffer pool hit rate 999 / 1000, young-making rate 1 / 1000 not 211 / 1000 Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 10782, unzip_LRU len: 64 I/O sum[745]:cur[0], unzip sum[0]:cur[0] ---BUFFER POOL 1 Buffer pool size 65528 Buffer pool size, bytes 1073610752 Free buffers 54385 Database pages 11123 Old database pages 4116 Modified db pages 0 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 5920, not young 417920 0.97 youngs/s, 964.13 non-youngs/s Pages read 9116, created 2552, written 11147 3.25 reads/s, 0.00 creates/s, 0.00 writes/s Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 211 / 1000 Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 11123, unzip_LRU len: 51 I/O sum[745]:cur[0], unzip sum[0]:cur[0] ---BUFFER POOL 2 Buffer pool size 65528 Buffer pool size, bytes 1073610752 Free buffers 56209 Database pages 9319 Old database pages 3425 Modified db pages 0 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 3878, not young 215598 3.53 youngs/s, 171.90 non-youngs/s Pages read 7638, created 2394, written 9937 2.19 reads/s, 0.00 creates/s, 0.00 writes/s Buffer pool hit rate 999 / 1000, young-making rate 2 / 1000 not 129 / 1000 Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 9319, unzip_LRU len: 0 I/O sum[745]:cur[0], unzip sum[0]:cur[0] ---BUFFER POOL 3 Buffer pool size 65528 Buffer pool size, bytes 1073610752 Free buffers 54984 Database pages 10512 Old database pages 3900 Modified db pages 0 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 5456, not young 330158 1.78 youngs/s, 299.24 non-youngs/s Pages read 8662, created 2246, written 383430 3.94 reads/s, 0.00 creates/s, 0.66 writes/s Buffer pool hit rate 999 / 1000, young-making rate 0 / 1000 not 125 / 1000 Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 10512, unzip_LRU len: 64 I/O sum[745]:cur[0], unzip sum[0]:cur[0] ---BUFFER POOL 4 Buffer pool size 65528 Buffer pool size, bytes 1073610752 Free buffers 54524 Database pages 10964 Old database pages 4028 Modified db pages 0 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 6240, not young 381524 3.37 youngs/s, 67.50 non-youngs/s Pages read 9210, created 2194, written 17477 2.09 reads/s, 0.00 creates/s, 0.09 writes/s Buffer pool hit rate 997 / 1000, young-making rate 5 / 1000 not 114 / 1000 Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 10964, unzip_LRU len: 79 I/O sum[745]:cur[0], unzip sum[0]:cur[0] ---BUFFER POOL 5 Buffer pool size 65528 Buffer pool size, bytes 1073610752 Free buffers 55713 Database pages 9796 Old database pages 3596 Modified db pages 0 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 5423, not young 338857 1.97 youngs/s, 11.44 non-youngs/s Pages read 8167, created 2071, written 32964 0.53 reads/s, 0.00 creates/s, 0.28 writes/s Buffer pool hit rate 999 / 1000, young-making rate 4 / 1000 not 25 / 1000 Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 9796, unzip_LRU len: 38 I/O sum[745]:cur[0], unzip sum[0]:cur[0] ---BUFFER POOL 6 Buffer pool size 65528 Buffer pool size, bytes 1073610752 Free buffers 54533 Database pages 10948 Old database pages 4038 Modified db pages 0 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 6065, not young 332109 1.22 youngs/s, 110.68 non-youngs/s Pages read 9013, created 2308, written 22931 1.34 reads/s, 0.00 creates/s, 0.09 writes/s Buffer pool hit rate 999 / 1000, young-making rate 1 / 1000 not 130 / 1000 Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 10948, unzip_LRU len: 93 I/O sum[745]:cur[0], unzip sum[0]:cur[0] ---BUFFER POOL 7 Buffer pool size 65528 Buffer pool size, bytes 1073610752 Free buffers 54370 Database pages 11116 Old database pages 4112 Modified db pages 0 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 6079, not young 355914 0.50 youngs/s, 945.60 non-youngs/s Pages read 9017, created 2299, written 24583 2.09 reads/s, 0.00 creates/s, 0.03 writes/s Buffer pool hit rate 999 / 1000, young-making rate 0 / 1000 not 636 / 1000 Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 11116, unzip_LRU len: 84 I/O sum[745]:cur[0], unzip sum[0]:cur[0] -------------- ROW OPERATIONS -------------- 0 queries inside InnoDB, 0 queries in queue 0 read views open inside InnoDB 0 RW transactions active inside InnoDB Process ID=15171, Main thread ID=140303226894080, state: sleeping Number of rows inserted 2664829, updated 393567, deleted 541307, read 126781699 21.41 inserts/s, 0.03 updates/s, 0.22 deletes/s, 5729.23 reads/s ---------------------------- END OF INNODB MONITOR OUTPUT ============================ [/CODE] > SHOW STATUS LIKE 'ws%'; [CODE] +----------------------------------+-------------------------------------------------------------+ | Variable_name | Value | +----------------------------------+-------------------------------------------------------------+ | wsrep_local_state_uuid | 62a52d06-60f4-11e9-8cf6-176abbd3c45e | | wsrep_protocol_version | 9 | | wsrep_last_applied | 3933551 | | wsrep_last_committed | 3933551 | | wsrep_replicated | 58 | | wsrep_replicated_bytes | 159312 | | wsrep_repl_keys | 301 | | wsrep_repl_keys_bytes | 3800 | | wsrep_repl_data_bytes | 151565 | | wsrep_repl_other_bytes | 0 | | wsrep_received | 21837 | | wsrep_received_bytes | 953012009 | | wsrep_local_commits | 44 | | wsrep_local_cert_failures | 0 | | wsrep_local_replays | 0 | | wsrep_local_send_queue | 0 | | wsrep_local_send_queue_max | 1 | | wsrep_local_send_queue_min | 0 | | wsrep_local_send_queue_avg | 0.000000 | | wsrep_local_recv_queue | 0 | | wsrep_local_recv_queue_max | 112 | | wsrep_local_recv_queue_min | 0 | | wsrep_local_recv_queue_avg | 1.146494 | | wsrep_local_cached_downto | 3929270 | | wsrep_flow_control_paused_ns | 0 | | wsrep_flow_control_paused | 0.000000 | | wsrep_flow_control_sent | 0 | | wsrep_flow_control_recv | 0 | | wsrep_flow_control_interval | [ 173, 173 ] | | wsrep_flow_control_interval_low | 173 | | wsrep_flow_control_interval_high | 173 | | wsrep_flow_control_status | OFF | | wsrep_cert_deps_distance | 33.123666 | | wsrep_apply_oooe | 0.157885 | | wsrep_apply_oool | 0.014538 | | wsrep_apply_window | 1.485438 | | wsrep_commit_oooe | 0.000000 | | wsrep_commit_oool | 0.000000 | | wsrep_commit_window | 1.106834 | | wsrep_local_state | 4 | | wsrep_local_state_comment | Synced | | wsrep_cert_index_size | 159 | | wsrep_cert_bucket_count | 256290 | | wsrep_gcache_pool_size | 134218992 | | wsrep_causal_reads | 0 | | wsrep_cert_interval | 0.002414 | | wsrep_open_transactions | 0 | | wsrep_open_connections | 0 | | wsrep_ist_receive_status | | | wsrep_ist_receive_seqno_start | 0 | | wsrep_ist_receive_seqno_current | 0 | | wsrep_ist_receive_seqno_end | 0 | | wsrep_incoming_addresses | 192.168.100.11:3306,192.168.100.10:3306,192.168.100.12:3306 | | wsrep_cluster_weight | 3 | | wsrep_desync_count | 0 | | wsrep_evs_delayed | | | wsrep_evs_evict_list | | | wsrep_evs_repl_latency | 0/0/0/0/0 | | wsrep_evs_state | OPERATIONAL | | wsrep_gcomm_uuid | 715e888c-afaa-11e9-b572-96a757ad2d70 | | wsrep_cluster_conf_id | 74 | | wsrep_cluster_size | 3 | | wsrep_cluster_state_uuid | 62a52d06-60f4-11e9-8cf6-176abbd3c45e | | wsrep_cluster_status | Primary | | wsrep_connected | ON | | wsrep_local_bf_aborts | 0 | | wsrep_local_index | 0 | | wsrep_provider_name | Galera | | wsrep_provider_vendor | Codership Oy | | wsrep_provider_version | 3.37(rff05089) | | wsrep_ready | ON | +----------------------------------+-------------------------------------------------------------+ [/CODE] NODE 3: > SHOW PROCESSLIST; [CODE] +--------+-------------+---------------------+------+---------+--------+--------------------------------------+------------------+-----------+---------------+ | Id | User | Host | db | Command | Time | State | Info | Rows_sent | Rows_examined | +--------+-------------+---------------------+------+---------+--------+--------------------------------------+------------------+-----------+---------------+ | 1 | system user | | NULL | Sleep | 588072 | wsrep: aborter idle | NULL | 0 | 0 | | 2 | system user | | NULL | Sleep | 149 | wsrep: committed write set (3933549) | NULL | 0 | 0 | | 3 | system user | | NULL | Sleep | 106 | wsrep: committed write set (3933551) | NULL | 0 | 0 | | 4 | system user | | NULL | Sleep | 43 | wsrep: committed write set (3933552) | NULL | 0 | 0 | | 6 | system user | | NULL | Sleep | 131 | wsrep: committed write set (3933550) | NULL | 0 | 0 | | 7 | system user | | NULL | Sleep | 33 | wsrep: committed write set (3933553) | NULL | 0 | 0 | | 8 | system user | | NULL | Sleep | 26 | wsrep: committed write set (3933554) | NULL | 0 | 0 | | 9 | system user | | NULL | Sleep | 149 | wsrep: committed write set (3933547) | NULL | 0 | 0 | | 10 | system user | | NULL | Sleep | 149 | wsrep: committed write set (3933548) | NULL | 0 | 0 | | 464166 | monitor | 192.168.100.1:47930 | NULL | Sleep | 4 | | NULL | 0 | 0 | | 558000 | monitor | 192.168.100.2:55996 | NULL | Sleep | 7 | | NULL | 0 | 0 | | 607080 | root | localhost | NULL | Sleep | 1 | | NULL | 487 | 974 | | 607106 | root | localhost | NULL | Sleep | 1 | | NULL | 1 | 0 | | 607133 | root | localhost | NULL | Sleep | 1 | | NULL | 238 | 238 | | 607136 | admin-pxc | localhost | NULL | Query | 0 | starting | SHOW PROCESSLIST | 0 | 0 | +--------+-------------+---------------------+------+---------+--------+--------------------------------------+------------------+-----------+---------------+ [/CODE] > SHOW ENGINE INNODB STATUS\G [CODE] *************************** 1. row *************************** Type: InnoDB Name: Status: ===================================== 2019-08-02 11:37:34 0x7f8864041700 INNODB MONITOR OUTPUT ===================================== Per second averages calculated from the last 14 seconds ----------------- BACKGROUND THREAD ----------------- srv_master_thread loops: 123555 srv_active, 0 srv_shutdown, 464073 srv_idle srv_master_thread log flush and writes: 587424 ---------- SEMAPHORES ---------- OS WAIT ARRAY INFO: reservation count 264302 OS WAIT ARRAY INFO: signal count 187389 RW-shared spins 0, rounds 253544, OS waits 31346 RW-excl spins 0, rounds 1017716, OS waits 4732 RW-sx spins 39193, rounds 588491, OS waits 4617 Spin rounds per wait: 253544.00 RW-shared, 1017716.00 RW-excl, 15.02 RW-sx ------------ TRANSACTIONS ------------ Trx id counter 36297847 Purge done for trx's n:o < 36297847 undo n:o < 0 state: running but idle History list length 2 LIST OF TRANSACTIONS FOR EACH SESSION: ---TRANSACTION 421699015298504, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421699015310104, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421699015307784, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421699015306624, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421699015308944, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421699015304304, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421699015299664, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421699015305464, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421699015303144, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421699015301984, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421699015300824, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421699015297344, not started 0 lock struct(s), heap size 1136, 0 row lock(s) -------- FILE I/O -------- I/O thread 0 state: waiting for completed aio requests (insert buffer thread) I/O thread 1 state: waiting for completed aio requests (log thread) I/O thread 2 state: waiting for completed aio requests (read thread) I/O thread 3 state: waiting for completed aio requests (read thread) I/O thread 4 state: waiting for completed aio requests (read thread) I/O thread 5 state: waiting for completed aio requests (read thread) I/O thread 6 state: waiting for completed aio requests (read thread) I/O thread 7 state: waiting for completed aio requests (read thread) I/O thread 8 state: waiting for completed aio requests (read thread) I/O thread 9 state: waiting for completed aio requests (read thread) I/O thread 10 state: waiting for completed aio requests (write thread) I/O thread 11 state: waiting for completed aio requests (write thread) I/O thread 12 state: waiting for completed aio requests (write thread) I/O thread 13 state: waiting for completed aio requests (write thread) I/O thread 14 state: waiting for completed aio requests (write thread) I/O thread 15 state: waiting for completed aio requests (write thread) I/O thread 16 state: waiting for completed aio requests (write thread) I/O thread 17 state: waiting for completed aio requests (write thread) Pending normal aio reads: [0, 0, 0, 0, 0, 0, 0, 0] , aio writes: [0, 0, 0, 0, 0, 0, 0, 0] , ibuf aio reads:, log i/o's:, sync i/o's: Pending flushes (fsync) log: 0; buffer pool: 0 61041 OS file reads, 625279 OS file writes, 57886 OS fsyncs 0.00 reads/s, 0 avg bytes/read, 0.64 writes/s, 0.00 fsyncs/s ------------------------------------- INSERT BUFFER AND ADAPTIVE HASH INDEX ------------------------------------- Ibuf: size 1, free list len 0, seg size 2, 1252 merges merged operations: insert 0, delete mark 0, delete 0 discarded operations: insert 0, delete mark 0, delete 0 Hash table size 2365241, node heap has 0 buffer(s) Hash table size 2365241, node heap has 0 buffer(s) Hash table size 2365241, node heap has 0 buffer(s) Hash table size 2365241, node heap has 0 buffer(s) Hash table size 2365241, node heap has 0 buffer(s) Hash table size 2365241, node heap has 0 buffer(s) Hash table size 2365241, node heap has 0 buffer(s) Hash table size 2365241, node heap has 0 buffer(s) 0.00 hash searches/s, 0.00 non-hash searches/s --- LOG --- Log sequence number 359999090119 Log flushed up to 359999090119 Pages flushed up to 359999090119 Last checkpoint at 359999090110 Max checkpoint age 1738750649 Checkpoint age target 1684414692 Modified age 0 Checkpoint age 9 0 pending log flushes, 0 pending chkp writes 54645 log i/o's done, 0.00 log i/o's/second ---------------------- BUFFER POOL AND MEMORY ---------------------- Total large memory allocated 8942256128 Dictionary memory allocated 8158113 Internal hash tables (constant factor + variable factor) Adaptive hash index 151409088 (151375424 + 33664) Page hash 1107112 (buffer pool 0 only) Dictionary cache 46001969 (37843856 + 8158113) File system 3049456 (812272 + 2237184) Lock system 21264200 (21250568 + 13632) Recovery system 0 (0 + 0) Buffer pool size 524224 Buffer pool size, bytes 8588886016 Free buffers 448946 Database pages 75439 Old database pages 27734 Modified db pages 0 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 9235, not young 962611 0.00 youngs/s, 0.00 non-youngs/s Pages read 60334, created 18667, written 538145 0.00 reads/s, 0.00 creates/s, 0.64 writes/s Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000 Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 75439, unzip_LRU len: 0 I/O sum[240]:cur[0], unzip sum[0]:cur[0] ---------------------- INDIVIDUAL BUFFER POOL INFO ---------------------- ---BUFFER POOL 0 Buffer pool size 65528 Buffer pool size, bytes 1073610752 Free buffers 56023 Database pages 9517 Old database pages 3505 Modified db pages 0 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 1157, not young 120927 0.00 youngs/s, 0.00 non-youngs/s Pages read 7448, created 2522, written 37287 0.00 reads/s, 0.00 creates/s, 0.00 writes/s Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000 Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 9517, unzip_LRU len: 0 I/O sum[30]:cur[0], unzip sum[0]:cur[0] ---BUFFER POOL 1 Buffer pool size 65528 Buffer pool size, bytes 1073610752 Free buffers 55895 Database pages 9662 Old database pages 3553 Modified db pages 0 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 814, not young 126553 0.00 youngs/s, 0.00 non-youngs/s Pages read 7570, created 2637, written 11280 0.00 reads/s, 0.00 creates/s, 0.00 writes/s No buffer pool page gets since the last printout Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 9662, unzip_LRU len: 0 I/O sum[30]:cur[0], unzip sum[0]:cur[0] ---BUFFER POOL 2 Buffer pool size 65528 Buffer pool size, bytes 1073610752 Free buffers 56728 Database pages 8800 Old database pages 3235 Modified db pages 0 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 865, not young 86968 0.00 youngs/s, 0.00 non-youngs/s Pages read 7018, created 2495, written 10217 0.00 reads/s, 0.00 creates/s, 0.00 writes/s No buffer pool page gets since the last printout Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 8800, unzip_LRU len: 0 I/O sum[30]:cur[0], unzip sum[0]:cur[0] ---BUFFER POOL 3 Buffer pool size 65528 Buffer pool size, bytes 1073610752 Free buffers 56188 Database pages 9352 Old database pages 3432 Modified db pages 0 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 1187, not young 117803 0.00 youngs/s, 0.00 non-youngs/s Pages read 7597, created 2151, written 29428 0.00 reads/s, 0.00 creates/s, 0.00 writes/s No buffer pool page gets since the last printout Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 9352, unzip_LRU len: 0 I/O sum[30]:cur[0], unzip sum[0]:cur[0] ---BUFFER POOL 4 Buffer pool size 65528 Buffer pool size, bytes 1073610752 Free buffers 55841 Database pages 9724 Old database pages 3579 Modified db pages 0 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 1230, not young 153104 0.00 youngs/s, 0.00 non-youngs/s Pages read 8021, created 2143, written 17201 0.00 reads/s, 0.00 creates/s, 0.00 writes/s No buffer pool page gets since the last printout Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 9724, unzip_LRU len: 0 I/O sum[30]:cur[0], unzip sum[0]:cur[0] ---BUFFER POOL 5 Buffer pool size 65528 Buffer pool size, bytes 1073610752 Free buffers 56523 Database pages 9018 Old database pages 3316 Modified db pages 0 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 1315, not young 154326 0.00 youngs/s, 0.00 non-youngs/s Pages read 7396, created 2064, written 32591 0.00 reads/s, 0.00 creates/s, 0.00 writes/s No buffer pool page gets since the last printout Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 9018, unzip_LRU len: 0 I/O sum[30]:cur[0], unzip sum[0]:cur[0] ---BUFFER POOL 6 Buffer pool size 65528 Buffer pool size, bytes 1073610752 Free buffers 55700 Database pages 9871 Old database pages 3626 Modified db pages 0 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 1347, not young 106582 0.00 youngs/s, 0.00 non-youngs/s Pages read 7817, created 2427, written 374605 0.00 reads/s, 0.00 creates/s, 0.64 writes/s Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000 Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 9871, unzip_LRU len: 0 I/O sum[30]:cur[0], unzip sum[0]:cur[0] ---BUFFER POOL 7 Buffer pool size 65528 Buffer pool size, bytes 1073610752 Free buffers 56048 Database pages 9495 Old database pages 3488 Modified db pages 0 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 1320, not young 96348 0.00 youngs/s, 0.00 non-youngs/s Pages read 7467, created 2228, written 25536 0.00 reads/s, 0.00 creates/s, 0.00 writes/s No buffer pool page gets since the last printout Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 9495, unzip_LRU len: 0 I/O sum[30]:cur[0], unzip sum[0]:cur[0] -------------- ROW OPERATIONS -------------- 0 queries inside InnoDB, 0 queries in queue 0 read views open inside InnoDB 0 RW transactions active inside InnoDB Process ID=1752, Main thread ID=140214307649280, state: sleeping Number of rows inserted 2636805, updated 393494, deleted 541280, read 21455694 2.14 inserts/s, 0.00 updates/s, 0.00 deletes/s, 2.14 reads/s ---------------------------- END OF INNODB MONITOR OUTPUT ============================ [/CODE] > SHOW STATUS LIKE 'ws%'; [CODE] +----------------------------------+-------------------------------------------------------------+ | wsrep_local_state_uuid | 62a52d06-60f4-11e9-8cf6-176abbd3c45e | | wsrep_protocol_version | 9 | | wsrep_last_applied | 3933554 | | wsrep_last_committed | 3933554 | | wsrep_replicated | 14 | | wsrep_replicated_bytes | 2800 | | wsrep_repl_keys | 14 | | wsrep_repl_keys_bytes | 448 | | wsrep_repl_data_bytes | 1379 | | wsrep_repl_other_bytes | 0 | | wsrep_received | 21826 | | wsrep_received_bytes | 952926776 | | wsrep_local_commits | 0 | | wsrep_local_cert_failures | 0 | | wsrep_local_replays | 0 | | wsrep_local_send_queue | 0 | | wsrep_local_send_queue_max | 1 | | wsrep_local_send_queue_min | 0 | | wsrep_local_send_queue_avg | 0.000000 | | wsrep_local_recv_queue | 0 | | wsrep_local_recv_queue_max | 112 | | wsrep_local_recv_queue_min | 0 | | wsrep_local_recv_queue_avg | 1.332173 | | wsrep_local_cached_downto | 3929270 | | wsrep_flow_control_paused_ns | 0 | | wsrep_flow_control_paused | 0.000000 | | wsrep_flow_control_sent | 0 | | wsrep_flow_control_recv | 0 | | wsrep_flow_control_interval | [ 173, 173 ] | | wsrep_flow_control_interval_low | 173 | | wsrep_flow_control_interval_high | 173 | | wsrep_flow_control_status | OFF | | wsrep_cert_deps_distance | 33.165497 | | wsrep_apply_oooe | 0.157303 | | wsrep_apply_oool | 0.015740 | | wsrep_apply_window | 1.499806 | | wsrep_commit_oooe | 0.000000 | | wsrep_commit_oool | 0.000000 | | wsrep_commit_window | 1.114539 | | wsrep_local_state | 4 | | wsrep_local_state_comment | Synced | | wsrep_cert_index_size | 171 | | wsrep_cert_bucket_count | 256290 | | wsrep_gcache_pool_size | 134218992 | | wsrep_causal_reads | 0 | | wsrep_cert_interval | 0.002420 | | wsrep_open_transactions | 0 | | wsrep_open_connections | 0 | | wsrep_ist_receive_status | | | wsrep_ist_receive_seqno_start | 0 | | wsrep_ist_receive_seqno_current | 0 | | wsrep_ist_receive_seqno_end | 0 | | wsrep_incoming_addresses | 192.168.100.11:3306,192.168.100.10:3306,192.168.100.12:3306 | | wsrep_cluster_weight | 3 | | wsrep_desync_count | 0 | | wsrep_evs_delayed | | | wsrep_evs_evict_list | | | wsrep_evs_repl_latency | 0/0/0/0/0 | | wsrep_evs_state | OPERATIONAL | | wsrep_gcomm_uuid | bd6efa6f-afaf-11e9-bbb3-26141c8fd98c | | wsrep_cluster_conf_id | 74 | | wsrep_cluster_size | 3 | | wsrep_cluster_state_uuid | 62a52d06-60f4-11e9-8cf6-176abbd3c45e | | wsrep_cluster_status | Primary | | wsrep_connected | ON | | wsrep_local_bf_aborts | 0 | | wsrep_local_index | 2 | | wsrep_provider_name | Galera | | wsrep_provider_vendor | Codership Oy | | wsrep_provider_version | 3.37(rff05089) | | wsrep_ready | ON | +----------------------------------+-------------------------------------------------------------+ [/CODE]