ITPUB论坛-中国最专业的IT技术社区

 找回密码
 注册
查看: 848|回复: 0

update死锁

[复制链接]
论坛徽章:
4
优秀写手
日期:2015-02-12 06:00:15优秀写手
日期:2015-02-11 06:00:14慢羊羊
日期:2015-03-04 14:53:332015年新春福章
日期:2015-03-06 11:58:39
发表于 2017-11-15 16:51 | 显示全部楼层 |阅读模式
本帖最后由 zimeng0 于 2017-11-15 19:59 编辑

遇到一个奇怪的死锁问题,数据库版本是5.6.16的阿里云的RDS,隔离级别:RC。一个update对唯一索引列进行更新,居然先对主键上锁,然后去等待二级索引的锁,然后就造成了死锁。
按照正常的锁逻辑,应该是先对二级索引加锁,然后再去主键加锁才对。

下面是表结构:
2.png

这个是update语句语句:
1.png

下面是innodb报告:
*************************** 1. row ***************************
  Type: InnoDB
  Name:
Status:
=====================================
2017-11-14 19:22:28 7f79b0dbd700 INNODB MONITOR OUTPUT
=====================================
Per second averages calculated from the last 58 seconds
-----------------
BACKGROUND THREAD
-----------------
srv_master_thread loops: 180445 srv_active, 0 srv_shutdown, 230 srv_idle
srv_master_thread log flush and writes: 180675
----------
SEMAPHORES
----------
OS WAIT ARRAY INFO: reservation count 229052
OS WAIT ARRAY INFO: signal count 27646690
Mutex spin waits 75948306, rounds 40461010, OS waits 55569
RW-shared spins 14955205, rounds 36180481, OS waits 116936
RW-excl spins 2249139, rounds 34073812, OS waits 55330
Spin rounds per wait: 0.53 mutex, 2.42 RW-shared, 15.15 RW-excl
------------------------
LATEST DETECTED DEADLOCK
------------------------
2017-11-14 19:17:50 7f77a96fb700
*** (1) TRANSACTION:
TRANSACTION 11494730, ACTIVE 0.061 sec starting index read
mysql tables in use 1, locked 1
LOCK WAIT 3 lock struct(s), heap size 1184, 2 row lock(s)
LOCK BLOCKING MySQL thread id: 34020568 block 50548568
MySQL thread id 50548568, OS thread handle 0x7f79b35e8700, query id 387195101 10.200.172.68 csroot statistics
SELECT
            *
        FROM
            order_info
        WHERE
            order_no = 1584040005404360705 FOR UPDATE
*** (1) WAITING FOR THIS LOCK TO BE GRANTED:
RECORD LOCKS space id 490 page no 26165 n bits 136 index `PRIMARY` of table `cs_ex`.`order_info` trx id 11494730 lock_mode X locks rec but not gap waiting
Record lock, heap no 62 PHYSICAL RECORD: n_fields 22; compact format; info bits 0
0: len 4; hex 000be3bf; asc     ;;
1: len 6; hex 000000af653e; asc     e>;;
2: len 7; hex 70000001582e3c; asc p   X.<;;
3: len 8; hex 15fba3fe08228001; asc      "  ;;
4: len 8; hex 15fb15f291606001; asc      `` ;;
5: len 4; hex 00000001; asc     ;;
6: len 4; hex 80000001; asc     ;;
7: len 3; hex 425443; asc BTC;;
8: len 4; hex 00000001; asc     ;;
9: len 4; hex 00000001; asc     ;;
10: len 15; hex 8000000000000000195e23c3460000; asc          ^# F  ;;
11: len 15; hex 800000000000000000000000000000; asc                ;;
12: len 15; hex 8000000000000000000007cee6c000; asc                ;;
13: len 15; hex 8000000000000000000007cee6c000; asc                ;;
14: len 15; hex 800000000000000000000000000000; asc                ;;
15: len 15; hex 800000000000000000000000000000; asc                ;;
16: len 15; hex 800000000000000000000000000000; asc                ;;
17: len 15; hex 80000000000000000000001e848000; asc                ;;
18: len 4; hex 00000000; asc     ;;
19: len 4; hex 00000001; asc     ;;
20: len 7; hex 999e1cb4710c44; asc     q D;;
21: len 7; hex 999e1cb472033e; asc     r >;;

