MariaDB [videoslots]> SHOW ENGINE INNODB STATUS \G *************************** 1. row *************************** Type: InnoDB Name: Status: ===================================== 2022-10-04 13:37:45 0x7ef994392700 INNODB MONITOR OUTPUT ===================================== Per second averages calculated from the last 8 seconds ----------------- BACKGROUND THREAD ----------------- srv_master_thread loops: 0 srv_active, 0 srv_shutdown, 1114 srv_idle srv_master_thread log flush and writes: 1114 ---------- SEMAPHORES ---------- OS WAIT ARRAY INFO: reservation count 3628 --Thread 139609597216512 has waited at row0ins.cc line 2969 for 3.00 seconds the semaphore: S-lock on RW-latch at 0x7f0648051278 created in file buf0buf.cc line 1221 a writer (thread id 139610418177792) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: f0000000 Last time write locked in file btr0btr.cc line 226 --Thread 139665290487552 has waited at row0ins.cc line 2969 for 0.00 seconds the semaphore: S-lock on RW-latch at 0x7f0648051278 created in file buf0buf.cc line 1221 a writer (thread id 139610418177792) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: f0000000 Last time write locked in file btr0btr.cc line 226 OS WAIT ARRAY INFO: signal count 38839 RW-shared spins 33499, rounds 734508, OS waits 3425 RW-excl spins 19717, rounds 26957, OS waits 118 RW-sx spins 101, rounds 215, OS waits 0 Spin rounds per wait: 21.93 RW-shared, 1.37 RW-excl, 2.13 RW-sx ------------ TRANSACTIONS ------------ Trx id counter 36378388014 Purge done for trx's n:o < 36378116119 undo n:o < 0 state: running History list length 134983 LIST OF TRANSACTIONS FOR EACH SESSION: ---TRANSACTION 421140319293968, ACTIVE 0 sec mysql tables in use 1, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) MySQL thread id 76501, OS thread handle 139665296942848, query id 1678119 172.16.0.144 reader Optimizing SELECT * FROM users_settings WHERE `user_id`=6454480 AND `setting`='balance_limit_exceeded' ---TRANSACTION 421140319285440, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421140319183104, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421140319123408, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421140319264120, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421140319191632, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421140319247064, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421140319097824, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421140319174576, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421140319281176, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 36378387897, ACTIVE 0 sec inserting mysql tables in use 1, locked 1 1 lock struct(s), heap size 1128, 0 row lock(s), undo log entries 1 MySQL thread id 76456, OS thread handle 139665290487552, query id 1677363 172.16.0.43 mastermaestro Update INSERT INTO `actions` SET `actor` ='5221818', `target` ='6926050', `descr` ='test@gmail.com set verified-nid to 1', `tag` ='verified-nid', `actor_username` ='system' ---TRANSACTION 421140319153256, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421140319383512, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 36378386788, ACTIVE 3 sec inserting mysql tables in use 1, locked 1 1 lock struct(s), heap size 1128, 0 row lock(s), undo log entries 1 MySQL thread id 76216, OS thread handle 139609597216512, query id 1673158 172.16.0.201 mastermaestro Update INSERT INTO `actions` SET `actor` ='5221818', `target` ='6723630', `descr` ='Trophy Awarded: test_test', `tag` ='trophy_awarded', `actor_username` ='system' ---TRANSACTION 421140319323816, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 36378384337, ACTIVE 14 sec inserting mysql tables in use 1, locked 1 1 lock struct(s), heap size 1128, 0 row lock(s), undo log entries 1 MySQL thread id 75420, OS thread handle 139610418177792, query id 1658346 172.16.0.215 mastermaestro Update INSERT INTO `actions` SET `actor` ='6399000', `target` ='6399000', `descr` ='test@icloud.com set test_mobile_search_filter_selection to {\"start_format\":\"all\",\"category\":\"test\",\"status\":\"all\",\"str_search\":\"\"}', `tag` ='test_mobile_search_filter_selection', `actor_username` ='test@icloud.com' ---TRANSACTION 421140319374984, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421140319221480, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421140319234272, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421140319217216, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421140319289704, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421140319366456, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421140319370720, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421140319272648, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421140319119144, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421140319242800, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421140319208688, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421140319212952, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421140319187368, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421140319255592, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421140319238536, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421140319259856, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421140319230008, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421140319157520, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421140319114880, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421140319178840, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421140319204424, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421140319225744, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421140319170312, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421140319136200, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421140319110616, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421140319080768, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421140319046656, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421140319251328, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421140319268384, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421140319195896, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421140319127672, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421140319102088, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421140319200160, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421140319161784, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421140319042392, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421140319038128, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421140319055184, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421140319131936, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421140319072240, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421140319093560, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421140319106352, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421140319089296, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421140318995488, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421140319033864, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421140319144728, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421140318978432, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421140319059448, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421140319148992, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421140319063712, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421140319004016, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421140319166048, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421140319076504, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421140318986960, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421140319008280, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421140318982696, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421140319016808, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421140319067976, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421140319050920, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421140319140464, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421140319085032, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421140319025336, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421140319021072, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421140319029600, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421140319012544, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421140318999752, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421140318991224, ACTIVE 1083 sec mysql tables in use 1, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) MySQL thread id 1006, OS thread handle 139610399344384, query id 26512 172.16.0.36 reader Sending data SELECT /*!40001 SQL_NO_CACHE */ * FROM `actions` Trx read view will not see trx with id >= 36378116118, sees < 36378116118 ---TRANSACTION 421140318974168, not started 0 lock struct(s), heap size 1128, 0 row lock(s) -------- FILE I/O -------- Pending normal aio reads: Pending flushes (fsync) log: 0; buffer pool: 0 3233415 OS file reads, 32702 OS file writes, 2905 OS fsyncs 1321.08 reads/s, 16380 avg bytes/read, 67.99 writes/s, 11.25 fsyncs/s ------------------------------------- INSERT BUFFER AND ADAPTIVE HASH INDEX ------------------------------------- Ibuf: size 109501, free list len 128055, seg size 237557, 1098 merges merged operations: insert 13477, delete mark 93, delete 43 discarded operations: insert 3618, delete mark 0, delete 0 0.00 hash searches/s, 25451.82 non-hash searches/s --- LOG --- Log sequence number 9811127358425 Log flushed up to 9811127342033 Pages flushed up to 9811102532652 Last checkpoint at 9811102532652 0 pending log flushes, 0 pending chkp writes 2091 log i/o's done, 2.00 log i/o's/second ---------------------- BUFFER POOL AND MEMORY ---------------------- Total large memory allocated 54223962112 Dictionary memory allocated 318979584 Buffer pool size 3226000 Free buffers 0 Database pages 3226000 Old database pages 1190828 Modified db pages 6217 Percent of dirty pages(LRU & free pages): 0.193 Max dirty pages percent: 90.000 Pending reads 0 Pending writes: LRU 0, flush list 0 Pages made young 18561, not young 194147 571.55 youngs/s, 18859.39 non-youngs/s Pages read 3232029, created 7867, written 31280 1321.08 reads/s, 3.25 creates/s, 63.99 writes/s Buffer pool hit rate 992 / 1000, young-making rate 3 / 1000 not 102 / 1000 Pages read ahead 0.00/s, evicted without access 873.14/s, Random read ahead 0.00/s LRU len: 3226000, unzip_LRU len: 0 I/O sum[13588]:cur[11082], unzip sum[0]:cur[0] -------------- ROW OPERATIONS -------------- 1 read views open inside InnoDB Process ID=0, Main thread ID=0, state: sleeping Number of rows inserted 14829, updated 120060, deleted 21, read 460135262 13.00 inserts/s, 107.11 updates/s, 0.00 deletes/s, 396931.63 reads/s Number of system rows inserted 0, updated 0, deleted 0, read 1 0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s ---------------------------- END OF INNODB MONITOR OUTPUT ============================ 1 row in set (0.001 sec) MariaDB [videoslots]> MariaDB [videoslots]> notee