Untitled
user_7805656
sql
a year ago
24 kB
6
Indexable
Never
MariaDB [(none)]> SHOW ENGINE INNODB STATUS \G *************************** 1. row *************************** Type: InnoDB Name: Status: ===================================== 2023-11-05 00:08:22 0x7f492b768700 INNODB MONITOR OUTPUT ===================================== Per second averages calculated from the last 1 seconds ----------------- BACKGROUND THREAD ----------------- srv_master_thread loops: 9778 srv_active, 0 srv_shutdown, 11755 srv_idle srv_master_thread log flush and writes: 21532 ---------- SEMAPHORES ---------- OS WAIT ARRAY INFO: reservation count 98252 OS WAIT ARRAY INFO: signal count 48814 RW-shared spins 6388, rounds 190164, OS waits 6331 RW-excl spins 168, rounds 3853, OS waits 119 RW-sx spins 20, rounds 579, OS waits 19 Spin rounds per wait: 29.77 RW-shared, 22.93 RW-excl, 28.95 RW-sx ------------ TRANSACTIONS ------------ Trx id counter 5939344 Purge done for trx's n:o < 5939295 undo n:o < 0 state: running History list length 1 LIST OF TRANSACTIONS FOR EACH SESSION: ---TRANSACTION 421433275370632, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421433275324696, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421433275316344, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 5939343, ACTIVE 3 sec starting index read mysql tables in use 3, locked 3 LOCK WAIT 3 lock struct(s), heap size 1128, 2 row lock(s) MySQL thread id 89431, OS thread handle 139952230541056, query id 482317 localhost 127.0.0.1 user_bandarvoucher Sending data SELECT id,user_code,name,email,hp,saldo,password,secret_key,created_at,updated_at,device_id,level,poin,is_blocked from tbl_user where id = 0 or user_code = 'U230710UIMB6374IP' FOR UPDATE ------- TRX HAS BEEN WAITING 3 SEC FOR THIS LOCK TO BE GRANTED: RECORD LOCKS space id 131 page no 24 n bits 664 index user_code of table `tokotopup_bandarvoucher`.`tbl_user` trx id 5939343 lock_mode X waiting Record lock, heap no 6 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 17; hex 5532333037313055494d42363337344950; asc U230710UIMB6374IP;; 1: len 4; hex 8000002d; asc -;; ------------------ ---TRANSACTION 421433275312168, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 5939342, ACTIVE 7 sec starting index read mysql tables in use 3, locked 3 LOCK WAIT 3 lock struct(s), heap size 1128, 2 row lock(s) MySQL thread id 89405, OS thread handle 139952230848256, query id 482213 localhost 127.0.0.1 user_bandarvoucher Sending data SELECT id,user_code,name,email,hp,saldo,password,secret_key,created_at,updated_at,device_id,level,poin,is_blocked from tbl_user where id = 0 or user_code = 'U230710UIMB6374IP' FOR UPDATE ------- TRX HAS BEEN WAITING 7 SEC FOR THIS LOCK TO BE GRANTED: RECORD LOCKS space id 131 page no 24 n bits 664 index user_code of table `tokotopup_bandarvoucher`.`tbl_user` trx id 5939342 lock_mode X waiting Record lock, heap no 6 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 17; hex 5532333037313055494d42363337344950; asc U230710UIMB6374IP;; 1: len 4; hex 8000002d; asc -;; ------------------ ---TRANSACTION 5939341, ACTIVE 7 sec starting index read mysql tables in use 3, locked 3 LOCK WAIT 3 lock struct(s), heap size 1128, 2 row lock(s) MySQL thread id 89404, OS thread handle 139952231155456, query id 482210 localhost 127.0.0.1 user_bandarvoucher Sending data SELECT id,user_code,name,email,hp,saldo,password,secret_key,created_at,updated_at,device_id,level,poin,is_blocked from tbl_user where id = 0 or user_code = 'U230710UIMB6374IP' FOR UPDATE ------- TRX HAS BEEN WAITING 7 SEC FOR THIS LOCK TO BE GRANTED: RECORD LOCKS space id 131 page no 24 n bits 664 index user_code of table `tokotopup_bandarvoucher`.`tbl_user` trx id 5939341 lock_mode X waiting Record lock, heap no 6 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 17; hex 5532333037313055494d42363337344950; asc U230710UIMB6374IP;; 1: len 4; hex 8000002d; asc -;; ------------------ ---TRANSACTION 421433275303816, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421433275299640, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 5939340, ACTIVE 12 sec starting index read mysql tables in use 3, locked 3 LOCK WAIT 3 lock struct(s), heap size 1128, 2 row lock(s) MySQL thread id 89401, OS thread handle 139952231462656, query id 482197 localhost 127.0.0.1 user_bandarvoucher Sending data SELECT id,user_code,name,email,hp,saldo,password,secret_key,created_at,updated_at,device_id,level,poin,is_blocked from tbl_user where id = 0 or user_code = 'U230710UIMB6374IP' FOR UPDATE ------- TRX HAS BEEN WAITING 12 SEC FOR THIS LOCK TO BE GRANTED: RECORD LOCKS space id 131 page no 24 n bits 664 index user_code of table `tokotopup_bandarvoucher`.`tbl_user` trx id 5939340 lock_mode X waiting Record lock, heap no 6 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 17; hex 5532333037313055494d42363337344950; asc U230710UIMB6374IP;; 1: len 4; hex 8000002d; asc -;; ------------------ ---TRANSACTION 5939339, ACTIVE 12 sec starting index read mysql tables in use 3, locked 3 LOCK WAIT 3 lock struct(s), heap size 1128, 2 row lock(s) MySQL thread id 89400, OS thread handle 139952235456256, query id 482194 localhost 127.0.0.1 user_bandarvoucher Sending data SELECT id,user_code,name,email,hp,saldo,password,secret_key,created_at,updated_at,device_id,level,poin,is_blocked from tbl_user where id = 0 or user_code = 'U230710UIMB6374IP' FOR UPDATE ------- TRX HAS BEEN WAITING 12 SEC FOR THIS LOCK TO BE GRANTED: RECORD LOCKS space id 131 page no 24 n bits 664 index user_code of table `tokotopup_bandarvoucher`.`tbl_user` trx id 5939339 lock_mode X waiting Record lock, heap no 6 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 17; hex 5532333037313055494d42363337344950; asc U230710UIMB6374IP;; 1: len 4; hex 8000002d; asc -;; ------------------ ---TRANSACTION 421433275295464, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421433275291288, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421433275287112, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421433275282936, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 5939338, ACTIVE 20 sec starting index read mysql tables in use 3, locked 3 LOCK WAIT 3 lock struct(s), heap size 1128, 2 row lock(s) MySQL thread id 89395, OS thread handle 139953061201664, query id 482168 localhost 127.0.0.1 user_bandarvoucher Sending data SELECT id,user_code,name,email,hp,saldo,password,secret_key,created_at,updated_at,device_id,level,poin,is_blocked from tbl_user where id = 0 or user_code = 'U230710UIMB6374IP' FOR UPDATE ------- TRX HAS BEEN WAITING 20 SEC FOR THIS LOCK TO BE GRANTED: RECORD LOCKS space id 131 page no 24 n bits 664 index user_code of table `tokotopup_bandarvoucher`.`tbl_user` trx id 5939338 lock_mode X waiting Record lock, heap no 6 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 17; hex 5532333037313055494d42363337344950; asc U230710UIMB6374IP;; 1: len 4; hex 8000002d; asc -;; ------------------ ---TRANSACTION 421433275140952, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421433275278760, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 5939337, ACTIVE 22 sec starting index read mysql tables in use 3, locked 3 LOCK WAIT 3 lock struct(s), heap size 1128, 2 row lock(s) MySQL thread id 89368, OS thread handle 139952232384256, query id 482060 localhost 127.0.0.1 user_bandarvoucher Sending data SELECT id,user_code,name,email,hp,saldo,password,secret_key,created_at,updated_at,device_id,level,poin,is_blocked from tbl_user where id = 0 or user_code = 'U230710UIMB6374IP' FOR UPDATE ------- TRX HAS BEEN WAITING 22 SEC FOR THIS LOCK TO BE GRANTED: RECORD LOCKS space id 131 page no 24 n bits 664 index user_code of table `tokotopup_bandarvoucher`.`tbl_user` trx id 5939337 lock_mode X waiting Record lock, heap no 6 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 17; hex 5532333037313055494d42363337344950; asc U230710UIMB6374IP;; 1: len 4; hex 8000002d; asc -;; ------------------ ---TRANSACTION 5939336, ACTIVE 23 sec starting index read mysql tables in use 3, locked 3 LOCK WAIT 3 lock struct(s), heap size 1128, 2 row lock(s) MySQL thread id 89366, OS thread handle 139952237606656, query id 482053 localhost 127.0.0.1 user_bandarvoucher Sending data SELECT id,user_code,name,email,hp,saldo,password,secret_key,created_at,updated_at,device_id,level,poin,is_blocked from tbl_user where id = 0 or user_code = 'U230710UIMB6374IP' FOR UPDATE ------- TRX HAS BEEN WAITING 23 SEC FOR THIS LOCK TO BE GRANTED: RECORD LOCKS space id 131 page no 24 n bits 664 index user_code of table `tokotopup_bandarvoucher`.`tbl_user` trx id 5939336 lock_mode X waiting Record lock, heap no 6 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 17; hex 5532333037313055494d42363337344950; asc U230710UIMB6374IP;; 1: len 4; hex 8000002d; asc -;; ------------------ ---TRANSACTION 421433275274584, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421433275270408, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 5939335, ACTIVE 31 sec starting index read mysql tables in use 3, locked 3 LOCK WAIT 3 lock struct(s), heap size 1128, 2 row lock(s) MySQL thread id 89363, OS thread handle 139952232998656, query id 482040 localhost 127.0.0.1 user_bandarvoucher Sending data SELECT id,user_code,name,email,hp,saldo,password,secret_key,created_at,updated_at,device_id,level,poin,is_blocked from tbl_user where id = 0 or user_code = 'U230707USYX9024MR' FOR UPDATE ------- TRX HAS BEEN WAITING 31 SEC FOR THIS LOCK TO BE GRANTED: RECORD LOCKS space id 131 page no 24 n bits 664 index user_code of table `tokotopup_bandarvoucher`.`tbl_user` trx id 5939335 lock_mode X waiting Record lock, heap no 4 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 17; hex 5532333037303755535958393032344d52; asc U230707USYX9024MR;; 1: len 4; hex 8000002b; asc +;; ------------------ ---TRANSACTION 421433275266232, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421433275262056, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 5939334, ACTIVE 34 sec starting index read mysql tables in use 3, locked 3 LOCK WAIT 3 lock struct(s), heap size 1128, 2 row lock(s) MySQL thread id 89360, OS thread handle 139952238835456, query id 482027 localhost 127.0.0.1 user_bandarvoucher Sending data SELECT id,user_code,name,email,hp,saldo,password,secret_key,created_at,updated_at,device_id,level,poin,is_blocked from tbl_user where id = 0 or user_code = 'U230824WWYB6374AJ' FOR UPDATE ------- TRX HAS BEEN WAITING 34 SEC FOR THIS LOCK TO BE GRANTED: RECORD LOCKS space id 131 page no 45 n bits 656 index user_code of table `tokotopup_bandarvoucher`.`tbl_user` trx id 5939334 lock_mode X waiting Record lock, heap no 515 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 17; hex 553233303832345757594236333734414a; asc U230824WWYB6374AJ;; 1: len 4; hex 80000471; asc q;; ------------------ ---TRANSACTION 5939333, ACTIVE 42 sec starting index read mysql tables in use 3, locked 3 LOCK WAIT 3 lock struct(s), heap size 1128, 2 row lock(s) MySQL thread id 89359, OS thread handle 139952233305856, query id 482023 localhost 127.0.0.1 user_bandarvoucher Sending data SELECT id,user_code,name,email,hp,saldo,password,secret_key,created_at,updated_at,device_id,level,poin,is_blocked from tbl_user where id = 0 or user_code = 'U230710UIMB6374IP' FOR UPDATE ------- TRX HAS BEEN WAITING 42 SEC FOR THIS LOCK TO BE GRANTED: RECORD LOCKS space id 131 page no 24 n bits 664 index user_code of table `tokotopup_bandarvoucher`.`tbl_user` trx id 5939333 lock_mode X waiting Record lock, heap no 6 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 17; hex 5532333037313055494d42363337344950; asc U230710UIMB6374IP;; 1: len 4; hex 8000002d; asc -;; ------------------ ---TRANSACTION 421433275257880, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 5939329, ACTIVE 56 sec 4 lock struct(s), heap size 1128, 3 row lock(s) MySQL thread id 89222, OS thread handle 139952234841856, query id 482163 localhost 127.0.0.1 user_bandarvoucher ---TRANSACTION 421433275253704, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421433275249528, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421433275245352, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421433275241176, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421433275237000, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421433275232824, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421433275228648, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421433275224472, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421433275220296, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421433275216120, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421433275211944, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421433275207768, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421433275203592, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421433275199416, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421433275195240, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421433275191064, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421433275186888, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421433275182712, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421433275178536, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421433275049080, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421433275149304, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421433275174360, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 5939297, ACTIVE 210 sec 4 lock struct(s), heap size 1128, 3 row lock(s) MySQL thread id 88804, OS thread handle 139957953115904, query id 479812 localhost 127.0.0.1 user_bandarvoucher ---TRANSACTION 421433275166008, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 5939296, ACTIVE 220 sec 4 lock struct(s), heap size 1128, 3 row lock(s) MySQL thread id 88802, OS thread handle 139958288013056, query id 479803 localhost 127.0.0.1 user_bandarvoucher ---TRANSACTION 421433275145128, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421433275161832, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421433275153480, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421433275024024, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421433275011496, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421433275136776, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421433275132600, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421433275128424, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421433275124248, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421433275120072, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421433275115896, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421433275111720, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421433275103368, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421433275099192, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421433275095016, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421433275090840, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421433275086664, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421433275082488, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421433275078312, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421433275074136, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421433275069960, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421433275107544, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421433275007320, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421433275061608, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421433275057432, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421433274998968, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421433275065784, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421433275036552, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421433275053256, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421433275044904, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421433275040728, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421433275032376, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421433275028200, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421433275019848, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421433275015672, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421433275003144, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421433274994792, not started 0 lock struct(s), heap size 1128, 0 row lock(s) -------- FILE I/O -------- I/O thread 0 state: waiting for completed aio requests (insert buffer thread) I/O thread 1 state: waiting for completed aio requests (log thread) I/O thread 2 state: waiting for completed aio requests (read thread) I/O thread 3 state: waiting for completed aio requests (read thread) I/O thread 4 state: waiting for completed aio requests (read thread) I/O thread 5 state: waiting for completed aio requests (read thread) I/O thread 6 state: waiting for completed aio requests (write thread) I/O thread 7 state: waiting for completed aio requests (write thread) I/O thread 8 state: waiting for completed aio requests (write thread) I/O thread 9 state: waiting for completed aio requests (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: 0; buffer pool: 0 38309 OS file reads, 256154 OS file writes, 106656 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 0, seg size 2, 7 merges merged operations: insert 7, delete mark 0, delete 0 discarded operations: insert 0, delete mark 0, delete 0 Hash table size 1106407, node heap has 0 buffer(s) Hash table size 1106407, node heap has 1 buffer(s) Hash table size 1106407, node heap has 3 buffer(s) Hash table size 1106407, node heap has 1 buffer(s) Hash table size 1106407, node heap has 166 buffer(s) Hash table size 1106407, node heap has 2 buffer(s) Hash table size 1106407, node heap has 1 buffer(s) Hash table size 1106407, node heap has 2 buffer(s) 0.00 hash searches/s, 0.00 non-hash searches/s --- LOG --- Log sequence number 3084321047 Log flushed up to 3084321047 Pages flushed up to 3084321047 Last checkpoint at 3084321038 0 pending log flushes, 0 pending chkp writes 67616 log i/o's done, 0.00 log i/o's/second ---------------------- BUFFER POOL AND MEMORY ---------------------- Total large memory allocated 4418699264 Dictionary memory allocated 150304 Buffer pool size 262144 Free buffers 223375 Database pages 38593 Old database pages 14229 Modified db pages 0 Percent of dirty pages(LRU & free pages): 0.000 Max dirty pages percent: 75.000 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 15, not young 0 0.00 youngs/s, 0.00 non-youngs/s Pages read 38244, created 349, written 162522 0.00 reads/s, 0.00 creates/s, 0.00 writes/s Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000 Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 38593, unzip_LRU len: 0 I/O sum[0]:cur[0], unzip sum[0]:cur[0] ---------------------- INDIVIDUAL BUFFER POOL INFO ---------------------- ---BUFFER POOL 0 Buffer pool size 65536 Free buffers 55459 Database pages 10013 Old database pages 3697 Modified db pages 0 Percent of dirty pages(LRU & free pages): 0.000 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 9958, created 55, written 44113 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: 10013, unzip_LRU len: 0 I/O sum[0]:cur[0], unzip sum[0]:cur[0] ---BUFFER POOL 1 Buffer pool size 65536 Free buffers 56304 Database pages 9194 Old database pages 3401 Modified db pages 0 Percent of dirty pages(LRU & free pages): 0.000 Max dirty pages percent: 75.000 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 2, not young 0 0.00 youngs/s, 0.00 non-youngs/s Pages read 9166, created 28, written 37553 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: 9194, unzip_LRU len: 0 I/O sum[0]:cur[0], unzip sum[0]:cur[0] ---BUFFER POOL 2 Buffer pool size 65536 Free buffers 55956 Database pages 9538 Old database pages 3511 Modified db pages 0 Percent of dirty pages(LRU & free pages): 0.000 Max dirty pages percent: 75.000 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 7, not young 0 0.00 youngs/s, 0.00 non-youngs/s Pages read 9415, created 123, written 39264 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: 9538, unzip_LRU len: 0 I/O sum[0]:cur[0], unzip sum[0]:cur[0] ---BUFFER POOL 3 Buffer pool size 65536 Free buffers 55656 Database pages 9848 Old database pages 3620 Modified db pages 0 Percent of dirty pages(LRU & free pages): 0.000 Max dirty pages percent: 75.000 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 6, not young 0 0.00 youngs/s, 0.00 non-youngs/s Pages read 9705, created 143, written 41592 0.00 reads/s, 0.00 creates/s, 0.00 writes/s Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000 Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 9848, 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=316801, Main thread ID=139953388611328, state: sleeping Number of rows inserted 14416, updated 12063, deleted 55, read 946836909 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 ============================