MySQL Forums
Forum List  »  General

Re: Lock wait timeout exceeded; try restarting transaction
Posted by: Harshdeep Khatri
Date: February 23, 2012 04:42PM

Hello Rick,
I am extremely sorry for the delay as I was on leave for some day and resuming operation from today.

As I have describe earlier I was not able connect due to max. connection limit hit this time, I will surely try for next time to collect innodb status log and update you with that. But this problem is not new for us we has also faced same issue in some time before and I was lucky that time to collect innodb status log. I am pasting it over here not sure it will reveal something.

=====================================
110805 20:49:32 INNODB MONITOR OUTPUT
=====================================
Per second averages calculated from the last 39 seconds
-----------------
BACKGROUND THREAD
-----------------
srv_master_thread loops: 45216 1_second, 45216 sleeps, 4074 10_second, 4527 background, 4519 flush
srv_master_thread log flush and writes: 45431
----------
SEMAPHORES
----------
OS WAIT ARRAY INFO: reservation count 4328, signal count 4326
Mutex spin waits 2226, rounds 66780, OS waits 88
RW-shared spins 4199, rounds 125970, OS waits 4086
RW-excl spins 2, rounds 4620, OS waits 153
Spin rounds per wait: 30.00 mutex, 30.00 RW-shared, 2310.00 RW-excl
------------
TRANSACTIONS
------------
Trx id counter CA70B8
Purge done for trx's n:o < CA6512 undo n:o < 0
History list length 2479
LIST OF TRANSACTIONS FOR EACH SESSION:
---TRANSACTION 0, not started, process no 26893, OS thread id 1096079680
MySQL thread id 7441, query id 1793274 ip-10-84-29-62.ec2.internal 10.84.29.62 saas
show engine innodb status
---TRANSACTION CA70B4, not started, process no 26893, OS thread id 1250629952
MySQL thread id 7476, query id 1793248 ip-10-84-29-62.ec2.internal 10.84.29.62 saas
---TRANSACTION CA70B0, not started, process no 26893, OS thread id 1087199552
MySQL thread id 7474, query id 1793115 ip-10-84-29-62.ec2.internal 10.84.29.62 saas
---TRANSACTION CA709F, not started, process no 26893, OS thread id 1253038400
MySQL thread id 7470, query id 1792887 ip-10-84-29-62.ec2.internal 10.84.29.62 saas
---TRANSACTION CA7099, not started, process no 26893, OS thread id 1255045440
MySQL thread id 7469, query id 1792756 ip-10-84-29-62.ec2.internal 10.84.29.62 saas
---TRANSACTION CA6FB3, not started, process no 26893, OS thread id 1253439808
MySQL thread id 7468, query id 1792053 ip-10-84-29-62.ec2.internal 10.84.29.62 saas
---TRANSACTION CA6FB9, not started, process no 26893, OS thread id 1075079488
MySQL thread id 7467, query id 1792238 ip-10-84-29-62.ec2.internal 10.84.29.62 saas
---TRANSACTION 0, not started, process no 26893, OS thread id 1255446848
MySQL thread id 7444, query id 1793221 ip-10-84-29-62.ec2.internal 10.84.29.62 saas
---TRANSACTION CA6D09, not started, process no 26893, OS thread id 1088981312
MySQL thread id 7451, query id 1790367 ip-10-84-29-62.ec2.internal 10.84.29.62 saas
---TRANSACTION 0, not started, process no 26893, OS thread id 1252636992
MySQL thread id 7431, query id 1789902 ip-10-84-29-62.ec2.internal 10.84.29.62 saas
---TRANSACTION CA6CC3, not started, process no 26893, OS thread id 1257453888
MySQL thread id 7428, query id 1789886 ip-10-84-29-62.ec2.internal 10.84.29.62 saas
---TRANSACTION CA6CB8, not started, process no 26893, OS thread id 1256048960
MySQL thread id 7427, query id 1789852 ip-10-84-29-62.ec2.internal 10.84.29.62 saas
---TRANSACTION CA6CB0, not started, process no 26893, OS thread id 1257052480
MySQL thread id 7426, query id 1789760 ip-10-84-29-62.ec2.internal 10.84.29.62 saas
---TRANSACTION 0, not started, process no 26893, OS thread id 1095878976
MySQL thread id 7396, query id 1789614 ip-10-84-29-62.ec2.internal 10.84.29.62 saas
---TRANSACTION CA70A9, not started, process no 26893, OS thread id 1254242624
MySQL thread id 7377, query id 1792960 ip-10-84-29-62.ec2.internal 10.84.29.62 saas
---TRANSACTION C7A9DF, not started, process no 26893, OS thread id 1102051648
MySQL thread id 1, query id 1782343 localhost 127.0.0.1 rdsadmin
flush logs
---TRANSACTION CA70B7, ACTIVE 15 sec, process no 26893, OS thread id 1092639040 starting index read
mysql tables in use 2, locked 2
LOCK WAIT 2 lock struct(s), heap size 376, 1 row lock(s)
MySQL thread id 7368, query id 1793272 ip-10-84-29-62.ec2.internal 10.84.29.62 saas statistics
UPDATE fdtraninfo AS FDTI, fdrentalinfo AS FDRI SET FDTI.statusunkid='4',FDRI.statusunkid='4',FDTI.reservationgauranteeunkid = '6800000000000001' WHERE FDTI.hotel_code='68' AND FDTI.tranunkid = FDRI.tranunkid AND FDRI.statusunkid<>8 AND FDRI.hotel_code='68' AND FDRI.statusunkid!='9' AND FDTI.tranunkid='6800000000000099'
------- TRX HAS BEEN WAITING 15 SEC FOR THIS LOCK TO BE GRANTED:
RECORD LOCKS space id 928 page no 12 n bits 128 index `PRIMARY` of table `saas_20110714`.`fdtraninfo` trx id CA70B7 lock_mode X locks rec but not gap waiting
Record lock, heap no 44 PHYSICAL RECORD: n_fields 51; compact format; info bits 0
0: len 8; hex 8018289060790063; asc ( `y c;;
1: len 6; hex 000000ca6520; asc e ;;
2: len 7; hex 4e000001cc0724; asc N $;;
3: len 4; hex 80000044; asc D;;
4: len 4; hex 800007db; asc ;;
5: len 8; hex 8000124a64fc226f; asc Jd "o;;
6: len 8; hex 8000124a6f1e8130; asc Jo 0;;
7: len 8; hex 8000124a6f3c6970; asc Jo<ip;;
8: len 8; hex 8000124a69359880; asc Ji5 ;;
9: len 4; hex 80000000; asc ;;
10: SQL NULL;
11: SQL NULL;
12: SQL NULL;
13: SQL NULL;
14: SQL NULL;
15: len 8; hex 8018289060790003; asc ( `y ;;
16: len 1; hex 80; asc ;;
17: len 8; hex 8000000000000004; asc ;;
18: SQL NULL;
19: len 4; hex 80000004; asc ;;
20: SQL NULL;
21: len 5; hex 4755455354; asc GUEST;;
22: SQL NULL;
23: len 8; hex 80000000000001fa; asc ;;
24: SQL NULL;
25: SQL NULL;
26: SQL NULL;
27: SQL NULL;
28: SQL NULL;
29: len 8; hex 80000000000001ff; asc ;;
30: len 0; hex ; asc ;;
31: len 2; hex 3636; asc 66;;
32: len 1; hex 38; asc 8;;
33: SQL NULL;
34: SQL NULL;
35: SQL NULL;
36: len 8; hex 801828906079006e; asc ( `y n;;
37: len 8; hex 8018289060790063; asc ( `y c;;
38: SQL NULL;
39: len 8; hex 8018289060790001; asc ( `y ;;
40: SQL NULL;
41: SQL NULL;
42: SQL NULL;
43: len 1; hex 80; asc ;;
44: SQL NULL;
45: len 0; hex ; asc ;;
46: len 8; hex 8018289060790002; asc ( `y ;;
47: SQL NULL;
48: SQL NULL;
49: len 0; hex ; asc ;;
50: len 0; hex ; asc ;;

------------------
---TRANSACTION CA70AD, ACTIVE (PREPARED) 113 sec, process no 26893, OS thread id 1258658112
mysql tables in use 1, locked 1
1 lock struct(s), heap size 376, 0 row lock(s), undo log entries 1
MySQL thread id 7473, query id 1793000 ip-10-84-29-62.ec2.internal 10.84.29.62 saas query end
INSERT INTO sysloginaudittrail (username,hotel_code,software,ip,country,city,success,proxyip,browser) VALUES ('admin','68','FrontDesk','10.59.20.62','NA','NA','1','10.59.20.62, 65.246.84.254, 10.249.81.167','Mozilla/5.0 (Macintosh; U; Intel Mac OS X 10_6_8; en-us) AppleWebKit/533.21.1 (KHTML, like Gecko) Version/5.0.5 Safari/533.21.1')
---TRANSACTION CA709C, ACTIVE (PREPARED) 125 sec, process no 26893, OS thread id 1250830656
mysql tables in use 1, locked 1
1 lock struct(s), heap size 376, 0 row lock(s), undo log entries 1
MySQL thread id 7472, query id 1792855 ip-10-84-29-62.ec2.internal 10.84.29.62 saas query end
INSERT INTO sysloginaudittrail (username,hotel_code,software,ip,country,city,success,proxyip,browser) VALUES ('admin','34','FrontDesk','123.201.81.42','INDIA','SURAT','1','123.201.81.42','Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US) AppleWebKit/534.20 (KHTML, like Gecko) Chrome/11.0.672.2 Safari/534.20')
---TRANSACTION CA6CDE, ACTIVE (PREPARED) 331 sec, process no 26893, OS thread id 1094760768
mysql tables in use 1, locked 1
1 lock struct(s), heap size 376, 0 row lock(s), undo log entries 1
MySQL thread id 7452, query id 1790084 ip-10-84-29-62.ec2.internal 10.84.29.62 saas query end
INSERT INTO sysloginaudittrail (username,hotel_code,software,ip,country,city,success,proxyip,browser) VALUES ('angie','68','FrontDesk','10.59.20.76','NA','NA','1','10.59.20.76, 65.246.84.254, 10.249.81.167','Mozilla/5.0 (Windows NT 6.1; WOW64; rv:5.0) Gecko/20100101 Firefox/5.0')
---TRANSACTION CA6CDD, ACTIVE (PREPARED) 331 sec, process no 26893, OS thread id 1094560064
mysql tables in use 1, locked 1
1 lock struct(s), heap size 376, 0 row lock(s), undo log entries 1
MySQL thread id 7448, query id 1790082 ip-10-84-29-62.ec2.internal 10.84.29.62 saas query end
INSERT INTO sysloginaudittrail (username,hotel_code,software,ip,country,city,success,proxyip,browser) VALUES ('nitesh','21','FrontDesk','123.201.81.42','INDIA','SURAT','1','123.201.81.42, 10.249.81.167','Mozilla/5.0 (Windows NT 5.1) AppleWebKit/534.24 (KHTML, like Gecko) Chrome/11.0.696.68 Safari/534.24')
---TRANSACTION CA6CDC, ACTIVE (PREPARED) 331 sec, process no 26893, OS thread id 1251432768
mysql tables in use 1, locked 1
1 lock struct(s), heap size 376, 0 row lock(s), undo log entries 1
MySQL thread id 7449, query id 1790081 ip-10-84-29-62.ec2.internal 10.84.29.62 saas query end
INSERT INTO sysloginaudittrail (username,hotel_code,software,ip,country,city,success,proxyip,browser) VALUES ('Mirita','68','FrontDesk','10.59.20.73','NA','NA','1','10.59.20.73, 65.246.84.254','Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/534.30 (KHTML, like Gecko) Chrome/12.0.742.122 Safari/534.30')
---TRANSACTION CA6CDB, ACTIVE (PREPARED) 331 sec, process no 26893, OS thread id 1253640512
mysql tables in use 1, locked 1
1 lock struct(s), heap size 376, 0 row lock(s), undo log entries 1
MySQL thread id 7405, query id 1790080 ip-10-84-29-62.ec2.internal 10.84.29.62 saas query end
INSERT INTO sysloginaudittrail (username,hotel_code,software,ip,country,city,success,proxyip,browser) VALUES ('migel','67','FrontDesk','186.15.26.3','COSTA RICA','HEREDIA','0','186.15.26.3, 10.249.81.167','Mozilla/5.0 (Windows NT 5.1) AppleWebKit/534.30 (KHTML, like Gecko) Chrome/12.0.742.122 Safari/534.30')
---TRANSACTION CA6CDA, ACTIVE (PREPARED) 331 sec, process no 26893, OS thread id 1257253184
mysql tables in use 1, locked 1
1 lock struct(s), heap size 376, 0 row lock(s), undo log entries 1
MySQL thread id 7411, query id 1790079 ip-10-84-29-62.ec2.internal 10.84.29.62 saas query end
INSERT INTO sysloginaudittrail (username,hotel_code,software,ip,country,city,success,proxyip,browser) VALUES ('angie','68','FrontDesk','10.59.20.76','NA','NA','1','10.59.20.76, 65.246.84.254','Mozilla/5.0 (Windows NT 6.1; WOW64; rv:5.0) Gecko/20100101 Firefox/5.0')
---TRANSACTION CA6CD9, ACTIVE (PREPARED) 331 sec, process no 26893, OS thread id 1258457408
mysql tables in use 1, locked 1
2 lock struct(s), heap size 376, 1 row lock(s), undo log entries 1
MySQL thread id 7450, query id 1790077 ip-10-84-29-62.ec2.internal 10.84.29.62 saas query end
UPDATE saasconfig.sysuser SET lastview='0' WHERE userunkid='541'
---TRANSACTION CA6CD5, ACTIVE (PREPARED) 331 sec, process no 26893, OS thread id 1095162176
mysql tables in use 1, locked 1
1 lock struct(s), heap size 376, 0 row lock(s), undo log entries 1
MySQL thread id 7446, query id 1790061 ip-10-84-29-62.ec2.internal 10.84.29.62 saas query end
INSERT INTO sysloginaudittrail (username,hotel_code,software,ip,country,city,success,proxyip,browser) VALUES ('carol','55','FrontDesk','115.135.183.60','MALAYSIA','KOTA KINABALU','0','115.135.183.60, 10.249.81.167','Mozilla/5.0 (Windows NT 6.1) AppleWebKit/535.1 (KHTML, like Gecko) Chrome/13.0.772.0 Safari/535.1')
---TRANSACTION CA6CC8, ACTIVE (PREPARED) 381 sec, process no 26893, OS thread id 1102453056
mysql tables in use 1, locked 1
1 lock struct(s), heap size 376, 0 row lock(s), undo log entries 1
MySQL thread id 7440, query id 1789928 ip-10-84-29-62.ec2.internal 10.84.29.62 saas query end
INSERT INTO sysloginaudittrail (username,hotel_code,software,ip,country,city,success,proxyip,browser) VALUES ('carol','55','FrontDesk','115.135.183.60','MALAYSIA','KOTA KINABALU','0','115.135.183.60, 10.249.81.167','Mozilla/5.0 (Windows NT 6.1) AppleWebKit/535.1 (KHTML, like Gecko) Chrome/13.0.772.0 Safari/535.1')
---TRANSACTION CA6CC6, ACTIVE (PREPARED) 848 sec, process no 26893, OS thread id 1255647552
mysql tables in use 1, locked 1
1 lock struct(s), heap size 376, 0 row lock(s), undo log entries 1
MySQL thread id 7433, query id 1789907 ip-10-84-29-62.ec2.internal 10.84.29.62 saas query end
INSERT INTO sysloginaudittrail (username,hotel_code,software,ip,country,city,success,proxyip,browser) VALUES ('admin','34','Configuration','123.201.81.42','INDIA','SURAT','1','123.201.81.42','Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US) AppleWebKit/534.20 (KHTML, like Gecko) Chrome/11.0.672.2 Safari/534.20')
---TRANSACTION CA6CAA, ACTIVE (PREPARED) 961 sec, process no 26893, OS thread id 1100319040
mysql tables in use 1, locked 1
1 lock struct(s), heap size 376, 0 row lock(s), undo log entries 1
MySQL thread id 7425, query id 1789733 ip-10-84-29-62.ec2.internal 10.84.29.62 saas query end
INSERT INTO sysloginaudittrail (username,hotel_code,software,ip,country,city,success,proxyip,browser) VALUES ('Mirita','68','FrontDesk','10.59.20.73','NA','NA','1','10.59.20.73, 65.246.84.254, 10.249.81.167','Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/534.30 (KHTML, like Gecko) Chrome/12.0.742.122 Safari/534.30')
---TRANSACTION CA6CA7, ACTIVE (PREPARED) 1069 sec, process no 26893, OS thread id 1100519744
mysql tables in use 1, locked 1
1 lock struct(s), heap size 376, 0 row lock(s), undo log entries 1
MySQL thread id 7421, query id 1789722 ip-10-84-29-62.ec2.internal 10.84.29.62 saas query end
INSERT INTO sysloginaudittrail (username,hotel_code,software,ip,country,city,success,proxyip,browser) VALUES ('angie','68','FrontDesk','10.59.20.76','NA','NA','1','10.59.20.76, 65.246.84.254','Mozilla/5.0 (Windows NT 6.1; WOW64; rv:5.0) Gecko/20100101 Firefox/5.0')
---TRANSACTION CA6CA4, ACTIVE (PREPARED) 1072 sec, process no 26893, OS thread id 1258056000
mysql tables in use 1, locked 1
1 lock struct(s), heap size 376, 0 row lock(s), undo log entries 1
MySQL thread id 7412, query id 1789718 ip-10-84-29-62.ec2.internal 10.84.29.62 saas query end
INSERT INTO sysloginaudittrail (username,hotel_code,software,ip,country,city,success,proxyip,browser) VALUES ('nitesh','21','Configuration','123.201.81.42','INDIA','SURAT','1','123.201.81.42, 10.249.81.167','Mozilla/5.0 (Windows NT 5.1) AppleWebKit/534.24 (KHTML, like Gecko) Chrome/11.0.696.68 Safari/534.24')
---TRANSACTION CA6CA1, ACTIVE (PREPARED) 1473 sec, process no 26893, OS thread id 1094961472
mysql tables in use 1, locked 1
1 lock struct(s), heap size 376, 0 row lock(s), undo log entries 1
MySQL thread id 7407, query id 1789681 ip-10-84-29-62.ec2.internal 10.84.29.62 saas query end
INSERT INTO sysloginaudittrail (username,hotel_code,software,ip,country,city,success,proxyip,browser) VALUES ('migel','67','FrontDesk','186.15.26.3','COSTA RICA','HEREDIA','0','186.15.26.3, 10.249.81.167','Mozilla/5.0 (Windows NT 5.1) AppleWebKit/534.30 (KHTML, like Gecko) Chrome/12.0.742.122 Safari/534.30')
---TRANSACTION CA6C9F, ACTIVE (PREPARED) 1625 sec, process no 26893, OS thread id 1254844736
mysql tables in use 1, locked 1
2 lock struct(s), heap size 376, 1 row lock(s), undo log entries 1
MySQL thread id 7402, query id 1789671 ip-10-84-29-62.ec2.internal 10.84.29.62 saas query end
UPDATE saasconfig.sysuser SET lastview='1' WHERE userunkid='506'
---TRANSACTION CA6C9D, ACTIVE (PREPARED) 1760 sec, process no 26893, OS thread id 1088780608
mysql tables in use 1, locked 1
1 lock struct(s), heap size 376, 0 row lock(s), undo log entries 1
MySQL thread id 7394, query id 1789594 ip-10-84-29-62.ec2.internal 10.84.29.62 saas query end
INSERT INTO sysloginaudittrail (username,hotel_code,software,ip,country,city,success,proxyip,browser) VALUES ('miguel','67','FrontDesk','186.15.26.3','COSTA RICA','HEREDIA','1','186.15.26.3, 10.249.81.167','Mozilla/5.0 (Windows NT 6.1) AppleWebKit/534.30 (KHTML, like Gecko) Chrome/12.0.742.122 Safari/534.30')
---TRANSACTION CA655C, ACTIVE (PREPARED) 1850 sec, process no 26893, OS thread id 1257654592
mysql tables in use 1, locked 1
1 lock struct(s), heap size 376, 0 row lock(s), undo log entries 1
MySQL thread id 7388, query id 1782718 ip-10-84-29-62.ec2.internal 10.84.29.62 saas query end
INSERT INTO sysloginaudittrail (username,hotel_code,software,ip,country,city,success,proxyip,browser) VALUES ('angie','68','FrontDesk','10.59.20.76','NA','NA','1','10.59.20.76, 65.246.84.254, 10.249.81.167','Mozilla/5.0 (Windows NT 6.1; WOW64; rv:5.0) Gecko/20100101 Firefox/5.0')
---TRANSACTION CA6541, ACTIVE (PREPARED) 2097 sec, process no 26893, OS thread id 1254041920
mysql tables in use 1, locked 1
1 lock struct(s), heap size 376, 0 row lock(s), undo log entries 1
MySQL thread id 7382, query id 1782620 ip-10-84-29-62.ec2.internal 10.84.29.62 saas query end
INSERT INTO sysloginaudittrail (username,hotel_code,software,ip,country,city,success,proxyip,browser) VALUES ('angie','68','FrontDesk','10.59.20.76','NA','NA','1','10.59.20.76, 65.246.84.254, 10.249.81.167','Mozilla/5.0 (Windows NT 6.1; WOW64; rv:5.0) Gecko/20100101 Firefox/5.0')
---TRANSACTION CA6520, ACTIVE (PREPARED) 2209 sec, process no 26893, OS thread id 1257855296
mysql tables in use 2, locked 2
6 lock struct(s), heap size 1248, 10 row lock(s), undo log entries 3
MySQL thread id 7374, query id 1782460 ip-10-84-29-62.ec2.internal 10.84.29.62 saas query end
UPDATE fdtraninfo AS FDTI, fdrentalinfo AS FDRI SET FDTI.statusunkid='4',FDRI.statusunkid='4',FDTI.reservationgauranteeunkid = '6800000000000001' WHERE FDTI.hotel_code='68' AND FDTI.tranunkid = FDRI.tranunkid AND FDRI.statusunkid<>8 AND FDRI.hotel_code='68' AND FDRI.statusunkid!='9' AND FDTI.tranunkid='6800000000000099'
---TRANSACTION CA651E, ACTIVE (PREPARED) 2364 sec, process no 26893, OS thread id 1255848256
mysql tables in use 1, locked 1
2 lock struct(s), heap size 376, 35 row lock(s), undo log entries 1
MySQL thread id 7342, query id 1782410 ip-10-84-29-62.ec2.internal 10.84.29.62 saas query end
DELETE FROM fdnetlock where lockedunkid='6800000000000626' AND tablename='fdtraninfo' AND hotel_code='68' AND sessionid='blvl050191o27fiiordguim9g6'
---TRANSACTION CA651D, ACTIVE (PREPARED) 2367 sec, process no 26893, OS thread id 1088538944
mysql tables in use 1, locked 1
2 lock struct(s), heap size 376, 1 row lock(s), undo log entries 1
MySQL thread id 7340, query id 1782396 ip-10-84-29-62.ec2.internal 10.84.29.62 saas query end
UPDATE hkunit SET statusunkid = NULL WHERE unitunkid='6800000000000013'
--------
FILE I/O
--------
I/O thread 0 state: waiting for i/o request (insert buffer thread)
I/O thread 1 state: waiting for i/o request (log thread)
I/O thread 2 state: waiting for i/o request (read thread)
I/O thread 3 state: waiting for i/o request (read thread)
I/O thread 4 state: waiting for i/o request (read thread)
I/O thread 5 state: waiting for i/o request (read thread)
I/O thread 6 state: waiting for i/o request (write thread)
I/O thread 7 state: waiting for i/o request (write thread)
I/O thread 8 state: waiting for i/o request (write thread)
I/O thread 9 state: waiting for i/o request (write thread)
Pending normal aio reads: 0 [0, 0, 0, 0] , aio writes: 0 [0, 0, 0, 0] ,
ibuf aio reads: 0, log i/o's: 0, sync i/o's: 0
Pending flushes (fsync) log: 0; buffer pool: 0
5250 OS file reads, 64612 OS file writes, 43757 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 8, delete mark 0, delete 0
discarded operations:
insert 0, delete mark 0, delete 0
Hash table size 2645971, node heap has 142 buffer(s)
65.20 hash searches/s, 3.69 non-hash searches/s
---
LOG
---
Log sequence number 731767188
Log flushed up to 731767188
Last checkpoint at 731767188
0 pending log writes, 0 pending chkp writes
24893 log i/o's done, 0.00 log i/o's/second
----------------------
BUFFER POOL AND MEMORY
----------------------
Total memory allocated 1368276992; in additional pool allocated 0
Dictionary memory allocated 1807885
Buffer pool size 81600
Free buffers 77011
Database pages 4447
Old database pages 1650
Modified db pages 0
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 4321, created 126, written 38738
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
LRU len: 4447, 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
1 read views open inside InnoDB
Main thread process no. 26893, id 1218558272, state: waiting for server activity
Number of rows inserted 5988, updated 17455, deleted 1026, read 1245286422
0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 342.71 reads/s
----------------------------
END OF INNODB MONITOR OUTPUT
============================

Options: ReplyQuote




Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.