*** (2) TRANSACTION:
TRANSACTION 11494726, ACTIVE 0.219 sec starting index read
mysql tables in use 1, locked 1
14 lock struct(s), heap size 2936, 46 row lock(s), undo log entries 108
MySQL thread id 34020568, OS thread handle 0x7f77a96fb700, query id 387195345 10.200.172.68 csroot Searching rows for update
UPDATE `order_info` SET quantity_remaining = CASE WHEN (action != 2 OR order_type != 2) THEN
IF(quantity_remaining > 0.0680, quantity_remaining - 0.0680, 0) ELSE quantity_remaining END,
amount_remaining = CASE WHEN (action = 2 AND order_type = 2) THEN IF(amount_remaining > CAST(6494.60
* 0.0680 AS DECIMAL(31, 11)), amount_remaining - CAST(6494.60 * 0.0680 AS DECIMAL(31, 11)),
0) ELSE amount_remaining END, state = CASE WHEN (action = 2 AND order_type = 2) THEN IF(amount_remaining
= 0, 3, 2) ELSE IF(quantity_remaining = 0, 3, 2) END, price_average = CASE WHEN (action = 2
AND order_type = 2) THEN IF(price_average = 0, 6494.60, (amount - amount_remaining) / ((amount
- amount_remaining - 6494.60 * 0.0680) / price_average + 0.0680)) ELSE IF(price_average = 0,
6494.60, (price_average * (quantity - quantity_remaining - 0.0680) + 6494.60 * 0.0680) / (quantity
- quantity_remaining)) END, fee = CASE WHEN action = 2 THEN 6494.60 * 0.0680 * fee_rate ELSE
0.0680 * fee_rate END, utc_update = '2017-11-14 11:17:50' WHERE order_no IN (1584040005943328769,1584040006550454273)
*** (2) HOLDS THE LOCK(S):
RECORD LOCKS space id 490 page no 26165 n bits 136 index `PRIMARY` of table `cs_ex`.`order_info` trx id 11494726 lock_mode X locks rec but not gap
Record lock, heap no 59 PHYSICAL RECORD: n_fields 22; compact format; info bits 0
0: len 4; hex 000be3bc; asc     ;;
1: len 6; hex 000000af6546; asc     eF;;
2: len 7; hex 740000014f1a29; asc t   O );;
3: len 8; hex 15fba3fe06128001; asc         ;;
4: len 8; hex 15fb15f291606001; asc      `` ;;
5: len 4; hex 00000001; asc     ;;
6: len 4; hex 80000001; asc     ;;
7: len 3; hex 425443; asc BTC;;
8: len 4; hex 00000001; asc     ;;
9: len 4; hex 00000001; asc     ;;
10: len 15; hex 8000000000000000195b1dcd650000; asc          [  e  ;;
11: len 15; hex 8000000000000000195b1dcd650000; asc          [  e  ;;
12: len 15; hex 800000000000000000002e7ddb0000; asc           .}   ;;
13: len 15; hex 800000000000000000000000000000; asc                ;;
14: len 15; hex 800000000000000000000000000000; asc                ;;
15: len 15; hex 800000000000000000000000000000; asc                ;;
16: len 15; hex 800000000000000000000017cdc000; asc                ;;
17: len 15; hex 80000000000000000000001e848000; asc                ;;
18: len 4; hex 00000000; asc     ;;
19: len 4; hex 00000003; asc     ;;
20: len 7; hex 999e1cb4710afa; asc     q  ;;
21: len 7; hex 999e1cb47205d2; asc     r  ;;

Record lock, heap no 60 PHYSICAL RECORD: n_fields 22; compact format; info bits 0
0: len 4; hex 000be3bd; asc     ;;
1: len 6; hex 000000af6546; asc     eF;;
2: len 7; hex 740000014f1ef5; asc t   O  ;;
3: len 8; hex 15fba3fe06328001; asc      2  ;;
4: len 8; hex 15fb15edc4e06001; asc       ` ;;
5: len 4; hex 00000001; asc     ;;
6: len 4; hex 80000001; asc     ;;
7: len 3; hex 425443; asc BTC;;
8: len 4; hex 00000001; asc     ;;
9: len 4; hex 00000001; asc     ;;
10: len 15; hex 8000000000000000195b1dcd650000; asc          [  e  ;;
11: len 15; hex 8000000000000000195b1dcd650000; asc          [  e  ;;
12: len 15; hex 80000000000000000000068e778000; asc             w  ;;
13: len 15; hex 800000000000000000000000000000; asc                ;;
14: len 15; hex 800000000000000000000000000000; asc                ;;
15: len 15; hex 800000000000000000000000000000; asc                ;;
16: len 15; hex 8000000000000000000000035b6000; asc             [` ;;
17: len 15; hex 80000000000000000000001e848000; asc                ;;
18: len 4; hex 00000000; asc     ;;
19: len 4; hex 00000003; asc     ;;
20: len 7; hex 999e1cb4710b0e; asc     q  ;;
21: len 7; hex 999e1cb47207ee; asc     r  ;;

Record lock, heap no 61 PHYSICAL RECORD: n_fields 22; compact format; info bits 0
0: len 4; hex 000be3be; asc     ;;
1: len 6; hex 000000af6546; asc     eF;;
2: len 7; hex 740000014f23aa; asc t   O# ;;
3: len 8; hex 15fba3fe06328002; asc      2  ;;
4: len 8; hex 15fb15f291606001; asc      `` ;;
5: len 4; hex 00000001; asc     ;;
6: len 4; hex 80000001; asc     ;;
7: len 3; hex 425443; asc BTC;;
8: len 4; hex 00000001; asc     ;;
9: len 4; hex 00000001; asc     ;;
10: len 15; hex 8000000000000000195b1dcd650000; asc          [  e  ;;
11: len 15; hex 8000000000000000195b1dcd650000; asc          [  e  ;;
12: len 15; hex 800000000000000000000c84588000; asc             X  ;;
13: len 15; hex 800000000000000000000000000000; asc                ;;
14: len 15; hex 800000000000000000000000000000; asc                ;;
15: len 15; hex 800000000000000000000000000000; asc                ;;
16: len 15; hex 80000000000000000000000668a000; asc             h  ;;
17: len 15; hex 80000000000000000000001e848000; asc                ;;
18: len 4; hex 00000000; asc     ;;
19: len 4; hex 00000003; asc     ;;
20: len 7; hex 999e1cb4710b0e; asc     q  ;;
21: len 7; hex 999e1cb4720a0a; asc     r  ;;

Record lock, heap no 62 PHYSICAL RECORD: n_fields 22; compact format; info bits 0
0: len 4; hex 000be3bf; asc     ;;
1: len 6; hex 000000af653e; asc     e>;;
2: len 7; hex 70000001582e3c; asc p   X.<;;
3: len 8; hex 15fba3fe08228001; asc      "  ;;
4: len 8; hex 15fb15f291606001; asc      `` ;;
5: len 4; hex 00000001; asc     ;;
6: len 4; hex 80000001; asc     ;;
7: len 3; hex 425443; asc BTC;;
8: len 4; hex 00000001; asc     ;;
9: len 4; hex 00000001; asc     ;;
10: len 15; hex 8000000000000000195e23c3460000; asc          ^# F  ;;
11: len 15; hex 800000000000000000000000000000; asc                ;;
12: len 15; hex 8000000000000000000007cee6c000; asc                ;;
13: len 15; hex 8000000000000000000007cee6c000; asc                ;;
14: len 15; hex 800000000000000000000000000000; asc                ;;
15: len 15; hex 800000000000000000000000000000; asc                ;;
16: len 15; hex 800000000000000000000000000000; asc                ;;
17: len 15; hex 80000000000000000000001e848000; asc                ;;
18: len 4; hex 00000000; asc     ;;
19: len 4; hex 00000001; asc     ;;
20: len 7; hex 999e1cb4710c44; asc     q D;;
21: len 7; hex 999e1cb472033e; asc     r >;;

Record lock, heap no 65 PHYSICAL RECORD: n_fields 22; compact format; info bits 0
0: len 4; hex 000be3c2; asc     ;;
1: len 6; hex 000000af6546; asc     eF;;
2: len 7; hex 740000014f285f; asc t   O(_;;
3: len 8; hex 15fba3fe26328001; asc     &2  ;;
4: len 8; hex 15fb15f291606001; asc      `` ;;
5: len 4; hex 00000001; asc     ;;
6: len 4; hex 80000001; asc     ;;
7: len 3; hex 425443; asc BTC;;
8: len 4; hex 00000001; asc     ;;
9: len 4; hex 00000001; asc     ;;
10: len 15; hex 8000000000000000195b1dcd650000; asc          [  e  ;;
11: len 15; hex 8000000000000000195b1dcd650000; asc          [  e  ;;
12: len 15; hex 8000000000000000000008f0d18000; asc                ;;
13: len 15; hex 800000000000000000000000000000; asc                ;;
14: len 15; hex 800000000000000000000000000000; asc                ;;
15: len 15; hex 800000000000000000000000000000; asc                ;;
16: len 15; hex 80000000000000000000000493e000; asc                ;;
17: len 15; hex 80000000000000000000001e848000; asc                ;;
18: len 4; hex 00000000; asc     ;;
19: len 4; hex 00000003; asc     ;;
20: len 7; hex 999e1cb4711f0e; asc     q  ;;
21: len 7; hex 999e1cb4720c30; asc     r 0;;

Record lock, heap no 66 PHYSICAL RECORD: n_fields 22; compact format; info bits 0
0: len 4; hex 000be3c3; asc     ;;
1: len 6; hex 000000af6546; asc     eF;;
2: len 7; hex 740000014f293e; asc t   O)>;;
3: len 8; hex 15fba3fe28428001; asc     (B  ;;
4: len 8; hex 15fb15f291006001; asc       ` ;;
5: len 4; hex 00000001; asc     ;;
6: len 4; hex 80000001; asc     ;;
7: len 3; hex 425443; asc BTC;;
8: len 4; hex 00000002; asc     ;;
9: len 4; hex 00000001; asc     ;;
10: len 15; hex 8000000000000000195e23c3460000; asc          ^# F  ;;
11: len 15; hex 8000000000000000195b1dcd650000; asc          [  e  ;;
12: len 15; hex 800000000000000000011bf45f4000; asc             _@ ;;
13: len 15; hex 800000000000000000000d0dacc000; asc                ;;
14: len 15; hex 800000000000000000000000000000; asc                ;;
15: len 15; hex 800000000000000000000000000000; asc                ;;
16: len 15; hex 800000000000000000013878f09000; asc           8x   ;;
17: len 15; hex 80000000000000000000001e848000; asc                ;;
18: len 4; hex 00000000; asc     ;;
19: len 4; hex 00000002; asc     ;;
20: len 7; hex 999e1cb4712058; asc     q X;;
21: len 7; hex 999e1cb4720c30; asc     r 0;;

*** (2) WAITING FOR THIS LOCK TO BE GRANTED:
RECORD LOCKS space id 490 page no 21980 n bits 552 index `uniq_order_no` of table `cs_ex`.`order_info` trx id 11494726 lock_mode X locks rec but not gap waiting
Record lock, heap no 476 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
0: len 8; hex 15fba3fe08228001; asc      "  ;;
1: len 4; hex 000be3bf; asc     ;;

*** WE ROLL BACK TRANSACTION (1)
------------
TRANSACTIONS
------------
Trx id counter 11507195
Purge done for trx's n < 11507195 undo n < 0 state: running but idle
History list length 1505
LIST OF TRANSACTIONS FOR EACH SESSION:
---TRANSACTION 421626890049640, not started
MySQL thread id 17758963, OS thread handle 0x7f79b0dbd700, query id 387875460 10.200.172.70 ex_admin init
show engine innodb status
---TRANSACTION 421626856487016, not started
MySQL thread id 51116028, OS thread handle 0x7f79b3525700, query id 387874278 10.200.172.67 csroot cleaning up
---TRANSACTION 421626499958888, not started
MySQL thread id 16993626, OS thread handle 0x7f79b0d3b700, query id 387871609 10.200.172.67 csroot cleaning up
---TRANSACTION 421626684559464, not started
MySQL thread id 33973911, OS thread handle 0x7f79b79a2700, query id 387866005 10.200.172.67 csroot cleaning up
---TRANSACTION 421626726465640, not started
MySQL thread id 16887846, OS thread handle 0x7f79b7a24700, query id 387871532 10.200.172.95 pltest cleaning up
---TRANSACTION 421626978359400, not started
MySQL thread id 33808597, OS thread handle 0x7f77a9bff700, query id 387821868 10.200.172.68 csroot cleaning up
---TRANSACTION 421626789384296, not started
MySQL thread id 16804056, OS thread handle 0x7f79b48fa700, query id 387875459 10.200.172.68 csroot cleaning up
---TRANSACTION 421626869080168, not started
MySQL thread id 17537759, OS thread handle 0x7f79b7920700, query id 387616098 10.200.172.68 csroot cleaning up
---TRANSACTION 421626751631464, not started
MySQL thread id 50548568, OS thread handle 0x7f79b35e8700, query id 387875445 10.200.172.68 csroot cleaning up
---TRANSACTION 421626684549224, not started
MySQL thread id 51050360, OS thread handle 0x7f79b37f0700, query id 387865491 10.200.172.68 csroot cleaning up
---TRANSACTION 421626806153320, not started
MySQL thread id 17084490, OS thread handle 0x7f79b79e3700, query id 387865587 10.200.172.68 csroot cleaning up
---TRANSACTION 421626911451240, not started
MySQL thread id 33627405, OS thread handle 0x7f77a9b7d700, query id 387874616 10.200.172.68 csroot cleaning up
---TRANSACTION 421626890037352, not started
MySQL thread id 17822530, OS thread handle 0x7f77a9b3c700, query id 387871421 10.200.172.68 csroot cleaning up
---TRANSACTION 421626852331624, not started
MySQL thread id 50348817, OS thread handle 0x7f79b78df700, query id 387865500 10.200.172.68 csroot cleaning up
---TRANSACTION 421626886068328, not started
MySQL thread id 34020568, OS thread handle 0x7f77a96fb700, query id 387875433 10.200.172.68 csroot cleaning up
---TRANSACTION 421626907068520, not started
MySQL thread id 34104417, OS thread handle 0x7f77a9bbe700, query id 387613121 10.200.172.68 csroot cleaning up
---TRANSACTION 421626856482920, not started
MySQL thread id 17403161, OS thread handle 0x7f77a7bbe700, query id 387867957 10.200.172.68 csroot cleaning up
---TRANSACTION 421626699821160, not started
MySQL thread id 16949560, OS thread handle 0x7f79b7961700, query id 387875452 10.200.172.68 csroot cleaning up
---TRANSACTION 421626827118696, not started
MySQL thread id 50408029, OS thread handle 0x7f79b3462700, query id 387617659 10.200.172.68 csroot cleaning up
---TRANSACTION 421626877673576, not started
MySQL thread id 51370842, OS thread handle 0x7f79b36ec700, query id 387875423 10.200.172.68 csroot cleaning up
---TRANSACTION 421626508343400, not started
MySQL thread id 50812381, OS thread handle 0x7f79b3566700, query id 387610991 10.200.172.68 csroot cleaning up
---TRANSACTION 421627262363752, not started
MySQL thread id 17556137, OS thread handle 0x7f79b35a7700, query id 387875436 10.200.172.68 csroot cleaning up
---TRANSACTION 421626818734184, not started
MySQL thread id 33725965, OS thread handle 0x7f79b34a3700, query id 387611556 10.200.172.68 csroot cleaning up
---TRANSACTION 421626495764584, not started
MySQL thread id 34309810, OS thread handle 0x7f79b0dfe700, query id 387617664 10.200.172.68 csroot cleaning up
---TRANSACTION 421626699831400, not started
MySQL thread id 33624733, OS thread handle 0x7f79b4878700, query id 387821849 10.200.172.68 csroot cleaning up
---TRANSACTION 421626827122792, not started
MySQL thread id 17113712, OS thread handle 0x7f77a5fff700, query id 387874984 10.200.172.97 pltest cleaning up
---TRANSACTION 421626667735144, not started
MySQL thread id 17076323, OS thread handle 0x7f79b366a700, query id 387867238 10.200.172.98 pltest cleaning up
---TRANSACTION 421626831564904, not started
MySQL thread id 50504236, OS thread handle 0x7f79b789e700, query id 387872730 10.200.172.96 pltest cleaning up
--------
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
12596 OS file reads, 8734197 OS file writes, 6599550 OS fsyncs
0.00 reads/s, 0 avg bytes/read, 55.84 writes/s, 41.33 fsyncs/s
-------------------------------------
INSERT BUFFER AND ADAPTIVE HASH INDEX
-------------------------------------
Ibuf: size 1, free list len 17, seg size 19, 185 merges
merged operations:
insert 2633, delete mark 159, delete 126
discarded operations:
insert 0, delete mark 0, delete 0
AHI PARTITION 1: Hash table size 1593833, node heap has 1154 buffer(s)
AHI PARTITION 2: Hash table size 1593833, node heap has 465 buffer(s)
AHI PARTITION 3: Hash table size 1593833, node heap has 7 buffer(s)
AHI PARTITION 4: Hash table size 1593833, node heap has 1202 buffer(s)
AHI PARTITION 5: Hash table size 1593833, node heap has 23 buffer(s)
AHI PARTITION 6: Hash table size 1593833, node heap has 567 buffer(s)
AHI PARTITION 7: Hash table size 1593833, node heap has 756 buffer(s)
AHI PARTITION 8: Hash table size 1593833, node heap has 790 buffer(s)
59889.50 hash searches/s, 6881.38 non-hash searches/s
---
LOG
---
Log sequence number 14542854775
Log flushed up to   14542854669
Pages flushed up to 14542834064
Last checkpoint at  14542490479
0 pending log flushes, 0 pending chkp writes
3600372 log i/o's done, 20.84 log i/o's/second
----------------------
BUFFER POOL AND MEMORY
----------------------
Total memory allocated 6609174528; in additional pool allocated 0
Dictionary memory allocated 1137864
Buffer pool size   393216
Free buffers       194866
Database pages     193382
Old database pages 71220
Modified db pages  74
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 39094, not young 195698
0.00 youngs/s, 0.00 non-youngs/s
Pages read 14999, created 178428, written 7421957
0.00 reads/s, 0.57 creates/s, 54.15 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: 193382, unzip_LRU len: 7
I/O sum[22096]:cur[64], unzip sum[0]:cur[0]
----------------------
INDIVIDUAL BUFFER POOL INFO
----------------------
---BUFFER POOL 0
Buffer pool size   49152
Free buffers       23920
Database pages     24592
Old database pages 9057
Modified db pages  7
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 4197, not young 6256
0.00 youngs/s, 0.00 non-youngs/s
Pages read 1826, created 22772, written 1145009
0.00 reads/s, 0.03 creates/s, 8.22 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: 24592, unzip_LRU len: 0
I/O sum[2762]:cur[8], unzip sum[0]:cur[0]
---BUFFER POOL 1
Buffer pool size   49152
Free buffers       24579
Database pages     24001
Old database pages 8839
Modified db pages  5
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 80, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 1710, created 22291, written 300809
0.00 reads/s, 0.10 creates/s, 2.36 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: 24001, unzip_LRU len: 0
I/O sum[2762]:cur[8], unzip sum[0]:cur[0]
---BUFFER POOL 2
Buffer pool size   49152
Free buffers       24216
Database pages     24299
Old database pages 8949
Modified db pages  7
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 10090, not young 37517
0.00 youngs/s, 0.00 non-youngs/s
Pages read 1878, created 22430, written 410184
0.00 reads/s, 0.05 creates/s, 2.40 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: 24299, unzip_LRU len: 0
I/O sum[2762]:cur[8], unzip sum[0]:cur[0]
---BUFFER POOL 3
Buffer pool size   49152
Free buffers       24430
Database pages     24087
Old database pages 8871
Modified db pages  6
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 9448, not young 76286
0.00 youngs/s, 0.00 non-youngs/s
Pages read 1853, created 22243, written 1810559
0.00 reads/s, 0.02 creates/s, 12.84 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: 24087, unzip_LRU len: 7
I/O sum[2762]:cur[8], unzip sum[0]:cur[0]
---BUFFER POOL 4
Buffer pool size   49152
Free buffers       24153
Database pages     24357
Old database pages 8971
Modified db pages  20
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 167, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 2094, created 22263, written 973837
0.00 reads/s, 0.09 creates/s, 6.41 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: 24357, unzip_LRU len: 0
I/O sum[2762]:cur[8], unzip sum[0]:cur[0]
---BUFFER POOL 5
Buffer pool size   49152
Free buffers       24307
Database pages     24236
Old database pages 8926
Modified db pages  5
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 47, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 2002, created 22234, written 1029912
0.00 reads/s, 0.00 creates/s, 7.81 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: 24236, unzip_LRU len: 0
I/O sum[2762]:cur[8], unzip sum[0]:cur[0]
---BUFFER POOL 6
Buffer pool size   49152
Free buffers       24409
Database pages     24110
Old database pages 8879
Modified db pages  12
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 10664, not young 58154
0.00 youngs/s, 0.00 non-youngs/s
Pages read 1806, created 22319, written 854959
0.00 reads/s, 0.09 creates/s, 7.34 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: 24110, unzip_LRU len: 0
I/O sum[2762]:cur[8], unzip sum[0]:cur[0]
---BUFFER POOL 7
Buffer pool size   49152
Free buffers       24852
Database pages     23700
Old database pages 8728
Modified db pages  12
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 4401, not young 17485
0.00 youngs/s, 0.00 non-youngs/s
Pages read 1830, created 21876, written 896688
0.00 reads/s, 0.19 creates/s, 6.76 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: 23700, unzip_LRU len: 0
I/O sum[2762]:cur[8], unzip sum[0]:cur[0]
--------------
ROW OPERATIONS
--------------
0 queries inside InnoDB, 0 queries in queue
18 read views open inside InnoDB
Main thread process no. 111087, id 140152133367552, state: sleeping
Number of rows inserted 12332236, updated 15631372, deleted 123, read 112551443800
35.81 inserts/s, 51.03 updates/s, 0.00 deletes/s, 910343.79 reads/s
----------------------------
END OF INNODB MONITOR OUTPUT
============================






file:///C:\Users\Administrator\AppData\Roaming\Tencent\Users\578668217\QQ\WinTemp\RichOle\1TC{V{MLH{JYZRP05KBW_0F.png



inno2.txt

24.1 KB, 下载次数: 3


您需要登录后才可以回帖 登录 | 注册

本版积分规则

TOP技术积分榜 社区积分榜 徽章 电子杂志 团队 统计 虎吧 老博客 知识索引树 读书频道 积分竞拍 文本模式 帮助
  ITPUB首页 | ITPUB论坛 | 数据库技术 | 企业信息化 | 开发技术 | 微软技术 | 软件工程与项目管理 | IBM技术园地 | 行业纵向讨论 | IT招聘 | IT文档 | IT博客
  ChinaUnix | ChinaUnix博客 | ChinaUnix论坛 | SAP ERP系统
CopyRight 1999-2011 itpub.net All Right Reserved. 北京盛拓优讯信息技术有限公司版权所有 联系我们 网站律师 隐私政策 知识产权声明
京ICP备16024965号 北京市公安局海淀分局网监中心备案编号:11010802021510 广播电视节目制作经营许可证:编号(京)字第1149号
  
快速回复 返回顶部 返回列表