InnoDB: using atomic writes. 2021-10-06 18:16:49 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions 2021-10-06 18:16:49 0 [Note] InnoDB: Uses event mutexes 2021-10-06 18:16:49 0 [Note] InnoDB: Compressed tables use zlib 1.2.11 2021-10-06 18:16:49 0 [Note] InnoDB: Number of pools: 1 2021-10-06 18:16:49 0 [Note] InnoDB: Using SSE2 crc32 instructions 2021-10-06 18:16:49 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M 2021-10-06 18:16:49 0 [Note] InnoDB: Completed initialization of buffer pool 2021-10-06 18:16:50 0 [Note] InnoDB: 128 out of 128 rollback segments are active. 2021-10-06 18:16:50 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2021-10-06 18:16:50 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2021-10-06 18:16:50 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB. 2021-10-06 18:16:50 0 [Note] InnoDB: 10.4.13 started; log sequence number 343309737; transaction id 1200065 2021-10-06 18:16:50 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool 2021-10-06 18:16:50 0 [Note] Plugin 'FEEDBACK' is disabled. 2021-10-06 18:16:50 0 [Note] Server socket created on IP: '::'. 2021-10-06 18:16:50 0 [Note] Reading of all Master_info entries succeeded 2021-10-06 18:16:50 0 [Note] Added new Master_info '' to hash table 2021-10-06 18:16:50 0 [Note] C:\xampp\mysql\bin\mysqld.exe: ready for connections. Version: '10.4.13-MariaDB' socket: '' port: 3306 mariadb.org binary distribution 2021-10-06 18:16:51 0 [Note] InnoDB: Buffer pool(s) load completed at 211006 18:16:51 2021-10-06 18:17:49 0 [Note] C:\xampp\mysql\bin\mysqld.exe (initiated by: unknown): Normal shutdown 2021-10-06 18:17:49 0 [Note] Event Scheduler: Purging the queue. 0 events 2021-10-06 18:17:49 0 [Note] InnoDB: FTS optimize thread exiting. 2021-10-06 18:17:49 0 [Note] InnoDB: Starting shutdown... 2021-10-06 18:17:49 0 [Note] InnoDB: Dumping buffer pool(s) to C:\xampp\mysql\data\ib_buffer_pool 2021-10-06 18:17:49 0 [Note] InnoDB: Instance 0, restricted to 250 pages due to innodb_buf_pool_dump_pct=25 2021-10-06 18:17:49 0 [Note] InnoDB: Buffer pool(s) dump completed at 211006 18:17:49 2021-10-06 18:17:49 0 [Note] InnoDB: Shutdown completed; log sequence number 343309746; transaction id 1200066 2021-10-06 18:17:49 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" 2021-10-06 18:17:50 0 [Note] C:\xampp\mysql\bin\mysqld.exe: Shutdown complete InnoDB: using atomic writes. 2021-10-06 18:18:34 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions 2021-10-06 18:18:34 0 [Note] InnoDB: Uses event mutexes 2021-10-06 18:18:34 0 [Note] InnoDB: Compressed tables use zlib 1.2.11 2021-10-06 18:18:34 0 [Note] InnoDB: Number of pools: 1 2021-10-06 18:18:34 0 [Note] InnoDB: Using SSE2 crc32 instructions 2021-10-06 18:18:34 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M 2021-10-06 18:18:34 0 [Note] InnoDB: Completed initialization of buffer pool 2021-10-06 18:18:35 0 [Note] InnoDB: 128 out of 128 rollback segments are active. 2021-10-06 18:18:35 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2021-10-06 18:18:35 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2021-10-06 18:18:35 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB. 2021-10-06 18:18:35 0 [Note] InnoDB: 10.4.13 started; log sequence number 343309746; transaction id 1200065 2021-10-06 18:18:35 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool 2021-10-06 18:18:35 0 [Note] Plugin 'FEEDBACK' is disabled. 2021-10-06 18:18:35 0 [Note] Server socket created on IP: '::'. 2021-10-06 18:18:35 0 [Note] Reading of all Master_info entries succeeded 2021-10-06 18:18:35 0 [Note] Added new Master_info '' to hash table 2021-10-06 18:18:35 0 [Note] C:\xampp\mysql\bin\mysqld.exe: ready for connections. Version: '10.4.13-MariaDB' socket: '' port: 3306 mariadb.org binary distribution 2021-10-06 18:18:36 0 [Note] InnoDB: Buffer pool(s) load completed at 211006 18:18:36 2021-10-07 1:24:17 0 [Warning] InnoDB: A long semaphore wait: --Thread 2880 has waited at trx0undo.ic line 114 for 241.00 seconds the semaphore: X-lock on RW-latch at 000000000EAE50F0 created in file buf0buf.cc line 1584 a writer (thread id 0) has reserved it in mode SX number of readers 0, waiters flag 1, lock_word: 10000000 Last time write locked in file buf0flu.cc line 1175 2021-10-07 1:24:17 0 [Note] InnoDB: A semaphore wait: --Thread 2880 has waited at trx0undo.ic line 114 for 241.00 seconds the semaphore: X-lock on RW-latch at 000000000EAE50F0 created in file buf0buf.cc line 1584 a writer (thread id 0) has reserved it in mode SX number of readers 0, waiters flag 1, lock_word: 10000000 Last time write locked in file buf0flu.cc line 1175 InnoDB: ###### Starts InnoDB Monitor for 30 secs to print diagnostic info: InnoDB: Pending reads 0, writes 0 ===================================== 2021-10-07 01:24:35 0xd30 INNODB MONITOR OUTPUT ===================================== Per second averages calculated from the last 15 seconds ----------------- BACKGROUND THREAD ----------------- srv_master_thread loops: 45 srv_active, 0 srv_shutdown, 25249 srv_idle srv_master_thread log flush and writes: 25293 ---------- SEMAPHORES ---------- OS WAIT ARRAY INFO: reservation count 256 --Thread 2880 has waited at trx0undo.ic line 114 for 259.00 seconds the semaphore: X-lock on RW-latch at 000000000EAE50F0 created in file buf0buf.cc line 1584 a writer (thread id 0) has reserved it in mode SX number of readers 0, waiters flag 1, lock_word: 10000000 Last time write locked in file buf0flu.cc line 1175 OS WAIT ARRAY INFO: signal count 138 RW-shared spins 0, rounds 118, OS waits 59 RW-excl spins 0, rounds 95, OS waits 3 RW-sx spins 0, rounds 0, OS waits 0 Spin rounds per wait: 118.00 RW-shared, 95.00 RW-excl, 0.00 RW-sx ------------ TRANSACTIONS ------------ Trx id counter 1200443 Purge done for trx's n:o < 1200441 undo n:o < 0 state: running History list length 1 LIST OF TRANSACTIONS FOR EACH SESSION: ---TRANSACTION 281475218547000, not started flushing log mysql tables in use 1, locked 1 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 281475218542784, not started 0 lock struct(s), heap size 1128, 0 row lock(s) -------- FILE I/O -------- I/O thread 0 state: native aio handle (insert buffer thread) I/O thread 1 state: native aio handle (log thread) I/O thread 2 state: native aio handle (read thread) I/O thread 3 state: native aio handle (read thread) I/O thread 4 state: native aio handle (read thread) I/O thread 5 state: native aio handle (read thread) I/O thread 6 state: native aio handle (write thread) I/O thread 7 state: native aio handle (write thread) I/O thread 8 state: native aio handle (write thread) I/O thread 9 state: native aio handle (write thread) Pending normal aio reads: [0, 0, 0, 0] , aio writes: [0, 0, 0, 0] , ibuf aio reads:, log i/o's:, sync i/o's: Pending flushes (fsync) log: 1; buffer pool: 0 1487 OS file reads, 1138 OS file writes, 430 OS fsyncs 0.00 reads/s, 0 avg bytes/read, 0.00 writes/s, 0.00 fsyncs/s ------------------------------------- INSERT BUFFER AND ADAPTIVE HASH INDEX ------------------------------------- Ibuf: size 1, free list len 3, seg size 5, 0 merges merged operations: insert 0, delete mark 0, delete 0 discarded operations: insert 0, delete mark 0, delete 0 Hash table size 4441, node heap has 1 buffer(s) Hash table size 4441, node heap has 2 buffer(s) Hash table size 4441, node heap has 0 buffer(s) Hash table size 4441, node heap has 0 buffer(s) Hash table size 4441, node heap has 1 buffer(s) Hash table size 4441, node heap has 1 buffer(s) Hash table size 4441, node heap has 1 buffer(s) Hash table size 4441, node heap has 0 buffer(s) 0.00 hash searches/s, 0.00 non-hash searches/s --- LOG --- Log sequence number 343363178 Log flushed up to 343361589 Pages flushed up to 343361589 Last checkpoint at 343361580 1 pending log flushes, 0 pending chkp writes 335 log i/o's done, 0.00 log i/o's/second ---------------------- BUFFER POOL AND MEMORY ---------------------- Total large memory allocated 33554432 Dictionary memory allocated 399168 Buffer pool size 1002 Free buffers 736 Database pages 260 Old database pages 0 Modified db pages 61 Percent of dirty pages(LRU & free pages): 6.118 Max dirty pages percent: 75.000 Pending reads 0 Pending writes: LRU 0, flush list 2, single page 0 Pages made young 0, not young 0 0.00 youngs/s, 0.00 non-youngs/s Pages read 1307, created 135, written 773 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: 260, 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 Process ID=3492, Main thread ID=3276, state: flushing log Number of rows inserted 0, updated 169, deleted 0, read 4882 0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s Number of system rows inserted 0, updated 0, deleted 0, read 0 0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s ---------------------------- END OF INNODB MONITOR OUTPUT ============================ InnoDB: ###### Diagnostic info printed to the standard error stream 2021-10-07 1:24:48 0 [Warning] InnoDB: A long semaphore wait: --Thread 2880 has waited at trx0undo.ic line 114 for 272.00 seconds the semaphore: X-lock on RW-latch at 000000000EAE50F0 created in file buf0buf.cc line 1584 a writer (thread id 0) has reserved it in mode SX number of readers 0, waiters flag 1, lock_word: 10000000 Last time write locked in file buf0flu.cc line 1175 2021-10-07 1:24:48 0 [Note] InnoDB: A semaphore wait: --Thread 2880 has waited at trx0undo.ic line 114 for 272.00 seconds the semaphore: X-lock on RW-latch at 000000000EAE50F0 created in file buf0buf.cc line 1584 a writer (thread id 0) has reserved it in mode SX number of readers 0, waiters flag 1, lock_word: 10000000 Last time write locked in file buf0flu.cc line 1175 InnoDB: ###### Starts InnoDB Monitor for 30 secs to print diagnostic info: InnoDB: Pending reads 0, writes 0 ===================================== 2021-10-07 01:24:55 0xd30 INNODB MONITOR OUTPUT ===================================== Per second averages calculated from the last 20 seconds ----------------- BACKGROUND THREAD ----------------- srv_master_thread loops: 45 srv_active, 0 srv_shutdown, 25249 srv_idle srv_master_thread log flush and writes: 25293 ---------- SEMAPHORES ---------- OS WAIT ARRAY INFO: reservation count 256 --Thread 2880 has waited at trx0undo.ic line 114 for 279.00 seconds the semaphore: X-lock on RW-latch at 000000000EAE50F0 created in file buf0buf.cc line 1584 a writer (thread id 0) has reserved it in mode SX number of readers 0, waiters flag 1, lock_word: 10000000 Last time write locked in file buf0flu.cc line 1175 OS WAIT ARRAY INFO: signal count 138 RW-shared spins 0, rounds 118, OS waits 59 RW-excl spins 0, rounds 95, OS waits 3 RW-sx spins 0, rounds 0, OS waits 0 Spin rounds per wait: 118.00 RW-shared, 95.00 RW-excl, 0.00 RW-sx ------------ TRANSACTIONS ------------ Trx id counter 1200443 Purge done for trx's n:o < 1200441 undo n:o < 0 state: running History list length 1 LIST OF TRANSACTIONS FOR EACH SESSION: ---TRANSACTION 281475218547000, not started flushing log mysql tables in use 1, locked 1 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 281475218542784, not started 0 lock struct(s), heap size 1128, 0 row lock(s) -------- FILE I/O -------- I/O thread 0 state: native aio handle (insert buffer thread) I/O thread 1 state: native aio handle (log thread) I/O thread 2 state: native aio handle (read thread) I/O thread 3 state: native aio handle (read thread) I/O thread 4 state: native aio handle (read thread) I/O thread 5 state: native aio handle (read thread) I/O thread 6 state: native aio handle (write thread) I/O thread 7 state: native aio handle (write thread) I/O thread 8 state: native aio handle (write thread) I/O thread 9 state: native aio handle (write thread) Pending normal aio reads: [0, 0, 0, 0] , aio writes: [0, 0, 0, 0] , ibuf aio reads:, log i/o's:, sync i/o's: Pending flushes (fsync) log: 1; buffer pool: 0 1487 OS file reads, 1138 OS file writes, 430 OS fsyncs 0.00 reads/s, 0 avg bytes/read, 0.00 writes/s, 0.00 fsyncs/s ------------------------------------- INSERT BUFFER AND ADAPTIVE HASH INDEX ------------------------------------- Ibuf: size 1, free list len 3, seg size 5, 0 merges merged operations: insert 0, delete mark 0, delete 0 discarded operations: insert 0, delete mark 0, delete 0 Hash table size 4441, node heap has 1 buffer(s) Hash table size 4441, node heap has 2 buffer(s) Hash table size 4441, node heap has 0 buffer(s) Hash table size 4441, node heap has 0 buffer(s) Hash table size 4441, node heap has 1 buffer(s) Hash table size 4441, node heap has 1 buffer(s) Hash table size 4441, node heap has 1 buffer(s) Hash table size 4441, node heap has 0 buffer(s) 0.00 hash searches/s, 0.00 non-hash searches/s --- LOG --- Log sequence number 343363178 Log flushed up to 343361589 Pages flushed up to 343361589 Last checkpoint at 343361580 1 pending log flushes, 0 pending chkp writes 335 log i/o's done, 0.00 log i/o's/second ---------------------- BUFFER POOL AND MEMORY ---------------------- Total large memory allocated 33554432 Dictionary memory allocated 399168 Buffer pool size 1002 Free buffers 736 Database pages 260 Old database pages 0 Modified db pages 61 Percent of dirty pages(LRU & free pages): 6.118 Max dirty pages percent: 75.000 Pending reads 0 Pending writes: LRU 0, flush list 2, single page 0 Pages made young 0, not young 0 0.00 youngs/s, 0.00 non-youngs/s Pages read 1307, created 135, written 773 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: 260, 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 Process ID=3492, Main thread ID=3276, state: flushing log Number of rows inserted 0, updated 169, deleted 0, read 4882 0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s Number of system rows inserted 0, updated 0, deleted 0, read 0 0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s ---------------------------- END OF INNODB MONITOR OUTPUT ============================ ===================================== 2021-10-07 01:25:15 0xd30 INNODB MONITOR OUTPUT ===================================== Per second averages calculated from the last 20 seconds ----------------- BACKGROUND THREAD ----------------- srv_master_thread loops: 45 srv_active, 0 srv_shutdown, 25249 srv_idle srv_master_thread log flush and writes: 25293 ---------- SEMAPHORES ---------- OS WAIT ARRAY INFO: reservation count 256 --Thread 2880 has waited at trx0undo.ic line 114 for 299.00 seconds the semaphore: X-lock on RW-latch at 000000000EAE50F0 created in file buf0buf.cc line 1584 a writer (thread id 0) has reserved it in mode SX number of readers 0, waiters flag 1, lock_word: 10000000 Last time write locked in file buf0flu.cc line 1175 OS WAIT ARRAY INFO: signal count 138 RW-shared spins 0, rounds 118, OS waits 59 RW-excl spins 0, rounds 95, OS waits 3 RW-sx spins 0, rounds 0, OS waits 0 Spin rounds per wait: 118.00 RW-shared, 95.00 RW-excl, 0.00 RW-sx ------------ TRANSACTIONS ------------ Trx id counter 1200443 Purge done for trx's n:o < 1200441 undo n:o < 0 state: running History list length 1 LIST OF TRANSACTIONS FOR EACH SESSION: ---TRANSACTION 281475218547000, not started flushing log mysql tables in use 1, locked 1 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 281475218542784, not started 0 lock struct(s), heap size 1128, 0 row lock(s) -------- FILE I/O -------- I/O thread 0 state: native aio handle (insert buffer thread) I/O thread 1 state: native aio handle (log thread) I/O thread 2 state: native aio handle (read thread) I/O thread 3 state: native aio handle (read thread) I/O thread 4 state: native aio handle (read thread) I/O thread 5 state: native aio handle (read thread) I/O thread 6 state: native aio handle (write thread) I/O thread 7 state: native aio handle (write thread) I/O thread 8 state: native aio handle (write thread) I/O thread 9 state: native aio handle (write thread) Pending normal aio reads: [0, 0, 0, 0] , aio writes: [0, 0, 0, 0] , ibuf aio reads:, log i/o's:, sync i/o's: Pending flushes (fsync) log: 1; buffer pool: 0 1487 OS file reads, 1138 OS file writes, 430 OS fsyncs 0.00 reads/s, 0 avg bytes/read, 0.00 writes/s, 0.00 fsyncs/s ------------------------------------- INSERT BUFFER AND ADAPTIVE HASH INDEX ------------------------------------- Ibuf: size 1, free list len 3, seg size 5, 0 merges merged operations: insert 0, delete mark 0, delete 0 discarded operations: insert 0, delete mark 0, delete 0 Hash table size 4441, node heap has 1 buffer(s) Hash table size 4441, node heap has 2 buffer(s) Hash table size 4441, node heap has 0 buffer(s) Hash table size 4441, node heap has 0 buffer(s) Hash table size 4441, node heap has 1 buffer(s) Hash table size 4441, node heap has 1 buffer(s) Hash table size 4441, node heap has 1 buffer(s) Hash table size 4441, node heap has 0 buffer(s) 0.00 hash searches/s, 0.00 non-hash searches/s --- LOG --- Log sequence number 343363178 Log flushed up to 343361589 Pages flushed up to 343361589 Last checkpoint at 343361580 1 pending log flushes, 0 pending chkp writes 335 log i/o's done, 0.00 log i/o's/second ---------------------- BUFFER POOL AND MEMORY ---------------------- Total large memory allocated 33554432 Dictionary memory allocated 399168 Buffer pool size 1002 Free buffers 736 Database pages 260 Old database pages 0 Modified db pages 61 Percent of dirty pages(LRU & free pages): 6.118 Max dirty pages percent: 75.000 Pending reads 0 Pending writes: LRU 0, flush list 2, single page 0 Pages made young 0, not young 0 0.00 youngs/s, 0.00 non-youngs/s Pages read 1307, created 135, written 773 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: 260, 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 Process ID=3492, Main thread ID=3276, state: flushing log Number of rows inserted 0, updated 169, deleted 0, read 4882 0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s Number of system rows inserted 0, updated 0, deleted 0, read 0 0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s ---------------------------- END OF INNODB MONITOR OUTPUT ============================ InnoDB: ###### Diagnostic info printed to the standard error stream 2021-10-07 1:25:20 0 [Warning] InnoDB: A long semaphore wait: --Thread 2880 has waited at trx0undo.ic line 114 for 304.00 seconds the semaphore: X-lock on RW-latch at 000000000EAE50F0 created in file buf0buf.cc line 1584 a writer (thread id 0) has reserved it in mode SX number of readers 0, waiters flag 1, lock_word: 10000000 Last time write locked in file buf0flu.cc line 1175 2021-10-07 1:25:20 0 [Note] InnoDB: A semaphore wait: --Thread 2880 has waited at trx0undo.ic line 114 for 304.00 seconds the semaphore: X-lock on RW-latch at 000000000EAE50F0 created in file buf0buf.cc line 1584 a writer (thread id 0) has reserved it in mode SX number of readers 0, waiters flag 1, lock_word: 10000000 Last time write locked in file buf0flu.cc line 1175 InnoDB: ###### Starts InnoDB Monitor for 30 secs to print diagnostic info: InnoDB: Pending reads 0, writes 0 ===================================== 2021-10-07 01:25:35 0xd30 INNODB MONITOR OUTPUT ===================================== Per second averages calculated from the last 20 seconds ----------------- BACKGROUND THREAD ----------------- srv_master_thread loops: 45 srv_active, 0 srv_shutdown, 25249 srv_idle srv_master_thread log flush and writes: 25293 ---------- SEMAPHORES ---------- OS WAIT ARRAY INFO: reservation count 256 --Thread 2880 has waited at trx0undo.ic line 114 for 319.00 seconds the semaphore: X-lock on RW-latch at 000000000EAE50F0 created in file buf0buf.cc line 1584 a writer (thread id 0) has reserved it in mode SX number of readers 0, waiters flag 1, lock_word: 10000000 Last time write locked in file buf0flu.cc line 1175 OS WAIT ARRAY INFO: signal count 138 RW-shared spins 0, rounds 118, OS waits 59 RW-excl spins 0, rounds 95, OS waits 3 RW-sx spins 0, rounds 0, OS waits 0 Spin rounds per wait: 118.00 RW-shared, 95.00 RW-excl, 0.00 RW-sx ------------ TRANSACTIONS ------------ Trx id counter 1200443 Purge done for trx's n:o < 1200441 undo n:o < 0 state: running History list length 1 LIST OF TRANSACTIONS FOR EACH SESSION: ---TRANSACTION 281475218547000, not started flushing log mysql tables in use 1, locked 1 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 281475218542784, not started 0 lock struct(s), heap size 1128, 0 row lock(s) -------- FILE I/O -------- I/O thread 0 state: native aio handle (insert buffer thread) I/O thread 1 state: native aio handle (log thread) I/O thread 2 state: native aio handle (read thread) I/O thread 3 state: native aio handle (read thread) I/O thread 4 state: native aio handle (read thread) I/O thread 5 state: native aio handle (read thread) I/O thread 6 state: native aio handle (write thread) I/O thread 7 state: native aio handle (write thread) I/O thread 8 state: native aio handle (write thread) I/O thread 9 state: native aio handle (write thread) Pending normal aio reads: [0, 0, 0, 0] , aio writes: [0, 0, 0, 0] , ibuf aio reads:, log i/o's:, sync i/o's: Pending flushes (fsync) log: 1; buffer pool: 0 1487 OS file reads, 1138 OS file writes, 430 OS fsyncs 0.00 reads/s, 0 avg bytes/read, 0.00 writes/s, 0.00 fsyncs/s ------------------------------------- INSERT BUFFER AND ADAPTIVE HASH INDEX ------------------------------------- Ibuf: size 1, free list len 3, seg size 5, 0 merges merged operations: insert 0, delete mark 0, delete 0 discarded operations: insert 0, delete mark 0, delete 0 Hash table size 4441, node heap has 1 buffer(s) Hash table size 4441, node heap has 2 buffer(s) Hash table size 4441, node heap has 0 buffer(s) Hash table size 4441, node heap has 0 buffer(s) Hash table size 4441, node heap has 1 buffer(s) Hash table size 4441, node heap has 1 buffer(s) Hash table size 4441, node heap has 1 buffer(s) Hash table size 4441, node heap has 0 buffer(s) 0.00 hash searches/s, 0.00 non-hash searches/s --- LOG --- Log sequence number 343363178 Log flushed up to 343361589 Pages flushed up to 343361589 Last checkpoint at 343361580 1 pending log flushes, 0 pending chkp writes 335 log i/o's done, 0.00 log i/o's/second ---------------------- BUFFER POOL AND MEMORY ---------------------- Total large memory allocated 33554432 Dictionary memory allocated 399168 Buffer pool size 1002 Free buffers 736 Database pages 260 Old database pages 0 Modified db pages 61 Percent of dirty pages(LRU & free pages): 6.118 Max dirty pages percent: 75.000 Pending reads 0 Pending writes: LRU 0, flush list 2, single page 0 Pages made young 0, not young 0 0.00 youngs/s, 0.00 non-youngs/s Pages read 1307, created 135, written 773 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: 260, 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 Process ID=3492, Main thread ID=3276, state: flushing log Number of rows inserted 0, updated 169, deleted 0, read 4882 0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s Number of system rows inserted 0, updated 0, deleted 0, read 0 0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s ---------------------------- END OF INNODB MONITOR OUTPUT ============================ InnoDB: ###### Diagnostic info printed to the standard error stream 2021-10-07 1:25:51 0 [Warning] InnoDB: A long semaphore wait: --Thread 2880 has waited at trx0undo.ic line 114 for 335.00 seconds the semaphore: X-lock on RW-latch at 000000000EAE50F0 created in file buf0buf.cc line 1584 a writer (thread id 0) has reserved it in mode SX number of readers 0, waiters flag 1, lock_word: 10000000 Last time write locked in file buf0flu.cc line 1175 2021-10-07 1:25:51 0 [Note] InnoDB: A semaphore wait: --Thread 2880 has waited at trx0undo.ic line 114 for 335.00 seconds the semaphore: X-lock on RW-latch at 000000000EAE50F0 created in file buf0buf.cc line 1584 a writer (thread id 0) has reserved it in mode SX number of readers 0, waiters flag 1, lock_word: 10000000 Last time write locked in file buf0flu.cc line 1175 InnoDB: ###### Starts InnoDB Monitor for 30 secs to print diagnostic info: InnoDB: Pending reads 0, writes 0 ===================================== 2021-10-07 01:25:55 0xd30 INNODB MONITOR OUTPUT ===================================== Per second averages calculated from the last 20 seconds ----------------- BACKGROUND THREAD ----------------- srv_master_thread loops: 45 srv_active, 0 srv_shutdown, 25249 srv_idle srv_master_thread log flush and writes: 25293 ---------- SEMAPHORES ---------- OS WAIT ARRAY INFO: reservation count 256 --Thread 2880 has waited at trx0undo.ic line 114 for 339.00 seconds the semaphore: X-lock on RW-latch at 000000000EAE50F0 created in file buf0buf.cc line 1584 a writer (thread id 0) has reserved it in mode SX number of readers 0, waiters flag 1, lock_word: 10000000 Last time write locked in file buf0flu.cc line 1175 OS WAIT ARRAY INFO: signal count 138 RW-shared spins 0, rounds 118, OS waits 59 RW-excl spins 0, rounds 95, OS waits 3 RW-sx spins 0, rounds 0, OS waits 0 Spin rounds per wait: 118.00 RW-shared, 95.00 RW-excl, 0.00 RW-sx ------------ TRANSACTIONS ------------ Trx id counter 1200443 Purge done for trx's n:o < 1200441 undo n:o < 0 state: running History list length 1 LIST OF TRANSACTIONS FOR EACH SESSION: ---TRANSACTION 281475218547000, not started flushing log mysql tables in use 1, locked 1 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 281475218542784, not started 0 lock struct(s), heap size 1128, 0 row lock(s) -------- FILE I/O -------- I/O thread 0 state: native aio handle (insert buffer thread) I/O thread 1 state: native aio handle (log thread) I/O thread 2 state: native aio handle (read thread) I/O thread 3 state: native aio handle (read thread) I/O thread 4 state: native aio handle (read thread) I/O thread 5 state: native aio handle (read thread) I/O thread 6 state: native aio handle (write thread) I/O thread 7 state: native aio handle (write thread) I/O thread 8 state: native aio handle (write thread) I/O thread 9 state: native aio handle (write thread) Pending normal aio reads: [0, 0, 0, 0] , aio writes: [0, 0, 0, 0] , ibuf aio reads:, log i/o's:, sync i/o's: Pending flushes (fsync) log: 1; buffer pool: 0 1487 OS file reads, 1138 OS file writes, 430 OS fsyncs 0.00 reads/s, 0 avg bytes/read, 0.00 writes/s, 0.00 fsyncs/s ------------------------------------- INSERT BUFFER AND ADAPTIVE HASH INDEX ------------------------------------- Ibuf: size 1, free list len 3, seg size 5, 0 merges merged operations: insert 0, delete mark 0, delete 0 discarded operations: insert 0, delete mark 0, delete 0 Hash table size 4441, node heap has 1 buffer(s) Hash table size 4441, node heap has 2 buffer(s) Hash table size 4441, node heap has 0 buffer(s) Hash table size 4441, node heap has 0 buffer(s) Hash table size 4441, node heap has 1 buffer(s) Hash table size 4441, node heap has 1 buffer(s) Hash table size 4441, node heap has 1 buffer(s) Hash table size 4441, node heap has 0 buffer(s) 0.00 hash searches/s, 0.00 non-hash searches/s --- LOG --- Log sequence number 343363178 Log flushed up to 343361589 Pages flushed up to 343361589 Last checkpoint at 343361580 1 pending log flushes, 0 pending chkp writes 335 log i/o's done, 0.00 log i/o's/second ---------------------- BUFFER POOL AND MEMORY ---------------------- Total large memory allocated 33554432 Dictionary memory allocated 399168 Buffer pool size 1002 Free buffers 736 Database pages 260 Old database pages 0 Modified db pages 61 Percent of dirty pages(LRU & free pages): 6.118 Max dirty pages percent: 75.000 Pending reads 0 Pending writes: LRU 0, flush list 2, single page 0 Pages made young 0, not young 0 0.00 youngs/s, 0.00 non-youngs/s Pages read 1307, created 135, written 773 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: 260, 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 Process ID=3492, Main thread ID=3276, state: flushing log Number of rows inserted 0, updated 169, deleted 0, read 4882 0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s Number of system rows inserted 0, updated 0, deleted 0, read 0 0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s ---------------------------- END OF INNODB MONITOR OUTPUT ============================ ===================================== 2021-10-07 01:26:15 0xd30 INNODB MONITOR OUTPUT ===================================== Per second averages calculated from the last 20 seconds ----------------- BACKGROUND THREAD ----------------- srv_master_thread loops: 45 srv_active, 0 srv_shutdown, 25249 srv_idle srv_master_thread log flush and writes: 25293 ---------- SEMAPHORES ---------- OS WAIT ARRAY INFO: reservation count 256 --Thread 2880 has waited at trx0undo.ic line 114 for 359.00 seconds the semaphore: X-lock on RW-latch at 000000000EAE50F0 created in file buf0buf.cc line 1584 a writer (thread id 0) has reserved it in mode SX number of readers 0, waiters flag 1, lock_word: 10000000 Last time write locked in file buf0flu.cc line 1175 OS WAIT ARRAY INFO: signal count 138 RW-shared spins 0, rounds 118, OS waits 59 RW-excl spins 0, rounds 95, OS waits 3 RW-sx spins 0, rounds 0, OS waits 0 Spin rounds per wait: 118.00 RW-shared, 95.00 RW-excl, 0.00 RW-sx ------------ TRANSACTIONS ------------ Trx id counter 1200443 Purge done for trx's n:o < 1200441 undo n:o < 0 state: running History list length 1 LIST OF TRANSACTIONS FOR EACH SESSION: ---TRANSACTION 281475218547000, not started flushing log mysql tables in use 1, locked 1 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 281475218542784, not started 0 lock struct(s), heap size 1128, 0 row lock(s) -------- FILE I/O -------- I/O thread 0 state: native aio handle (insert buffer thread) I/O thread 1 state: native aio handle (log thread) I/O thread 2 state: native aio handle (read thread) I/O thread 3 state: native aio handle (read thread) I/O thread 4 state: native aio handle (read thread) I/O thread 5 state: native aio handle (read thread) I/O thread 6 state: native aio handle (write thread) I/O thread 7 state: native aio handle (write thread) I/O thread 8 state: native aio handle (write thread) I/O thread 9 state: native aio handle (write thread) Pending normal aio reads: [0, 0, 0, 0] , aio writes: [0, 0, 0, 0] , ibuf aio reads:, log i/o's:, sync i/o's: Pending flushes (fsync) log: 1; buffer pool: 0 1487 OS file reads, 1138 OS file writes, 430 OS fsyncs 0.00 reads/s, 0 avg bytes/read, 0.00 writes/s, 0.00 fsyncs/s ------------------------------------- INSERT BUFFER AND ADAPTIVE HASH INDEX ------------------------------------- Ibuf: size 1, free list len 3, seg size 5, 0 merges merged operations: insert 0, delete mark 0, delete 0 discarded operations: insert 0, delete mark 0, delete 0 Hash table size 4441, node heap has 1 buffer(s) Hash table size 4441, node heap has 2 buffer(s) Hash table size 4441, node heap has 0 buffer(s) Hash table size 4441, node heap has 0 buffer(s) Hash table size 4441, node heap has 1 buffer(s) Hash table size 4441, node heap has 1 buffer(s) Hash table size 4441, node heap has 1 buffer(s) Hash table size 4441, node heap has 0 buffer(s) 0.00 hash searches/s, 0.00 non-hash searches/s --- LOG --- Log sequence number 343363178 Log flushed up to 343361589 Pages flushed up to 343361589 Last checkpoint at 343361580 1 pending log flushes, 0 pending chkp writes 335 log i/o's done, 0.00 log i/o's/second ---------------------- BUFFER POOL AND MEMORY ---------------------- Total large memory allocated 33554432 Dictionary memory allocated 399168 Buffer pool size 1002 Free buffers 736 Database pages 260 Old database pages 0 Modified db pages 61 Percent of dirty pages(LRU & free pages): 6.118 Max dirty pages percent: 75.000 Pending reads 0 Pending writes: LRU 0, flush list 2, single page 0 Pages made young 0, not young 0 0.00 youngs/s, 0.00 non-youngs/s Pages read 1307, created 135, written 773 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: 260, 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 Process ID=3492, Main thread ID=3276, state: flushing log Number of rows inserted 0, updated 169, deleted 0, read 4882 0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s Number of system rows inserted 0, updated 0, deleted 0, read 0 0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s ---------------------------- END OF INNODB MONITOR OUTPUT ============================ InnoDB: ###### Diagnostic info printed to the standard error stream 2021-10-07 1:26:28 0 [Warning] InnoDB: A long semaphore wait: --Thread 2880 has waited at trx0undo.ic line 114 for 372.00 seconds the semaphore: X-lock on RW-latch at 000000000EAE50F0 created in file buf0buf.cc line 1584 a writer (thread id 0) has reserved it in mode SX number of readers 0, waiters flag 1, lock_word: 10000000 Last time write locked in file buf0flu.cc line 1175 2021-10-07 1:26:28 0 [Note] InnoDB: A semaphore wait: --Thread 2880 has waited at trx0undo.ic line 114 for 372.00 seconds the semaphore: X-lock on RW-latch at 000000000EAE50F0 created in file buf0buf.cc line 1584 a writer (thread id 0) has reserved it in mode SX number of readers 0, waiters flag 1, lock_word: 10000000 Last time write locked in file buf0flu.cc line 1175 2021-10-07 1:26:28 0 [Note] InnoDB: A semaphore wait: --Thread 2420 has waited at row0upd.cc line 3108 for 6.00 seconds the semaphore: X-lock on RW-latch at 000000000EAE3990 created in file buf0buf.cc line 1584 a writer (thread id 0) has reserved it in mode SX number of readers 0, waiters flag 1, lock_word: 10000000 Last time write locked in file buf0flu.cc line 1175 InnoDB: ###### Starts InnoDB Monitor for 30 secs to print diagnostic info: InnoDB: Pending reads 0, writes 0 ===================================== 2021-10-07 01:26:35 0xd30 INNODB MONITOR OUTPUT ===================================== Per second averages calculated from the last 20 seconds ----------------- BACKGROUND THREAD ----------------- srv_master_thread loops: 45 srv_active, 0 srv_shutdown, 25250 srv_idle srv_master_thread log flush and writes: 25295 ---------- SEMAPHORES ---------- OS WAIT ARRAY INFO: reservation count 262 OS WAIT ARRAY INFO: signal count 144 RW-shared spins 0, rounds 118, OS waits 59 RW-excl spins 0, rounds 155, OS waits 5 RW-sx spins 1, rounds 30, OS waits 1 Spin rounds per wait: 118.00 RW-shared, 155.00 RW-excl, 30.00 RW-sx ------------ TRANSACTIONS ------------ Trx id counter 1200446 Purge done for trx's n:o < 1200441 undo n:o < 0 state: running History list length 2 LIST OF TRANSACTIONS FOR EACH SESSION: ---TRANSACTION 281475218547000, not started flushing log mysql tables in use 1, locked 1 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 281475218542784, not started 0 lock struct(s), heap size 1128, 0 row lock(s) -------- FILE I/O -------- I/O thread 0 state: native aio handle (insert buffer thread) I/O thread 1 state: native aio handle (log thread) I/O thread 2 state: native aio handle (read thread) I/O thread 3 state: native aio handle (read thread) I/O thread 4 state: native aio handle (read thread) I/O thread 5 state: native aio handle (read thread) I/O thread 6 state: native aio handle (write thread) I/O thread 7 state: native aio handle (write thread) I/O thread 8 state: native aio handle (write thread) I/O thread 9 state: native aio handle (write thread) Pending normal aio reads: [0, 0, 0, 0] , aio writes: [0, 0, 0, 0] , ibuf aio reads:, log i/o's:, sync i/o's: Pending flushes (fsync) log: 1; buffer pool: 1 1490 OS file reads, 1144 OS file writes, 436 OS fsyncs 1 pending reads, 0 pending writes 0.15 reads/s, 16384 avg bytes/read, 0.30 writes/s, 0.30 fsyncs/s ------------------------------------- INSERT BUFFER AND ADAPTIVE HASH INDEX ------------------------------------- Ibuf: size 1, free list len 3, seg size 5, 0 merges merged operations: insert 0, delete mark 0, delete 0 discarded operations: insert 0, delete mark 0, delete 0 Hash table size 4441, node heap has 1 buffer(s) Hash table size 4441, node heap has 2 buffer(s) Hash table size 4441, node heap has 0 buffer(s) Hash table size 4441, node heap has 0 buffer(s) Hash table size 4441, node heap has 1 buffer(s) Hash table size 4441, node heap has 1 buffer(s) Hash table size 4441, node heap has 1 buffer(s) Hash table size 4441, node heap has 0 buffer(s) 0.05 hash searches/s, 0.05 non-hash searches/s --- LOG --- Log sequence number 343363478 Log flushed up to 343363178 Pages flushed up to 343361778 Last checkpoint at 343361580 1 pending log flushes, 0 pending chkp writes 337 log i/o's done, 0.10 log i/o's/second ---------------------- BUFFER POOL AND MEMORY ---------------------- Total large memory allocated 33554432 Dictionary memory allocated 399168 Buffer pool size 1002 Free buffers 733 Database pages 263 Old database pages 0 Modified db pages 62 Percent of dirty pages(LRU & free pages): 6.219 Max dirty pages percent: 75.000 Pending reads 1 Pending writes: LRU 0, flush list 1, single page 0 Pages made young 0, not young 0 0.00 youngs/s, 0.00 non-youngs/s Pages read 1309, created 135, written 775 0.10 reads/s, 0.00 creates/s, 0.10 writes/s Buffer pool hit rate 970 / 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: 263, unzip_LRU len: 0 I/O sum[2]:cur[3], unzip sum[0]:cur[0] -------------- ROW OPERATIONS -------------- 0 queries inside InnoDB, 0 queries in queue 0 read views open inside InnoDB Process ID=3492, Main thread ID=3276, state: making checkpoint Number of rows inserted 0, updated 170, deleted 0, read 4915 0.00 inserts/s, 0.05 updates/s, 0.00 deletes/s, 1.65 reads/s Number of system rows inserted 0, updated 0, deleted 0, read 0 0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s ---------------------------- END OF INNODB MONITOR OUTPUT ============================ ===================================== 2021-10-07 01:26:55 0xd30 INNODB MONITOR OUTPUT ===================================== Per second averages calculated from the last 20 seconds ----------------- BACKGROUND THREAD ----------------- srv_master_thread loops: 46 srv_active, 0 srv_shutdown, 25250 srv_idle srv_master_thread log flush and writes: 25295 ---------- SEMAPHORES ---------- OS WAIT ARRAY INFO: reservation count 265 OS WAIT ARRAY INFO: signal count 146 RW-shared spins 0, rounds 121, OS waits 60 RW-excl spins 0, rounds 155, OS waits 5 RW-sx spins 1, rounds 30, OS waits 1 Spin rounds per wait: 121.00 RW-shared, 155.00 RW-excl, 30.00 RW-sx ------------ TRANSACTIONS ------------ Trx id counter 1200448 Purge done for trx's n:o < 1200448 undo n:o < 0 state: running but idle History list length 3 LIST OF TRANSACTIONS FOR EACH SESSION: ---TRANSACTION 281475218547000, not started flushing log mysql tables in use 1, locked 1 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 281475218542784, not started 0 lock struct(s), heap size 1128, 0 row lock(s) -------- FILE I/O -------- I/O thread 0 state: native aio handle (insert buffer thread) I/O thread 1 state: native aio handle (log thread) I/O thread 2 state: native aio handle (read thread) I/O thread 3 state: native aio handle (read thread) I/O thread 4 state: native aio handle (read thread) I/O thread 5 state: native aio handle (read thread) I/O thread 6 state: native aio handle (write thread) I/O thread 7 state: native aio handle (write thread) I/O thread 8 state: native aio handle (write thread) I/O thread 9 state: native aio handle (write thread) Pending normal aio reads: [0, 0, 0, 0] , aio writes: [0, 0, 0, 0] , ibuf aio reads:, log i/o's:, sync i/o's: Pending flushes (fsync) log: 1; buffer pool: 1 1492 OS file reads, 1149 OS file writes, 441 OS fsyncs 0.10 reads/s, 16384 avg bytes/read, 0.25 writes/s, 0.25 fsyncs/s ------------------------------------- INSERT BUFFER AND ADAPTIVE HASH INDEX ------------------------------------- Ibuf: size 1, free list len 3, seg size 5, 0 merges merged operations: insert 0, delete mark 0, delete 0 discarded operations: insert 0, delete mark 0, delete 0 Hash table size 4441, node heap has 1 buffer(s) Hash table size 4441, node heap has 2 buffer(s) Hash table size 4441, node heap has 0 buffer(s) Hash table size 4441, node heap has 0 buffer(s) Hash table size 4441, node heap has 1 buffer(s) Hash table size 4441, node heap has 1 buffer(s) Hash table size 4441, node heap has 1 buffer(s) Hash table size 4441, node heap has 0 buffer(s) 0.15 hash searches/s, 0.05 non-hash searches/s --- LOG --- Log sequence number 343363762 Log flushed up to 343363478 Pages flushed up to 343361854 Last checkpoint at 343361778 1 pending log flushes, 0 pending chkp writes 340 log i/o's done, 0.15 log i/o's/second ---------------------- BUFFER POOL AND MEMORY ---------------------- Total large memory allocated 33554432 Dictionary memory allocated 399168 Buffer pool size 1002 Free buffers 739 Database pages 257 Old database pages 0 Modified db pages 63 Percent of dirty pages(LRU & free pages): 6.319 Max dirty pages percent: 75.000 Pending reads 0 Pending writes: LRU 0, flush list 61, single page 0 Pages made young 0, not young 0 0.00 youngs/s, 0.00 non-youngs/s Pages read 1312, created 135, written 776 0.15 reads/s, 0.00 creates/s, 0.05 writes/s Buffer pool hit rate 931 / 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: 257, unzip_LRU len: 0 I/O sum[2]:cur[65], unzip sum[0]:cur[0] -------------- ROW OPERATIONS -------------- 0 queries inside InnoDB, 0 queries in queue 0 read views open inside InnoDB Process ID=3492, Main thread ID=3276, state: flushing log Number of rows inserted 0, updated 171, deleted 0, read 4916 0.00 inserts/s, 0.05 updates/s, 0.00 deletes/s, 0.05 reads/s Number of system rows inserted 0, updated 0, deleted 0, read 0 0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s ---------------------------- END OF INNODB MONITOR OUTPUT ============================ InnoDB: ###### Diagnostic info printed to the standard error stream 2021-10-07 1:33:23 0 [Warning] InnoDB: A long semaphore wait: --Thread 2420 has waited at row0upd.cc line 3108 for 282.00 seconds the semaphore: X-lock on RW-latch at 000000000EAE3990 created in file buf0buf.cc line 1584 a writer (thread id 0) has reserved it in mode SX number of readers 0, waiters flag 1, lock_word: 10000000 Last time write locked in file buf0flu.cc line 1186 2021-10-07 1:34:04 0 [Warning] InnoDB: A long semaphore wait: --Thread 3092 has waited at log0log.cc line 890 for 282.00 seconds the semaphore: Mutex at 000000014080F080, Mutex LOG_WRITE created log0log.cc:540, lock var 2 2021-10-07 1:34:04 0 [Note] InnoDB: A semaphore wait: --Thread 2420 has waited at row0upd.cc line 3108 for 282.00 seconds the semaphore: X-lock on RW-latch at 000000000EAE3990 created in file buf0buf.cc line 1584 a writer (thread id 0) has reserved it in mode SX number of readers 0, waiters flag 1, lock_word: 10000000 Last time write locked in file buf0flu.cc line 1186 2021-10-07 1:34:04 0 [Note] InnoDB: A semaphore wait: --Thread 3092 has waited at log0log.cc line 890 for 282.00 seconds the semaphore: Mutex at 000000014080F080, Mutex LOG_WRITE created log0log.cc:540, lock var 2 InnoDB: ###### Starts InnoDB Monitor for 30 secs to print diagnostic info: InnoDB: Pending reads 0, writes 1 ===================================== 2021-10-07 01:34:15 0xd30 INNODB MONITOR OUTPUT ===================================== Per second averages calculated from the last 50 seconds ----------------- BACKGROUND THREAD ----------------- srv_master_thread loops: 46 srv_active, 0 srv_shutdown, 25251 srv_idle srv_master_thread log flush and writes: 25297 ---------- SEMAPHORES ---------- OS WAIT ARRAY INFO: reservation count 267 OS WAIT ARRAY INFO: signal count 148 RW-shared spins 0, rounds 121, OS waits 60 RW-excl spins 0, rounds 185, OS waits 6 RW-sx spins 1, rounds 30, OS waits 1 Spin rounds per wait: 121.00 RW-shared, 185.00 RW-excl, 30.00 RW-sx ------------ TRANSACTIONS ------------ Trx id counter 1200449 Purge done for trx's n:o < 1200448 undo n:o < 0 state: running but idle History list length 3 LIST OF TRANSACTIONS FOR EACH SESSION: ---TRANSACTION 1200448, ACTIVE 293 sec updating or deleting mysql tables in use 1, locked 1 2 lock struct(s), heap size 1128, 1 row lock(s) MySQL thread id 36, OS thread handle 2420, query id 518 vtigercrmsale fe80::e98a:dfea:59cd:2924%11 vtigerdb Updating UPDATE vtiger_cron_task SET status=1, lastend=1633562962 WHERE id='3' ---TRANSACTION 281475218542784, not started 0 lock struct(s), heap size 1128, 0 row lock(s) -------- FILE I/O -------- I/O thread 0 state: native aio handle (insert buffer thread) I/O thread 1 state: native aio handle (log thread) I/O thread 2 state: native aio handle (read thread) I/O thread 3 state: native aio handle (read thread) I/O thread 4 state: native aio handle (read thread) I/O thread 5 state: native aio handle (read thread) I/O thread 6 state: native aio handle (write thread) I/O thread 7 state: complete io for buf page (write thread) I/O thread 8 state: native aio handle (write thread) I/O thread 9 state: native aio handle (write thread) Pending normal aio reads: [0, 0, 0, 0] , aio writes: [0, 0, 0, 0] , ibuf aio reads:, log i/o's:, sync i/o's: Pending flushes (fsync) log: 1; buffer pool: 1 1493 OS file reads, 1213 OS file writes, 446 OS fsyncs 1 pending reads, 0 pending writes 0.02 reads/s, 16384 avg bytes/read, 0.08 writes/s, 0.10 fsyncs/s ------------------------------------- INSERT BUFFER AND ADAPTIVE HASH INDEX ------------------------------------- Ibuf: size 1, free list len 3, seg size 5, 0 merges merged operations: insert 0, delete mark 0, delete 0 discarded operations: insert 0, delete mark 0, delete 0 Hash table size 4441, node heap has 1 buffer(s) Hash table size 4441, node heap has 2 buffer(s) Hash table size 4441, node heap has 0 buffer(s) Hash table size 4441, node heap has 0 buffer(s) Hash table size 4441, node heap has 1 buffer(s) Hash table size 4441, node heap has 1 buffer(s) Hash table size 4441, node heap has 1 buffer(s) Hash table size 4441, node heap has 0 buffer(s) 0.00 hash searches/s, 0.00 non-hash searches/s --- LOG --- Log sequence number 343363809 Log flushed up to 343363762 Pages flushed up to 343363499 Last checkpoint at 343361778 1 pending log flushes, 0 pending chkp writes 342 log i/o's done, 0.02 log i/o's/second ---------------------- BUFFER POOL AND MEMORY ---------------------- Total large memory allocated 33554432 Dictionary memory allocated 399168 Buffer pool size 1002 Free buffers 739 Database pages 257 Old database pages 0 Modified db pages 2 Percent of dirty pages(LRU & free pages): 0.201 Max dirty pages percent: 75.000 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 1313, created 135, written 837 0.02 reads/s, 0.00 creates/s, 0.24 writes/s Buffer pool hit rate 0 / 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: 257, unzip_LRU len: 0 I/O sum[0]:cur[3], unzip sum[0]:cur[0] -------------- ROW OPERATIONS -------------- 0 queries inside InnoDB, 0 queries in queue 0 read views open inside InnoDB Process ID=3492, Main thread ID=3276, state: making checkpoint Number of rows inserted 0, updated 172, deleted 0, read 4928 0.00 inserts/s, 0.02 updates/s, 0.00 deletes/s, 0.00 reads/s Number of system rows inserted 0, updated 0, deleted 0, read 0 0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s ---------------------------- END OF INNODB MONITOR OUTPUT ============================ InnoDB: ###### Diagnostic info printed to the standard error stream 2021-10-07 2:05:21 0 [Warning] InnoDB: A long semaphore wait: --Thread 2520 has waited at row0upd.cc line 3108 for 241.00 seconds the semaphore: X-lock on RW-latch at 000000000EAE3990 created in file buf0buf.cc line 1584 a writer (thread id 0) has reserved it in mode SX number of readers 0, waiters flag 1, lock_word: 10000000 Last time write locked in file buf0flu.cc line 1175 2021-10-07 2:05:21 0 [Note] InnoDB: A semaphore wait: --Thread 2520 has waited at row0upd.cc line 3108 for 241.00 seconds the semaphore: X-lock on RW-latch at 000000000EAE3990 created in file buf0buf.cc line 1584 a writer (thread id 0) has reserved it in mode SX number of readers 0, waiters flag 1, lock_word: 10000000 Last time write locked in file buf0flu.cc line 1175 InnoDB: ###### Starts InnoDB Monitor for 30 secs to print diagnostic info: InnoDB: Pending reads 0, writes 0 ===================================== 2021-10-07 02:05:35 0xd30 INNODB MONITOR OUTPUT ===================================== Per second averages calculated from the last 60 seconds ----------------- BACKGROUND THREAD ----------------- srv_master_thread loops: 49 srv_active, 0 srv_shutdown, 25376 srv_idle srv_master_thread log flush and writes: 25425 ---------- SEMAPHORES ---------- OS WAIT ARRAY INFO: reservation count 293 --Thread 2520 has waited at row0upd.cc line 3108 for 255.00 seconds the semaphore: X-lock on RW-latch at 000000000EAE3990 created in file buf0buf.cc line 1584 a writer (thread id 0) has reserved it in mode SX number of readers 0, waiters flag 1, lock_word: 10000000 Last time write locked in file buf0flu.cc line 1175 OS WAIT ARRAY INFO: signal count 166 RW-shared spins 0, rounds 131, OS waits 65 RW-excl spins 0, rounds 215, OS waits 7 RW-sx spins 1, rounds 30, OS waits 1 Spin rounds per wait: 131.00 RW-shared, 215.00 RW-excl, 30.00 RW-sx ------------ TRANSACTIONS ------------ Trx id counter 1200460 Purge done for trx's n:o < 1200459 undo n:o < 0 state: running but idle History list length 8 LIST OF TRANSACTIONS FOR EACH SESSION: ---TRANSACTION 1200459, ACTIVE 255 sec updating or deleting mysql tables in use 1, locked 1 2 lock struct(s), heap size 1128, 1 row lock(s) MySQL thread id 37, OS thread handle 2520, query id 534 vtigercrmsale fe80::e98a:dfea:59cd:2924%11 vtigerdb Updating UPDATE vtiger_cron_task SET status=2, laststart=1633564880, lastend=0 WHERE id='3' ---TRANSACTION 281475218542784, not started 0 lock struct(s), heap size 1128, 0 row lock(s) -------- FILE I/O -------- I/O thread 0 state: native aio handle (insert buffer thread) I/O thread 1 state: native aio handle (log thread) I/O thread 2 state: native aio handle (read thread) I/O thread 3 state: native aio handle (read thread) I/O thread 4 state: native aio handle (read thread) I/O thread 5 state: native aio handle (read thread) I/O thread 6 state: native aio handle (write thread) I/O thread 7 state: native aio handle (write thread) I/O thread 8 state: native aio handle (write thread) I/O thread 9 state: native aio handle (write thread) Pending normal aio reads: [0, 0, 0, 0] , aio writes: [0, 0, 0, 0] , ibuf aio reads:, log i/o's:, sync i/o's: Pending flushes (fsync) log: 1; buffer pool: 0 1497 OS file reads, 1244 OS file writes, 472 OS fsyncs 0.00 reads/s, 0 avg bytes/read, 0.00 writes/s, 0.00 fsyncs/s ------------------------------------- INSERT BUFFER AND ADAPTIVE HASH INDEX ------------------------------------- Ibuf: size 1, free list len 3, seg size 5, 0 merges merged operations: insert 0, delete mark 0, delete 0 discarded operations: insert 0, delete mark 0, delete 0 Hash table size 4441, node heap has 1 buffer(s) Hash table size 4441, node heap has 2 buffer(s) Hash table size 4441, node heap has 0 buffer(s) Hash table size 4441, node heap has 0 buffer(s) Hash table size 4441, node heap has 1 buffer(s) Hash table size 4441, node heap has 1 buffer(s) Hash table size 4441, node heap has 1 buffer(s) Hash table size 4441, node heap has 0 buffer(s) 0.00 hash searches/s, 0.00 non-hash searches/s --- LOG --- Log sequence number 343365292 Log flushed up to 343365224 Pages flushed up to 343364994 Last checkpoint at 343364699 1 pending log flushes, 0 pending chkp writes 358 log i/o's done, 0.00 log i/o's/second ---------------------- BUFFER POOL AND MEMORY ---------------------- Total large memory allocated 33554432 Dictionary memory allocated 399168 Buffer pool size 1002 Free buffers 740 Database pages 256 Old database pages 0 Modified db pages 3 Percent of dirty pages(LRU & free pages): 0.301 Max dirty pages percent: 75.000 Pending reads 0 Pending writes: LRU 0, flush list 3, single page 0 Pages made young 0, not young 0 0.00 youngs/s, 0.00 non-youngs/s Pages read 1317, created 135, written 849 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: 256, 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 Process ID=3492, Main thread ID=3276, state: making checkpoint Number of rows inserted 0, updated 176, deleted 0, read 5086 0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s Number of system rows inserted 0, updated 0, deleted 0, read 0 0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s ---------------------------- END OF INNODB MONITOR OUTPUT ============================ InnoDB: ###### Diagnostic info printed to the standard error stream 2021-10-07 2:05:52 0 [Warning] InnoDB: A long semaphore wait: --Thread 2520 has waited at row0upd.cc line 3108 for 272.00 seconds the semaphore: X-lock on RW-latch at 000000000EAE3990 created in file buf0buf.cc line 1584 a writer (thread id 0) has reserved it in mode SX number of readers 0, waiters flag 1, lock_word: 10000000 Last time write locked in file buf0flu.cc line 1175 2021-10-07 2:05:52 0 [Note] InnoDB: A semaphore wait: --Thread 2520 has waited at row0upd.cc line 3108 for 272.00 seconds the semaphore: X-lock on RW-latch at 000000000EAE3990 created in file buf0buf.cc line 1584 a writer (thread id 0) has reserved it in mode SX number of readers 0, waiters flag 1, lock_word: 10000000 Last time write locked in file buf0flu.cc line 1175 InnoDB: ###### Starts InnoDB Monitor for 30 secs to print diagnostic info: InnoDB: Pending reads 0, writes 0 ===================================== 2021-10-07 02:05:55 0xd30 INNODB MONITOR OUTPUT ===================================== Per second averages calculated from the last 20 seconds ----------------- BACKGROUND THREAD ----------------- srv_master_thread loops: 49 srv_active, 0 srv_shutdown, 25376 srv_idle srv_master_thread log flush and writes: 25425 ---------- SEMAPHORES ---------- OS WAIT ARRAY INFO: reservation count 293 --Thread 2520 has waited at row0upd.cc line 3108 for 275.00 seconds the semaphore: X-lock on RW-latch at 000000000EAE3990 created in file buf0buf.cc line 1584 a writer (thread id 0) has reserved it in mode SX number of readers 0, waiters flag 1, lock_word: 10000000 Last time write locked in file buf0flu.cc line 1175 OS WAIT ARRAY INFO: signal count 166 RW-shared spins 0, rounds 131, OS waits 65 RW-excl spins 0, rounds 215, OS waits 7 RW-sx spins 1, rounds 30, OS waits 1 Spin rounds per wait: 131.00 RW-shared, 215.00 RW-excl, 30.00 RW-sx ------------ TRANSACTIONS ------------ Trx id counter 1200460 Purge done for trx's n:o < 1200459 undo n:o < 0 state: running but idle History list length 8 LIST OF TRANSACTIONS FOR EACH SESSION: ---TRANSACTION 1200459, ACTIVE 275 sec updating or deleting mysql tables in use 1, locked 1 2 lock struct(s), heap size 1128, 1 row lock(s) MySQL thread id 37, OS thread handle 2520, query id 534 vtigercrmsale fe80::e98a:dfea:59cd:2924%11 vtigerdb Updating UPDATE vtiger_cron_task SET status=2, laststart=1633564880, lastend=0 WHERE id='3' ---TRANSACTION 281475218542784, not started 0 lock struct(s), heap size 1128, 0 row lock(s) -------- FILE I/O -------- I/O thread 0 state: native aio handle (insert buffer thread) I/O thread 1 state: native aio handle (log thread) I/O thread 2 state: native aio handle (read thread) I/O thread 3 state: native aio handle (read thread) I/O thread 4 state: native aio handle (read thread) I/O thread 5 state: native aio handle (read thread) I/O thread 6 state: native aio handle (write thread) I/O thread 7 state: native aio handle (write thread) I/O thread 8 state: native aio handle (write thread) I/O thread 9 state: native aio handle (write thread) Pending normal aio reads: [0, 0, 0, 0] , aio writes: [0, 0, 0, 0] , ibuf aio reads:, log i/o's:, sync i/o's: Pending flushes (fsync) log: 1; buffer pool: 0 1497 OS file reads, 1244 OS file writes, 472 OS fsyncs 0.00 reads/s, 0 avg bytes/read, 0.00 writes/s, 0.00 fsyncs/s ------------------------------------- INSERT BUFFER AND ADAPTIVE HASH INDEX ------------------------------------- Ibuf: size 1, free list len 3, seg size 5, 0 merges merged operations: insert 0, delete mark 0, delete 0 discarded operations: insert 0, delete mark 0, delete 0 Hash table size 4441, node heap has 1 buffer(s) Hash table size 4441, node heap has 2 buffer(s) Hash table size 4441, node heap has 0 buffer(s) Hash table size 4441, node heap has 0 buffer(s) Hash table size 4441, node heap has 1 buffer(s) Hash table size 4441, node heap has 1 buffer(s) Hash table size 4441, node heap has 1 buffer(s) Hash table size 4441, node heap has 0 buffer(s) 0.00 hash searches/s, 0.00 non-hash searches/s --- LOG --- Log sequence number 343365292 Log flushed up to 343365224 Pages flushed up to 343364994 Last checkpoint at 343364699 1 pending log flushes, 0 pending chkp writes 358 log i/o's done, 0.00 log i/o's/second ---------------------- BUFFER POOL AND MEMORY ---------------------- Total large memory allocated 33554432 Dictionary memory allocated 399168 Buffer pool size 1002 Free buffers 740 Database pages 256 Old database pages 0 Modified db pages 3 Percent of dirty pages(LRU & free pages): 0.301 Max dirty pages percent: 75.000 Pending reads 0 Pending writes: LRU 0, flush list 3, single page 0 Pages made young 0, not young 0 0.00 youngs/s, 0.00 non-youngs/s Pages read 1317, created 135, written 849 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: 256, 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 Process ID=3492, Main thread ID=3276, state: making checkpoint Number of rows inserted 0, updated 176, deleted 0, read 5086 0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s Number of system rows inserted 0, updated 0, deleted 0, read 0 0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s ---------------------------- END OF INNODB MONITOR OUTPUT ============================ ===================================== 2021-10-07 02:06:15 0xd30 INNODB MONITOR OUTPUT ===================================== Per second averages calculated from the last 20 seconds ----------------- BACKGROUND THREAD ----------------- srv_master_thread loops: 49 srv_active, 0 srv_shutdown, 25376 srv_idle srv_master_thread log flush and writes: 25425 ---------- SEMAPHORES ---------- OS WAIT ARRAY INFO: reservation count 293 --Thread 2520 has waited at row0upd.cc line 3108 for 295.00 seconds the semaphore: X-lock on RW-latch at 000000000EAE3990 created in file buf0buf.cc line 1584 a writer (thread id 0) has reserved it in mode SX number of readers 0, waiters flag 1, lock_word: 10000000 Last time write locked in file buf0flu.cc line 1175 OS WAIT ARRAY INFO: signal count 166 RW-shared spins 0, rounds 131, OS waits 65 RW-excl spins 0, rounds 215, OS waits 7 RW-sx spins 1, rounds 30, OS waits 1 Spin rounds per wait: 131.00 RW-shared, 215.00 RW-excl, 30.00 RW-sx ------------ TRANSACTIONS ------------ Trx id counter 1200460 Purge done for trx's n:o < 1200459 undo n:o < 0 state: running but idle History list length 8 LIST OF TRANSACTIONS FOR EACH SESSION: ---TRANSACTION 1200459, ACTIVE 295 sec updating or deleting mysql tables in use 1, locked 1 2 lock struct(s), heap size 1128, 1 row lock(s) MySQL thread id 37, OS thread handle 2520, query id 534 vtigercrmsale fe80::e98a:dfea:59cd:2924%11 vtigerdb Updating UPDATE vtiger_cron_task SET status=2, laststart=1633564880, lastend=0 WHERE id='3' ---TRANSACTION 281475218542784, not started 0 lock struct(s), heap size 1128, 0 row lock(s) -------- FILE I/O -------- I/O thread 0 state: native aio handle (insert buffer thread) I/O thread 1 state: native aio handle (log thread) I/O thread 2 state: native aio handle (read thread) I/O thread 3 state: native aio handle (read thread) I/O thread 4 state: native aio handle (read thread) I/O thread 5 state: native aio handle (read thread) I/O thread 6 state: native aio handle (write thread) I/O thread 7 state: native aio handle (write thread) I/O thread 8 state: native aio handle (write thread) I/O thread 9 state: native aio handle (write thread) Pending normal aio reads: [0, 0, 0, 0] , aio writes: [0, 0, 0, 0] , ibuf aio reads:, log i/o's:, sync i/o's: Pending flushes (fsync) log: 1; buffer pool: 0 1497 OS file reads, 1244 OS file writes, 472 OS fsyncs 0.00 reads/s, 0 avg bytes/read, 0.00 writes/s, 0.00 fsyncs/s ------------------------------------- INSERT BUFFER AND ADAPTIVE HASH INDEX ------------------------------------- Ibuf: size 1, free list len 3, seg size 5, 0 merges merged operations: insert 0, delete mark 0, delete 0 discarded operations: insert 0, delete mark 0, delete 0 Hash table size 4441, node heap has 1 buffer(s) Hash table size 4441, node heap has 2 buffer(s) Hash table size 4441, node heap has 0 buffer(s) Hash table size 4441, node heap has 0 buffer(s) Hash table size 4441, node heap has 1 buffer(s) Hash table size 4441, node heap has 1 buffer(s) Hash table size 4441, node heap has 1 buffer(s) Hash table size 4441, node heap has 0 buffer(s) 0.00 hash searches/s, 0.00 non-hash searches/s --- LOG --- Log sequence number 343365292 Log flushed up to 343365224 Pages flushed up to 343364994 Last checkpoint at 343364699 1 pending log flushes, 0 pending chkp writes 358 log i/o's done, 0.00 log i/o's/second ---------------------- BUFFER POOL AND MEMORY ---------------------- Total large memory allocated 33554432 Dictionary memory allocated 399168 Buffer pool size 1002 Free buffers 740 Database pages 256 Old database pages 0 Modified db pages 3 Percent of dirty pages(LRU & free pages): 0.301 Max dirty pages percent: 75.000 Pending reads 0 Pending writes: LRU 0, flush list 3, single page 0 Pages made young 0, not young 0 0.00 youngs/s, 0.00 non-youngs/s Pages read 1317, created 135, written 849 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: 256, 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 Process ID=3492, Main thread ID=3276, state: making checkpoint Number of rows inserted 0, updated 176, deleted 0, read 5086 0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s Number of system rows inserted 0, updated 0, deleted 0, read 0 0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s ---------------------------- END OF INNODB MONITOR OUTPUT ============================ InnoDB: ###### Diagnostic info printed to the standard error stream 2021-10-07 2:06:23 0 [Warning] InnoDB: A long semaphore wait: --Thread 2520 has waited at row0upd.cc line 3108 for 303.00 seconds the semaphore: X-lock on RW-latch at 000000000EAE3990 created in file buf0buf.cc line 1584 a writer (thread id 0) has reserved it in mode SX number of readers 0, waiters flag 1, lock_word: 10000000 Last time write locked in file buf0flu.cc line 1175 2021-10-07 2:06:23 0 [Note] InnoDB: A semaphore wait: --Thread 2520 has waited at row0upd.cc line 3108 for 303.00 seconds the semaphore: X-lock on RW-latch at 000000000EAE3990 created in file buf0buf.cc line 1584 a writer (thread id 0) has reserved it in mode SX number of readers 0, waiters flag 1, lock_word: 10000000 Last time write locked in file buf0flu.cc line 1175 InnoDB: ###### Starts InnoDB Monitor for 30 secs to print diagnostic info: InnoDB: Pending reads 0, writes 0 ===================================== 2021-10-07 02:06:35 0xd30 INNODB MONITOR OUTPUT ===================================== Per second averages calculated from the last 20 seconds ----------------- BACKGROUND THREAD ----------------- srv_master_thread loops: 49 srv_active, 0 srv_shutdown, 25376 srv_idle srv_master_thread log flush and writes: 25425 ---------- SEMAPHORES ---------- OS WAIT ARRAY INFO: reservation count 293 --Thread 2520 has waited at row0upd.cc line 3108 for 315.00 seconds the semaphore: X-lock on RW-latch at 000000000EAE3990 created in file buf0buf.cc line 1584 a writer (thread id 0) has reserved it in mode SX number of readers 0, waiters flag 1, lock_word: 10000000 Last time write locked in file buf0flu.cc line 1175 OS WAIT ARRAY INFO: signal count 166 RW-shared spins 0, rounds 131, OS waits 65 RW-excl spins 0, rounds 215, OS waits 7 RW-sx spins 1, rounds 30, OS waits 1 Spin rounds per wait: 131.00 RW-shared, 215.00 RW-excl, 30.00 RW-sx ------------ TRANSACTIONS ------------ Trx id counter 1200460 Purge done for trx's n:o < 1200459 undo n:o < 0 state: running but idle History list length 8 LIST OF TRANSACTIONS FOR EACH SESSION: ---TRANSACTION 1200459, ACTIVE 315 sec updating or deleting mysql tables in use 1, locked 1 2 lock struct(s), heap size 1128, 1 row lock(s) MySQL thread id 37, OS thread handle 2520, query id 534 vtigercrmsale fe80::e98a:dfea:59cd:2924%11 vtigerdb Updating UPDATE vtiger_cron_task SET status=2, laststart=1633564880, lastend=0 WHERE id='3' ---TRANSACTION 281475218542784, not started 0 lock struct(s), heap size 1128, 0 row lock(s) -------- FILE I/O -------- I/O thread 0 state: native aio handle (insert buffer thread) I/O thread 1 state: native aio handle (log thread) I/O thread 2 state: native aio handle (read thread) I/O thread 3 state: native aio handle (read thread) I/O thread 4 state: native aio handle (read thread) I/O thread 5 state: native aio handle (read thread) I/O thread 6 state: native aio handle (write thread) I/O thread 7 state: native aio handle (write thread) I/O thread 8 state: native aio handle (write thread) I/O thread 9 state: native aio handle (write thread) Pending normal aio reads: [0, 0, 0, 0] , aio writes: [0, 0, 0, 0] , ibuf aio reads:, log i/o's:, sync i/o's: Pending flushes (fsync) log: 1; buffer pool: 0 1497 OS file reads, 1244 OS file writes, 472 OS fsyncs 0.00 reads/s, 0 avg bytes/read, 0.00 writes/s, 0.00 fsyncs/s ------------------------------------- INSERT BUFFER AND ADAPTIVE HASH INDEX ------------------------------------- Ibuf: size 1, free list len 3, seg size 5, 0 merges merged operations: insert 0, delete mark 0, delete 0 discarded operations: insert 0, delete mark 0, delete 0 Hash table size 4441, node heap has 1 buffer(s) Hash table size 4441, node heap has 2 buffer(s) Hash table size 4441, node heap has 0 buffer(s) Hash table size 4441, node heap has 0 buffer(s) Hash table size 4441, node heap has 1 buffer(s) Hash table size 4441, node heap has 1 buffer(s) Hash table size 4441, node heap has 1 buffer(s) Hash table size 4441, node heap has 0 buffer(s) 0.00 hash searches/s, 0.00 non-hash searches/s --- LOG --- Log sequence number 343365292 Log flushed up to 343365224 Pages flushed up to 343364994 Last checkpoint at 343364699 1 pending log flushes, 0 pending chkp writes 358 log i/o's done, 0.00 log i/o's/second ---------------------- BUFFER POOL AND MEMORY ---------------------- Total large memory allocated 33554432 Dictionary memory allocated 399168 Buffer pool size 1002 Free buffers 740 Database pages 256 Old database pages 0 Modified db pages 3 Percent of dirty pages(LRU & free pages): 0.301 Max dirty pages percent: 75.000 Pending reads 0 Pending writes: LRU 0, flush list 3, single page 0 Pages made young 0, not young 0 0.00 youngs/s, 0.00 non-youngs/s Pages read 1317, created 135, written 849 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: 256, 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 Process ID=3492, Main thread ID=3276, state: making checkpoint Number of rows inserted 0, updated 176, deleted 0, read 5086 0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s Number of system rows inserted 0, updated 0, deleted 0, read 0 0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s ---------------------------- END OF INNODB MONITOR OUTPUT ============================ InnoDB: ###### Diagnostic info printed to the standard error stream 2021-10-07 2:06:54 0 [Warning] InnoDB: A long semaphore wait: --Thread 2520 has waited at row0upd.cc line 3108 for 334.00 seconds the semaphore: X-lock on RW-latch at 000000000EAE3990 created in file buf0buf.cc line 1584 a writer (thread id 0) has reserved it in mode SX number of readers 0, waiters flag 1, lock_word: 10000000 Last time write locked in file buf0flu.cc line 1175 2021-10-07 2:06:54 0 [Note] InnoDB: A semaphore wait: --Thread 2520 has waited at row0upd.cc line 3108 for 334.00 seconds the semaphore: X-lock on RW-latch at 000000000EAE3990 created in file buf0buf.cc line 1584 a writer (thread id 0) has reserved it in mode SX number of readers 0, waiters flag 1, lock_word: 10000000 Last time write locked in file buf0flu.cc line 1175 InnoDB: ###### Starts InnoDB Monitor for 30 secs to print diagnostic info: InnoDB: Pending reads 0, writes 0 ===================================== 2021-10-07 02:06:55 0xd30 INNODB MONITOR OUTPUT ===================================== Per second averages calculated from the last 20 seconds ----------------- BACKGROUND THREAD ----------------- srv_master_thread loops: 49 srv_active, 0 srv_shutdown, 25376 srv_idle srv_master_thread log flush and writes: 25425 ---------- SEMAPHORES ---------- OS WAIT ARRAY INFO: reservation count 293 --Thread 2520 has waited at row0upd.cc line 3108 for 335.00 seconds the semaphore: X-lock on RW-latch at 000000000EAE3990 created in file buf0buf.cc line 1584 a writer (thread id 0) has reserved it in mode SX number of readers 0, waiters flag 1, lock_word: 10000000 Last time write locked in file buf0flu.cc line 1175 OS WAIT ARRAY INFO: signal count 166 RW-shared spins 0, rounds 131, OS waits 65 RW-excl spins 0, rounds 215, OS waits 7 RW-sx spins 1, rounds 30, OS waits 1 Spin rounds per wait: 131.00 RW-shared, 215.00 RW-excl, 30.00 RW-sx ------------ TRANSACTIONS ------------ Trx id counter 1200460 Purge done for trx's n:o < 1200459 undo n:o < 0 state: running but idle History list length 8 LIST OF TRANSACTIONS FOR EACH SESSION: ---TRANSACTION 1200459, ACTIVE 335 sec updating or deleting mysql tables in use 1, locked 1 2 lock struct(s), heap size 1128, 1 row lock(s) MySQL thread id 37, OS thread handle 2520, query id 534 vtigercrmsale fe80::e98a:dfea:59cd:2924%11 vtigerdb Updating UPDATE vtiger_cron_task SET status=2, laststart=1633564880, lastend=0 WHERE id='3' ---TRANSACTION 281475218542784, not started 0 lock struct(s), heap size 1128, 0 row lock(s) -------- FILE I/O -------- I/O thread 0 state: native aio handle (insert buffer thread) I/O thread 1 state: native aio handle (log thread) I/O thread 2 state: native aio handle (read thread) I/O thread 3 state: native aio handle (read thread) I/O thread 4 state: native aio handle (read thread) I/O thread 5 state: native aio handle (read thread) I/O thread 6 state: native aio handle (write thread) I/O thread 7 state: native aio handle (write thread) I/O thread 8 state: native aio handle (write thread) I/O thread 9 state: native aio handle (write thread) Pending normal aio reads: [0, 0, 0, 0] , aio writes: [0, 0, 0, 0] , ibuf aio reads:, log i/o's:, sync i/o's: Pending flushes (fsync) log: 1; buffer pool: 0 1497 OS file reads, 1244 OS file writes, 472 OS fsyncs 0.00 reads/s, 0 avg bytes/read, 0.00 writes/s, 0.00 fsyncs/s ------------------------------------- INSERT BUFFER AND ADAPTIVE HASH INDEX ------------------------------------- Ibuf: size 1, free list len 3, seg size 5, 0 merges merged operations: insert 0, delete mark 0, delete 0 discarded operations: insert 0, delete mark 0, delete 0 Hash table size 4441, node heap has 1 buffer(s) Hash table size 4441, node heap has 2 buffer(s) Hash table size 4441, node heap has 0 buffer(s) Hash table size 4441, node heap has 0 buffer(s) Hash table size 4441, node heap has 1 buffer(s) Hash table size 4441, node heap has 1 buffer(s) Hash table size 4441, node heap has 1 buffer(s) Hash table size 4441, node heap has 0 buffer(s) 0.00 hash searches/s, 0.00 non-hash searches/s --- LOG --- Log sequence number 343365292 Log flushed up to 343365224 Pages flushed up to 343364994 Last checkpoint at 343364699 1 pending log flushes, 0 pending chkp writes 358 log i/o's done, 0.00 log i/o's/second ---------------------- BUFFER POOL AND MEMORY ---------------------- Total large memory allocated 33554432 Dictionary memory allocated 399168 Buffer pool size 1002 Free buffers 740 Database pages 256 Old database pages 0 Modified db pages 3 Percent of dirty pages(LRU & free pages): 0.301 Max dirty pages percent: 75.000 Pending reads 0 Pending writes: LRU 0, flush list 3, single page 0 Pages made young 0, not young 0 0.00 youngs/s, 0.00 non-youngs/s Pages read 1317, created 135, written 849 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: 256, 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 Process ID=3492, Main thread ID=3276, state: making checkpoint Number of rows inserted 0, updated 176, deleted 0, read 5086 0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s Number of system rows inserted 0, updated 0, deleted 0, read 0 0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s ---------------------------- END OF INNODB MONITOR OUTPUT ============================ ===================================== 2021-10-07 02:07:15 0xd30 INNODB MONITOR OUTPUT ===================================== Per second averages calculated from the last 20 seconds ----------------- BACKGROUND THREAD ----------------- srv_master_thread loops: 49 srv_active, 0 srv_shutdown, 25376 srv_idle srv_master_thread log flush and writes: 25425 ---------- SEMAPHORES ---------- OS WAIT ARRAY INFO: reservation count 293 --Thread 2520 has waited at row0upd.cc line 3108 for 355.00 seconds the semaphore: X-lock on RW-latch at 000000000EAE3990 created in file buf0buf.cc line 1584 a writer (thread id 0) has reserved it in mode SX number of readers 0, waiters flag 1, lock_word: 10000000 Last time write locked in file buf0flu.cc line 1175 OS WAIT ARRAY INFO: signal count 166 RW-shared spins 0, rounds 131, OS waits 65 RW-excl spins 0, rounds 215, OS waits 7 RW-sx spins 1, rounds 30, OS waits 1 Spin rounds per wait: 131.00 RW-shared, 215.00 RW-excl, 30.00 RW-sx ------------ TRANSACTIONS ------------ Trx id counter 1200460 Purge done for trx's n:o < 1200459 undo n:o < 0 state: running but idle History list length 8 LIST OF TRANSACTIONS FOR EACH SESSION: ---TRANSACTION 1200459, ACTIVE 355 sec updating or deleting mysql tables in use 1, locked 1 2 lock struct(s), heap size 1128, 1 row lock(s) MySQL thread id 37, OS thread handle 2520, query id 534 vtigercrmsale fe80::e98a:dfea:59cd:2924%11 vtigerdb Updating UPDATE vtiger_cron_task SET status=2, laststart=1633564880, lastend=0 WHERE id='3' ---TRANSACTION 281475218542784, not started 0 lock struct(s), heap size 1128, 0 row lock(s) -------- FILE I/O -------- I/O thread 0 state: native aio handle (insert buffer thread) I/O thread 1 state: native aio handle (log thread) I/O thread 2 state: native aio handle (read thread) I/O thread 3 state: native aio handle (read thread) I/O thread 4 state: native aio handle (read thread) I/O thread 5 state: native aio handle (read thread) I/O thread 6 state: native aio handle (write thread) I/O thread 7 state: native aio handle (write thread) I/O thread 8 state: native aio handle (write thread) I/O thread 9 state: native aio handle (write thread) Pending normal aio reads: [0, 0, 0, 0] , aio writes: [0, 0, 0, 0] , ibuf aio reads:, log i/o's:, sync i/o's: Pending flushes (fsync) log: 1; buffer pool: 0 1497 OS file reads, 1244 OS file writes, 472 OS fsyncs 0.00 reads/s, 0 avg bytes/read, 0.00 writes/s, 0.00 fsyncs/s ------------------------------------- INSERT BUFFER AND ADAPTIVE HASH INDEX ------------------------------------- Ibuf: size 1, free list len 3, seg size 5, 0 merges merged operations: insert 0, delete mark 0, delete 0 discarded operations: insert 0, delete mark 0, delete 0 Hash table size 4441, node heap has 1 buffer(s) Hash table size 4441, node heap has 2 buffer(s) Hash table size 4441, node heap has 0 buffer(s) Hash table size 4441, node heap has 0 buffer(s) Hash table size 4441, node heap has 1 buffer(s) Hash table size 4441, node heap has 1 buffer(s) Hash table size 4441, node heap has 1 buffer(s) Hash table size 4441, node heap has 0 buffer(s) 0.00 hash searches/s, 0.00 non-hash searches/s --- LOG --- Log sequence number 343365292 Log flushed up to 343365224 Pages flushed up to 343364994 Last checkpoint at 343364699 1 pending log flushes, 0 pending chkp writes 358 log i/o's done, 0.00 log i/o's/second ---------------------- BUFFER POOL AND MEMORY ---------------------- Total large memory allocated 33554432 Dictionary memory allocated 399168 Buffer pool size 1002 Free buffers 740 Database pages 256 Old database pages 0 Modified db pages 3 Percent of dirty pages(LRU & free pages): 0.301 Max dirty pages percent: 75.000 Pending reads 0 Pending writes: LRU 0, flush list 3, single page 0 Pages made young 0, not young 0 0.00 youngs/s, 0.00 non-youngs/s Pages read 1317, created 135, written 849 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: 256, 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 Process ID=3492, Main thread ID=3276, state: making checkpoint Number of rows inserted 0, updated 176, deleted 0, read 5086 0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s Number of system rows inserted 0, updated 0, deleted 0, read 0 0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s ---------------------------- END OF INNODB MONITOR OUTPUT ============================ InnoDB: ###### Diagnostic info printed to the standard error stream 2021-10-07 2:07:25 0 [Warning] InnoDB: A long semaphore wait: --Thread 2520 has waited at row0upd.cc line 3108 for 365.00 seconds the semaphore: X-lock on RW-latch at 000000000EAE3990 created in file buf0buf.cc line 1584 a writer (thread id 0) has reserved it in mode SX number of readers 0, waiters flag 1, lock_word: 10000000 Last time write locked in file buf0flu.cc line 1175 2021-10-07 2:07:25 0 [Note] InnoDB: A semaphore wait: --Thread 2520 has waited at row0upd.cc line 3108 for 365.00 seconds the semaphore: X-lock on RW-latch at 000000000EAE3990 created in file buf0buf.cc line 1584 a writer (thread id 0) has reserved it in mode SX number of readers 0, waiters flag 1, lock_word: 10000000 Last time write locked in file buf0flu.cc line 1175 InnoDB: ###### Starts InnoDB Monitor for 30 secs to print diagnostic info: InnoDB: Pending reads 0, writes 0 ===================================== 2021-10-07 02:07:35 0xd30 INNODB MONITOR OUTPUT ===================================== Per second averages calculated from the last 20 seconds ----------------- BACKGROUND THREAD ----------------- srv_master_thread loops: 49 srv_active, 0 srv_shutdown, 25376 srv_idle srv_master_thread log flush and writes: 25425 ---------- SEMAPHORES ---------- OS WAIT ARRAY INFO: reservation count 293 --Thread 2520 has waited at row0upd.cc line 3108 for 375.00 seconds the semaphore: X-lock on RW-latch at 000000000EAE3990 created in file buf0buf.cc line 1584 a writer (thread id 0) has reserved it in mode SX number of readers 0, waiters flag 1, lock_word: 10000000 Last time write locked in file buf0flu.cc line 1175 OS WAIT ARRAY INFO: signal count 166 RW-shared spins 0, rounds 131, OS waits 65 RW-excl spins 0, rounds 215, OS waits 7 RW-sx spins 1, rounds 30, OS waits 1 Spin rounds per wait: 131.00 RW-shared, 215.00 RW-excl, 30.00 RW-sx ------------ TRANSACTIONS ------------ Trx id counter 1200460 Purge done for trx's n:o < 1200459 undo n:o < 0 state: running but idle History list length 8 LIST OF TRANSACTIONS FOR EACH SESSION: ---TRANSACTION 1200459, ACTIVE 375 sec updating or deleting mysql tables in use 1, locked 1 2 lock struct(s), heap size 1128, 1 row lock(s) MySQL thread id 37, OS thread handle 2520, query id 534 vtigercrmsale fe80::e98a:dfea:59cd:2924%11 vtigerdb Updating UPDATE vtiger_cron_task SET status=2, laststart=1633564880, lastend=0 WHERE id='3' ---TRANSACTION 281475218542784, not started 0 lock struct(s), heap size 1128, 0 row lock(s) -------- FILE I/O -------- I/O thread 0 state: native aio handle (insert buffer thread) I/O thread 1 state: native aio handle (log thread) I/O thread 2 state: native aio handle (read thread) I/O thread 3 state: native aio handle (read thread) I/O thread 4 state: native aio handle (read thread) I/O thread 5 state: native aio handle (read thread) I/O thread 6 state: native aio handle (write thread) I/O thread 7 state: native aio handle (write thread) I/O thread 8 state: native aio handle (write thread) I/O thread 9 state: native aio handle (write thread) Pending normal aio reads: [0, 0, 0, 0] , aio writes: [0, 0, 0, 0] , ibuf aio reads:, log i/o's:, sync i/o's: Pending flushes (fsync) log: 1; buffer pool: 0 1497 OS file reads, 1244 OS file writes, 472 OS fsyncs 0.00 reads/s, 0 avg bytes/read, 0.00 writes/s, 0.00 fsyncs/s ------------------------------------- INSERT BUFFER AND ADAPTIVE HASH INDEX ------------------------------------- Ibuf: size 1, free list len 3, seg size 5, 0 merges merged operations: insert 0, delete mark 0, delete 0 discarded operations: insert 0, delete mark 0, delete 0 Hash table size 4441, node heap has 1 buffer(s) Hash table size 4441, node heap has 2 buffer(s) Hash table size 4441, node heap has 0 buffer(s) Hash table size 4441, node heap has 0 buffer(s) Hash table size 4441, node heap has 1 buffer(s) Hash table size 4441, node heap has 1 buffer(s) Hash table size 4441, node heap has 1 buffer(s) Hash table size 4441, node heap has 0 buffer(s) 0.00 hash searches/s, 0.00 non-hash searches/s --- LOG --- Log sequence number 343365292 Log flushed up to 343365224 Pages flushed up to 343364994 Last checkpoint at 343364699 1 pending log flushes, 0 pending chkp writes 358 log i/o's done, 0.00 log i/o's/second ---------------------- BUFFER POOL AND MEMORY ---------------------- Total large memory allocated 33554432 Dictionary memory allocated 399168 Buffer pool size 1002 Free buffers 740 Database pages 256 Old database pages 0 Modified db pages 3 Percent of dirty pages(LRU & free pages): 0.301 Max dirty pages percent: 75.000 Pending reads 0 Pending writes: LRU 0, flush list 3, single page 0 Pages made young 0, not young 0 0.00 youngs/s, 0.00 non-youngs/s Pages read 1317, created 135, written 849 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: 256, 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 Process ID=3492, Main thread ID=3276, state: making checkpoint Number of rows inserted 0, updated 176, deleted 0, read 5086 0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s Number of system rows inserted 0, updated 0, deleted 0, read 0 0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s ---------------------------- END OF INNODB MONITOR OUTPUT ============================ InnoDB: ###### Diagnostic info printed to the standard error stream 2021-10-07 2:07:56 0 [Warning] InnoDB: A long semaphore wait: --Thread 2520 has waited at row0upd.cc line 3108 for 396.00 seconds the semaphore: X-lock on RW-latch at 000000000EAE3990 created in file buf0buf.cc line 1584 a writer (thread id 0) has reserved it in mode SX number of readers 0, waiters flag 1, lock_word: 10000000 Last time write locked in file buf0flu.cc line 1175 2021-10-07 2:07:56 0 [Note] InnoDB: A semaphore wait: --Thread 2520 has waited at row0upd.cc line 3108 for 396.00 seconds the semaphore: X-lock on RW-latch at 000000000EAE3990 created in file buf0buf.cc line 1584 a writer (thread id 0) has reserved it in mode SX number of readers 0, waiters flag 1, lock_word: 10000000 Last time write locked in file buf0flu.cc line 1175 InnoDB: ###### Starts InnoDB Monitor for 30 secs to print diagnostic info: InnoDB: Pending reads 0, writes 0 ===================================== 2021-10-07 02:08:15 0xd30 INNODB MONITOR OUTPUT ===================================== Per second averages calculated from the last 40 seconds ----------------- BACKGROUND THREAD ----------------- srv_master_thread loops: 49 srv_active, 0 srv_shutdown, 25376 srv_idle srv_master_thread log flush and writes: 25425 ---------- SEMAPHORES ---------- OS WAIT ARRAY INFO: reservation count 293 --Thread 2520 has waited at row0upd.cc line 3108 for 415.00 seconds the semaphore: X-lock on RW-latch at 000000000EAE3990 created in file buf0buf.cc line 1584 a writer (thread id 0) has reserved it in mode SX number of readers 0, waiters flag 1, lock_word: 10000000 Last time write locked in file buf0flu.cc line 1175 OS WAIT ARRAY INFO: signal count 166 RW-shared spins 0, rounds 131, OS waits 65 RW-excl spins 0, rounds 215, OS waits 7 RW-sx spins 1, rounds 30, OS waits 1 Spin rounds per wait: 131.00 RW-shared, 215.00 RW-excl, 30.00 RW-sx ------------ TRANSACTIONS ------------ Trx id counter 1200460 Purge done for trx's n:o < 1200459 undo n:o < 0 state: running but idle History list length 8 LIST OF TRANSACTIONS FOR EACH SESSION: ---TRANSACTION 1200459, ACTIVE 415 sec updating or deleting mysql tables in use 1, locked 1 2 lock struct(s), heap size 1128, 1 row lock(s) MySQL thread id 37, OS thread handle 2520, query id 534 vtigercrmsale fe80::e98a:dfea:59cd:2924%11 vtigerdb Updating UPDATE vtiger_cron_task SET status=2, laststart=1633564880, lastend=0 WHERE id='3' ---TRANSACTION 281475218542784, not started 0 lock struct(s), heap size 1128, 0 row lock(s) -------- FILE I/O -------- I/O thread 0 state: native aio handle (insert buffer thread) I/O thread 1 state: native aio handle (log thread) I/O thread 2 state: native aio handle (read thread) I/O thread 3 state: native aio handle (read thread) I/O thread 4 state: native aio handle (read thread) I/O thread 5 state: native aio handle (read thread) I/O thread 6 state: native aio handle (write thread) I/O thread 7 state: native aio handle (write thread) I/O thread 8 state: native aio handle (write thread) I/O thread 9 state: native aio handle (write thread) Pending normal aio reads: [0, 0, 0, 0] , aio writes: [0, 0, 0, 0] , ibuf aio reads:, log i/o's:, sync i/o's: Pending flushes (fsync) log: 1; buffer pool: 0 1497 OS file reads, 1244 OS file writes, 472 OS fsyncs 0.00 reads/s, 0 avg bytes/read, 0.00 writes/s, 0.00 fsyncs/s ------------------------------------- INSERT BUFFER AND ADAPTIVE HASH INDEX ------------------------------------- Ibuf: size 1, free list len 3, seg size 5, 0 merges merged operations: insert 0, delete mark 0, delete 0 discarded operations: insert 0, delete mark 0, delete 0 Hash table size 4441, node heap has 1 buffer(s) Hash table size 4441, node heap has 2 buffer(s) Hash table size 4441, node heap has 0 buffer(s) Hash table size 4441, node heap has 0 buffer(s) Hash table size 4441, node heap has 1 buffer(s) Hash table size 4441, node heap has 1 buffer(s) Hash table size 4441, node heap has 1 buffer(s) Hash table size 4441, node heap has 0 buffer(s) 0.00 hash searches/s, 0.00 non-hash searches/s --- LOG --- Log sequence number 343365292 Log flushed up to 343365224 Pages flushed up to 343364994 Last checkpoint at 343364699 1 pending log flushes, 0 pending chkp writes 358 log i/o's done, 0.00 log i/o's/second ---------------------- BUFFER POOL AND MEMORY ---------------------- Total large memory allocated 33554432 Dictionary memory allocated 399168 Buffer pool size 1002 Free buffers 740 Database pages 256 Old database pages 0 Modified db pages 3 Percent of dirty pages(LRU & free pages): 0.301 Max dirty pages percent: 75.000 Pending reads 0 Pending writes: LRU 0, flush list 3, single page 0 Pages made young 0, not young 0 0.00 youngs/s, 0.00 non-youngs/s Pages read 1317, created 135, written 849 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: 256, 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 Process ID=3492, Main thread ID=3276, state: making checkpoint Number of rows inserted 0, updated 176, deleted 0, read 5086 0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s Number of system rows inserted 0, updated 0, deleted 0, read 0 0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s ---------------------------- END OF INNODB MONITOR OUTPUT ============================ InnoDB: ###### Diagnostic info printed to the standard error stream 2021-10-07 2:08:27 0 [Warning] InnoDB: A long semaphore wait: --Thread 2520 has waited at row0upd.cc line 3108 for 427.00 seconds the semaphore: X-lock on RW-latch at 000000000EAE3990 created in file buf0buf.cc line 1584 a writer (thread id 0) has reserved it in mode SX number of readers 0, waiters flag 1, lock_word: 10000000 Last time write locked in file buf0flu.cc line 1175 2021-10-07 2:08:27 0 [Note] InnoDB: A semaphore wait: --Thread 2520 has waited at row0upd.cc line 3108 for 427.00 seconds the semaphore: X-lock on RW-latch at 000000000EAE3990 created in file buf0buf.cc line 1584 a writer (thread id 0) has reserved it in mode SX number of readers 0, waiters flag 1, lock_word: 10000000 Last time write locked in file buf0flu.cc line 1175 InnoDB: ###### Starts InnoDB Monitor for 30 secs to print diagnostic info: InnoDB: Pending reads 0, writes 0 ===================================== 2021-10-07 02:08:35 0xd30 INNODB MONITOR OUTPUT ===================================== Per second averages calculated from the last 20 seconds ----------------- BACKGROUND THREAD ----------------- srv_master_thread loops: 49 srv_active, 0 srv_shutdown, 25376 srv_idle srv_master_thread log flush and writes: 25425 ---------- SEMAPHORES ---------- OS WAIT ARRAY INFO: reservation count 293 --Thread 2520 has waited at row0upd.cc line 3108 for 435.00 seconds the semaphore: X-lock on RW-latch at 000000000EAE3990 created in file buf0buf.cc line 1584 a writer (thread id 0) has reserved it in mode SX number of readers 0, waiters flag 1, lock_word: 10000000 Last time write locked in file buf0flu.cc line 1175 OS WAIT ARRAY INFO: signal count 166 RW-shared spins 0, rounds 131, OS waits 65 RW-excl spins 0, rounds 215, OS waits 7 RW-sx spins 1, rounds 30, OS waits 1 Spin rounds per wait: 131.00 RW-shared, 215.00 RW-excl, 30.00 RW-sx ------------ TRANSACTIONS ------------ Trx id counter 1200460 Purge done for trx's n:o < 1200459 undo n:o < 0 state: running but idle History list length 8 LIST OF TRANSACTIONS FOR EACH SESSION: ---TRANSACTION 1200459, ACTIVE 435 sec updating or deleting mysql tables in use 1, locked 1 2 lock struct(s), heap size 1128, 1 row lock(s) MySQL thread id 37, OS thread handle 2520, query id 534 vtigercrmsale fe80::e98a:dfea:59cd:2924%11 vtigerdb Updating UPDATE vtiger_cron_task SET status=2, laststart=1633564880, lastend=0 WHERE id='3' ---TRANSACTION 281475218542784, not started 0 lock struct(s), heap size 1128, 0 row lock(s) -------- FILE I/O -------- I/O thread 0 state: native aio handle (insert buffer thread) I/O thread 1 state: native aio handle (log thread) I/O thread 2 state: native aio handle (read thread) I/O thread 3 state: native aio handle (read thread) I/O thread 4 state: native aio handle (read thread) I/O thread 5 state: native aio handle (read thread) I/O thread 6 state: native aio handle (write thread) I/O thread 7 state: native aio handle (write thread) I/O thread 8 state: native aio handle (write thread) I/O thread 9 state: native aio handle (write thread) Pending normal aio reads: [0, 0, 0, 0] , aio writes: [0, 0, 0, 0] , ibuf aio reads:, log i/o's:, sync i/o's: Pending flushes (fsync) log: 1; buffer pool: 0 1497 OS file reads, 1244 OS file writes, 472 OS fsyncs 0.00 reads/s, 0 avg bytes/read, 0.00 writes/s, 0.00 fsyncs/s ------------------------------------- INSERT BUFFER AND ADAPTIVE HASH INDEX ------------------------------------- Ibuf: size 1, free list len 3, seg size 5, 0 merges merged operations: insert 0, delete mark 0, delete 0 discarded operations: insert 0, delete mark 0, delete 0 Hash table size 4441, node heap has 1 buffer(s) Hash table size 4441, node heap has 2 buffer(s) Hash table size 4441, node heap has 0 buffer(s) Hash table size 4441, node heap has 0 buffer(s) Hash table size 4441, node heap has 1 buffer(s) Hash table size 4441, node heap has 1 buffer(s) Hash table size 4441, node heap has 1 buffer(s) Hash table size 4441, node heap has 0 buffer(s) 0.00 hash searches/s, 0.00 non-hash searches/s --- LOG --- Log sequence number 343365292 Log flushed up to 343365224 Pages flushed up to 343364994 Last checkpoint at 343364699 1 pending log flushes, 0 pending chkp writes 358 log i/o's done, 0.00 log i/o's/second ---------------------- BUFFER POOL AND MEMORY ---------------------- Total large memory allocated 33554432 Dictionary memory allocated 399168 Buffer pool size 1002 Free buffers 740 Database pages 256 Old database pages 0 Modified db pages 3 Percent of dirty pages(LRU & free pages): 0.301 Max dirty pages percent: 75.000 Pending reads 0 Pending writes: LRU 0, flush list 3, single page 0 Pages made young 0, not young 0 0.00 youngs/s, 0.00 non-youngs/s Pages read 1317, created 135, written 849 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: 256, 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 Process ID=3492, Main thread ID=3276, state: making checkpoint Number of rows inserted 0, updated 176, deleted 0, read 5086 0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s Number of system rows inserted 0, updated 0, deleted 0, read 0 0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s ---------------------------- END OF INNODB MONITOR OUTPUT ============================ ===================================== 2021-10-07 02:08:55 0xd30 INNODB MONITOR OUTPUT ===================================== Per second averages calculated from the last 20 seconds ----------------- BACKGROUND THREAD ----------------- srv_master_thread loops: 49 srv_active, 0 srv_shutdown, 25376 srv_idle srv_master_thread log flush and writes: 25425 ---------- SEMAPHORES ---------- OS WAIT ARRAY INFO: reservation count 293 --Thread 2520 has waited at row0upd.cc line 3108 for 455.00 seconds the semaphore: X-lock on RW-latch at 000000000EAE3990 created in file buf0buf.cc line 1584 a writer (thread id 0) has reserved it in mode SX number of readers 0, waiters flag 1, lock_word: 10000000 Last time write locked in file buf0flu.cc line 1175 OS WAIT ARRAY INFO: signal count 166 RW-shared spins 0, rounds 131, OS waits 65 RW-excl spins 0, rounds 215, OS waits 7 RW-sx spins 1, rounds 30, OS waits 1 Spin rounds per wait: 131.00 RW-shared, 215.00 RW-excl, 30.00 RW-sx ------------ TRANSACTIONS ------------ Trx id counter 1200460 Purge done for trx's n:o < 1200459 undo n:o < 0 state: running but idle History list length 8 LIST OF TRANSACTIONS FOR EACH SESSION: ---TRANSACTION 1200459, ACTIVE 455 sec updating or deleting mysql tables in use 1, locked 1 2 lock struct(s), heap size 1128, 1 row lock(s) MySQL thread id 37, OS thread handle 2520, query id 534 vtigercrmsale fe80::e98a:dfea:59cd:2924%11 vtigerdb Updating UPDATE vtiger_cron_task SET status=2, laststart=1633564880, lastend=0 WHERE id='3' ---TRANSACTION 281475218542784, not started 0 lock struct(s), heap size 1128, 0 row lock(s) -------- FILE I/O -------- I/O thread 0 state: native aio handle (insert buffer thread) I/O thread 1 state: native aio handle (log thread) I/O thread 2 state: native aio handle (read thread) I/O thread 3 state: native aio handle (read thread) I/O thread 4 state: native aio handle (read thread) I/O thread 5 state: native aio handle (read thread) I/O thread 6 state: native aio handle (write thread) I/O thread 7 state: native aio handle (write thread) I/O thread 8 state: native aio handle (write thread) I/O thread 9 state: native aio handle (write thread) Pending normal aio reads: [0, 0, 0, 0] , aio writes: [0, 0, 0, 0] , ibuf aio reads:, log i/o's:, sync i/o's: Pending flushes (fsync) log: 1; buffer pool: 0 1497 OS file reads, 1244 OS file writes, 472 OS fsyncs 0.00 reads/s, 0 avg bytes/read, 0.00 writes/s, 0.00 fsyncs/s ------------------------------------- INSERT BUFFER AND ADAPTIVE HASH INDEX ------------------------------------- Ibuf: size 1, free list len 3, seg size 5, 0 merges merged operations: insert 0, delete mark 0, delete 0 discarded operations: insert 0, delete mark 0, delete 0 Hash table size 4441, node heap has 1 buffer(s) Hash table size 4441, node heap has 2 buffer(s) Hash table size 4441, node heap has 0 buffer(s) Hash table size 4441, node heap has 0 buffer(s) Hash table size 4441, node heap has 1 buffer(s) Hash table size 4441, node heap has 1 buffer(s) Hash table size 4441, node heap has 1 buffer(s) Hash table size 4441, node heap has 0 buffer(s) 0.00 hash searches/s, 0.00 non-hash searches/s --- LOG --- Log sequence number 343365292 Log flushed up to 343365224 Pages flushed up to 343364994 Last checkpoint at 343364699 1 pending log flushes, 0 pending chkp writes 358 log i/o's done, 0.00 log i/o's/second ---------------------- BUFFER POOL AND MEMORY ---------------------- Total large memory allocated 33554432 Dictionary memory allocated 399168 Buffer pool size 1002 Free buffers 740 Database pages 256 Old database pages 0 Modified db pages 3 Percent of dirty pages(LRU & free pages): 0.301 Max dirty pages percent: 75.000 Pending reads 0 Pending writes: LRU 0, flush list 3, single page 0 Pages made young 0, not young 0 0.00 youngs/s, 0.00 non-youngs/s Pages read 1317, created 135, written 849 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: 256, 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 Process ID=3492, Main thread ID=3276, state: making checkpoint Number of rows inserted 0, updated 176, deleted 0, read 5086 0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s Number of system rows inserted 0, updated 0, deleted 0, read 0 0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s ---------------------------- END OF INNODB MONITOR OUTPUT ============================ InnoDB: ###### Diagnostic info printed to the standard error stream 2021-10-07 2:08:58 0 [Warning] InnoDB: A long semaphore wait: --Thread 2520 has waited at row0upd.cc line 3108 for 458.00 seconds the semaphore: X-lock on RW-latch at 000000000EAE3990 created in file buf0buf.cc line 1584 a writer (thread id 0) has reserved it in mode SX number of readers 0, waiters flag 1, lock_word: 10000000 Last time write locked in file buf0flu.cc line 1175 2021-10-07 2:08:58 0 [Note] InnoDB: A semaphore wait: --Thread 2520 has waited at row0upd.cc line 3108 for 458.00 seconds the semaphore: X-lock on RW-latch at 000000000EAE3990 created in file buf0buf.cc line 1584 a writer (thread id 0) has reserved it in mode SX number of readers 0, waiters flag 1, lock_word: 10000000 Last time write locked in file buf0flu.cc line 1175 InnoDB: ###### Starts InnoDB Monitor for 30 secs to print diagnostic info: InnoDB: Pending reads 0, writes 0 ===================================== 2021-10-07 02:09:15 0xd30 INNODB MONITOR OUTPUT ===================================== Per second averages calculated from the last 20 seconds ----------------- BACKGROUND THREAD ----------------- srv_master_thread loops: 49 srv_active, 0 srv_shutdown, 25376 srv_idle srv_master_thread log flush and writes: 25425 ---------- SEMAPHORES ---------- OS WAIT ARRAY INFO: reservation count 293 --Thread 2520 has waited at row0upd.cc line 3108 for 475.00 seconds the semaphore: X-lock on RW-latch at 000000000EAE3990 created in file buf0buf.cc line 1584 a writer (thread id 0) has reserved it in mode SX number of readers 0, waiters flag 1, lock_word: 10000000 Last time write locked in file buf0flu.cc line 1175 OS WAIT ARRAY INFO: signal count 166 RW-shared spins 0, rounds 131, OS waits 65 RW-excl spins 0, rounds 215, OS waits 7 RW-sx spins 1, rounds 30, OS waits 1 Spin rounds per wait: 131.00 RW-shared, 215.00 RW-excl, 30.00 RW-sx ------------ TRANSACTIONS ------------ Trx id counter 1200460 Purge done for trx's n:o < 1200459 undo n:o < 0 state: running but idle History list length 8 LIST OF TRANSACTIONS FOR EACH SESSION: ---TRANSACTION 1200459, ACTIVE 475 sec updating or deleting mysql tables in use 1, locked 1 2 lock struct(s), heap size 1128, 1 row lock(s) MySQL thread id 37, OS thread handle 2520, query id 534 vtigercrmsale fe80::e98a:dfea:59cd:2924%11 vtigerdb Updating UPDATE vtiger_cron_task SET status=2, laststart=1633564880, lastend=0 WHERE id='3' ---TRANSACTION 281475218542784, not started 0 lock struct(s), heap size 1128, 0 row lock(s) -------- FILE I/O -------- I/O thread 0 state: native aio handle (insert buffer thread) I/O thread 1 state: native aio handle (log thread) I/O thread 2 state: native aio handle (read thread) I/O thread 3 state: native aio handle (read thread) I/O thread 4 state: native aio handle (read thread) I/O thread 5 state: native aio handle (read thread) I/O thread 6 state: native aio handle (write thread) I/O thread 7 state: native aio handle (write thread) I/O thread 8 state: native aio handle (write thread) I/O thread 9 state: native aio handle (write thread) Pending normal aio reads: [0, 0, 0, 0] , aio writes: [0, 0, 0, 0] , ibuf aio reads:, log i/o's:, sync i/o's: Pending flushes (fsync) log: 1; buffer pool: 0 1497 OS file reads, 1244 OS file writes, 472 OS fsyncs 0.00 reads/s, 0 avg bytes/read, 0.00 writes/s, 0.00 fsyncs/s ------------------------------------- INSERT BUFFER AND ADAPTIVE HASH INDEX ------------------------------------- Ibuf: size 1, free list len 3, seg size 5, 0 merges merged operations: insert 0, delete mark 0, delete 0 discarded operations: insert 0, delete mark 0, delete 0 Hash table size 4441, node heap has 1 buffer(s) Hash table size 4441, node heap has 2 buffer(s) Hash table size 4441, node heap has 0 buffer(s) Hash table size 4441, node heap has 0 buffer(s) Hash table size 4441, node heap has 1 buffer(s) Hash table size 4441, node heap has 1 buffer(s) Hash table size 4441, node heap has 1 buffer(s) Hash table size 4441, node heap has 0 buffer(s) 0.00 hash searches/s, 0.00 non-hash searches/s --- LOG --- Log sequence number 343365292 Log flushed up to 343365224 Pages flushed up to 343364994 Last checkpoint at 343364699 1 pending log flushes, 0 pending chkp writes 358 log i/o's done, 0.00 log i/o's/second ---------------------- BUFFER POOL AND MEMORY ---------------------- Total large memory allocated 33554432 Dictionary memory allocated 399168 Buffer pool size 1002 Free buffers 740 Database pages 256 Old database pages 0 Modified db pages 3 Percent of dirty pages(LRU & free pages): 0.301 Max dirty pages percent: 75.000 Pending reads 0 Pending writes: LRU 0, flush list 3, single page 0 Pages made young 0, not young 0 0.00 youngs/s, 0.00 non-youngs/s Pages read 1317, created 135, written 849 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: 256, 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 Process ID=3492, Main thread ID=3276, state: making checkpoint Number of rows inserted 0, updated 176, deleted 0, read 5086 0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s Number of system rows inserted 0, updated 0, deleted 0, read 0 0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s ---------------------------- END OF INNODB MONITOR OUTPUT ============================ InnoDB: ###### Diagnostic info printed to the standard error stream 2021-10-07 2:09:29 0 [Warning] InnoDB: A long semaphore wait: --Thread 2520 has waited at row0upd.cc line 3108 for 489.00 seconds the semaphore: X-lock on RW-latch at 000000000EAE3990 created in file buf0buf.cc line 1584 a writer (thread id 0) has reserved it in mode SX number of readers 0, waiters flag 1, lock_word: 10000000 Last time write locked in file buf0flu.cc line 1175 2021-10-07 2:09:29 0 [Note] InnoDB: A semaphore wait: --Thread 2520 has waited at row0upd.cc line 3108 for 489.00 seconds the semaphore: X-lock on RW-latch at 000000000EAE3990 created in file buf0buf.cc line 1584 a writer (thread id 0) has reserved it in mode SX number of readers 0, waiters flag 1, lock_word: 10000000 Last time write locked in file buf0flu.cc line 1175 InnoDB: ###### Starts InnoDB Monitor for 30 secs to print diagnostic info: InnoDB: Pending reads 0, writes 0 ===================================== 2021-10-07 02:09:35 0xd30 INNODB MONITOR OUTPUT ===================================== Per second averages calculated from the last 20 seconds ----------------- BACKGROUND THREAD ----------------- srv_master_thread loops: 49 srv_active, 0 srv_shutdown, 25376 srv_idle srv_master_thread log flush and writes: 25425 ---------- SEMAPHORES ---------- OS WAIT ARRAY INFO: reservation count 293 --Thread 2520 has waited at row0upd.cc line 3108 for 495.00 seconds the semaphore: X-lock on RW-latch at 000000000EAE3990 created in file buf0buf.cc line 1584 a writer (thread id 0) has reserved it in mode SX number of readers 0, waiters flag 1, lock_word: 10000000 Last time write locked in file buf0flu.cc line 1175 OS WAIT ARRAY INFO: signal count 166 RW-shared spins 0, rounds 131, OS waits 65 RW-excl spins 0, rounds 215, OS waits 7 RW-sx spins 1, rounds 30, OS waits 1 Spin rounds per wait: 131.00 RW-shared, 215.00 RW-excl, 30.00 RW-sx ------------ TRANSACTIONS ------------ Trx id counter 1200460 Purge done for trx's n:o < 1200459 undo n:o < 0 state: running but idle History list length 8 LIST OF TRANSACTIONS FOR EACH SESSION: ---TRANSACTION 1200459, ACTIVE 495 sec updating or deleting mysql tables in use 1, locked 1 2 lock struct(s), heap size 1128, 1 row lock(s) MySQL thread id 37, OS thread handle 2520, query id 534 vtigercrmsale fe80::e98a:dfea:59cd:2924%11 vtigerdb Updating UPDATE vtiger_cron_task SET status=2, laststart=1633564880, lastend=0 WHERE id='3' ---TRANSACTION 281475218542784, not started 0 lock struct(s), heap size 1128, 0 row lock(s) -------- FILE I/O -------- I/O thread 0 state: native aio handle (insert buffer thread) I/O thread 1 state: native aio handle (log thread) I/O thread 2 state: native aio handle (read thread) I/O thread 3 state: native aio handle (read thread) I/O thread 4 state: native aio handle (read thread) I/O thread 5 state: native aio handle (read thread) I/O thread 6 state: native aio handle (write thread) I/O thread 7 state: native aio handle (write thread) I/O thread 8 state: native aio handle (write thread) I/O thread 9 state: native aio handle (write thread) Pending normal aio reads: [0, 0, 0, 0] , aio writes: [0, 0, 0, 0] , ibuf aio reads:, log i/o's:, sync i/o's: Pending flushes (fsync) log: 1; buffer pool: 0 1497 OS file reads, 1244 OS file writes, 472 OS fsyncs 0.00 reads/s, 0 avg bytes/read, 0.00 writes/s, 0.00 fsyncs/s ------------------------------------- INSERT BUFFER AND ADAPTIVE HASH INDEX ------------------------------------- Ibuf: size 1, free list len 3, seg size 5, 0 merges merged operations: insert 0, delete mark 0, delete 0 discarded operations: insert 0, delete mark 0, delete 0 Hash table size 4441, node heap has 1 buffer(s) Hash table size 4441, node heap has 2 buffer(s) Hash table size 4441, node heap has 0 buffer(s) Hash table size 4441, node heap has 0 buffer(s) Hash table size 4441, node heap has 1 buffer(s) Hash table size 4441, node heap has 1 buffer(s) Hash table size 4441, node heap has 1 buffer(s) Hash table size 4441, node heap has 0 buffer(s) 0.00 hash searches/s, 0.00 non-hash searches/s --- LOG --- Log sequence number 343365292 Log flushed up to 343365224 Pages flushed up to 343364994 Last checkpoint at 343364699 1 pending log flushes, 0 pending chkp writes 358 log i/o's done, 0.00 log i/o's/second ---------------------- BUFFER POOL AND MEMORY ---------------------- Total large memory allocated 33554432 Dictionary memory allocated 399168 Buffer pool size 1002 Free buffers 740 Database pages 256 Old database pages 0 Modified db pages 3 Percent of dirty pages(LRU & free pages): 0.301 Max dirty pages percent: 75.000 Pending reads 0 Pending writes: LRU 0, flush list 3, single page 0 Pages made young 0, not young 0 0.00 youngs/s, 0.00 non-youngs/s Pages read 1317, created 135, written 849 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: 256, 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 Process ID=3492, Main thread ID=3276, state: making checkpoint Number of rows inserted 0, updated 176, deleted 0, read 5086 0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s Number of system rows inserted 0, updated 0, deleted 0, read 0 0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s ---------------------------- END OF INNODB MONITOR OUTPUT ============================ ===================================== 2021-10-07 02:09:55 0xd30 INNODB MONITOR OUTPUT ===================================== Per second averages calculated from the last 20 seconds ----------------- BACKGROUND THREAD ----------------- srv_master_thread loops: 49 srv_active, 0 srv_shutdown, 25376 srv_idle srv_master_thread log flush and writes: 25425 ---------- SEMAPHORES ---------- OS WAIT ARRAY INFO: reservation count 293 --Thread 2520 has waited at row0upd.cc line 3108 for 515.00 seconds the semaphore: X-lock on RW-latch at 000000000EAE3990 created in file buf0buf.cc line 1584 a writer (thread id 0) has reserved it in mode SX number of readers 0, waiters flag 1, lock_word: 10000000 Last time write locked in file buf0flu.cc line 1175 OS WAIT ARRAY INFO: signal count 166 RW-shared spins 0, rounds 131, OS waits 65 RW-excl spins 0, rounds 215, OS waits 7 RW-sx spins 1, rounds 30, OS waits 1 Spin rounds per wait: 131.00 RW-shared, 215.00 RW-excl, 30.00 RW-sx ------------ TRANSACTIONS ------------ Trx id counter 1200460 Purge done for trx's n:o < 1200459 undo n:o < 0 state: running but idle History list length 8 LIST OF TRANSACTIONS FOR EACH SESSION: ---TRANSACTION 1200459, ACTIVE 515 sec updating or deleting mysql tables in use 1, locked 1 2 lock struct(s), heap size 1128, 1 row lock(s) MySQL thread id 37, OS thread handle 2520, query id 534 vtigercrmsale fe80::e98a:dfea:59cd:2924%11 vtigerdb Updating UPDATE vtiger_cron_task SET status=2, laststart=1633564880, lastend=0 WHERE id='3' ---TRANSACTION 281475218542784, not started 0 lock struct(s), heap size 1128, 0 row lock(s) -------- FILE I/O -------- I/O thread 0 state: native aio handle (insert buffer thread) I/O thread 1 state: native aio handle (log thread) I/O thread 2 state: native aio handle (read thread) I/O thread 3 state: native aio handle (read thread) I/O thread 4 state: native aio handle (read thread) I/O thread 5 state: native aio handle (read thread) I/O thread 6 state: native aio handle (write thread) I/O thread 7 state: native aio handle (write thread) I/O thread 8 state: native aio handle (write thread) I/O thread 9 state: native aio handle (write thread) Pending normal aio reads: [0, 0, 0, 0] , aio writes: [0, 0, 0, 0] , ibuf aio reads:, log i/o's:, sync i/o's: Pending flushes (fsync) log: 1; buffer pool: 0 1497 OS file reads, 1244 OS file writes, 472 OS fsyncs 0.00 reads/s, 0 avg bytes/read, 0.00 writes/s, 0.00 fsyncs/s ------------------------------------- INSERT BUFFER AND ADAPTIVE HASH INDEX ------------------------------------- Ibuf: size 1, free list len 3, seg size 5, 0 merges merged operations: insert 0, delete mark 0, delete 0 discarded operations: insert 0, delete mark 0, delete 0 Hash table size 4441, node heap has 1 buffer(s) Hash table size 4441, node heap has 2 buffer(s) Hash table size 4441, node heap has 0 buffer(s) Hash table size 4441, node heap has 0 buffer(s) Hash table size 4441, node heap has 1 buffer(s) Hash table size 4441, node heap has 1 buffer(s) Hash table size 4441, node heap has 1 buffer(s) Hash table size 4441, node heap has 0 buffer(s) 0.00 hash searches/s, 0.00 non-hash searches/s --- LOG --- Log sequence number 343365292 Log flushed up to 343365224 Pages flushed up to 343364994 Last checkpoint at 343364699 1 pending log flushes, 0 pending chkp writes 358 log i/o's done, 0.00 log i/o's/second ---------------------- BUFFER POOL AND MEMORY ---------------------- Total large memory allocated 33554432 Dictionary memory allocated 399168 Buffer pool size 1002 Free buffers 740 Database pages 256 Old database pages 0 Modified db pages 3 Percent of dirty pages(LRU & free pages): 0.301 Max dirty pages percent: 75.000 Pending reads 0 Pending writes: LRU 0, flush list 3, single page 0 Pages made young 0, not young 0 0.00 youngs/s, 0.00 non-youngs/s Pages read 1317, created 135, written 849 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: 256, 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 Process ID=3492, Main thread ID=3276, state: making checkpoint Number of rows inserted 0, updated 176, deleted 0, read 5086 0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s Number of system rows inserted 0, updated 0, deleted 0, read 0 0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s ---------------------------- END OF INNODB MONITOR OUTPUT ============================ InnoDB: ###### Diagnostic info printed to the standard error stream 2021-10-07 2:10:00 0 [Warning] InnoDB: A long semaphore wait: --Thread 2520 has waited at row0upd.cc line 3108 for 520.00 seconds the semaphore: X-lock on RW-latch at 000000000EAE3990 created in file buf0buf.cc line 1584 a writer (thread id 0) has reserved it in mode SX number of readers 0, waiters flag 1, lock_word: 10000000 Last time write locked in file buf0flu.cc line 1175 2021-10-07 2:10:00 0 [Note] InnoDB: A semaphore wait: --Thread 2520 has waited at row0upd.cc line 3108 for 520.00 seconds the semaphore: X-lock on RW-latch at 000000000EAE3990 created in file buf0buf.cc line 1584 a writer (thread id 0) has reserved it in mode SX number of readers 0, waiters flag 1, lock_word: 10000000 Last time write locked in file buf0flu.cc line 1175 InnoDB: ###### Starts InnoDB Monitor for 30 secs to print diagnostic info: InnoDB: Pending reads 0, writes 0 ===================================== 2021-10-07 02:10:15 0xd30 INNODB MONITOR OUTPUT ===================================== Per second averages calculated from the last 20 seconds ----------------- BACKGROUND THREAD ----------------- srv_master_thread loops: 49 srv_active, 0 srv_shutdown, 25376 srv_idle srv_master_thread log flush and writes: 25425 ---------- SEMAPHORES ---------- OS WAIT ARRAY INFO: reservation count 293 --Thread 2520 has waited at row0upd.cc line 3108 for 535.00 seconds the semaphore: X-lock on RW-latch at 000000000EAE3990 created in file buf0buf.cc line 1584 a writer (thread id 0) has reserved it in mode SX number of readers 0, waiters flag 1, lock_word: 10000000 Last time write locked in file buf0flu.cc line 1175 OS WAIT ARRAY INFO: signal count 166 RW-shared spins 0, rounds 131, OS waits 65 RW-excl spins 0, rounds 215, OS waits 7 RW-sx spins 1, rounds 30, OS waits 1 Spin rounds per wait: 131.00 RW-shared, 215.00 RW-excl, 30.00 RW-sx ------------ TRANSACTIONS ------------ Trx id counter 1200460 Purge done for trx's n:o < 1200459 undo n:o < 0 state: running but idle History list length 8 LIST OF TRANSACTIONS FOR EACH SESSION: ---TRANSACTION 1200459, ACTIVE 535 sec updating or deleting mysql tables in use 1, locked 1 2 lock struct(s), heap size 1128, 1 row lock(s) MySQL thread id 37, OS thread handle 2520, query id 534 vtigercrmsale fe80::e98a:dfea:59cd:2924%11 vtigerdb Updating UPDATE vtiger_cron_task SET status=2, laststart=1633564880, lastend=0 WHERE id='3' ---TRANSACTION 281475218542784, not started 0 lock struct(s), heap size 1128, 0 row lock(s) -------- FILE I/O -------- I/O thread 0 state: native aio handle (insert buffer thread) I/O thread 1 state: native aio handle (log thread) I/O thread 2 state: native aio handle (read thread) I/O thread 3 state: native aio handle (read thread) I/O thread 4 state: native aio handle (read thread) I/O thread 5 state: native aio handle (read thread) I/O thread 6 state: native aio handle (write thread) I/O thread 7 state: native aio handle (write thread) I/O thread 8 state: native aio handle (write thread) I/O thread 9 state: native aio handle (write thread) Pending normal aio reads: [0, 0, 0, 0] , aio writes: [0, 0, 0, 0] , ibuf aio reads:, log i/o's:, sync i/o's: Pending flushes (fsync) log: 1; buffer pool: 0 1497 OS file reads, 1244 OS file writes, 472 OS fsyncs 0.00 reads/s, 0 avg bytes/read, 0.00 writes/s, 0.00 fsyncs/s ------------------------------------- INSERT BUFFER AND ADAPTIVE HASH INDEX ------------------------------------- Ibuf: size 1, free list len 3, seg size 5, 0 merges merged operations: insert 0, delete mark 0, delete 0 discarded operations: insert 0, delete mark 0, delete 0 Hash table size 4441, node heap has 1 buffer(s) Hash table size 4441, node heap has 2 buffer(s) Hash table size 4441, node heap has 0 buffer(s) Hash table size 4441, node heap has 0 buffer(s) Hash table size 4441, node heap has 1 buffer(s) Hash table size 4441, node heap has 1 buffer(s) Hash table size 4441, node heap has 1 buffer(s) Hash table size 4441, node heap has 0 buffer(s) 0.00 hash searches/s, 0.00 non-hash searches/s --- LOG --- Log sequence number 343365292 Log flushed up to 343365224 Pages flushed up to 343364994 Last checkpoint at 343364699 1 pending log flushes, 0 pending chkp writes 358 log i/o's done, 0.00 log i/o's/second ---------------------- BUFFER POOL AND MEMORY ---------------------- Total large memory allocated 33554432 Dictionary memory allocated 399168 Buffer pool size 1002 Free buffers 740 Database pages 256 Old database pages 0 Modified db pages 3 Percent of dirty pages(LRU & free pages): 0.301 Max dirty pages percent: 75.000 Pending reads 0 Pending writes: LRU 0, flush list 3, single page 0 Pages made young 0, not young 0 0.00 youngs/s, 0.00 non-youngs/s Pages read 1317, created 135, written 849 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: 256, 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 Process ID=3492, Main thread ID=3276, state: making checkpoint Number of rows inserted 0, updated 176, deleted 0, read 5086 0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s Number of system rows inserted 0, updated 0, deleted 0, read 0 0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s ---------------------------- END OF INNODB MONITOR OUTPUT ============================ InnoDB: ###### Diagnostic info printed to the standard error stream 2021-10-07 2:10:31 0 [Warning] InnoDB: A long semaphore wait: --Thread 2520 has waited at row0upd.cc line 3108 for 551.00 seconds the semaphore: X-lock on RW-latch at 000000000EAE3990 created in file buf0buf.cc line 1584 a writer (thread id 0) has reserved it in mode SX number of readers 0, waiters flag 1, lock_word: 10000000 Last time write locked in file buf0flu.cc line 1175 2021-10-07 2:10:31 0 [Note] InnoDB: A semaphore wait: --Thread 2520 has waited at row0upd.cc line 3108 for 551.00 seconds the semaphore: X-lock on RW-latch at 000000000EAE3990 created in file buf0buf.cc line 1584 a writer (thread id 0) has reserved it in mode SX number of readers 0, waiters flag 1, lock_word: 10000000 Last time write locked in file buf0flu.cc line 1175 InnoDB: ###### Starts InnoDB Monitor for 30 secs to print diagnostic info: InnoDB: Pending reads 0, writes 0 ===================================== 2021-10-07 02:10:35 0xd30 INNODB MONITOR OUTPUT ===================================== Per second averages calculated from the last 20 seconds ----------------- BACKGROUND THREAD ----------------- srv_master_thread loops: 49 srv_active, 0 srv_shutdown, 25376 srv_idle srv_master_thread log flush and writes: 25425 ---------- SEMAPHORES ---------- OS WAIT ARRAY INFO: reservation count 293 --Thread 2520 has waited at row0upd.cc line 3108 for 555.00 seconds the semaphore: X-lock on RW-latch at 000000000EAE3990 created in file buf0buf.cc line 1584 a writer (thread id 0) has reserved it in mode SX number of readers 0, waiters flag 1, lock_word: 10000000 Last time write locked in file buf0flu.cc line 1175 OS WAIT ARRAY INFO: signal count 166 RW-shared spins 0, rounds 131, OS waits 65 RW-excl spins 0, rounds 215, OS waits 7 RW-sx spins 1, rounds 30, OS waits 1 Spin rounds per wait: 131.00 RW-shared, 215.00 RW-excl, 30.00 RW-sx ------------ TRANSACTIONS ------------ Trx id counter 1200460 Purge done for trx's n:o < 1200459 undo n:o < 0 state: running but idle History list length 8 LIST OF TRANSACTIONS FOR EACH SESSION: ---TRANSACTION 1200459, ACTIVE 555 sec updating or deleting mysql tables in use 1, locked 1 2 lock struct(s), heap size 1128, 1 row lock(s) MySQL thread id 37, OS thread handle 2520, query id 534 vtigercrmsale fe80::e98a:dfea:59cd:2924%11 vtigerdb Updating UPDATE vtiger_cron_task SET status=2, laststart=1633564880, lastend=0 WHERE id='3' ---TRANSACTION 281475218542784, not started 0 lock struct(s), heap size 1128, 0 row lock(s) -------- FILE I/O -------- I/O thread 0 state: native aio handle (insert buffer thread) I/O thread 1 state: native aio handle (log thread) I/O thread 2 state: native aio handle (read thread) I/O thread 3 state: native aio handle (read thread) I/O thread 4 state: native aio handle (read thread) I/O thread 5 state: native aio handle (read thread) I/O thread 6 state: native aio handle (write thread) I/O thread 7 state: native aio handle (write thread) I/O thread 8 state: native aio handle (write thread) I/O thread 9 state: native aio handle (write thread) Pending normal aio reads: [0, 0, 0, 0] , aio writes: [0, 0, 0, 0] , ibuf aio reads:, log i/o's:, sync i/o's: Pending flushes (fsync) log: 1; buffer pool: 0 1497 OS file reads, 1244 OS file writes, 472 OS fsyncs 0.00 reads/s, 0 avg bytes/read, 0.00 writes/s, 0.00 fsyncs/s ------------------------------------- INSERT BUFFER AND ADAPTIVE HASH INDEX ------------------------------------- Ibuf: size 1, free list len 3, seg size 5, 0 merges merged operations: insert 0, delete mark 0, delete 0 discarded operations: insert 0, delete mark 0, delete 0 Hash table size 4441, node heap has 1 buffer(s) Hash table size 4441, node heap has 2 buffer(s) Hash table size 4441, node heap has 0 buffer(s) Hash table size 4441, node heap has 0 buffer(s) Hash table size 4441, node heap has 1 buffer(s) Hash table size 4441, node heap has 1 buffer(s) Hash table size 4441, node heap has 1 buffer(s) Hash table size 4441, node heap has 0 buffer(s) 0.00 hash searches/s, 0.00 non-hash searches/s --- LOG --- Log sequence number 343365292 Log flushed up to 343365224 Pages flushed up to 343364994 Last checkpoint at 343364699 1 pending log flushes, 0 pending chkp writes 358 log i/o's done, 0.00 log i/o's/second ---------------------- BUFFER POOL AND MEMORY ---------------------- Total large memory allocated 33554432 Dictionary memory allocated 399168 Buffer pool size 1002 Free buffers 740 Database pages 256 Old database pages 0 Modified db pages 3 Percent of dirty pages(LRU & free pages): 0.301 Max dirty pages percent: 75.000 Pending reads 0 Pending writes: LRU 0, flush list 3, single page 0 Pages made young 0, not young 0 0.00 youngs/s, 0.00 non-youngs/s Pages read 1317, created 135, written 849 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: 256, 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 Process ID=3492, Main thread ID=3276, state: making checkpoint Number of rows inserted 0, updated 176, deleted 0, read 5086 0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s Number of system rows inserted 0, updated 0, deleted 0, read 0 0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s ---------------------------- END OF INNODB MONITOR OUTPUT ============================ ===================================== 2021-10-07 02:10:55 0xd30 INNODB MONITOR OUTPUT ===================================== Per second averages calculated from the last 20 seconds ----------------- BACKGROUND THREAD ----------------- srv_master_thread loops: 49 srv_active, 0 srv_shutdown, 25376 srv_idle srv_master_thread log flush and writes: 25425 ---------- SEMAPHORES ---------- OS WAIT ARRAY INFO: reservation count 293 --Thread 2520 has waited at row0upd.cc line 3108 for 575.00 seconds the semaphore: X-lock on RW-latch at 000000000EAE3990 created in file buf0buf.cc line 1584 a writer (thread id 0) has reserved it in mode SX number of readers 0, waiters flag 1, lock_word: 10000000 Last time write locked in file buf0flu.cc line 1175 OS WAIT ARRAY INFO: signal count 166 RW-shared spins 0, rounds 131, OS waits 65 RW-excl spins 0, rounds 215, OS waits 7 RW-sx spins 1, rounds 30, OS waits 1 Spin rounds per wait: 131.00 RW-shared, 215.00 RW-excl, 30.00 RW-sx ------------ TRANSACTIONS ------------ Trx id counter 1200460 Purge done for trx's n:o < 1200459 undo n:o < 0 state: running but idle History list length 8 LIST OF TRANSACTIONS FOR EACH SESSION: ---TRANSACTION 1200459, ACTIVE 575 sec updating or deleting mysql tables in use 1, locked 1 2 lock struct(s), heap size 1128, 1 row lock(s) MySQL thread id 37, OS thread handle 2520, query id 534 vtigercrmsale fe80::e98a:dfea:59cd:2924%11 vtigerdb Updating UPDATE vtiger_cron_task SET status=2, laststart=1633564880, lastend=0 WHERE id='3' ---TRANSACTION 281475218542784, not started 0 lock struct(s), heap size 1128, 0 row lock(s) -------- FILE I/O -------- I/O thread 0 state: native aio handle (insert buffer thread) I/O thread 1 state: native aio handle (log thread) I/O thread 2 state: native aio handle (read thread) I/O thread 3 state: native aio handle (read thread) I/O thread 4 state: native aio handle (read thread) I/O thread 5 state: native aio handle (read thread) I/O thread 6 state: native aio handle (write thread) I/O thread 7 state: native aio handle (write thread) I/O thread 8 state: native aio handle (write thread) I/O thread 9 state: native aio handle (write thread) Pending normal aio reads: [0, 0, 0, 0] , aio writes: [0, 0, 0, 0] , ibuf aio reads:, log i/o's:, sync i/o's: Pending flushes (fsync) log: 1; buffer pool: 0 1497 OS file reads, 1244 OS file writes, 472 OS fsyncs 0.00 reads/s, 0 avg bytes/read, 0.00 writes/s, 0.00 fsyncs/s ------------------------------------- INSERT BUFFER AND ADAPTIVE HASH INDEX ------------------------------------- Ibuf: size 1, free list len 3, seg size 5, 0 merges merged operations: insert 0, delete mark 0, delete 0 discarded operations: insert 0, delete mark 0, delete 0 Hash table size 4441, node heap has 1 buffer(s) Hash table size 4441, node heap has 2 buffer(s) Hash table size 4441, node heap has 0 buffer(s) Hash table size 4441, node heap has 0 buffer(s) Hash table size 4441, node heap has 1 buffer(s) Hash table size 4441, node heap has 1 buffer(s) Hash table size 4441, node heap has 1 buffer(s) Hash table size 4441, node heap has 0 buffer(s) 0.00 hash searches/s, 0.00 non-hash searches/s --- LOG --- Log sequence number 343365292 Log flushed up to 343365224 Pages flushed up to 343364994 Last checkpoint at 343364699 1 pending log flushes, 0 pending chkp writes 358 log i/o's done, 0.00 log i/o's/second ---------------------- BUFFER POOL AND MEMORY ---------------------- Total large memory allocated 33554432 Dictionary memory allocated 399168 Buffer pool size 1002 Free buffers 740 Database pages 256 Old database pages 0 Modified db pages 3 Percent of dirty pages(LRU & free pages): 0.301 Max dirty pages percent: 75.000 Pending reads 0 Pending writes: LRU 0, flush list 3, single page 0 Pages made young 0, not young 0 0.00 youngs/s, 0.00 non-youngs/s Pages read 1317, created 135, written 849 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: 256, 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 Process ID=3492, Main thread ID=3276, state: making checkpoint Number of rows inserted 0, updated 176, deleted 0, read 5086 0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s Number of system rows inserted 0, updated 0, deleted 0, read 0 0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s ---------------------------- END OF INNODB MONITOR OUTPUT ============================ InnoDB: ###### Diagnostic info printed to the standard error stream 2021-10-07 2:11:02 0 [Warning] InnoDB: A long semaphore wait: --Thread 2520 has waited at row0upd.cc line 3108 for 582.00 seconds the semaphore: X-lock on RW-latch at 000000000EAE3990 created in file buf0buf.cc line 1584 a writer (thread id 0) has reserved it in mode SX number of readers 0, waiters flag 1, lock_word: 10000000 Last time write locked in file buf0flu.cc line 1175 2021-10-07 2:11:02 0 [Note] InnoDB: A semaphore wait: --Thread 2520 has waited at row0upd.cc line 3108 for 582.00 seconds the semaphore: X-lock on RW-latch at 000000000EAE3990 created in file buf0buf.cc line 1584 a writer (thread id 0) has reserved it in mode SX number of readers 0, waiters flag 1, lock_word: 10000000 Last time write locked in file buf0flu.cc line 1175 InnoDB: ###### Starts InnoDB Monitor for 30 secs to print diagnostic info: InnoDB: Pending reads 0, writes 0 ===================================== 2021-10-07 02:11:15 0xd30 INNODB MONITOR OUTPUT ===================================== Per second averages calculated from the last 20 seconds ----------------- BACKGROUND THREAD ----------------- srv_master_thread loops: 49 srv_active, 0 srv_shutdown, 25376 srv_idle srv_master_thread log flush and writes: 25425 ---------- SEMAPHORES ---------- OS WAIT ARRAY INFO: reservation count 293 --Thread 2520 has waited at row0upd.cc line 3108 for 595.00 seconds the semaphore: X-lock on RW-latch at 000000000EAE3990 created in file buf0buf.cc line 1584 a writer (thread id 0) has reserved it in mode SX number of readers 0, waiters flag 1, lock_word: 10000000 Last time write locked in file buf0flu.cc line 1175 OS WAIT ARRAY INFO: signal count 166 RW-shared spins 0, rounds 131, OS waits 65 RW-excl spins 0, rounds 215, OS waits 7 RW-sx spins 1, rounds 30, OS waits 1 Spin rounds per wait: 131.00 RW-shared, 215.00 RW-excl, 30.00 RW-sx ------------ TRANSACTIONS ------------ Trx id counter 1200460 Purge done for trx's n:o < 1200459 undo n:o < 0 state: running but idle History list length 8 LIST OF TRANSACTIONS FOR EACH SESSION: ---TRANSACTION 1200459, ACTIVE 595 sec updating or deleting mysql tables in use 1, locked 1 2 lock struct(s), heap size 1128, 1 row lock(s) MySQL thread id 37, OS thread handle 2520, query id 534 vtigercrmsale fe80::e98a:dfea:59cd:2924%11 vtigerdb Updating UPDATE vtiger_cron_task SET status=2, laststart=1633564880, lastend=0 WHERE id='3' ---TRANSACTION 281475218542784, not started 0 lock struct(s), heap size 1128, 0 row lock(s) -------- FILE I/O -------- I/O thread 0 state: native aio handle (insert buffer thread) I/O thread 1 state: native aio handle (log thread) I/O thread 2 state: native aio handle (read thread) I/O thread 3 state: native aio handle (read thread) I/O thread 4 state: native aio handle (read thread) I/O thread 5 state: native aio handle (read thread) I/O thread 6 state: native aio handle (write thread) I/O thread 7 state: native aio handle (write thread) I/O thread 8 state: native aio handle (write thread) I/O thread 9 state: native aio handle (write thread) Pending normal aio reads: [0, 0, 0, 0] , aio writes: [0, 0, 0, 0] , ibuf aio reads:, log i/o's:, sync i/o's: Pending flushes (fsync) log: 1; buffer pool: 0 1497 OS file reads, 1244 OS file writes, 472 OS fsyncs 0.00 reads/s, 0 avg bytes/read, 0.00 writes/s, 0.00 fsyncs/s ------------------------------------- INSERT BUFFER AND ADAPTIVE HASH INDEX ------------------------------------- Ibuf: size 1, free list len 3, seg size 5, 0 merges merged operations: insert 0, delete mark 0, delete 0 discarded operations: insert 0, delete mark 0, delete 0 Hash table size 4441, node heap has 1 buffer(s) Hash table size 4441, node heap has 2 buffer(s) Hash table size 4441, node heap has 0 buffer(s) Hash table size 4441, node heap has 0 buffer(s) Hash table size 4441, node heap has 1 buffer(s) Hash table size 4441, node heap has 1 buffer(s) Hash table size 4441, node heap has 1 buffer(s) Hash table size 4441, node heap has 0 buffer(s) 0.00 hash searches/s, 0.00 non-hash searches/s --- LOG --- Log sequence number 343365292 Log flushed up to 343365224 Pages flushed up to 343364994 Last checkpoint at 343364699 1 pending log flushes, 0 pending chkp writes 358 log i/o's done, 0.00 log i/o's/second ---------------------- BUFFER POOL AND MEMORY ---------------------- Total large memory allocated 33554432 Dictionary memory allocated 399168 Buffer pool size 1002 Free buffers 740 Database pages 256 Old database pages 0 Modified db pages 3 Percent of dirty pages(LRU & free pages): 0.301 Max dirty pages percent: 75.000 Pending reads 0 Pending writes: LRU 0, flush list 3, single page 0 Pages made young 0, not young 0 0.00 youngs/s, 0.00 non-youngs/s Pages read 1317, created 135, written 849 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: 256, 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 Process ID=3492, Main thread ID=3276, state: making checkpoint Number of rows inserted 0, updated 176, deleted 0, read 5086 0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s Number of system rows inserted 0, updated 0, deleted 0, read 0 0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s ---------------------------- END OF INNODB MONITOR OUTPUT ============================ InnoDB: ###### Diagnostic info printed to the standard error stream 2021-10-07 2:11:33 0 [Warning] InnoDB: A long semaphore wait: --Thread 2520 has waited at row0upd.cc line 3108 for 613.00 seconds the semaphore: X-lock on RW-latch at 000000000EAE3990 created in file buf0buf.cc line 1584 a writer (thread id 0) has reserved it in mode SX number of readers 0, waiters flag 1, lock_word: 10000000 Last time write locked in file buf0flu.cc line 1175 2021-10-07 2:11:33 0 [Note] InnoDB: A semaphore wait: --Thread 2520 has waited at row0upd.cc line 3108 for 613.00 seconds the semaphore: X-lock on RW-latch at 000000000EAE3990 created in file buf0buf.cc line 1584 a writer (thread id 0) has reserved it in mode SX number of readers 0, waiters flag 1, lock_word: 10000000 Last time write locked in file buf0flu.cc line 1175 InnoDB: ###### Starts InnoDB Monitor for 30 secs to print diagnostic info: InnoDB: Pending reads 0, writes 0 ===================================== 2021-10-07 02:11:35 0xd30 INNODB MONITOR OUTPUT ===================================== Per second averages calculated from the last 20 seconds ----------------- BACKGROUND THREAD ----------------- srv_master_thread loops: 49 srv_active, 0 srv_shutdown, 25376 srv_idle srv_master_thread log flush and writes: 25425 ---------- SEMAPHORES ---------- OS WAIT ARRAY INFO: reservation count 293 --Thread 2520 has waited at row0upd.cc line 3108 for 615.00 seconds the semaphore: X-lock on RW-latch at 000000000EAE3990 created in file buf0buf.cc line 1584 a writer (thread id 0) has reserved it in mode SX number of readers 0, waiters flag 1, lock_word: 10000000 Last time write locked in file buf0flu.cc line 1175 OS WAIT ARRAY INFO: signal count 166 RW-shared spins 0, rounds 131, OS waits 65 RW-excl spins 0, rounds 215, OS waits 7 RW-sx spins 1, rounds 30, OS waits 1 Spin rounds per wait: 131.00 RW-shared, 215.00 RW-excl, 30.00 RW-sx ------------ TRANSACTIONS ------------ Trx id counter 1200460 Purge done for trx's n:o < 1200459 undo n:o < 0 state: running but idle History list length 8 LIST OF TRANSACTIONS FOR EACH SESSION: ---TRANSACTION 1200459, ACTIVE 615 sec updating or deleting mysql tables in use 1, locked 1 2 lock struct(s), heap size 1128, 1 row lock(s) MySQL thread id 37, OS thread handle 2520, query id 534 vtigercrmsale fe80::e98a:dfea:59cd:2924%11 vtigerdb Updating UPDATE vtiger_cron_task SET status=2, laststart=1633564880, lastend=0 WHERE id='3' ---TRANSACTION 281475218542784, not started 0 lock struct(s), heap size 1128, 0 row lock(s) -------- FILE I/O -------- I/O thread 0 state: native aio handle (insert buffer thread) I/O thread 1 state: native aio handle (log thread) I/O thread 2 state: native aio handle (read thread) I/O thread 3 state: native aio handle (read thread) I/O thread 4 state: native aio handle (read thread) I/O thread 5 state: native aio handle (read thread) I/O thread 6 state: native aio handle (write thread) I/O thread 7 state: native aio handle (write thread) I/O thread 8 state: native aio handle (write thread) I/O thread 9 state: native aio handle (write thread) Pending normal aio reads: [0, 0, 0, 0] , aio writes: [0, 0, 0, 0] , ibuf aio reads:, log i/o's:, sync i/o's: Pending flushes (fsync) log: 1; buffer pool: 0 1497 OS file reads, 1244 OS file writes, 472 OS fsyncs 0.00 reads/s, 0 avg bytes/read, 0.00 writes/s, 0.00 fsyncs/s ------------------------------------- INSERT BUFFER AND ADAPTIVE HASH INDEX ------------------------------------- Ibuf: size 1, free list len 3, seg size 5, 0 merges merged operations: insert 0, delete mark 0, delete 0 discarded operations: insert 0, delete mark 0, delete 0 Hash table size 4441, node heap has 1 buffer(s) Hash table size 4441, node heap has 2 buffer(s) Hash table size 4441, node heap has 0 buffer(s) Hash table size 4441, node heap has 0 buffer(s) Hash table size 4441, node heap has 1 buffer(s) Hash table size 4441, node heap has 1 buffer(s) Hash table size 4441, node heap has 1 buffer(s) Hash table size 4441, node heap has 0 buffer(s) 0.00 hash searches/s, 0.00 non-hash searches/s --- LOG --- Log sequence number 343365292 Log flushed up to 343365224 Pages flushed up to 343364994 Last checkpoint at 343364699 1 pending log flushes, 0 pending chkp writes 358 log i/o's done, 0.00 log i/o's/second ---------------------- BUFFER POOL AND MEMORY ---------------------- Total large memory allocated 33554432 Dictionary memory allocated 399168 Buffer pool size 1002 Free buffers 740 Database pages 256 Old database pages 0 Modified db pages 3 Percent of dirty pages(LRU & free pages): 0.301 Max dirty pages percent: 75.000 Pending reads 0 Pending writes: LRU 0, flush list 3, single page 0 Pages made young 0, not young 0 0.00 youngs/s, 0.00 non-youngs/s Pages read 1317, created 135, written 849 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: 256, 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 Process ID=3492, Main thread ID=3276, state: making checkpoint Number of rows inserted 0, updated 176, deleted 0, read 5086 0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s Number of system rows inserted 0, updated 0, deleted 0, read 0 0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s ---------------------------- END OF INNODB MONITOR OUTPUT ============================ ===================================== 2021-10-07 02:11:55 0xd30 INNODB MONITOR OUTPUT ===================================== Per second averages calculated from the last 20 seconds ----------------- BACKGROUND THREAD ----------------- srv_master_thread loops: 49 srv_active, 0 srv_shutdown, 25376 srv_idle srv_master_thread log flush and writes: 25425 ---------- SEMAPHORES ---------- OS WAIT ARRAY INFO: reservation count 293 --Thread 2520 has waited at row0upd.cc line 3108 for 635.00 seconds the semaphore: X-lock on RW-latch at 000000000EAE3990 created in file buf0buf.cc line 1584 a writer (thread id 0) has reserved it in mode SX number of readers 0, waiters flag 1, lock_word: 10000000 Last time write locked in file buf0flu.cc line 1175 OS WAIT ARRAY INFO: signal count 166 RW-shared spins 0, rounds 131, OS waits 65 RW-excl spins 0, rounds 215, OS waits 7 RW-sx spins 1, rounds 30, OS waits 1 Spin rounds per wait: 131.00 RW-shared, 215.00 RW-excl, 30.00 RW-sx ------------ TRANSACTIONS ------------ Trx id counter 1200460 Purge done for trx's n:o < 1200459 undo n:o < 0 state: running but idle History list length 8 LIST OF TRANSACTIONS FOR EACH SESSION: ---TRANSACTION 1200459, ACTIVE 635 sec updating or deleting mysql tables in use 1, locked 1 2 lock struct(s), heap size 1128, 1 row lock(s) MySQL thread id 37, OS thread handle 2520, query id 534 vtigercrmsale fe80::e98a:dfea:59cd:2924%11 vtigerdb Updating UPDATE vtiger_cron_task SET status=2, laststart=1633564880, lastend=0 WHERE id='3' ---TRANSACTION 281475218542784, not started 0 lock struct(s), heap size 1128, 0 row lock(s) -------- FILE I/O -------- I/O thread 0 state: native aio handle (insert buffer thread) I/O thread 1 state: native aio handle (log thread) I/O thread 2 state: native aio handle (read thread) I/O thread 3 state: native aio handle (read thread) I/O thread 4 state: native aio handle (read thread) I/O thread 5 state: native aio handle (read thread) I/O thread 6 state: native aio handle (write thread) I/O thread 7 state: native aio handle (write thread) I/O thread 8 state: native aio handle (write thread) I/O thread 9 state: native aio handle (write thread) Pending normal aio reads: [0, 0, 0, 0] , aio writes: [0, 0, 0, 0] , ibuf aio reads:, log i/o's:, sync i/o's: Pending flushes (fsync) log: 1; buffer pool: 0 1497 OS file reads, 1244 OS file writes, 472 OS fsyncs 0.00 reads/s, 0 avg bytes/read, 0.00 writes/s, 0.00 fsyncs/s ------------------------------------- INSERT BUFFER AND ADAPTIVE HASH INDEX ------------------------------------- Ibuf: size 1, free list len 3, seg size 5, 0 merges merged operations: insert 0, delete mark 0, delete 0 discarded operations: insert 0, delete mark 0, delete 0 Hash table size 4441, node heap has 1 buffer(s) Hash table size 4441, node heap has 2 buffer(s) Hash table size 4441, node heap has 0 buffer(s) Hash table size 4441, node heap has 0 buffer(s) Hash table size 4441, node heap has 1 buffer(s) Hash table size 4441, node heap has 1 buffer(s) Hash table size 4441, node heap has 1 buffer(s) Hash table size 4441, node heap has 0 buffer(s) 0.00 hash searches/s, 0.00 non-hash searches/s --- LOG --- Log sequence number 343365292 Log flushed up to 343365224 Pages flushed up to 343364994 Last checkpoint at 343364699 1 pending log flushes, 0 pending chkp writes 358 log i/o's done, 0.00 log i/o's/second ---------------------- BUFFER POOL AND MEMORY ---------------------- Total large memory allocated 33554432 Dictionary memory allocated 399168 Buffer pool size 1002 Free buffers 740 Database pages 256 Old database pages 0 Modified db pages 3 Percent of dirty pages(LRU & free pages): 0.301 Max dirty pages percent: 75.000 Pending reads 0 Pending writes: LRU 0, flush list 3, single page 0 Pages made young 0, not young 0 0.00 youngs/s, 0.00 non-youngs/s Pages read 1317, created 135, written 849 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: 256, 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 Process ID=3492, Main thread ID=3276, state: making checkpoint Number of rows inserted 0, updated 176, deleted 0, read 5086 0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s Number of system rows inserted 0, updated 0, deleted 0, read 0 0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s ---------------------------- END OF INNODB MONITOR OUTPUT ============================ InnoDB: ###### Diagnostic info printed to the standard error stream 2021-10-07 2:12:04 0 [Warning] InnoDB: A long semaphore wait: --Thread 2520 has waited at row0upd.cc line 3108 for 646.00 seconds the semaphore: X-lock on RW-latch at 000000000EAE3990 created in file buf0buf.cc line 1584 a writer (thread id 0) has reserved it in mode SX number of readers 0, waiters flag 1, lock_word: 10000000 Last time write locked in file buf0flu.cc line 1175 2021-10-07 2:12:06 0 [Note] InnoDB: A semaphore wait: --Thread 2520 has waited at row0upd.cc line 3108 for 646.00 seconds the semaphore: X-lock on RW-latch at 000000000EAE3990 created in file buf0buf.cc line 1584 a writer (thread id 0) has reserved it in mode SX number of readers 0, waiters flag 1, lock_word: 10000000 Last time write locked in file buf0flu.cc line 1175 InnoDB: ###### Starts InnoDB Monitor for 30 secs to print diagnostic info: InnoDB: Pending reads 0, writes 0 ===================================== 2021-10-07 02:12:15 0xd30 INNODB MONITOR OUTPUT ===================================== Per second averages calculated from the last 20 seconds ----------------- BACKGROUND THREAD ----------------- srv_master_thread loops: 49 srv_active, 0 srv_shutdown, 25376 srv_idle srv_master_thread log flush and writes: 25425 ---------- SEMAPHORES ---------- OS WAIT ARRAY INFO: reservation count 293 --Thread 2520 has waited at row0upd.cc line 3108 for 655.00 seconds the semaphore: X-lock on RW-latch at 000000000EAE3990 created in file buf0buf.cc line 1584 a writer (thread id 0) has reserved it in mode SX number of readers 0, waiters flag 1, lock_word: 10000000 Last time write locked in file buf0flu.cc line 1175 OS WAIT ARRAY INFO: signal count 166 RW-shared spins 0, rounds 131, OS waits 65 RW-excl spins 0, rounds 215, OS waits 7 RW-sx spins 1, rounds 30, OS waits 1 Spin rounds per wait: 131.00 RW-shared, 215.00 RW-excl, 30.00 RW-sx ------------ TRANSACTIONS ------------ Trx id counter 1200460 Purge done for trx's n:o < 1200459 undo n:o < 0 state: running but idle History list length 8 LIST OF TRANSACTIONS FOR EACH SESSION: ---TRANSACTION 1200459, ACTIVE 655 sec updating or deleting mysql tables in use 1, locked 1 2 lock struct(s), heap size 1128, 1 row lock(s) MySQL thread id 37, OS thread handle 2520, query id 534 vtigercrmsale fe80::e98a:dfea:59cd:2924%11 vtigerdb Updating UPDATE vtiger_cron_task SET status=2, laststart=1633564880, lastend=0 WHERE id='3' ---TRANSACTION 281475218542784, not started 0 lock struct(s), heap size 1128, 0 row lock(s) -------- FILE I/O -------- I/O thread 0 state: native aio handle (insert buffer thread) I/O thread 1 state: native aio handle (log thread) I/O thread 2 state: native aio handle (read thread) I/O thread 3 state: native aio handle (read thread) I/O thread 4 state: native aio handle (read thread) I/O thread 5 state: native aio handle (read thread) I/O thread 6 state: native aio handle (write thread) I/O thread 7 state: native aio handle (write thread) I/O thread 8 state: native aio handle (write thread) I/O thread 9 state: native aio handle (write thread) Pending normal aio reads: [0, 0, 0, 0] , aio writes: [0, 0, 0, 0] , ibuf aio reads:, log i/o's:, sync i/o's: Pending flushes (fsync) log: 1; buffer pool: 0 1497 OS file reads, 1244 OS file writes, 472 OS fsyncs 0.00 reads/s, 0 avg bytes/read, 0.00 writes/s, 0.00 fsyncs/s ------------------------------------- INSERT BUFFER AND ADAPTIVE HASH INDEX ------------------------------------- Ibuf: size 1, free list len 3, seg size 5, 0 merges merged operations: insert 0, delete mark 0, delete 0 discarded operations: insert 0, delete mark 0, delete 0 Hash table size 4441, node heap has 1 buffer(s) Hash table size 4441, node heap has 2 buffer(s) Hash table size 4441, node heap has 0 buffer(s) Hash table size 4441, node heap has 0 buffer(s) Hash table size 4441, node heap has 1 buffer(s) Hash table size 4441, node heap has 1 buffer(s) Hash table size 4441, node heap has 1 buffer(s) Hash table size 4441, node heap has 0 buffer(s) 0.00 hash searches/s, 0.00 non-hash searches/s --- LOG --- Log sequence number 343365292 Log flushed up to 343365224 Pages flushed up to 343364994 Last checkpoint at 343364699 1 pending log flushes, 0 pending chkp writes 358 log i/o's done, 0.00 log i/o's/second ---------------------- BUFFER POOL AND MEMORY ---------------------- Total large memory allocated 33554432 Dictionary memory allocated 399168 Buffer pool size 1002 Free buffers 740 Database pages 256 Old database pages 0 Modified db pages 3 Percent of dirty pages(LRU & free pages): 0.301 Max dirty pages percent: 75.000 Pending reads 0 Pending writes: LRU 0, flush list 3, single page 0 Pages made young 0, not young 0 0.00 youngs/s, 0.00 non-youngs/s Pages read 1317, created 135, written 849 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: 256, 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 Process ID=3492, Main thread ID=3276, state: making checkpoint Number of rows inserted 0, updated 176, deleted 0, read 5086 0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s Number of system rows inserted 0, updated 0, deleted 0, read 0 0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s ---------------------------- END OF INNODB MONITOR OUTPUT ============================ ===================================== 2021-10-07 02:12:35 0xd30 INNODB MONITOR OUTPUT ===================================== Per second averages calculated from the last 20 seconds ----------------- BACKGROUND THREAD ----------------- srv_master_thread loops: 49 srv_active, 0 srv_shutdown, 25376 srv_idle srv_master_thread log flush and writes: 25425 ---------- SEMAPHORES ---------- OS WAIT ARRAY INFO: reservation count 293 --Thread 2520 has waited at row0upd.cc line 3108 for 675.00 seconds the semaphore: X-lock on RW-latch at 000000000EAE3990 created in file buf0buf.cc line 1584 a writer (thread id 0) has reserved it in mode SX number of readers 0, waiters flag 1, lock_word: 10000000 Last time write locked in file buf0flu.cc line 1175 OS WAIT ARRAY INFO: signal count 166 RW-shared spins 0, rounds 131, OS waits 65 RW-excl spins 0, rounds 215, OS waits 7 RW-sx spins 1, rounds 30, OS waits 1 Spin rounds per wait: 131.00 RW-shared, 215.00 RW-excl, 30.00 RW-sx ------------ TRANSACTIONS ------------ Trx id counter 1200460 Purge done for trx's n:o < 1200459 undo n:o < 0 state: running but idle History list length 8 LIST OF TRANSACTIONS FOR EACH SESSION: ---TRANSACTION 1200459, ACTIVE 675 sec updating or deleting mysql tables in use 1, locked 1 2 lock struct(s), heap size 1128, 1 row lock(s) MySQL thread id 37, OS thread handle 2520, query id 534 vtigercrmsale fe80::e98a:dfea:59cd:2924%11 vtigerdb Updating UPDATE vtiger_cron_task SET status=2, laststart=1633564880, lastend=0 WHERE id='3' ---TRANSACTION 281475218542784, not started 0 lock struct(s), heap size 1128, 0 row lock(s) -------- FILE I/O -------- I/O thread 0 state: native aio handle (insert buffer thread) I/O thread 1 state: native aio handle (log thread) I/O thread 2 state: native aio handle (read thread) I/O thread 3 state: native aio handle (read thread) I/O thread 4 state: native aio handle (read thread) I/O thread 5 state: native aio handle (read thread) I/O thread 6 state: native aio handle (write thread) I/O thread 7 state: native aio handle (write thread) I/O thread 8 state: native aio handle (write thread) I/O thread 9 state: native aio handle (write thread) Pending normal aio reads: [0, 0, 0, 0] , aio writes: [0, 0, 0, 0] , ibuf aio reads:, log i/o's:, sync i/o's: Pending flushes (fsync) log: 1; buffer pool: 0 1497 OS file reads, 1244 OS file writes, 472 OS fsyncs 0.00 reads/s, 0 avg bytes/read, 0.00 writes/s, 0.00 fsyncs/s ------------------------------------- INSERT BUFFER AND ADAPTIVE HASH INDEX ------------------------------------- Ibuf: size 1, free list len 3, seg size 5, 0 merges merged operations: insert 0, delete mark 0, delete 0 discarded operations: insert 0, delete mark 0, delete 0 Hash table size 4441, node heap has 1 buffer(s) Hash table size 4441, node heap has 2 buffer(s) Hash table size 4441, node heap has 0 buffer(s) Hash table size 4441, node heap has 0 buffer(s) Hash table size 4441, node heap has 1 buffer(s) Hash table size 4441, node heap has 1 buffer(s) Hash table size 4441, node heap has 1 buffer(s) Hash table size 4441, node heap has 0 buffer(s) 0.00 hash searches/s, 0.00 non-hash searches/s --- LOG --- Log sequence number 343365292 Log flushed up to 343365224 Pages flushed up to 343364994 Last checkpoint at 343364699 1 pending log flushes, 0 pending chkp writes 358 log i/o's done, 0.00 log i/o's/second ---------------------- BUFFER POOL AND MEMORY ---------------------- Total large memory allocated 33554432 Dictionary memory allocated 399168 Buffer pool size 1002 Free buffers 740 Database pages 256 Old database pages 0 Modified db pages 3 Percent of dirty pages(LRU & free pages): 0.301 Max dirty pages percent: 75.000 Pending reads 0 Pending writes: LRU 0, flush list 3, single page 0 Pages made young 0, not young 0 0.00 youngs/s, 0.00 non-youngs/s Pages read 1317, created 135, written 849 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: 256, 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 Process ID=3492, Main thread ID=3276, state: making checkpoint Number of rows inserted 0, updated 176, deleted 0, read 5086 0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s Number of system rows inserted 0, updated 0, deleted 0, read 0 0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s ---------------------------- END OF INNODB MONITOR OUTPUT ============================ InnoDB: ###### Diagnostic info printed to the standard error stream 2021-10-07 2:12:38 0 [Warning] InnoDB: A long semaphore wait: --Thread 2520 has waited at row0upd.cc line 3108 for 678.00 seconds the semaphore: X-lock on RW-latch at 000000000EAE3990 created in file buf0buf.cc line 1584 a writer (thread id 0) has reserved it in mode SX number of readers 0, waiters flag 1, lock_word: 10000000 Last time write locked in file buf0flu.cc line 1175 2021-10-07 2:12:38 0 [Note] InnoDB: A semaphore wait: --Thread 2520 has waited at row0upd.cc line 3108 for 678.00 seconds the semaphore: X-lock on RW-latch at 000000000EAE3990 created in file buf0buf.cc line 1584 a writer (thread id 0) has reserved it in mode SX number of readers 0, waiters flag 1, lock_word: 10000000 Last time write locked in file buf0flu.cc line 1175 InnoDB: ###### Starts InnoDB Monitor for 30 secs to print diagnostic info: InnoDB: Pending reads 0, writes 0 ===================================== 2021-10-07 02:12:55 0xd30 INNODB MONITOR OUTPUT ===================================== Per second averages calculated from the last 20 seconds ----------------- BACKGROUND THREAD ----------------- srv_master_thread loops: 49 srv_active, 0 srv_shutdown, 25376 srv_idle srv_master_thread log flush and writes: 25425 ---------- SEMAPHORES ---------- OS WAIT ARRAY INFO: reservation count 293 --Thread 2520 has waited at row0upd.cc line 3108 for 695.00 seconds the semaphore: X-lock on RW-latch at 000000000EAE3990 created in file buf0buf.cc line 1584 a writer (thread id 0) has reserved it in mode SX number of readers 0, waiters flag 1, lock_word: 10000000 Last time write locked in file buf0flu.cc line 1175 OS WAIT ARRAY INFO: signal count 166 RW-shared spins 0, rounds 131, OS waits 65 RW-excl spins 0, rounds 215, OS waits 7 RW-sx spins 1, rounds 30, OS waits 1 Spin rounds per wait: 131.00 RW-shared, 215.00 RW-excl, 30.00 RW-sx ------------ TRANSACTIONS ------------ Trx id counter 1200460 Purge done for trx's n:o < 1200459 undo n:o < 0 state: running but idle History list length 8 LIST OF TRANSACTIONS FOR EACH SESSION: ---TRANSACTION 1200459, ACTIVE 695 sec updating or deleting mysql tables in use 1, locked 1 2 lock struct(s), heap size 1128, 1 row lock(s) MySQL thread id 37, OS thread handle 2520, query id 534 vtigercrmsale fe80::e98a:dfea:59cd:2924%11 vtigerdb Updating UPDATE vtiger_cron_task SET status=2, laststart=1633564880, lastend=0 WHERE id='3' ---TRANSACTION 281475218542784, not started 0 lock struct(s), heap size 1128, 0 row lock(s) -------- FILE I/O -------- I/O thread 0 state: native aio handle (insert buffer thread) I/O thread 1 state: native aio handle (log thread) I/O thread 2 state: native aio handle (read thread) I/O thread 3 state: native aio handle (read thread) I/O thread 4 state: native aio handle (read thread) I/O thread 5 state: native aio handle (read thread) I/O thread 6 state: native aio handle (write thread) I/O thread 7 state: native aio handle (write thread) I/O thread 8 state: native aio handle (write thread) I/O thread 9 state: native aio handle (write thread) Pending normal aio reads: [0, 0, 0, 0] , aio writes: [0, 0, 0, 0] , ibuf aio reads:, log i/o's:, sync i/o's: Pending flushes (fsync) log: 1; buffer pool: 0 1497 OS file reads, 1244 OS file writes, 472 OS fsyncs 0.00 reads/s, 0 avg bytes/read, 0.00 writes/s, 0.00 fsyncs/s ------------------------------------- INSERT BUFFER AND ADAPTIVE HASH INDEX ------------------------------------- Ibuf: size 1, free list len 3, seg size 5, 0 merges merged operations: insert 0, delete mark 0, delete 0 discarded operations: insert 0, delete mark 0, delete 0 Hash table size 4441, node heap has 1 buffer(s) Hash table size 4441, node heap has 2 buffer(s) Hash table size 4441, node heap has 0 buffer(s) Hash table size 4441, node heap has 0 buffer(s) Hash table size 4441, node heap has 1 buffer(s) Hash table size 4441, node heap has 1 buffer(s) Hash table size 4441, node heap has 1 buffer(s) Hash table size 4441, node heap has 0 buffer(s) 0.00 hash searches/s, 0.00 non-hash searches/s --- LOG --- Log sequence number 343365292 Log flushed up to 343365224 Pages flushed up to 343364994 Last checkpoint at 343364699 1 pending log flushes, 0 pending chkp writes 358 log i/o's done, 0.00 log i/o's/second ---------------------- BUFFER POOL AND MEMORY ---------------------- Total large memory allocated 33554432 Dictionary memory allocated 399168 Buffer pool size 1002 Free buffers 740 Database pages 256 Old database pages 0 Modified db pages 3 Percent of dirty pages(LRU & free pages): 0.301 Max dirty pages percent: 75.000 Pending reads 0 Pending writes: LRU 0, flush list 3, single page 0 Pages made young 0, not young 0 0.00 youngs/s, 0.00 non-youngs/s Pages read 1317, created 135, written 849 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: 256, 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 Process ID=3492, Main thread ID=3276, state: making checkpoint Number of rows inserted 0, updated 176, deleted 0, read 5086 0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s Number of system rows inserted 0, updated 0, deleted 0, read 0 0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s ---------------------------- END OF INNODB MONITOR OUTPUT ============================ InnoDB: ###### Diagnostic info printed to the standard error stream 2021-10-07 2:13:09 0 [Warning] InnoDB: A long semaphore wait: --Thread 2520 has waited at row0upd.cc line 3108 for 709.00 seconds the semaphore: X-lock on RW-latch at 000000000EAE3990 created in file buf0buf.cc line 1584 a writer (thread id 0) has reserved it in mode SX number of readers 0, waiters flag 1, lock_word: 10000000 Last time write locked in file buf0flu.cc line 1175 2021-10-07 2:13:09 0 [Note] InnoDB: A semaphore wait: --Thread 2520 has waited at row0upd.cc line 3108 for 709.00 seconds the semaphore: X-lock on RW-latch at 000000000EAE3990 created in file buf0buf.cc line 1584 a writer (thread id 0) has reserved it in mode SX number of readers 0, waiters flag 1, lock_word: 10000000 Last time write locked in file buf0flu.cc line 1175 InnoDB: ###### Starts InnoDB Monitor for 30 secs to print diagnostic info: InnoDB: Pending reads 0, writes 0 ===================================== 2021-10-07 02:13:15 0xd30 INNODB MONITOR OUTPUT ===================================== Per second averages calculated from the last 20 seconds ----------------- BACKGROUND THREAD ----------------- srv_master_thread loops: 49 srv_active, 0 srv_shutdown, 25376 srv_idle srv_master_thread log flush and writes: 25425 ---------- SEMAPHORES ---------- OS WAIT ARRAY INFO: reservation count 293 --Thread 2520 has waited at row0upd.cc line 3108 for 715.00 seconds the semaphore: X-lock on RW-latch at 000000000EAE3990 created in file buf0buf.cc line 1584 a writer (thread id 0) has reserved it in mode SX number of readers 0, waiters flag 1, lock_word: 10000000 Last time write locked in file buf0flu.cc line 1175 OS WAIT ARRAY INFO: signal count 166 RW-shared spins 0, rounds 131, OS waits 65 RW-excl spins 0, rounds 215, OS waits 7 RW-sx spins 1, rounds 30, OS waits 1 Spin rounds per wait: 131.00 RW-shared, 215.00 RW-excl, 30.00 RW-sx ------------ TRANSACTIONS ------------ Trx id counter 1200460 Purge done for trx's n:o < 1200459 undo n:o < 0 state: running but idle History list length 8 LIST OF TRANSACTIONS FOR EACH SESSION: ---TRANSACTION 1200459, ACTIVE 715 sec updating or deleting mysql tables in use 1, locked 1 2 lock struct(s), heap size 1128, 1 row lock(s) MySQL thread id 37, OS thread handle 2520, query id 534 vtigercrmsale fe80::e98a:dfea:59cd:2924%11 vtigerdb Updating UPDATE vtiger_cron_task SET status=2, laststart=1633564880, lastend=0 WHERE id='3' ---TRANSACTION 281475218542784, not started 0 lock struct(s), heap size 1128, 0 row lock(s) -------- FILE I/O -------- I/O thread 0 state: native aio handle (insert buffer thread) I/O thread 1 state: native aio handle (log thread) I/O thread 2 state: native aio handle (read thread) I/O thread 3 state: native aio handle (read thread) I/O thread 4 state: native aio handle (read thread) I/O thread 5 state: native aio handle (read thread) I/O thread 6 state: native aio handle (write thread) I/O thread 7 state: native aio handle (write thread) I/O thread 8 state: native aio handle (write thread) I/O thread 9 state: native aio handle (write thread) Pending normal aio reads: [0, 0, 0, 0] , aio writes: [0, 0, 0, 0] , ibuf aio reads:, log i/o's:, sync i/o's: Pending flushes (fsync) log: 1; buffer pool: 0 1497 OS file reads, 1244 OS file writes, 472 OS fsyncs 0.00 reads/s, 0 avg bytes/read, 0.00 writes/s, 0.00 fsyncs/s ------------------------------------- INSERT BUFFER AND ADAPTIVE HASH INDEX ------------------------------------- Ibuf: size 1, free list len 3, seg size 5, 0 merges merged operations: insert 0, delete mark 0, delete 0 discarded operations: insert 0, delete mark 0, delete 0 Hash table size 4441, node heap has 1 buffer(s) Hash table size 4441, node heap has 2 buffer(s) Hash table size 4441, node heap has 0 buffer(s) Hash table size 4441, node heap has 0 buffer(s) Hash table size 4441, node heap has 1 buffer(s) Hash table size 4441, node heap has 1 buffer(s) Hash table size 4441, node heap has 1 buffer(s) Hash table size 4441, node heap has 0 buffer(s) 0.00 hash searches/s, 0.00 non-hash searches/s --- LOG --- Log sequence number 343365292 Log flushed up to 343365224 Pages flushed up to 343364994 Last checkpoint at 343364699 1 pending log flushes, 0 pending chkp writes 358 log i/o's done, 0.00 log i/o's/second ---------------------- BUFFER POOL AND MEMORY ---------------------- Total large memory allocated 33554432 Dictionary memory allocated 399168 Buffer pool size 1002 Free buffers 740 Database pages 256 Old database pages 0 Modified db pages 3 Percent of dirty pages(LRU & free pages): 0.301 Max dirty pages percent: 75.000 Pending reads 0 Pending writes: LRU 0, flush list 3, single page 0 Pages made young 0, not young 0 0.00 youngs/s, 0.00 non-youngs/s Pages read 1317, created 135, written 849 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: 256, 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 Process ID=3492, Main thread ID=3276, state: making checkpoint Number of rows inserted 0, updated 176, deleted 0, read 5086 0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s Number of system rows inserted 0, updated 0, deleted 0, read 0 0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s ---------------------------- END OF INNODB MONITOR OUTPUT ============================ ===================================== 2021-10-07 02:13:35 0xd30 INNODB MONITOR OUTPUT ===================================== Per second averages calculated from the last 20 seconds ----------------- BACKGROUND THREAD ----------------- srv_master_thread loops: 49 srv_active, 0 srv_shutdown, 25376 srv_idle srv_master_thread log flush and writes: 25425 ---------- SEMAPHORES ---------- OS WAIT ARRAY INFO: reservation count 293 --Thread 2520 has waited at row0upd.cc line 3108 for 735.00 seconds the semaphore: X-lock on RW-latch at 000000000EAE3990 created in file buf0buf.cc line 1584 a writer (thread id 0) has reserved it in mode SX number of readers 0, waiters flag 1, lock_word: 10000000 Last time write locked in file buf0flu.cc line 1175 OS WAIT ARRAY INFO: signal count 166 RW-shared spins 0, rounds 131, OS waits 65 RW-excl spins 0, rounds 215, OS waits 7 RW-sx spins 1, rounds 30, OS waits 1 Spin rounds per wait: 131.00 RW-shared, 215.00 RW-excl, 30.00 RW-sx ------------ TRANSACTIONS ------------ Trx id counter 1200460 Purge done for trx's n:o < 1200459 undo n:o < 0 state: running but idle History list length 8 LIST OF TRANSACTIONS FOR EACH SESSION: ---TRANSACTION 1200459, ACTIVE 735 sec updating or deleting mysql tables in use 1, locked 1 2 lock struct(s), heap size 1128, 1 row lock(s) MySQL thread id 37, OS thread handle 2520, query id 534 vtigercrmsale fe80::e98a:dfea:59cd:2924%11 vtigerdb Updating UPDATE vtiger_cron_task SET status=2, laststart=1633564880, lastend=0 WHERE id='3' ---TRANSACTION 281475218542784, not started 0 lock struct(s), heap size 1128, 0 row lock(s) -------- FILE I/O -------- I/O thread 0 state: native aio handle (insert buffer thread) I/O thread 1 state: native aio handle (log thread) I/O thread 2 state: native aio handle (read thread) I/O thread 3 state: native aio handle (read thread) I/O thread 4 state: native aio handle (read thread) I/O thread 5 state: native aio handle (read thread) I/O thread 6 state: native aio handle (write thread) I/O thread 7 state: native aio handle (write thread) I/O thread 8 state: native aio handle (write thread) I/O thread 9 state: native aio handle (write thread) Pending normal aio reads: [0, 0, 0, 0] , aio writes: [0, 0, 0, 0] , ibuf aio reads:, log i/o's:, sync i/o's: Pending flushes (fsync) log: 1; buffer pool: 0 1497 OS file reads, 1244 OS file writes, 472 OS fsyncs 0.00 reads/s, 0 avg bytes/read, 0.00 writes/s, 0.00 fsyncs/s ------------------------------------- INSERT BUFFER AND ADAPTIVE HASH INDEX ------------------------------------- Ibuf: size 1, free list len 3, seg size 5, 0 merges merged operations: insert 0, delete mark 0, delete 0 discarded operations: insert 0, delete mark 0, delete 0 Hash table size 4441, node heap has 1 buffer(s) Hash table size 4441, node heap has 2 buffer(s) Hash table size 4441, node heap has 0 buffer(s) Hash table size 4441, node heap has 0 buffer(s) Hash table size 4441, node heap has 1 buffer(s) Hash table size 4441, node heap has 1 buffer(s) Hash table size 4441, node heap has 1 buffer(s) Hash table size 4441, node heap has 0 buffer(s) 0.00 hash searches/s, 0.00 non-hash searches/s --- LOG --- Log sequence number 343365292 Log flushed up to 343365224 Pages flushed up to 343364994 Last checkpoint at 343364699 1 pending log flushes, 0 pending chkp writes 358 log i/o's done, 0.00 log i/o's/second ---------------------- BUFFER POOL AND MEMORY ---------------------- Total large memory allocated 33554432 Dictionary memory allocated 399168 Buffer pool size 1002 Free buffers 740 Database pages 256 Old database pages 0 Modified db pages 3 Percent of dirty pages(LRU & free pages): 0.301 Max dirty pages percent: 75.000 Pending reads 0 Pending writes: LRU 0, flush list 3, single page 0 Pages made young 0, not young 0 0.00 youngs/s, 0.00 non-youngs/s Pages read 1317, created 135, written 849 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: 256, 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 Process ID=3492, Main thread ID=3276, state: making checkpoint Number of rows inserted 0, updated 176, deleted 0, read 5086 0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s Number of system rows inserted 0, updated 0, deleted 0, read 0 0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s ---------------------------- END OF INNODB MONITOR OUTPUT ============================ InnoDB: ###### Diagnostic info printed to the standard error stream 2021-10-07 2:13:40 0 [Warning] InnoDB: A long semaphore wait: --Thread 2520 has waited at row0upd.cc line 3108 for 740.00 seconds the semaphore: X-lock on RW-latch at 000000000EAE3990 created in file buf0buf.cc line 1584 a writer (thread id 0) has reserved it in mode SX number of readers 0, waiters flag 1, lock_word: 10000000 Last time write locked in file buf0flu.cc line 1175 2021-10-07 2:13:40 0 [Note] InnoDB: A semaphore wait: --Thread 2520 has waited at row0upd.cc line 3108 for 740.00 seconds the semaphore: X-lock on RW-latch at 000000000EAE3990 created in file buf0buf.cc line 1584 a writer (thread id 0) has reserved it in mode SX number of readers 0, waiters flag 1, lock_word: 10000000 Last time write locked in file buf0flu.cc line 1175 InnoDB: ###### Starts InnoDB Monitor for 30 secs to print diagnostic info: InnoDB: Pending reads 0, writes 0 ===================================== 2021-10-07 02:13:55 0xd30 INNODB MONITOR OUTPUT ===================================== Per second averages calculated from the last 20 seconds ----------------- BACKGROUND THREAD ----------------- srv_master_thread loops: 49 srv_active, 0 srv_shutdown, 25376 srv_idle srv_master_thread log flush and writes: 25425 ---------- SEMAPHORES ---------- OS WAIT ARRAY INFO: reservation count 293 --Thread 2520 has waited at row0upd.cc line 3108 for 755.00 seconds the semaphore: X-lock on RW-latch at 000000000EAE3990 created in file buf0buf.cc line 1584 a writer (thread id 0) has reserved it in mode SX number of readers 0, waiters flag 1, lock_word: 10000000 Last time write locked in file buf0flu.cc line 1175 OS WAIT ARRAY INFO: signal count 166 RW-shared spins 0, rounds 131, OS waits 65 RW-excl spins 0, rounds 215, OS waits 7 RW-sx spins 1, rounds 30, OS waits 1 Spin rounds per wait: 131.00 RW-shared, 215.00 RW-excl, 30.00 RW-sx ------------ TRANSACTIONS ------------ Trx id counter 1200460 Purge done for trx's n:o < 1200459 undo n:o < 0 state: running but idle History list length 8 LIST OF TRANSACTIONS FOR EACH SESSION: ---TRANSACTION 1200459, ACTIVE 755 sec updating or deleting mysql tables in use 1, locked 1 2 lock struct(s), heap size 1128, 1 row lock(s) MySQL thread id 37, OS thread handle 2520, query id 534 vtigercrmsale fe80::e98a:dfea:59cd:2924%11 vtigerdb Updating UPDATE vtiger_cron_task SET status=2, laststart=1633564880, lastend=0 WHERE id='3' ---TRANSACTION 281475218542784, not started 0 lock struct(s), heap size 1128, 0 row lock(s) -------- FILE I/O -------- I/O thread 0 state: native aio handle (insert buffer thread) I/O thread 1 state: native aio handle (log thread) I/O thread 2 state: native aio handle (read thread) I/O thread 3 state: native aio handle (read thread) I/O thread 4 state: native aio handle (read thread) I/O thread 5 state: native aio handle (read thread) I/O thread 6 state: native aio handle (write thread) I/O thread 7 state: native aio handle (write thread) I/O thread 8 state: native aio handle (write thread) I/O thread 9 state: native aio handle (write thread) Pending normal aio reads: [0, 0, 0, 0] , aio writes: [0, 0, 0, 0] , ibuf aio reads:, log i/o's:, sync i/o's: Pending flushes (fsync) log: 1; buffer pool: 0 1497 OS file reads, 1244 OS file writes, 472 OS fsyncs 0.00 reads/s, 0 avg bytes/read, 0.00 writes/s, 0.00 fsyncs/s ------------------------------------- INSERT BUFFER AND ADAPTIVE HASH INDEX ------------------------------------- Ibuf: size 1, free list len 3, seg size 5, 0 merges merged operations: insert 0, delete mark 0, delete 0 discarded operations: insert 0, delete mark 0, delete 0 Hash table size 4441, node heap has 1 buffer(s) Hash table size 4441, node heap has 2 buffer(s) Hash table size 4441, node heap has 0 buffer(s) Hash table size 4441, node heap has 0 buffer(s) Hash table size 4441, node heap has 1 buffer(s) Hash table size 4441, node heap has 1 buffer(s) Hash table size 4441, node heap has 1 buffer(s) Hash table size 4441, node heap has 0 buffer(s) 0.00 hash searches/s, 0.00 non-hash searches/s --- LOG --- Log sequence number 343365292 Log flushed up to 343365224 Pages flushed up to 343364994 Last checkpoint at 343364699 1 pending log flushes, 0 pending chkp writes 358 log i/o's done, 0.00 log i/o's/second ---------------------- BUFFER POOL AND MEMORY ---------------------- Total large memory allocated 33554432 Dictionary memory allocated 399168 Buffer pool size 1002 Free buffers 740 Database pages 256 Old database pages 0 Modified db pages 3 Percent of dirty pages(LRU & free pages): 0.301 Max dirty pages percent: 75.000 Pending reads 0 Pending writes: LRU 0, flush list 3, single page 0 Pages made young 0, not young 0 0.00 youngs/s, 0.00 non-youngs/s Pages read 1317, created 135, written 849 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: 256, 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 Process ID=3492, Main thread ID=3276, state: making checkpoint Number of rows inserted 0, updated 176, deleted 0, read 5086 0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s Number of system rows inserted 0, updated 0, deleted 0, read 0 0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s ---------------------------- END OF INNODB MONITOR OUTPUT ============================ InnoDB: ###### Diagnostic info printed to the standard error stream 2021-10-07 2:14:11 0 [Warning] InnoDB: A long semaphore wait: --Thread 2520 has waited at row0upd.cc line 3108 for 771.00 seconds the semaphore: X-lock on RW-latch at 000000000EAE3990 created in file buf0buf.cc line 1584 a writer (thread id 0) has reserved it in mode SX number of readers 0, waiters flag 1, lock_word: 10000000 Last time write locked in file buf0flu.cc line 1175 2021-10-07 2:14:11 0 [Note] InnoDB: A semaphore wait: --Thread 2520 has waited at row0upd.cc line 3108 for 771.00 seconds the semaphore: X-lock on RW-latch at 000000000EAE3990 created in file buf0buf.cc line 1584 a writer (thread id 0) has reserved it in mode SX number of readers 0, waiters flag 1, lock_word: 10000000 Last time write locked in file buf0flu.cc line 1175 InnoDB: ###### Starts InnoDB Monitor for 30 secs to print diagnostic info: InnoDB: Pending reads 0, writes 0 ===================================== 2021-10-07 02:14:15 0xd30 INNODB MONITOR OUTPUT ===================================== Per second averages calculated from the last 20 seconds ----------------- BACKGROUND THREAD ----------------- srv_master_thread loops: 49 srv_active, 0 srv_shutdown, 25376 srv_idle srv_master_thread log flush and writes: 25425 ---------- SEMAPHORES ---------- OS WAIT ARRAY INFO: reservation count 293 --Thread 2520 has waited at row0upd.cc line 3108 for 775.00 seconds the semaphore: X-lock on RW-latch at 000000000EAE3990 created in file buf0buf.cc line 1584 a writer (thread id 0) has reserved it in mode SX number of readers 0, waiters flag 1, lock_word: 10000000 Last time write locked in file buf0flu.cc line 1175 OS WAIT ARRAY INFO: signal count 166 RW-shared spins 0, rounds 131, OS waits 65 RW-excl spins 0, rounds 215, OS waits 7 RW-sx spins 1, rounds 30, OS waits 1 Spin rounds per wait: 131.00 RW-shared, 215.00 RW-excl, 30.00 RW-sx ------------ TRANSACTIONS ------------ Trx id counter 1200460 Purge done for trx's n:o < 1200459 undo n:o < 0 state: running but idle History list length 8 LIST OF TRANSACTIONS FOR EACH SESSION: ---TRANSACTION 1200459, ACTIVE 775 sec updating or deleting mysql tables in use 1, locked 1 2 lock struct(s), heap size 1128, 1 row lock(s) MySQL thread id 37, OS thread handle 2520, query id 534 vtigercrmsale fe80::e98a:dfea:59cd:2924%11 vtigerdb Updating UPDATE vtiger_cron_task SET status=2, laststart=1633564880, lastend=0 WHERE id='3' ---TRANSACTION 281475218542784, not started 0 lock struct(s), heap size 1128, 0 row lock(s) -------- FILE I/O -------- I/O thread 0 state: native aio handle (insert buffer thread) I/O thread 1 state: native aio handle (log thread) I/O thread 2 state: native aio handle (read thread) I/O thread 3 state: native aio handle (read thread) I/O thread 4 state: native aio handle (read thread) I/O thread 5 state: native aio handle (read thread) I/O thread 6 state: native aio handle (write thread) I/O thread 7 state: native aio handle (write thread) I/O thread 8 state: native aio handle (write thread) I/O thread 9 state: native aio handle (write thread) Pending normal aio reads: [0, 0, 0, 0] , aio writes: [0, 0, 0, 0] , ibuf aio reads:, log i/o's:, sync i/o's: Pending flushes (fsync) log: 1; buffer pool: 0 1497 OS file reads, 1244 OS file writes, 472 OS fsyncs 0.00 reads/s, 0 avg bytes/read, 0.00 writes/s, 0.00 fsyncs/s ------------------------------------- INSERT BUFFER AND ADAPTIVE HASH INDEX ------------------------------------- Ibuf: size 1, free list len 3, seg size 5, 0 merges merged operations: insert 0, delete mark 0, delete 0 discarded operations: insert 0, delete mark 0, delete 0 Hash table size 4441, node heap has 1 buffer(s) Hash table size 4441, node heap has 2 buffer(s) Hash table size 4441, node heap has 0 buffer(s) Hash table size 4441, node heap has 0 buffer(s) Hash table size 4441, node heap has 1 buffer(s) Hash table size 4441, node heap has 1 buffer(s) Hash table size 4441, node heap has 1 buffer(s) Hash table size 4441, node heap has 0 buffer(s) 0.00 hash searches/s, 0.00 non-hash searches/s --- LOG --- Log sequence number 343365292 Log flushed up to 343365224 Pages flushed up to 343364994 Last checkpoint at 343364699 1 pending log flushes, 0 pending chkp writes 358 log i/o's done, 0.00 log i/o's/second ---------------------- BUFFER POOL AND MEMORY ---------------------- Total large memory allocated 33554432 Dictionary memory allocated 399168 Buffer pool size 1002 Free buffers 740 Database pages 256 Old database pages 0 Modified db pages 3 Percent of dirty pages(LRU & free pages): 0.301 Max dirty pages percent: 75.000 Pending reads 0 Pending writes: LRU 0, flush list 3, single page 0 Pages made young 0, not young 0 0.00 youngs/s, 0.00 non-youngs/s Pages read 1317, created 135, written 849 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: 256, 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 Process ID=3492, Main thread ID=3276, state: making checkpoint Number of rows inserted 0, updated 176, deleted 0, read 5086 0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s Number of system rows inserted 0, updated 0, deleted 0, read 0 0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s ---------------------------- END OF INNODB MONITOR OUTPUT ============================ ===================================== 2021-10-07 02:14:35 0xd30 INNODB MONITOR OUTPUT ===================================== Per second averages calculated from the last 20 seconds ----------------- BACKGROUND THREAD ----------------- srv_master_thread loops: 49 srv_active, 0 srv_shutdown, 25376 srv_idle srv_master_thread log flush and writes: 25425 ---------- SEMAPHORES ---------- OS WAIT ARRAY INFO: reservation count 293 --Thread 2520 has waited at row0upd.cc line 3108 for 795.00 seconds the semaphore: X-lock on RW-latch at 000000000EAE3990 created in file buf0buf.cc line 1584 a writer (thread id 0) has reserved it in mode SX number of readers 0, waiters flag 1, lock_word: 10000000 Last time write locked in file buf0flu.cc line 1175 OS WAIT ARRAY INFO: signal count 166 RW-shared spins 0, rounds 131, OS waits 65 RW-excl spins 0, rounds 215, OS waits 7 RW-sx spins 1, rounds 30, OS waits 1 Spin rounds per wait: 131.00 RW-shared, 215.00 RW-excl, 30.00 RW-sx ------------ TRANSACTIONS ------------ Trx id counter 1200460 Purge done for trx's n:o < 1200459 undo n:o < 0 state: running but idle History list length 8 LIST OF TRANSACTIONS FOR EACH SESSION: ---TRANSACTION 1200459, ACTIVE 795 sec updating or deleting mysql tables in use 1, locked 1 2 lock struct(s), heap size 1128, 1 row lock(s) MySQL thread id 37, OS thread handle 2520, query id 534 vtigercrmsale fe80::e98a:dfea:59cd:2924%11 vtigerdb Updating UPDATE vtiger_cron_task SET status=2, laststart=1633564880, lastend=0 WHERE id='3' ---TRANSACTION 281475218542784, not started 0 lock struct(s), heap size 1128, 0 row lock(s) -------- FILE I/O -------- I/O thread 0 state: native aio handle (insert buffer thread) I/O thread 1 state: native aio handle (log thread) I/O thread 2 state: native aio handle (read thread) I/O thread 3 state: native aio handle (read thread) I/O thread 4 state: native aio handle (read thread) I/O thread 5 state: native aio handle (read thread) I/O thread 6 state: native aio handle (write thread) I/O thread 7 state: native aio handle (write thread) I/O thread 8 state: native aio handle (write thread) I/O thread 9 state: native aio handle (write thread) Pending normal aio reads: [0, 0, 0, 0] , aio writes: [0, 0, 0, 0] , ibuf aio reads:, log i/o's:, sync i/o's: Pending flushes (fsync) log: 1; buffer pool: 0 1497 OS file reads, 1244 OS file writes, 472 OS fsyncs 0.00 reads/s, 0 avg bytes/read, 0.00 writes/s, 0.00 fsyncs/s ------------------------------------- INSERT BUFFER AND ADAPTIVE HASH INDEX ------------------------------------- Ibuf: size 1, free list len 3, seg size 5, 0 merges merged operations: insert 0, delete mark 0, delete 0 discarded operations: insert 0, delete mark 0, delete 0 Hash table size 4441, node heap has 1 buffer(s) Hash table size 4441, node heap has 2 buffer(s) Hash table size 4441, node heap has 0 buffer(s) Hash table size 4441, node heap has 0 buffer(s) Hash table size 4441, node heap has 1 buffer(s) Hash table size 4441, node heap has 1 buffer(s) Hash table size 4441, node heap has 1 buffer(s) Hash table size 4441, node heap has 0 buffer(s) 0.00 hash searches/s, 0.00 non-hash searches/s --- LOG --- Log sequence number 343365292 Log flushed up to 343365224 Pages flushed up to 343364994 Last checkpoint at 343364699 1 pending log flushes, 0 pending chkp writes 358 log i/o's done, 0.00 log i/o's/second ---------------------- BUFFER POOL AND MEMORY ---------------------- Total large memory allocated 33554432 Dictionary memory allocated 399168 Buffer pool size 1002 Free buffers 740 Database pages 256 Old database pages 0 Modified db pages 3 Percent of dirty pages(LRU & free pages): 0.301 Max dirty pages percent: 75.000 Pending reads 0 Pending writes: LRU 0, flush list 3, single page 0 Pages made young 0, not young 0 0.00 youngs/s, 0.00 non-youngs/s Pages read 1317, created 135, written 849 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: 256, 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 Process ID=3492, Main thread ID=3276, state: making checkpoint Number of rows inserted 0, updated 176, deleted 0, read 5086 0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s Number of system rows inserted 0, updated 0, deleted 0, read 0 0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s ---------------------------- END OF INNODB MONITOR OUTPUT ============================ InnoDB: ###### Diagnostic info printed to the standard error stream 2021-10-07 2:14:42 0 [Warning] InnoDB: A long semaphore wait: --Thread 2520 has waited at row0upd.cc line 3108 for 802.00 seconds the semaphore: X-lock on RW-latch at 000000000EAE3990 created in file buf0buf.cc line 1584 a writer (thread id 0) has reserved it in mode SX number of readers 0, waiters flag 1, lock_word: 10000000 Last time write locked in file buf0flu.cc line 1175 2021-10-07 2:14:42 0 [Note] InnoDB: A semaphore wait: --Thread 2520 has waited at row0upd.cc line 3108 for 802.00 seconds the semaphore: X-lock on RW-latch at 000000000EAE3990 created in file buf0buf.cc line 1584 a writer (thread id 0) has reserved it in mode SX number of readers 0, waiters flag 1, lock_word: 10000000 Last time write locked in file buf0flu.cc line 1175 InnoDB: ###### Starts InnoDB Monitor for 30 secs to print diagnostic info: InnoDB: Pending reads 0, writes 0 ===================================== 2021-10-07 02:14:55 0xd30 INNODB MONITOR OUTPUT ===================================== Per second averages calculated from the last 20 seconds ----------------- BACKGROUND THREAD ----------------- srv_master_thread loops: 49 srv_active, 0 srv_shutdown, 25376 srv_idle srv_master_thread log flush and writes: 25425 ---------- SEMAPHORES ---------- OS WAIT ARRAY INFO: reservation count 293 --Thread 2520 has waited at row0upd.cc line 3108 for 815.00 seconds the semaphore: X-lock on RW-latch at 000000000EAE3990 created in file buf0buf.cc line 1584 a writer (thread id 0) has reserved it in mode SX number of readers 0, waiters flag 1, lock_word: 10000000 Last time write locked in file buf0flu.cc line 1175 OS WAIT ARRAY INFO: signal count 166 RW-shared spins 0, rounds 131, OS waits 65 RW-excl spins 0, rounds 215, OS waits 7 RW-sx spins 1, rounds 30, OS waits 1 Spin rounds per wait: 131.00 RW-shared, 215.00 RW-excl, 30.00 RW-sx ------------ TRANSACTIONS ------------ Trx id counter 1200460 Purge done for trx's n:o < 1200459 undo n:o < 0 state: running but idle History list length 8 LIST OF TRANSACTIONS FOR EACH SESSION: ---TRANSACTION 1200459, ACTIVE 815 sec updating or deleting mysql tables in use 1, locked 1 2 lock struct(s), heap size 1128, 1 row lock(s) MySQL thread id 37, OS thread handle 2520, query id 534 vtigercrmsale fe80::e98a:dfea:59cd:2924%11 vtigerdb Updating UPDATE vtiger_cron_task SET status=2, laststart=1633564880, lastend=0 WHERE id='3' ---TRANSACTION 281475218542784, not started 0 lock struct(s), heap size 1128, 0 row lock(s) -------- FILE I/O -------- I/O thread 0 state: native aio handle (insert buffer thread) I/O thread 1 state: native aio handle (log thread) I/O thread 2 state: native aio handle (read thread) I/O thread 3 state: native aio handle (read thread) I/O thread 4 state: native aio handle (read thread) I/O thread 5 state: native aio handle (read thread) I/O thread 6 state: native aio handle (write thread) I/O thread 7 state: native aio handle (write thread) I/O thread 8 state: native aio handle (write thread) I/O thread 9 state: native aio handle (write thread) Pending normal aio reads: [0, 0, 0, 0] , aio writes: [0, 0, 0, 0] , ibuf aio reads:, log i/o's:, sync i/o's: Pending flushes (fsync) log: 1; buffer pool: 0 1497 OS file reads, 1244 OS file writes, 472 OS fsyncs 0.00 reads/s, 0 avg bytes/read, 0.00 writes/s, 0.00 fsyncs/s ------------------------------------- INSERT BUFFER AND ADAPTIVE HASH INDEX ------------------------------------- Ibuf: size 1, free list len 3, seg size 5, 0 merges merged operations: insert 0, delete mark 0, delete 0 discarded operations: insert 0, delete mark 0, delete 0 Hash table size 4441, node heap has 1 buffer(s) Hash table size 4441, node heap has 2 buffer(s) Hash table size 4441, node heap has 0 buffer(s) Hash table size 4441, node heap has 0 buffer(s) Hash table size 4441, node heap has 1 buffer(s) Hash table size 4441, node heap has 1 buffer(s) Hash table size 4441, node heap has 1 buffer(s) Hash table size 4441, node heap has 0 buffer(s) 0.00 hash searches/s, 0.00 non-hash searches/s --- LOG --- Log sequence number 343365292 Log flushed up to 343365224 Pages flushed up to 343364994 Last checkpoint at 343364699 1 pending log flushes, 0 pending chkp writes 358 log i/o's done, 0.00 log i/o's/second ---------------------- BUFFER POOL AND MEMORY ---------------------- Total large memory allocated 33554432 Dictionary memory allocated 399168 Buffer pool size 1002 Free buffers 740 Database pages 256 Old database pages 0 Modified db pages 3 Percent of dirty pages(LRU & free pages): 0.301 Max dirty pages percent: 75.000 Pending reads 0 Pending writes: LRU 0, flush list 3, single page 0 Pages made young 0, not young 0 0.00 youngs/s, 0.00 non-youngs/s Pages read 1317, created 135, written 849 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: 256, 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 Process ID=3492, Main thread ID=3276, state: making checkpoint Number of rows inserted 0, updated 176, deleted 0, read 5086 0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s Number of system rows inserted 0, updated 0, deleted 0, read 0 0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s ---------------------------- END OF INNODB MONITOR OUTPUT ============================ InnoDB: ###### Diagnostic info printed to the standard error stream 2021-10-07 2:15:13 0 [Warning] InnoDB: A long semaphore wait: --Thread 2520 has waited at row0upd.cc line 3108 for 833.00 seconds the semaphore: X-lock on RW-latch at 000000000EAE3990 created in file buf0buf.cc line 1584 a writer (thread id 0) has reserved it in mode SX number of readers 0, waiters flag 1, lock_word: 10000000 Last time write locked in file buf0flu.cc line 1175 2021-10-07 2:15:13 0 [Note] InnoDB: A semaphore wait: --Thread 2520 has waited at row0upd.cc line 3108 for 833.00 seconds the semaphore: X-lock on RW-latch at 000000000EAE3990 created in file buf0buf.cc line 1584 a writer (thread id 0) has reserved it in mode SX number of readers 0, waiters flag 1, lock_word: 10000000 Last time write locked in file buf0flu.cc line 1175 InnoDB: ###### Starts InnoDB Monitor for 30 secs to print diagnostic info: InnoDB: Pending reads 0, writes 0 ===================================== 2021-10-07 02:15:15 0xd30 INNODB MONITOR OUTPUT ===================================== Per second averages calculated from the last 20 seconds ----------------- BACKGROUND THREAD ----------------- srv_master_thread loops: 49 srv_active, 0 srv_shutdown, 25376 srv_idle srv_master_thread log flush and writes: 25425 ---------- SEMAPHORES ---------- OS WAIT ARRAY INFO: reservation count 293 --Thread 2520 has waited at row0upd.cc line 3108 for 835.00 seconds the semaphore: X-lock on RW-latch at 000000000EAE3990 created in file buf0buf.cc line 1584 a writer (thread id 0) has reserved it in mode SX number of readers 0, waiters flag 1, lock_word: 10000000 Last time write locked in file buf0flu.cc line 1175 OS WAIT ARRAY INFO: signal count 166 RW-shared spins 0, rounds 131, OS waits 65 RW-excl spins 0, rounds 215, OS waits 7 RW-sx spins 1, rounds 30, OS waits 1 Spin rounds per wait: 131.00 RW-shared, 215.00 RW-excl, 30.00 RW-sx ------------ TRANSACTIONS ------------ Trx id counter 1200460 Purge done for trx's n:o < 1200459 undo n:o < 0 state: running but idle History list length 8 LIST OF TRANSACTIONS FOR EACH SESSION: ---TRANSACTION 1200459, ACTIVE 835 sec updating or deleting mysql tables in use 1, locked 1 2 lock struct(s), heap size 1128, 1 row lock(s) MySQL thread id 37, OS thread handle 2520, query id 534 vtigercrmsale fe80::e98a:dfea:59cd:2924%11 vtigerdb Updating UPDATE vtiger_cron_task SET status=2, laststart=1633564880, lastend=0 WHERE id='3' ---TRANSACTION 281475218542784, not started 0 lock struct(s), heap size 1128, 0 row lock(s) -------- FILE I/O -------- I/O thread 0 state: native aio handle (insert buffer thread) I/O thread 1 state: native aio handle (log thread) I/O thread 2 state: native aio handle (read thread) I/O thread 3 state: native aio handle (read thread) I/O thread 4 state: native aio handle (read thread) I/O thread 5 state: native aio handle (read thread) I/O thread 6 state: native aio handle (write thread) I/O thread 7 state: native aio handle (write thread) I/O thread 8 state: native aio handle (write thread) I/O thread 9 state: native aio handle (write thread) Pending normal aio reads: [0, 0, 0, 0] , aio writes: [0, 0, 0, 0] , ibuf aio reads:, log i/o's:, sync i/o's: Pending flushes (fsync) log: 1; buffer pool: 0 1497 OS file reads, 1244 OS file writes, 472 OS fsyncs 0.00 reads/s, 0 avg bytes/read, 0.00 writes/s, 0.00 fsyncs/s ------------------------------------- INSERT BUFFER AND ADAPTIVE HASH INDEX ------------------------------------- Ibuf: size 1, free list len 3, seg size 5, 0 merges merged operations: insert 0, delete mark 0, delete 0 discarded operations: insert 0, delete mark 0, delete 0 Hash table size 4441, node heap has 1 buffer(s) Hash table size 4441, node heap has 2 buffer(s) Hash table size 4441, node heap has 0 buffer(s) Hash table size 4441, node heap has 0 buffer(s) Hash table size 4441, node heap has 1 buffer(s) Hash table size 4441, node heap has 1 buffer(s) Hash table size 4441, node heap has 1 buffer(s) Hash table size 4441, node heap has 0 buffer(s) 0.00 hash searches/s, 0.00 non-hash searches/s --- LOG --- Log sequence number 343365292 Log flushed up to 343365224 Pages flushed up to 343364994 Last checkpoint at 343364699 1 pending log flushes, 0 pending chkp writes 358 log i/o's done, 0.00 log i/o's/second ---------------------- BUFFER POOL AND MEMORY ---------------------- Total large memory allocated 33554432 Dictionary memory allocated 399168 Buffer pool size 1002 Free buffers 740 Database pages 256 Old database pages 0 Modified db pages 3 Percent of dirty pages(LRU & free pages): 0.301 Max dirty pages percent: 75.000 Pending reads 0 Pending writes: LRU 0, flush list 3, single page 0 Pages made young 0, not young 0 0.00 youngs/s, 0.00 non-youngs/s Pages read 1317, created 135, written 849 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: 256, 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 Process ID=3492, Main thread ID=3276, state: making checkpoint Number of rows inserted 0, updated 176, deleted 0, read 5086 0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s Number of system rows inserted 0, updated 0, deleted 0, read 0 0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s ---------------------------- END OF INNODB MONITOR OUTPUT ============================ ===================================== 2021-10-07 02:15:35 0xd30 INNODB MONITOR OUTPUT ===================================== Per second averages calculated from the last 20 seconds ----------------- BACKGROUND THREAD ----------------- srv_master_thread loops: 49 srv_active, 0 srv_shutdown, 25376 srv_idle srv_master_thread log flush and writes: 25425 ---------- SEMAPHORES ---------- OS WAIT ARRAY INFO: reservation count 293 --Thread 2520 has waited at row0upd.cc line 3108 for 855.00 seconds the semaphore: X-lock on RW-latch at 000000000EAE3990 created in file buf0buf.cc line 1584 a writer (thread id 0) has reserved it in mode SX number of readers 0, waiters flag 1, lock_word: 10000000 Last time write locked in file buf0flu.cc line 1175 OS WAIT ARRAY INFO: signal count 166 RW-shared spins 0, rounds 131, OS waits 65 RW-excl spins 0, rounds 215, OS waits 7 RW-sx spins 1, rounds 30, OS waits 1 Spin rounds per wait: 131.00 RW-shared, 215.00 RW-excl, 30.00 RW-sx ------------ TRANSACTIONS ------------ Trx id counter 1200460 Purge done for trx's n:o < 1200459 undo n:o < 0 state: running but idle History list length 8 LIST OF TRANSACTIONS FOR EACH SESSION: ---TRANSACTION 1200459, ACTIVE 855 sec updating or deleting mysql tables in use 1, locked 1 2 lock struct(s), heap size 1128, 1 row lock(s) MySQL thread id 37, OS thread handle 2520, query id 534 vtigercrmsale fe80::e98a:dfea:59cd:2924%11 vtigerdb Updating UPDATE vtiger_cron_task SET status=2, laststart=1633564880, lastend=0 WHERE id='3' ---TRANSACTION 281475218542784, not started 0 lock struct(s), heap size 1128, 0 row lock(s) -------- FILE I/O -------- I/O thread 0 state: native aio handle (insert buffer thread) I/O thread 1 state: native aio handle (log thread) I/O thread 2 state: native aio handle (read thread) I/O thread 3 state: native aio handle (read thread) I/O thread 4 state: native aio handle (read thread) I/O thread 5 state: native aio handle (read thread) I/O thread 6 state: native aio handle (write thread) I/O thread 7 state: native aio handle (write thread) I/O thread 8 state: native aio handle (write thread) I/O thread 9 state: native aio handle (write thread) Pending normal aio reads: [0, 0, 0, 0] , aio writes: [0, 0, 0, 0] , ibuf aio reads:, log i/o's:, sync i/o's: Pending flushes (fsync) log: 1; buffer pool: 0 1497 OS file reads, 1244 OS file writes, 472 OS fsyncs 0.00 reads/s, 0 avg bytes/read, 0.00 writes/s, 0.00 fsyncs/s ------------------------------------- INSERT BUFFER AND ADAPTIVE HASH INDEX ------------------------------------- Ibuf: size 1, free list len 3, seg size 5, 0 merges merged operations: insert 0, delete mark 0, delete 0 discarded operations: insert 0, delete mark 0, delete 0 Hash table size 4441, node heap has 1 buffer(s) Hash table size 4441, node heap has 2 buffer(s) Hash table size 4441, node heap has 0 buffer(s) Hash table size 4441, node heap has 0 buffer(s) Hash table size 4441, node heap has 1 buffer(s) Hash table size 4441, node heap has 1 buffer(s) Hash table size 4441, node heap has 1 buffer(s) Hash table size 4441, node heap has 0 buffer(s) 0.00 hash searches/s, 0.00 non-hash searches/s --- LOG --- Log sequence number 343365292 Log flushed up to 343365224 Pages flushed up to 343364994 Last checkpoint at 343364699 1 pending log flushes, 0 pending chkp writes 358 log i/o's done, 0.00 log i/o's/second ---------------------- BUFFER POOL AND MEMORY ---------------------- Total large memory allocated 33554432 Dictionary memory allocated 399168 Buffer pool size 1002 Free buffers 740 Database pages 256 Old database pages 0 Modified db pages 3 Percent of dirty pages(LRU & free pages): 0.301 Max dirty pages percent: 75.000 Pending reads 0 Pending writes: LRU 0, flush list 3, single page 0 Pages made young 0, not young 0 0.00 youngs/s, 0.00 non-youngs/s Pages read 1317, created 135, written 849 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: 256, 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 Process ID=3492, Main thread ID=3276, state: making checkpoint Number of rows inserted 0, updated 176, deleted 0, read 5086 0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s Number of system rows inserted 0, updated 0, deleted 0, read 0 0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s ---------------------------- END OF INNODB MONITOR OUTPUT ============================ InnoDB: ###### Diagnostic info printed to the standard error stream 2021-10-07 2:15:44 0 [Warning] InnoDB: A long semaphore wait: --Thread 2520 has waited at row0upd.cc line 3108 for 864.00 seconds the semaphore: X-lock on RW-latch at 000000000EAE3990 created in file buf0buf.cc line 1584 a writer (thread id 0) has reserved it in mode SX number of readers 0, waiters flag 1, lock_word: 10000000 Last time write locked in file buf0flu.cc line 1175 2021-10-07 2:15:44 0 [Note] InnoDB: A semaphore wait: --Thread 2520 has waited at row0upd.cc line 3108 for 864.00 seconds the semaphore: X-lock on RW-latch at 000000000EAE3990 created in file buf0buf.cc line 1584 a writer (thread id 0) has reserved it in mode SX number of readers 0, waiters flag 1, lock_word: 10000000 Last time write locked in file buf0flu.cc line 1175 InnoDB: ###### Starts InnoDB Monitor for 30 secs to print diagnostic info: InnoDB: Pending reads 0, writes 0 ===================================== 2021-10-07 02:15:55 0xd30 INNODB MONITOR OUTPUT ===================================== Per second averages calculated from the last 20 seconds ----------------- BACKGROUND THREAD ----------------- srv_master_thread loops: 49 srv_active, 0 srv_shutdown, 25376 srv_idle srv_master_thread log flush and writes: 25425 ---------- SEMAPHORES ---------- OS WAIT ARRAY INFO: reservation count 293 --Thread 2520 has waited at row0upd.cc line 3108 for 875.00 seconds the semaphore: X-lock on RW-latch at 000000000EAE3990 created in file buf0buf.cc line 1584 a writer (thread id 0) has reserved it in mode SX number of readers 0, waiters flag 1, lock_word: 10000000 Last time write locked in file buf0flu.cc line 1175 OS WAIT ARRAY INFO: signal count 166 RW-shared spins 0, rounds 131, OS waits 65 RW-excl spins 0, rounds 215, OS waits 7 RW-sx spins 1, rounds 30, OS waits 1 Spin rounds per wait: 131.00 RW-shared, 215.00 RW-excl, 30.00 RW-sx ------------ TRANSACTIONS ------------ Trx id counter 1200460 Purge done for trx's n:o < 1200459 undo n:o < 0 state: running but idle History list length 8 LIST OF TRANSACTIONS FOR EACH SESSION: ---TRANSACTION 1200459, ACTIVE 875 sec updating or deleting mysql tables in use 1, locked 1 2 lock struct(s), heap size 1128, 1 row lock(s) MySQL thread id 37, OS thread handle 2520, query id 534 vtigercrmsale fe80::e98a:dfea:59cd:2924%11 vtigerdb Updating UPDATE vtiger_cron_task SET status=2, laststart=1633564880, lastend=0 WHERE id='3' ---TRANSACTION 281475218542784, not started 0 lock struct(s), heap size 1128, 0 row lock(s) -------- FILE I/O -------- I/O thread 0 state: native aio handle (insert buffer thread) I/O thread 1 state: native aio handle (log thread) I/O thread 2 state: native aio handle (read thread) I/O thread 3 state: native aio handle (read thread) I/O thread 4 state: native aio handle (read thread) I/O thread 5 state: native aio handle (read thread) I/O thread 6 state: native aio handle (write thread) I/O thread 7 state: native aio handle (write thread) I/O thread 8 state: native aio handle (write thread) I/O thread 9 state: native aio handle (write thread) Pending normal aio reads: [0, 0, 0, 0] , aio writes: [0, 0, 0, 0] , ibuf aio reads:, log i/o's:, sync i/o's: Pending flushes (fsync) log: 1; buffer pool: 0 1497 OS file reads, 1244 OS file writes, 472 OS fsyncs 0.00 reads/s, 0 avg bytes/read, 0.00 writes/s, 0.00 fsyncs/s ------------------------------------- INSERT BUFFER AND ADAPTIVE HASH INDEX ------------------------------------- Ibuf: size 1, free list len 3, seg size 5, 0 merges merged operations: insert 0, delete mark 0, delete 0 discarded operations: insert 0, delete mark 0, delete 0 Hash table size 4441, node heap has 1 buffer(s) Hash table size 4441, node heap has 2 buffer(s) Hash table size 4441, node heap has 0 buffer(s) Hash table size 4441, node heap has 0 buffer(s) Hash table size 4441, node heap has 1 buffer(s) Hash table size 4441, node heap has 1 buffer(s) Hash table size 4441, node heap has 1 buffer(s) Hash table size 4441, node heap has 0 buffer(s) 0.00 hash searches/s, 0.00 non-hash searches/s --- LOG --- Log sequence number 343365292 Log flushed up to 343365224 Pages flushed up to 343364994 Last checkpoint at 343364699 1 pending log flushes, 0 pending chkp writes 358 log i/o's done, 0.00 log i/o's/second ---------------------- BUFFER POOL AND MEMORY ---------------------- Total large memory allocated 33554432 Dictionary memory allocated 399168 Buffer pool size 1002 Free buffers 740 Database pages 256 Old database pages 0 Modified db pages 3 Percent of dirty pages(LRU & free pages): 0.301 Max dirty pages percent: 75.000 Pending reads 0 Pending writes: LRU 0, flush list 3, single page 0 Pages made young 0, not young 0 0.00 youngs/s, 0.00 non-youngs/s Pages read 1317, created 135, written 849 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: 256, 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 Process ID=3492, Main thread ID=3276, state: making checkpoint Number of rows inserted 0, updated 176, deleted 0, read 5086 0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s Number of system rows inserted 0, updated 0, deleted 0, read 0 0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s ---------------------------- END OF INNODB MONITOR OUTPUT ============================ InnoDB: ###### Diagnostic info printed to the standard error stream 2021-10-07 2:16:15 0 [Warning] InnoDB: A long semaphore wait: --Thread 2520 has waited at row0upd.cc line 3108 for 895.00 seconds the semaphore: X-lock on RW-latch at 000000000EAE3990 created in file buf0buf.cc line 1584 a writer (thread id 0) has reserved it in mode SX number of readers 0, waiters flag 1, lock_word: 10000000 Last time write locked in file buf0flu.cc line 1175 2021-10-07 2:16:15 0 [Note] InnoDB: A semaphore wait: --Thread 2520 has waited at row0upd.cc line 3108 for 895.00 seconds the semaphore: X-lock on RW-latch at 000000000EAE3990 created in file buf0buf.cc line 1584 a writer (thread id 0) has reserved it in mode SX number of readers 0, waiters flag 1, lock_word: 10000000 Last time write locked in file buf0flu.cc line 1175 InnoDB: ###### Starts InnoDB Monitor for 30 secs to print diagnostic info: InnoDB: Pending reads 0, writes 0 ===================================== 2021-10-07 02:16:15 0xd30 INNODB MONITOR OUTPUT ===================================== Per second averages calculated from the last 20 seconds ----------------- BACKGROUND THREAD ----------------- srv_master_thread loops: 49 srv_active, 0 srv_shutdown, 25376 srv_idle srv_master_thread log flush and writes: 25425 ---------- SEMAPHORES ---------- OS WAIT ARRAY INFO: reservation count 293 --Thread 2520 has waited at row0upd.cc line 3108 for 895.00 seconds the semaphore: X-lock on RW-latch at 000000000EAE3990 created in file buf0buf.cc line 1584 a writer (thread id 0) has reserved it in mode SX number of readers 0, waiters flag 1, lock_word: 10000000 Last time write locked in file buf0flu.cc line 1175 OS WAIT ARRAY INFO: signal count 166 RW-shared spins 0, rounds 131, OS waits 65 RW-excl spins 0, rounds 215, OS waits 7 RW-sx spins 1, rounds 30, OS waits 1 Spin rounds per wait: 131.00 RW-shared, 215.00 RW-excl, 30.00 RW-sx ------------ TRANSACTIONS ------------ Trx id counter 1200460 Purge done for trx's n:o < 1200459 undo n:o < 0 state: running but idle History list length 8 LIST OF TRANSACTIONS FOR EACH SESSION: ---TRANSACTION 1200459, ACTIVE 895 sec updating or deleting mysql tables in use 1, locked 1 2 lock struct(s), heap size 1128, 1 row lock(s) MySQL thread id 37, OS thread handle 2520, query id 534 vtigercrmsale fe80::e98a:dfea:59cd:2924%11 vtigerdb Updating UPDATE vtiger_cron_task SET status=2, laststart=1633564880, lastend=0 WHERE id='3' ---TRANSACTION 281475218542784, not started 0 lock struct(s), heap size 1128, 0 row lock(s) -------- FILE I/O -------- I/O thread 0 state: native aio handle (insert buffer thread) I/O thread 1 state: native aio handle (log thread) I/O thread 2 state: native aio handle (read thread) I/O thread 3 state: native aio handle (read thread) I/O thread 4 state: native aio handle (read thread) I/O thread 5 state: native aio handle (read thread) I/O thread 6 state: native aio handle (write thread) I/O thread 7 state: native aio handle (write thread) I/O thread 8 state: native aio handle (write thread) I/O thread 9 state: native aio handle (write thread) Pending normal aio reads: [0, 0, 0, 0] , aio writes: [0, 0, 0, 0] , ibuf aio reads:, log i/o's:, sync i/o's: Pending flushes (fsync) log: 1; buffer pool: 0 1497 OS file reads, 1244 OS file writes, 472 OS fsyncs 0.00 reads/s, 0 avg bytes/read, 0.00 writes/s, 0.00 fsyncs/s ------------------------------------- INSERT BUFFER AND ADAPTIVE HASH INDEX ------------------------------------- Ibuf: size 1, free list len 3, seg size 5, 0 merges merged operations: insert 0, delete mark 0, delete 0 discarded operations: insert 0, delete mark 0, delete 0 Hash table size 4441, node heap has 1 buffer(s) Hash table size 4441, node heap has 2 buffer(s) Hash table size 4441, node heap has 0 buffer(s) Hash table size 4441, node heap has 0 buffer(s) Hash table size 4441, node heap has 1 buffer(s) Hash table size 4441, node heap has 1 buffer(s) Hash table size 4441, node heap has 1 buffer(s) Hash table size 4441, node heap has 0 buffer(s) 0.00 hash searches/s, 0.00 non-hash searches/s --- LOG --- Log sequence number 343365292 Log flushed up to 343365224 Pages flushed up to 343364994 Last checkpoint at 343364699 1 pending log flushes, 0 pending chkp writes 358 log i/o's done, 0.00 log i/o's/second ---------------------- BUFFER POOL AND MEMORY ---------------------- Total large memory allocated 33554432 Dictionary memory allocated 399168 Buffer pool size 1002 Free buffers 740 Database pages 256 Old database pages 0 Modified db pages 3 Percent of dirty pages(LRU & free pages): 0.301 Max dirty pages percent: 75.000 Pending reads 0 Pending writes: LRU 0, flush list 3, single page 0 Pages made young 0, not young 0 0.00 youngs/s, 0.00 non-youngs/s Pages read 1317, created 135, written 849 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: 256, 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 Process ID=3492, Main thread ID=3276, state: making checkpoint Number of rows inserted 0, updated 176, deleted 0, read 5086 0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s Number of system rows inserted 0, updated 0, deleted 0, read 0 0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s ---------------------------- END OF INNODB MONITOR OUTPUT ============================ ===================================== 2021-10-07 02:16:35 0xd30 INNODB MONITOR OUTPUT ===================================== Per second averages calculated from the last 20 seconds ----------------- BACKGROUND THREAD ----------------- srv_master_thread loops: 49 srv_active, 0 srv_shutdown, 25376 srv_idle srv_master_thread log flush and writes: 25425 ---------- SEMAPHORES ---------- OS WAIT ARRAY INFO: reservation count 293 --Thread 2520 has waited at row0upd.cc line 3108 for 915.00 seconds the semaphore: X-lock on RW-latch at 000000000EAE3990 created in file buf0buf.cc line 1584 a writer (thread id 0) has reserved it in mode SX number of readers 0, waiters flag 1, lock_word: 10000000 Last time write locked in file buf0flu.cc line 1175 OS WAIT ARRAY INFO: signal count 166 RW-shared spins 0, rounds 131, OS waits 65 RW-excl spins 0, rounds 215, OS waits 7 RW-sx spins 1, rounds 30, OS waits 1 Spin rounds per wait: 131.00 RW-shared, 215.00 RW-excl, 30.00 RW-sx ------------ TRANSACTIONS ------------ Trx id counter 1200460 Purge done for trx's n:o < 1200459 undo n:o < 0 state: running but idle History list length 8 LIST OF TRANSACTIONS FOR EACH SESSION: ---TRANSACTION 1200459, ACTIVE 915 sec updating or deleting mysql tables in use 1, locked 1 2 lock struct(s), heap size 1128, 1 row lock(s) MySQL thread id 37, OS thread handle 2520, query id 534 vtigercrmsale fe80::e98a:dfea:59cd:2924%11 vtigerdb Updating UPDATE vtiger_cron_task SET status=2, laststart=1633564880, lastend=0 WHERE id='3' ---TRANSACTION 281475218542784, not started 0 lock struct(s), heap size 1128, 0 row lock(s) -------- FILE I/O -------- I/O thread 0 state: native aio handle (insert buffer thread) I/O thread 1 state: native aio handle (log thread) I/O thread 2 state: native aio handle (read thread) I/O thread 3 state: native aio handle (read thread) I/O thread 4 state: native aio handle (read thread) I/O thread 5 state: native aio handle (read thread) I/O thread 6 state: native aio handle (write thread) I/O thread 7 state: native aio handle (write thread) I/O thread 8 state: native aio handle (write thread) I/O thread 9 state: native aio handle (write thread) Pending normal aio reads: [0, 0, 0, 0] , aio writes: [0, 0, 0, 0] , ibuf aio reads:, log i/o's:, sync i/o's: Pending flushes (fsync) log: 1; buffer pool: 0 1497 OS file reads, 1244 OS file writes, 472 OS fsyncs 0.00 reads/s, 0 avg bytes/read, 0.00 writes/s, 0.00 fsyncs/s ------------------------------------- INSERT BUFFER AND ADAPTIVE HASH INDEX ------------------------------------- Ibuf: size 1, free list len 3, seg size 5, 0 merges merged operations: insert 0, delete mark 0, delete 0 discarded operations: insert 0, delete mark 0, delete 0 Hash table size 4441, node heap has 1 buffer(s) Hash table size 4441, node heap has 2 buffer(s) Hash table size 4441, node heap has 0 buffer(s) Hash table size 4441, node heap has 0 buffer(s) Hash table size 4441, node heap has 1 buffer(s) Hash table size 4441, node heap has 1 buffer(s) Hash table size 4441, node heap has 1 buffer(s) Hash table size 4441, node heap has 0 buffer(s) 0.00 hash searches/s, 0.00 non-hash searches/s --- LOG --- Log sequence number 343365292 Log flushed up to 343365224 Pages flushed up to 343364994 Last checkpoint at 343364699 1 pending log flushes, 0 pending chkp writes 358 log i/o's done, 0.00 log i/o's/second ---------------------- BUFFER POOL AND MEMORY ---------------------- Total large memory allocated 33554432 Dictionary memory allocated 399168 Buffer pool size 1002 Free buffers 740 Database pages 256 Old database pages 0 Modified db pages 3 Percent of dirty pages(LRU & free pages): 0.301 Max dirty pages percent: 75.000 Pending reads 0 Pending writes: LRU 0, flush list 3, single page 0 Pages made young 0, not young 0 0.00 youngs/s, 0.00 non-youngs/s Pages read 1317, created 135, written 849 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: 256, 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 Process ID=3492, Main thread ID=3276, state: making checkpoint Number of rows inserted 0, updated 176, deleted 0, read 5086 0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s Number of system rows inserted 0, updated 0, deleted 0, read 0 0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s ---------------------------- END OF INNODB MONITOR OUTPUT ============================ InnoDB: ###### Diagnostic info printed to the standard error stream 2021-10-07 2:16:46 0 [Warning] InnoDB: A long semaphore wait: --Thread 2520 has waited at row0upd.cc line 3108 for 926.00 seconds the semaphore: X-lock on RW-latch at 000000000EAE3990 created in file buf0buf.cc line 1584 a writer (thread id 0) has reserved it in mode SX number of readers 0, waiters flag 1, lock_word: 10000000 Last time write locked in file buf0flu.cc line 1175 2021-10-07 2:16:46 0 [Note] InnoDB: A semaphore wait: --Thread 2520 has waited at row0upd.cc line 3108 for 926.00 seconds the semaphore: X-lock on RW-latch at 000000000EAE3990 created in file buf0buf.cc line 1584 a writer (thread id 0) has reserved it in mode SX number of readers 0, waiters flag 1, lock_word: 10000000 Last time write locked in file buf0flu.cc line 1175 InnoDB: ###### Starts InnoDB Monitor for 30 secs to print diagnostic info: InnoDB: Pending reads 0, writes 0 ===================================== 2021-10-07 02:16:55 0xd30 INNODB MONITOR OUTPUT ===================================== Per second averages calculated from the last 20 seconds ----------------- BACKGROUND THREAD ----------------- srv_master_thread loops: 49 srv_active, 0 srv_shutdown, 25376 srv_idle srv_master_thread log flush and writes: 25425 ---------- SEMAPHORES ---------- OS WAIT ARRAY INFO: reservation count 293 --Thread 2520 has waited at row0upd.cc line 3108 for 935.00 seconds the semaphore: X-lock on RW-latch at 000000000EAE3990 created in file buf0buf.cc line 1584 a writer (thread id 0) has reserved it in mode SX number of readers 0, waiters flag 1, lock_word: 10000000 Last time write locked in file buf0flu.cc line 1175 OS WAIT ARRAY INFO: signal count 166 RW-shared spins 0, rounds 131, OS waits 65 RW-excl spins 0, rounds 215, OS waits 7 RW-sx spins 1, rounds 30, OS waits 1 Spin rounds per wait: 131.00 RW-shared, 215.00 RW-excl, 30.00 RW-sx ------------ TRANSACTIONS ------------ Trx id counter 1200460 Purge done for trx's n:o < 1200459 undo n:o < 0 state: running but idle History list length 8 LIST OF TRANSACTIONS FOR EACH SESSION: ---TRANSACTION 1200459, ACTIVE 935 sec updating or deleting mysql tables in use 1, locked 1 2 lock struct(s), heap size 1128, 1 row lock(s) MySQL thread id 37, OS thread handle 2520, query id 534 vtigercrmsale fe80::e98a:dfea:59cd:2924%11 vtigerdb Updating UPDATE vtiger_cron_task SET status=2, laststart=1633564880, lastend=0 WHERE id='3' ---TRANSACTION 281475218542784, not started 0 lock struct(s), heap size 1128, 0 row lock(s) -------- FILE I/O -------- I/O thread 0 state: native aio handle (insert buffer thread) I/O thread 1 state: native aio handle (log thread) I/O thread 2 state: native aio handle (read thread) I/O thread 3 state: native aio handle (read thread) I/O thread 4 state: native aio handle (read thread) I/O thread 5 state: native aio handle (read thread) I/O thread 6 state: native aio handle (write thread) I/O thread 7 state: native aio handle (write thread) I/O thread 8 state: native aio handle (write thread) I/O thread 9 state: native aio handle (write thread) Pending normal aio reads: [0, 0, 0, 0] , aio writes: [0, 0, 0, 0] , ibuf aio reads:, log i/o's:, sync i/o's: Pending flushes (fsync) log: 1; buffer pool: 0 1497 OS file reads, 1244 OS file writes, 472 OS fsyncs 0.00 reads/s, 0 avg bytes/read, 0.00 writes/s, 0.00 fsyncs/s ------------------------------------- INSERT BUFFER AND ADAPTIVE HASH INDEX ------------------------------------- Ibuf: size 1, free list len 3, seg size 5, 0 merges merged operations: insert 0, delete mark 0, delete 0 discarded operations: insert 0, delete mark 0, delete 0 Hash table size 4441, node heap has 1 buffer(s) Hash table size 4441, node heap has 2 buffer(s) Hash table size 4441, node heap has 0 buffer(s) Hash table size 4441, node heap has 0 buffer(s) Hash table size 4441, node heap has 1 buffer(s) Hash table size 4441, node heap has 1 buffer(s) Hash table size 4441, node heap has 1 buffer(s) Hash table size 4441, node heap has 0 buffer(s) 0.00 hash searches/s, 0.00 non-hash searches/s --- LOG --- Log sequence number 343365292 Log flushed up to 343365224 Pages flushed up to 343364994 Last checkpoint at 343364699 1 pending log flushes, 0 pending chkp writes 358 log i/o's done, 0.00 log i/o's/second ---------------------- BUFFER POOL AND MEMORY ---------------------- Total large memory allocated 33554432 Dictionary memory allocated 399168 Buffer pool size 1002 Free buffers 740 Database pages 256 Old database pages 0 Modified db pages 3 Percent of dirty pages(LRU & free pages): 0.301 Max dirty pages percent: 75.000 Pending reads 0 Pending writes: LRU 0, flush list 3, single page 0 Pages made young 0, not young 0 0.00 youngs/s, 0.00 non-youngs/s Pages read 1317, created 135, written 849 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: 256, 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 Process ID=3492, Main thread ID=3276, state: making checkpoint Number of rows inserted 0, updated 176, deleted 0, read 5086 0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s Number of system rows inserted 0, updated 0, deleted 0, read 0 0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s ---------------------------- END OF INNODB MONITOR OUTPUT ============================ ===================================== 2021-10-07 02:17:15 0xd30 INNODB MONITOR OUTPUT ===================================== Per second averages calculated from the last 20 seconds ----------------- BACKGROUND THREAD ----------------- srv_master_thread loops: 49 srv_active, 0 srv_shutdown, 25376 srv_idle srv_master_thread log flush and writes: 25425 ---------- SEMAPHORES ---------- OS WAIT ARRAY INFO: reservation count 293 --Thread 2520 has waited at row0upd.cc line 3108 for 955.00 seconds the semaphore: X-lock on RW-latch at 000000000EAE3990 created in file buf0buf.cc line 1584 a writer (thread id 0) has reserved it in mode SX number of readers 0, waiters flag 1, lock_word: 10000000 Last time write locked in file buf0flu.cc line 1175 OS WAIT ARRAY INFO: signal count 166 RW-shared spins 0, rounds 131, OS waits 65 RW-excl spins 0, rounds 215, OS waits 7 RW-sx spins 1, rounds 30, OS waits 1 Spin rounds per wait: 131.00 RW-shared, 215.00 RW-excl, 30.00 RW-sx ------------ TRANSACTIONS ------------ Trx id counter 1200460 Purge done for trx's n:o < 1200459 undo n:o < 0 state: running but idle History list length 8 LIST OF TRANSACTIONS FOR EACH SESSION: ---TRANSACTION 1200459, ACTIVE 955 sec updating or deleting mysql tables in use 1, locked 1 2 lock struct(s), heap size 1128, 1 row lock(s) MySQL thread id 37, OS thread handle 2520, query id 534 vtigercrmsale fe80::e98a:dfea:59cd:2924%11 vtigerdb Updating UPDATE vtiger_cron_task SET status=2, laststart=1633564880, lastend=0 WHERE id='3' ---TRANSACTION 281475218542784, not started 0 lock struct(s), heap size 1128, 0 row lock(s) -------- FILE I/O -------- I/O thread 0 state: native aio handle (insert buffer thread) I/O thread 1 state: native aio handle (log thread) I/O thread 2 state: native aio handle (read thread) I/O thread 3 state: native aio handle (read thread) I/O thread 4 state: native aio handle (read thread) I/O thread 5 state: native aio handle (read thread) I/O thread 6 state: native aio handle (write thread) I/O thread 7 state: native aio handle (write thread) I/O thread 8 state: native aio handle (write thread) I/O thread 9 state: native aio handle (write thread) Pending normal aio reads: [0, 0, 0, 0] , aio writes: [0, 0, 0, 0] , ibuf aio reads:, log i/o's:, sync i/o's: Pending flushes (fsync) log: 1; buffer pool: 0 1497 OS file reads, 1244 OS file writes, 472 OS fsyncs 0.00 reads/s, 0 avg bytes/read, 0.00 writes/s, 0.00 fsyncs/s ------------------------------------- INSERT BUFFER AND ADAPTIVE HASH INDEX ------------------------------------- Ibuf: size 1, free list len 3, seg size 5, 0 merges merged operations: insert 0, delete mark 0, delete 0 discarded operations: insert 0, delete mark 0, delete 0 Hash table size 4441, node heap has 1 buffer(s) Hash table size 4441, node heap has 2 buffer(s) Hash table size 4441, node heap has 0 buffer(s) Hash table size 4441, node heap has 0 buffer(s) Hash table size 4441, node heap has 1 buffer(s) Hash table size 4441, node heap has 1 buffer(s) Hash table size 4441, node heap has 1 buffer(s) Hash table size 4441, node heap has 0 buffer(s) 0.00 hash searches/s, 0.00 non-hash searches/s --- LOG --- Log sequence number 343365292 Log flushed up to 343365224 Pages flushed up to 343364994 Last checkpoint at 343364699 1 pending log flushes, 0 pending chkp writes 358 log i/o's done, 0.00 log i/o's/second ---------------------- BUFFER POOL AND MEMORY ---------------------- Total large memory allocated 33554432 Dictionary memory allocated 399168 Buffer pool size 1002 Free buffers 740 Database pages 256 Old database pages 0 Modified db pages 3 Percent of dirty pages(LRU & free pages): 0.301 Max dirty pages percent: 75.000 Pending reads 0 Pending writes: LRU 0, flush list 3, single page 0 Pages made young 0, not young 0 0.00 youngs/s, 0.00 non-youngs/s Pages read 1317, created 135, written 849 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: 256, 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 Process ID=3492, Main thread ID=3276, state: making checkpoint Number of rows inserted 0, updated 176, deleted 0, read 5086 0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s Number of system rows inserted 0, updated 0, deleted 0, read 0 0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s ---------------------------- END OF INNODB MONITOR OUTPUT ============================ InnoDB: ###### Diagnostic info printed to the standard error stream 2021-10-07 2:17:16 0 [ERROR] [FATAL] InnoDB: Semaphore wait has lasted > 600 seconds. We intentionally crash the server because it appears to be hung. 211007 2:17:16 [ERROR] mysqld got exception 0x80000003 ; This could be because you hit a bug. It is also possible that this binary or one of the libraries it was linked against is corrupt, improperly built, or misconfigured. This error can also be caused by malfunctioning hardware. To report this bug, see https://mariadb.com/kb/en/reporting-bugs We will try our best to scrape up some info that will hopefully help diagnose the problem, but since we have already crashed, something is definitely wrong and this may fail. Server version: 10.4.13-MariaDB key_buffer_size=67108864 read_buffer_size=524288 max_used_connections=1 max_threads=65537 thread_count=7 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 70208 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. Thread pointer: 0x0 Attempting backtrace. You can use the following information to find out where mysqld died. If you see no messages after this, something went terribly wrong... mysqld.exe!my_parameter_handler() ucrtbase.DLL!raise() ucrtbase.DLL!abort() mysqld.exe!??$_Construct_in_place@PEAU?$_List_node@U?$pair@QEAU_iobuf@@PEAX@std@@PEAX@std@@AEAPEAU12@@std@@YAXAEAPEAU?$_List_node@U?$pair@QEAU_iobuf@@PEAX@std@@PEAX@0@0@Z() mysqld.exe!pthread_dummy() kernel32.dll!BaseThreadInitThunk() ntdll.dll!RtlUserThreadStart() The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains information that should help you find out what is causing the crash. Writing a core file at C:\xampp\mysql\data\ Minidump written to C:\xampp\mysql\data\mysqld.dmp InnoDB: using atomic writes. 2021-10-07 10:02:01 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions 2021-10-07 10:02:01 0 [Note] InnoDB: Uses event mutexes 2021-10-07 10:02:01 0 [Note] InnoDB: Compressed tables use zlib 1.2.11 2021-10-07 10:02:01 0 [Note] InnoDB: Number of pools: 1 2021-10-07 10:02:01 0 [Note] InnoDB: Using SSE2 crc32 instructions 2021-10-07 10:02:01 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M 2021-10-07 10:02:01 0 [Note] InnoDB: Completed initialization of buffer pool 2021-10-07 10:02:02 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=343366366 2021-10-07 10:02:03 0 [Note] InnoDB: Starting final batch to recover 1 pages from redo log. 2021-10-07 10:02:04 0 [Note] InnoDB: 128 out of 128 rollback segments are active. 2021-10-07 10:02:04 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" 2021-10-07 10:02:04 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2021-10-07 10:02:04 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2021-10-07 10:02:04 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB. 2021-10-07 10:02:04 0 [Note] InnoDB: 10.4.13 started; log sequence number 343366750; transaction id 1200469 2021-10-07 10:02:04 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool 2021-10-07 10:02:04 0 [Note] Plugin 'FEEDBACK' is disabled. 2021-10-07 10:02:05 0 [Note] Server socket created on IP: '::'. 2021-10-07 10:02:05 0 [Note] Reading of all Master_info entries succeeded 2021-10-07 10:02:05 0 [Note] Added new Master_info '' to hash table 2021-10-07 10:02:05 0 [Note] C:\xampp\mysql\bin\mysqld.exe: ready for connections. Version: '10.4.13-MariaDB' socket: '' port: 3306 mariadb.org binary distribution 2021-10-07 10:02:06 0 [Note] InnoDB: Buffer pool(s) load completed at 211007 10:02:06