Mysql 数据库锁
Summary: Author: 张亚飞 | Read Time: 46 minute read | Published: 2018-06-13
Filed under
—
Categories:
Linux
—
Tags:
Note,
数据库锁
数据类型
char(m)
: 定长类型,非Union
编码,字母数字占用1个字节,汉字占用2个字节,不足使用空格不全;适合定长字段,速度快,不定长字段浪费空间;最大长度:256;
varchar(m)
: 可变长类型,代表最多可存储m个字符;最大长度(2*2e16-1=65532);
text(m)
: 可变长类型,代表最多可存储m个字符;最大长度(2*2e16-1=65532);
blog(m)
: 可变长类型,代表最多可存储m个字符;适合存储图片文件等二进制文件,不常用,最大长度(2*2e16-1=65532);
TINYTEXT
: 最大长度(2*2e8-1=65532);
TINYTEXT
: 最大长度(2*2e16-1=65532);
MEDIUMTEXT
: 最大长度(2*2e32-1=65532);
LARGETEXT
: 最大长度(2*2e64-1=65532);
设置区分大小写:
varchar
写入数据超长还是截断,通过Mysql
配置;
- 查看 Mysql 存储引擎
SHOW ENGINES
- 乐观锁: 见共享锁,数据加一个版本,读取数据时把版本一并读出来,如果数据被修改,则更新版本号,已读写入的时候判断版本号是否更新过;
1、数据库表设计三个字段,分别是id,value、version
select id,value,version from TABLE where id=#{id}
2、每次更新表中的value字段时,为了防止发生冲突,需要这样操作
update TABLE set value=2,version=version+1 where id=#{id} and version=#{version};
- 悲观锁:
悲观锁就是在操作数据时,认为此操作会出现数据冲突,所以在进行每次操作时都要通过获取锁才能进行对相同数据的操作,悲观锁是数据库已经实现了的,有现成的语句;
说到这里,由悲观锁涉及到的另外两个锁概念就出来了,它们就是共享锁与排它锁。共享锁和排它锁是悲观锁的不同的实现,它俩都属于悲观锁的范畴。
悲观锁(共享锁): 读锁,允许多个进程同时读;
悲观锁(排他锁): 写锁,只有一个进程可写,其它进程不可写也不可读;
set autocommit=0;
# 设置完autocommit后,我们就可以执行我们的正常业务了。具体如下:
# 1. 开始事务
begin;/begin work;/start transaction; (三者选一就可以)
# 2. 查询表信息
select status from TABLE where id=1 for update;
# 3. 插入一条数据
insert into TABLE (id,value) values (2,2);
# 4. 修改数据为
update TABLE set value=2 where id=1;
# 5. 提交事务
commit;/commit work;
- 死锁: 两个进程相互加锁未释放,造成相互等待,不通过外力无法解决;
- 行锁: 加锁时查询条件包含索引;
- 表锁: 加锁时查询条件不包含索引;
锁
MySQL/InnoDB中,乐观锁、悲观锁、共享锁、排它锁、行锁、表锁、死锁概念的理解
测试表
DROP TABLE IF EXISTS `working`;
CREATE TABLE `working`
(
`id` int(11) NOT NULL,
`name` varchar(50) COLLATE utf8_bin NOT NULL,
`info` varchar(50) COLLATE utf8mb4_bin NOT NULL COMMENT '区分大小写',
`content` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '不区分大小写',
`extends` text COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '扩展信息',
`version` int(11) NOT NULL DEFAULT '0',
`created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY (`id`)
) ENGINE = InnoDB
DEFAULT CHARSET = utf8
COLLATE = utf8_bin;
# Clear...
DELETE
FROM `working`
WHERE `working`.`id` BETWEEN 1 AND 10000;
# Faker...
INSERT INTO `working` (`id`, `name`, `info`, `content`, `extends`, `version`, `created_at`)
VALUES (1, '商墅物流:(1)', 'ABCDEFG12345', 'ABCDEFG12345', '', 0, NOW()),
(2, '商墅物流:(2)', '别墅111111111', 'ABCDEFG12345', '', 0, NOW()),
(3, '商墅物流:(3)', 'ABCDEFG12345', 'ABCDEFG12345', '', 0, NOW()),
(4, '商墅物流:(4)', '大家222222222', 'ABCDEFG12345', '', 0, NOW()),
(5, '商墅物流:(5)', 'ABCDEFG12345', 'ABCDEFG12345', '', 0, NOW()),
(6, '商墅物流:(6)', 'ABCDEFG12345', 'ABCDEFG12345', '', 0, NOW()),
(7, '商墅物流:(7)', 'ABcdEFG12345', 'ABcdEFG12345', '', 0, NOW()),
(8, '商墅物流:(8)', 'abcdefg12345', 'abcdefg12345', '', 0, NOW()),
(9, '商墅物流:(9)', 'ABCDEFG12345', 'ABCDEFG12345', '', 0, NOW()),
(10, '商墅物流:(10)', 'ABCDEFG123', 'ABCDEFG12345', '', 0, NOW());
字符集配置MySQL查询对大小写不敏感
*_bin
: 表示的是binary case sensitive collation
,也就是说是区分大小写的
*_cs
: case sensitive collation
,区分大小写
*_ci
: case insensitive collation
,不区分大小写
测试是否大小写敏感
大小写敏感(utf8mb4_bin)
SELECT *
FROM working
WHERE info LIKE '%bcd%';
大小写不敏感(utf8mb4_unicode_ci)
SELECT *
FROM working
WHERE content LIKE '%bcd%';
强制大小写敏感
SELECT *
FROM working
WHERE binary content LIKE '%bcd%';
共享锁
关闭自动提交
set autocommit = 0;
打开第一个查询窗口
begin;
SELECT *
from working
where id = 1 lock in share mode;
打开另一个查询窗口
update working
set name="www.iirii.com"
where id = 1;
加上共享锁后,对于update
,insert
,delete
语句会自动加排它锁
- 排他锁: 写锁,只有一个进程可写,其它进程不可写也不可读;
SELECT *
from working
where id = 1 for
update
- 表锁
只有通过索引条件检索数据,
InnoDB
才使用行级锁,否则,InnoDB
将使用表锁!
乐观锁: 见共享锁,如果数据被修改,则重新读取
共享锁: 读锁,允许多个进程同时读;
死锁: 是指两个或两个以上的进程在执行过程中,因争夺资源而造成的一种互相等待的现象,不通过外力无法解决;
第一种:
1.查询是否锁表
show OPEN TABLES where In_use > 0;
2.查询进程(如果您有SUPER权限,您可以看到所有线程。否则,您只能看到您自己的线程)
show processlist
3.杀死进程id(就是上面命令的id列)
kill id
第二种:
1.查看当前的事务
SELECT * FROM INFORMATION_SCHEMA.INNODB_TRX;
2.查看当前锁定的事务
SELECT * FROM INFORMATION_SCHEMA.INNODB_LOCKS;
3.查看当前等锁的事务
SELECT * FROM INFORMATION_SCHEMA.INNODB_LOCK_WAITS;
杀死进程
kill 进程ID
Mysql 死锁问题
SQLSTATE[40001]: Serialization failure: 1213 Deadlock found when trying to get lock; try restarting transaction
首先确认是否打开开关 innodb_status_output_locks
SHOW VARIABLES LIKE '%innodb_status_output_locks%';
SET GLOBAL innodb_status_output_locks=ON;
查看死锁产生原因
> SHOW ENGINE INNODB STATUS;
=====================================
2022-09-22 11:07:34 7f9c70cb2700 INNODB MONITOR OUTPUT
=====================================
Per second averages calculated from the last 13 seconds
-----------------
BACKGROUND THREAD
-----------------
srv_master_thread loops: 46814078 srv_active, 0 srv_shutdown, 584 srv_idle
srv_master_thread log flush and writes: 46814657
----------
SEMAPHORES
----------
OS WAIT ARRAY INFO: reservation count 11468443
OS WAIT ARRAY INFO: reservation count 11468444
OS WAIT ARRAY INFO: reservation count 11468444
OS WAIT ARRAY INFO: reservation count 11468444
OS WAIT ARRAY INFO: reservation count 11468444
OS WAIT ARRAY INFO: reservation count 11468443
OS WAIT ARRAY INFO: reservation count 11468443
OS WAIT ARRAY INFO: reservation count 11468443
OS WAIT ARRAY INFO: reservation count 11468443
OS WAIT ARRAY INFO: reservation count 11468443
OS WAIT ARRAY INFO: reservation count 11468443
OS WAIT ARRAY INFO: reservation count 11468443
OS WAIT ARRAY INFO: reservation count 11468443
OS WAIT ARRAY INFO: reservation count 11468443
OS WAIT ARRAY INFO: reservation count 11468443
OS WAIT ARRAY INFO: reservation count 11468443
OS WAIT ARRAY INFO: signal count 208545648
Mutex spin waits 14959988035, rounds 34400472947, OS waits 148395014
RW-shared spins 182065156, rounds 1576187180, OS waits 30837634
RW-excl spins 157649352, rounds 737583204, OS waits 2482448
Spin rounds per wait: 16.58 mutex, 8.66 RW-shared, 4.68 RW-excl
------------------------
LATEST DETECTED DEADLOCK
------------------------
2022-09-22 10:02:57 7f9c705d7700
*** (1) TRANSACTION:
TRANSACTION 9023189510, ACTIVE 0.005 sec fetching rows
mysql tables in use 1, locked 1
LOCK WAIT 30 lock struct(s), heap size 6544, 3 row lock(s)
LOCK BLOCKING MySQL thread id: 836393190 block 1104860300
MySQL thread id 1104860300, OS thread handle 0x7f9d0b16f700, query id 115417531156 172.17.1.6 p_all_rw Searching rows for update
UPDATE
partner_product_app
SET
tc_app_id = '1400429076',
tc_app_key = '822175ae60ab175c18e79ee49734f66c1bbc068f6cacb5193e5659df738179a6'
WHERE
super_partner_id = '58083585'
*** (1) WAITING FOR THIS LOCK TO BE GRANTED:
RECORD LOCKS space id 2696 page no 32 n bits 128 index `PRIMARY` of table `baijiacloud`.`partner_product_app` trx id 9023189510 lock_mode X locks rec but not gap waiting
Record lock, heap no 33 PHYSICAL RECORD: n_fields 16; compact format; info bits 0
0: len 8; hex 00000000000016df; asc ;;
1: len 6; hex 000219d2f202; asc ;;
2: len 7; hex 0e000000132bc2; asc + ;;
3: len 8; hex 0000000003764901; asc vI ;;
4: len 8; hex 0000000003764201; asc vB ;;
5: len 1; hex 02; asc ;;
6: len 30; hex 5341536c6d71574f326546783730633971497a54646c6e764b4e4b764a5a; asc SASlmqWO2eFx70c9qIzTdlnvKNKvJZ; (total 32 bytes);
7: len 30; hex 713774427256383163794c496230725350305a724f4e6841796530697643; asc q7tBrV81cyLIb0rSP0ZrONhAye0ivC; (total 32 bytes);
8: len 1; hex 01; asc ;;
9: len 30; hex 5341536d4a50414f6b5959425438736c767666794971344a324c4b574e49; asc SASmJPAOkYYBT8slvvfyIq4J2LKWNI; (total 32 bytes);
10: len 30; hex 6a727a426d666472596a6748314969314d69346a30463061767737673036; asc jrzBmfdrYjgH1Ii1Mi4j0F0avw7g06; (total 32 bytes);
11: len 10; hex 31343030343239303736; asc 1400429076;;
12: len 30; hex 383232313735616536306162313735633138653739656534393733346636; asc 822175ae60ab175c18e79ee49734f6; (total 64 bytes);
13: len 4; hex 6165923d; asc ae =;;
14: len 4; hex 6165923d; asc ae =;;
15: len 1; hex 01; asc ;;
*** (2) TRANSACTION:
TRANSACTION 9023189509, ACTIVE 0.009 sec fetching rows
mysql tables in use 1, locked 1
111 lock struct(s), heap size 13864, 2 row lock(s)
MySQL thread id 836393190, OS thread handle 0x7f9c705d7700, query id 115417531161 172.17.0.217 p_all_rw Searching rows for update
UPDATE `partner_product_app` SET `blive_app_env` = '1' WHERE vrtc_app_id IN ('SASlmqWO2eFx70c9qIzTdlnvKNKvJZgn') OR trtc_app_id IN ('SASlmqWO2eFx70c9qIzTdlnvKNKvJZgn')
*** (2) HOLDS THE LOCK(S):
RECORD LOCKS space id 2696 page no 32 n bits 128 index `PRIMARY` of table `baijiacloud`.`partner_product_app` trx id 9023189509 lock_mode X locks rec but not gap
Record lock, heap no 33 PHYSICAL RECORD: n_fields 16; compact format; info bits 0
0: len 8; hex 00000000000016df; asc ;;
1: len 6; hex 000219d2f202; asc ;;
2: len 7; hex 0e000000132bc2; asc + ;;
3: len 8; hex 0000000003764901; asc vI ;;
4: len 8; hex 0000000003764201; asc vB ;;
5: len 1; hex 02; asc ;;
6: len 30; hex 5341536c6d71574f326546783730633971497a54646c6e764b4e4b764a5a; asc SASlmqWO2eFx70c9qIzTdlnvKNKvJZ; (total 32 bytes);
7: len 30; hex 713774427256383163794c496230725350305a724f4e6841796530697643; asc q7tBrV81cyLIb0rSP0ZrONhAye0ivC; (total 32 bytes);
8: len 1; hex 01; asc ;;
9: len 30; hex 5341536d4a50414f6b5959425438736c767666794971344a324c4b574e49; asc SASmJPAOkYYBT8slvvfyIq4J2LKWNI; (total 32 bytes);
10: len 30; hex 6a727a426d666472596a6748314969314d69346a30463061767737673036; asc jrzBmfdrYjgH1Ii1Mi4j0F0avw7g06; (total 32 bytes);
11: len 10; hex 31343030343239303736; asc 1400429076;;
12: len 30; hex 383232313735616536306162313735633138653739656534393733346636; asc 822175ae60ab175c18e79ee49734f6; (total 64 bytes);
13: len 4; hex 6165923d; asc ae =;;
14: len 4; hex 6165923d; asc ae =;;
15: len 1; hex 01; asc ;;
*** (2) WAITING FOR THIS LOCK TO BE GRANTED:
RECORD LOCKS space id 2696 page no 29 n bits 128 index `PRIMARY` of table `baijiacloud`.`partner_product_app` trx id 9023189509 lock_mode X locks rec but not gap waiting
Record lock, heap no 2 PHYSICAL RECORD: n_fields 16; compact format; info bits 0
0: len 8; hex 0000000000001287; asc ;;
1: len 6; hex 00021899a994; asc ;;
2: len 7; hex 62000000140391; asc b ;;
3: len 8; hex 0000000003764901; asc vI ;;
4: len 8; hex 000000000336e980; asc 6 ;;
5: len 1; hex 01; asc ;;
6: len 30; hex 5341534e483969487332335a6c457a42794b356f67657454426c50476d79; asc SASNH9iHs23ZlEzByK5ogetTBlPGmy; (total 32 bytes);
7: len 30; hex 6f6b487567723154425143396f437779756c4745776a56556a693066616c; asc okHugr1TBQC9oCwyulGEwjVUji0fal; (total 32 bytes);
8: len 1; hex 02; asc ;;
9: len 30; hex 534153386f463268664b7278354d543170653842356968714d3275456275; asc SAS8oF2hfKrx5MT1pe8B5ihqM2uEbu; (total 32 bytes);
10: len 30; hex 48736366776b775467456b4b614c63516343533748535471485342577551; asc HscfwkwTgEkKaLcQcCS7HSTqHSBWuQ; (total 32 bytes);
11: len 10; hex 31343030343239303736; asc 1400429076;;
12: len 30; hex 383232313735616536306162313735633138653739656534393733346636; asc 822175ae60ab175c18e79ee49734f6; (total 64 bytes);
13: len 4; hex 61528d5f; asc aR _;;
14: len 4; hex 61528d5f; asc aR _;;
15: len 1; hex 01; asc ;;
*** WE ROLL BACK TRANSACTION (1)
------------
TRANSACTIONS
------------
Trx id counter 9023377085
Purge done for trx's n:o < 9023376785 undo n:o < 0 state: running but idle
History list length 771
LIST OF TRANSACTIONS FOR EACH SESSION:
---TRANSACTION 421783680775784, not started
MySQL thread id 837277236, OS thread handle 0x7f9c70cb2700, query id 115425777612 172.17.0.239 p_all_rw init
show engine innodb status
---TRANSACTION 421784066364008, not started
MySQL thread id 837286125, OS thread handle 0x7f9cb4471700, query id 115425777607 172.17.0.218 p_all_rw cleaning up
---TRANSACTION 421783072416360, not started
MySQL thread id 1105753239, OS thread handle 0x7f9cb69f7700, query id 115425777611 172.17.0.218 p_all_rw cleaning up
---TRANSACTION 421784147155560, not started
MySQL thread id 1105753240, OS thread handle 0x7f9cb3df7700, query id 115425777589 172.17.0.217 p_all_rw cleaning up
---TRANSACTION 421782464549736, not started
MySQL thread id 1105753238, OS thread handle 0x7f9cec6fb700, query id 115425777595 172.17.0.218 p_all_rw cleaning up
---TRANSACTION 421783626709352, not started
MySQL thread id 3243600, OS thread handle 0x7fa412eb9700, query id 115425777569 172.17.0.217 p_all_rw cleaning up
---TRANSACTION 421783609559912, not started
MySQL thread id 3243597, OS thread handle 0x7f9cb24f3700, query id 115425777562 172.17.1.6 p_all_rw cleaning up
---TRANSACTION 421784413843560, not started
MySQL thread id 1105753230, OS thread handle 0x7fa4199aa700, query id 115425777554 172.17.0.217 p_all_rw cleaning up
---TRANSACTION 421782625088616, not started
MySQL thread id 1105753229, OS thread handle 0x7fa40d1f6700, query id 115425777602 172.17.1.6 p_all_rw cleaning up
---TRANSACTION 421783631952232, not started
MySQL thread id 1105753228, OS thread handle 0x7fa412e78700, query id 115425777501 172.17.16.219 scrm cleaning up
---TRANSACTION 421783972585320, not started
MySQL thread id 3243580, OS thread handle 0x7f9c8e830700, query id 115425777495 172.17.0.218 p_all_rw cleaning up
---TRANSACTION 421782480092776, not started
MySQL thread id 837286109, OS thread handle 0x7f9cb9638700, query id 115425777596 172.17.0.218 p_all_rw cleaning up
---TRANSACTION 421784787337832, not started
MySQL thread id 3242921, OS thread handle 0x7f9c937ff700, query id 115425777296 172.17.0.236 p_all_rw cleaning up
---TRANSACTION 421784447515496, not started
MySQL thread id 3232535, OS thread handle 0x7f9c8e669700, query id 115425775845 10.16.30.2 p_all_rw cleaning up
---TRANSACTION 421783596733544, not started
MySQL thread id 3232536, OS thread handle 0x7f9cb973c700, query id 115425775839 10.16.30.2 p_all_rw cleaning up
---TRANSACTION 421783597244264, not started
MySQL thread id 3242074, OS thread handle 0x7fa0e1ebe700, query id 115425776026 172.17.1.99 p_all_rw cleaning up
---TRANSACTION 421784733385576, not started
MySQL thread id 3242454, OS thread handle 0x7f9c6e6dd700, query id 115425776748 172.17.1.77 p_all_rw cleaning up
---TRANSACTION 421784178622824, not started
MySQL thread id 3240306, OS thread handle 0x7fa40a5b5700, query id 115425774376 172.17.0.55 p_all_rw cleaning up
---TRANSACTION 421784732862056, not started
MySQL thread id 3240307, OS thread handle 0x7f9d28237700, query id 115425774361 172.17.0.55 p_all_rw cleaning up
---TRANSACTION 421783087364712, not started
MySQL thread id 3238971, OS thread handle 0x7f9cec52d700, query id 115425771529 172.17.0.224 p_all_rw cleaning up
---TRANSACTION 421782464551528, not started
MySQL thread id 3238972, OS thread handle 0x7f9d0286f700, query id 115425771517 172.17.0.224 p_all_rw cleaning up
---TRANSACTION 421782412214120, not started
MySQL thread id 3241824, OS thread handle 0x7fa41133b700, query id 115425770737 10.16.30.2 p_all_rw cleaning up
---TRANSACTION 421784180776040, not started
MySQL thread id 3240548, OS thread handle 0x7f9d04235700, query id 115425777605 172.17.1.78 p_all_rw cleaning up
---TRANSACTION 421782480291944, not started
MySQL thread id 3236894, OS thread handle 0x7fa40d133700, query id 115425768577 172.17.0.32 p_all_rw cleaning up
---TRANSACTION 421784206431592, not started
MySQL thread id 3220999, OS thread handle 0x7f9d516b9700, query id 115425768140 172.17.0.219 p_all_rw cleaning up
---TRANSACTION 421782480101736, not started
MySQL thread id 3235704, OS thread handle 0x7f9c7ca38700, query id 115425767116 10.16.30.2 p_all_rw cleaning up
---TRANSACTION 421784092918632, not started
MySQL thread id 3240549, OS thread handle 0x7f9c70820700, query id 115425768935 172.17.1.78 p_all_rw cleaning up
---TRANSACTION 421783791746920, not started
MySQL thread id 3240380, OS thread handle 0x7f9c70b2c700, query id 115425762648 114.67.227.250 p_all_rw cleaning up
---TRANSACTION 421784092711016, not started
MySQL thread id 3240383, OS thread handle 0x7f9c93534700, query id 115425762640 114.67.227.250 p_all_rw cleaning up
---TRANSACTION 421783626675304, not started
MySQL thread id 3240373, OS thread handle 0x7f9c8e35d700, query id 115425762638 114.67.227.250 p_all_rw cleaning up
---TRANSACTION 421784732849512, not started
MySQL thread id 3240378, OS thread handle 0x7f9c70fbe700, query id 115425762623 114.67.227.250 p_all_rw cleaning up
---TRANSACTION 421784733383784, not started
MySQL thread id 3240365, OS thread handle 0x7f9c3e268700, query id 115425762614 114.67.227.250 p_all_rw cleaning up
---TRANSACTION 421784189057896, not started
MySQL thread id 3240372, OS thread handle 0x7fa4198a6700, query id 115425762595 114.67.227.250 p_all_rw cleaning up
---TRANSACTION 421783107411560, not started
MySQL thread id 3240358, OS thread handle 0x7f9c70c71700, query id 115425762592 114.67.227.250 p_all_rw cleaning up
---TRANSACTION 421783088612712, not started
MySQL thread id 3240364, OS thread handle 0x7f9c8e76d700, query id 115425762565 114.67.227.250 p_all_rw cleaning up
---TRANSACTION 421783971309928, not started
MySQL thread id 3240361, OS thread handle 0x7f9d2933b700, query id 115425762552 114.67.227.250 p_all_rw cleaning up
---TRANSACTION 421784031679592, not started
MySQL thread id 3240354, OS thread handle 0x7f9c604f3700, query id 115425762543 114.67.227.250 p_all_rw cleaning up
---TRANSACTION 421783055343464, not started
MySQL thread id 1105751757, OS thread handle 0x7f9c7c524700, query id 115425762426 172.17.0.217 p_all_rw cleaning up
---TRANSACTION 421782363957608, not started
MySQL thread id 3237911, OS thread handle 0x7f9c8ea79700, query id 115425759839 172.17.0.219 p_all_rw cleaning up
---TRANSACTION 421782467543912, not started
MySQL thread id 3237912, OS thread handle 0x7f9cb473c700, query id 115425759822 172.17.0.219 p_all_rw cleaning up
---TRANSACTION 421782467502696, not started
MySQL thread id 3239285, OS thread handle 0x7fa4122f9700, query id 115425776564 172.17.1.100 p_all_rw cleaning up
---TRANSACTION 421783364766568, not started
MySQL thread id 3239144, OS thread handle 0x7f9c6f2cc700, query id 115425774980 172.17.2.110 p_baijiacloud_ro cleaning up
---TRANSACTION 421783110689896, not started
MySQL thread id 3237337, OS thread handle 0x7f9bd72fb700, query id 115425777434 172.17.1.77 p_all_rw cleaning up
---TRANSACTION 421783087361128, not started
MySQL thread id 3238659, OS thread handle 0x7f9d02b7b700, query id 115425774992 172.17.2.110 p_baijiacloud_ro cleaning up
---TRANSACTION 421784787524456, not started
MySQL thread id 3227623, OS thread handle 0x7f9c1f506700, query id 115425774355 172.17.0.55 p_all_rw cleaning up
---TRANSACTION 421783656942952, not started
MySQL thread id 3234374, OS thread handle 0x7f9c92e38700, query id 115425753036 172.17.0.55 p_all_rw cleaning up
---TRANSACTION 421783174381416, not started
MySQL thread id 3235914, OS thread handle 0x7f9d09bbc700, query id 115425752569 10.16.30.2 p_all_rw cleaning up
---TRANSACTION 421783972569192, not started
MySQL thread id 1105745813, OS thread handle 0x7f9c8e29a700, query id 115425753778 172.17.0.18 p_all_rw cleaning up
---TRANSACTION 421783596771176, not started
MySQL thread id 3232325, OS thread handle 0x7f9c6e822700, query id 115425751305 172.17.0.31 p_all_rw cleaning up
---TRANSACTION 421784092043368, not started
MySQL thread id 3237338, OS thread handle 0x7f9c6ed36700, query id 115425777438 172.17.1.77 p_all_rw cleaning up
---TRANSACTION 421782095610472, not started
MySQL thread id 3235574, OS thread handle 0x7f9f4be3c700, query id 115425747997 172.17.0.57 p_all_rw cleaning up
---TRANSACTION 421782114895208, not started
MySQL thread id 3236775, OS thread handle 0x7fa40d3bd700, query id 115425777608 172.17.1.77 p_all_rw cleaning up
---TRANSACTION 421782464574824, not started
MySQL thread id 3229165, OS thread handle 0x7f9c92df7700, query id 115425744286 172.17.1.99 p_all_rw cleaning up
---TRANSACTION 421782361638248, not started
MySQL thread id 3236295, OS thread handle 0x7f9c7c9b6700, query id 115425745899 172.17.1.99 p_all_rw cleaning up
---TRANSACTION 421783790461544, not started
MySQL thread id 3232954, OS thread handle 0x7fa342d79700, query id 115425743231 172.17.1.100 p_all_rw cleaning up
---TRANSACTION 421782480128616, not started
MySQL thread id 3234649, OS thread handle 0x7f9d2837c700, query id 115425772671 172.17.1.78 p_all_rw cleaning up
---TRANSACTION 421784413872232, not started
MySQL thread id 3235657, OS thread handle 0x7f9c6fd75700, query id 115425755644 114.67.228.240 p_all_rw cleaning up
---TRANSACTION 421783792662376, not started
MySQL thread id 3234650, OS thread handle 0x7f9cb3fbe700, query id 115425772677 172.17.1.78 p_all_rw cleaning up
---TRANSACTION 421784147148392, not started
MySQL thread id 3232955, OS thread handle 0x7f9c5f935700, query id 115425743228 172.17.1.100 p_all_rw cleaning up
---TRANSACTION 421784180768872, not started
MySQL thread id 1105729861, OS thread handle 0x7fa1acdba700, query id 115425728148 172.17.2.110 p_all_rw cleaning up
---TRANSACTION 421782114882664, not started
MySQL thread id 3226145, OS thread handle 0x7fa40a7fe700, query id 115425723023 172.17.0.224 p_all_rw cleaning up
---TRANSACTION 421783641787240, not started
MySQL thread id 837275393, OS thread handle 0x7f9d09af9700, query id 115425722486 172.17.2.110 p_all_rw cleaning up
---TRANSACTION 421783591929448, not started
MySQL thread id 3224232, OS thread handle 0x7f9c4e051700, query id 115425768580 172.17.0.32 p_all_rw cleaning up
---TRANSACTION 421783087826024, not started
MySQL thread id 3229324, OS thread handle 0x7f9c7c669700, query id 115425719727 172.17.0.32 p_all_rw cleaning up
---TRANSACTION 421783147735912, not started
MySQL thread id 3221203, OS thread handle 0x7fa1accf7700, query id 115425718464 10.16.30.2 p_all_rw cleaning up
---TRANSACTION 421783626058088, not started
MySQL thread id 3226475, OS thread handle 0x7f9d517fe700, query id 115425736289 172.17.1.100 p_all_rw cleaning up
---TRANSACTION 421782625119080, not started
MySQL thread id 3228831, OS thread handle 0x7fa277dba700, query id 115425770418 172.17.1.99 p_all_rw cleaning up
---TRANSACTION 421783127617384, not started
MySQL thread id 3228624, OS thread handle 0x7f9c70924700, query id 115425730835 10.16.30.2 p_all_rw cleaning up
---TRANSACTION 421784104288872, not started
MySQL thread id 3225079, OS thread handle 0x7f9c6f0c4700, query id 115425711712 172.17.0.219 p_all_rw cleaning up
---TRANSACTION 421783618293096, not started
MySQL thread id 3226341, OS thread handle 0x7f9c6fc71700, query id 115425768137 172.17.0.219 p_all_rw cleaning up
---TRANSACTION 421782099623528, not started
MySQL thread id 3220988, OS thread handle 0x7fa4123bc700, query id 115425769395 172.17.0.31 p_all_rw cleaning up
---TRANSACTION 421782712608360, not started
MySQL thread id 3226332, OS thread handle 0x7f9c6f1c8700, query id 115425704693 172.17.0.31 p_all_rw cleaning up
---TRANSACTION 421783658216296, not started
MySQL thread id 3226476, OS thread handle 0x7f9cb6934700, query id 115425755241 172.17.1.100 p_all_rw cleaning up
---TRANSACTION 421783626644840, not started
MySQL thread id 3223320, OS thread handle 0x7f9c6ec32700, query id 115425747987 172.17.0.57 p_all_rw cleaning up
---TRANSACTION 421783626054504, not started
MySQL thread id 3223321, OS thread handle 0x7f9d280f2700, query id 115425702258 172.17.0.57 p_all_rw cleaning up
---TRANSACTION 421784371670632, not started
MySQL thread id 3226005, OS thread handle 0x7f9c7c7ae700, query id 115425708591 172.17.0.31 p_all_rw cleaning up
---TRANSACTION 421782625113704, not started
MySQL thread id 3218331, OS thread handle 0x7f9c6f042700, query id 115425748306 172.17.1.99 p_all_rw cleaning up
---TRANSACTION 421783063282280, not started
MySQL thread id 3224082, OS thread handle 0x7f9c5fe08700, query id 115425698944 172.17.1.99 p_all_rw cleaning up
---TRANSACTION 421784092048744, not started
MySQL thread id 3222496, OS thread handle 0x7f9cb25f7700, query id 115425706011 172.17.0.55 p_all_rw cleaning up
---TRANSACTION 421782480119656, not started
MySQL thread id 3223428, OS thread handle 0x7f9cb9575700, query id 115425694905 10.16.30.2 p_all_rw cleaning up
---TRANSACTION 421783656989544, not started
MySQL thread id 3224145, OS thread handle 0x7f9c3e533700, query id 115425739146 172.17.1.77 p_all_rw cleaning up
---TRANSACTION 421783791391336, not started
MySQL thread id 3222419, OS thread handle 0x7f9c6e4d5700, query id 115425763103 172.17.1.78 p_all_rw cleaning up
---TRANSACTION 421782464937576, not started
MySQL thread id 3214675, OS thread handle 0x7f9cbe37d700, query id 115425755592 172.17.0.224 p_all_rw cleaning up
---TRANSACTION 421784732860264, not started
MySQL thread id 3220767, OS thread handle 0x7f9c92f3c700, query id 115425683552 172.17.0.224 p_all_rw cleaning up
---TRANSACTION 421783609556328, not started
MySQL thread id 3221534, OS thread handle 0x7f9d290b1700, query id 115425698028 172.17.1.100 p_all_rw cleaning up
---TRANSACTION 421784733365864, not started
MySQL thread id 3215041, OS thread handle 0x7f9f4bcb6700, query id 115425681561 172.17.1.100 p_all_rw cleaning up
---TRANSACTION 421783082991976, not started
MySQL thread id 3218503, OS thread handle 0x7f9cb69b6700, query id 115425680441 172.17.0.32 p_all_rw cleaning up
---TRANSACTION 421782464567656, not started
MySQL thread id 1105742869, OS thread handle 0x7f9c70d75700, query id 115425679929 172.17.2.110 p_all_rw cleaning up
---TRANSACTION 421783220296040, not started
MySQL thread id 3213318, OS thread handle 0x7f9cb4679700, query id 115425727259 172.17.0.219 p_all_rw cleaning up
---TRANSACTION 421783085565800, not started
MySQL thread id 3219554, OS thread handle 0x7f9c7caba700, query id 115425671910 172.17.0.219 p_all_rw cleaning up
---TRANSACTION 421783626671720, not started
MySQL thread id 3207567, OS thread handle 0x7f9cb9471700, query id 115425718466 10.16.30.2 p_all_rw cleaning up
---TRANSACTION 421783063907176, not started
MySQL thread id 3207570, OS thread handle 0x7f9c60638700, query id 115425670229 10.16.30.2 p_all_rw cleaning up
---TRANSACTION 421783971311720, not started
MySQL thread id 3218950, OS thread handle 0x7f9c70eba700, query id 115425684666 172.17.1.77 p_all_rw cleaning up
---TRANSACTION 421784733240680, not started
MySQL thread id 3218006, OS thread handle 0x7f9c7c461700, query id 115425769940 172.17.1.99 p_all_rw cleaning up
---TRANSACTION 421784733204840, not started
MySQL thread id 3218415, OS thread handle 0x7fa0e1cb6700, query id 115425744872 172.17.1.77 p_all_rw cleaning up
---TRANSACTION 421784413886568, not started
MySQL thread id 3216516, OS thread handle 0x7f9c3d430700, query id 115425665390 172.17.0.55 p_all_rw cleaning up
---TRANSACTION 421783127612008, not started
MySQL thread id 3217732, OS thread handle 0x7f9c7c6eb700, query id 115425689536 10.16.30.2 p_all_rw cleaning up
---TRANSACTION 421783147768168, not started
MySQL thread id 3214874, OS thread handle 0x7f9c60534700, query id 115425664007 172.17.0.31 p_all_rw cleaning up
---TRANSACTION 421782095569256, not started
MySQL thread id 3214519, OS thread handle 0x7f9c937be700, query id 115425708603 172.17.0.31 p_all_rw cleaning up
---TRANSACTION 421783597415272, not started
MySQL thread id 3214520, OS thread handle 0x7f9d280b1700, query id 115425665524 172.17.0.31 p_all_rw cleaning up
---TRANSACTION 421783174698344, not started
MySQL thread id 3216427, OS thread handle 0x7fa412cb1700, query id 115425681859 172.17.1.78 p_all_rw cleaning up
---TRANSACTION 421783083148648, not started
MySQL thread id 3216428, OS thread handle 0x7f9d28133700, query id 115425760489 172.17.1.78 p_all_rw cleaning up
---TRANSACTION 421782412201576, not started
MySQL thread id 837260045, OS thread handle 0x7f9c5fd04700, query id 115425657548 172.17.2.110 p_all_rw cleaning up
---TRANSACTION 421784733338984, not started
MySQL thread id 3207997, OS thread handle 0x7fa40a6fa700, query id 115425707484 172.17.1.100 p_all_rw cleaning up
---TRANSACTION 421783791371624, not started
MySQL thread id 3215431, OS thread handle 0x7f9c6f001700, query id 115425655974 172.17.1.100 p_all_rw cleaning up
---TRANSACTION 421784733403496, not started
MySQL thread id 3209797, OS thread handle 0x7f9c92d34700, query id 115425699635 172.17.1.78 p_all_rw cleaning up
---TRANSACTION 421782346659432, not started
MySQL thread id 3215042, OS thread handle 0x7f9cb3e79700, query id 115425701327 172.17.1.100 p_all_rw cleaning up
---TRANSACTION 421783600525928, not started
MySQL thread id 837269713, OS thread handle 0x7f9cb24b2700, query id 115425680284 172.17.2.110 p_all_rw cleaning up
---TRANSACTION 421784180774248, not started
MySQL thread id 3211173, OS thread handle 0x7f9db5c75700, query id 115425732613 10.16.30.2 p_all_rw cleaning up
---TRANSACTION 421784092893544, not started
MySQL thread id 3212705, OS thread handle 0x7f9c3d638700, query id 115425736559 172.17.1.77 p_all_rw cleaning up
---TRANSACTION 421783618246504, not started
MySQL thread id 3209798, OS thread handle 0x7f9c92eba700, query id 115425699640 172.17.1.78 p_all_rw cleaning up
---TRANSACTION 421783680765032, not started
MySQL thread id 3211181, OS thread handle 0x7f9cb277d700, query id 115425741468 172.17.0.68 p_all_rw cleaning up
---TRANSACTION 421783663754344, not started
MySQL thread id 3200911, OS thread handle 0x7f9c5fd45700, query id 115425706012 172.17.0.55 p_all_rw cleaning up
---TRANSACTION 421784102769768, not started
MySQL thread id 1105722864, OS thread handle 0x7f9c600d3700, query id 115425728379 172.17.2.110 p_all_rw cleaning up
---TRANSACTION 421783055382888, not started
MySQL thread id 3195744, OS thread handle 0x7fa016ebe700, query id 115425674022 172.17.0.57 p_all_rw cleaning up
---TRANSACTION 421782363912808, not started
MySQL thread id 3203033, OS thread handle 0x7f9c5fabb700, query id 115425774061 10.16.30.2 p_all_rw cleaning up
---TRANSACTION 421784086902376, not started
MySQL thread id 3192978, OS thread handle 0x7f9cb03be700, query id 115425662431 172.17.0.219 p_all_rw cleaning up
---TRANSACTION 421783147734120, not started
MySQL thread id 3199333, OS thread handle 0x7fa0e1d38700, query id 115425662437 172.17.0.219 p_all_rw cleaning up
---TRANSACTION 421782363896680, not started
MySQL thread id 3198679, OS thread handle 0x7f9d09b7b700, query id 115425768205 116.196.90.147 p_all_rw cleaning up
---TRANSACTION 421782625271912, not started
MySQL thread id 3196919, OS thread handle 0x7f9c1ec71700, query id 115425681617 172.17.0.32 p_all_rw cleaning up
---TRANSACTION 421783972610408, not started
MySQL thread id 3192963, OS thread handle 0x7f9d28278700, query id 115425665518 172.17.0.31 p_all_rw cleaning up
---TRANSACTION 421784189050728, not started
MySQL thread id 837246983, OS thread handle 0x7f9c92c71700, query id 115425750995 172.17.2.110 p_all_rw cleaning up
---TRANSACTION 421784066043496, not started
MySQL thread id 3190858, OS thread handle 0x7f9cf0f6a700, query id 115425745785 172.17.1.77 p_all_rw cleaning up
---TRANSACTION 421784371659880, not started
MySQL thread id 1105725401, OS thread handle 0x7f9cb037d700, query id 115425675458 172.17.2.110 p_all_rw cleaning up
---TRANSACTION 421782346664808, not started
MySQL thread id 1105693847, OS thread handle 0x7f9c8e196700, query id 115425757384 172.17.0.18 p_all_rw cleaning up
---TRANSACTION 421782464942952, not started
MySQL thread id 3180105, OS thread handle 0x7f9c6f556700, query id 115425773882 172.17.1.78 p_all_rw cleaning up
---TRANSACTION 421783972621160, not started
MySQL thread id 837255009, OS thread handle 0x7f9c5fb3d700, query id 115425753641 172.17.0.18 p_all_rw cleaning up
---TRANSACTION 421783087838568, not started
MySQL thread id 3105620, OS thread handle 0x7fa4111f6700, query id 115425566408 10.16.30.2 p_all_rw cleaning up
---TRANSACTION 421782361656168, not started
MySQL thread id 3105621, OS thread handle 0x7f9c3c5f7700, query id 115425566410 10.16.30.2 p_all_rw cleaning up
---TRANSACTION 421783592198504, not started
MySQL thread id 3173953, OS thread handle 0x7f9cec77d700, query id 115425771767 172.17.1.77 p_all_rw cleaning up
---TRANSACTION 421783174662504, not started
MySQL thread id 837242380, OS thread handle 0x7f9c7c76d700, query id 115425704911 172.17.0.18 p_all_rw cleaning up
---TRANSACTION 421783972581736, not started
MySQL thread id 837234759, OS thread handle 0x7f9c8e8f3700, query id 115425722041 172.17.2.110 p_all_rw cleaning up
---TRANSACTION 421783127592296, not started
MySQL thread id 3147336, OS thread handle 0x7f9d2b231700, query id 115425774243 172.17.0.236 p_all_rw cleaning up
---TRANSACTION 421783618250088, not started
MySQL thread id 1105700946, OS thread handle 0x7f9c6f4d4700, query id 115425298623 172.17.2.39 p_all_rw cleaning up
---TRANSACTION 421782414337640, not started
MySQL thread id 1105700945, OS thread handle 0x7f9d281f6700, query id 115425298620 172.17.2.39 p_all_rw cleaning up
---TRANSACTION 421782716176488, not started
MySQL thread id 1105700931, OS thread handle 0x7f9cec73c700, query id 115425298627 172.17.2.39 p_all_rw cleaning up
---TRANSACTION 421783592178792, not started
MySQL thread id 837233820, OS thread handle 0x7f9c8e9f7700, query id 115425298618 172.17.2.39 p_all_rw cleaning up
---TRANSACTION 421784032815464, not started
MySQL thread id 837233826, OS thread handle 0x7f9cf0c5e700, query id 115425298621 172.17.2.39 p_all_rw cleaning up
---TRANSACTION 421784732813672, not started
MySQL thread id 1105700932, OS thread handle 0x7fa41acb3700, query id 115425298616 172.17.2.39 p_all_rw cleaning up
---TRANSACTION 421784162730856, not started
MySQL thread id 1105700930, OS thread handle 0x7f9c8e6aa700, query id 115425298613 172.17.2.39 p_all_rw cleaning up
---TRANSACTION 421782480248936, not started
MySQL thread id 837233817, OS thread handle 0x7f9d09bfd700, query id 115425493676 172.17.2.39 p_all_rw cleaning up
---TRANSACTION 421782414335848, not started
MySQL thread id 1105699185, OS thread handle 0x7fa419969700, query id 115425451092 172.17.1.105 p_all_rw cleaning up
---TRANSACTION 421784180777832, not started
MySQL thread id 1105699186, OS thread handle 0x7f9c92cf3700, query id 115425432981 172.17.1.105 p_all_rw cleaning up
---TRANSACTION 421782095590760, not started
MySQL thread id 1105699178, OS thread handle 0x7f9d0b3b8700, query id 115425394861 172.17.1.105 p_all_rw cleaning up
---TRANSACTION 421784413895528, not started
MySQL thread id 1105699182, OS thread handle 0x7f9c1ef7d700, query id 115425414873 172.17.1.105 p_all_rw cleaning up
---TRANSACTION 421782095551336, not started
MySQL thread id 1105699181, OS thread handle 0x7f9cb47be700, query id 115425370690 172.17.1.105 p_all_rw cleaning up
---TRANSACTION 421783597192296, not started
MySQL thread id 1105697405, OS thread handle 0x7f9d2b3f8700, query id 115425750554 172.17.2.110 p_all_rw cleaning up
---TRANSACTION 421784787545960, not started
MySQL thread id 837216895, OS thread handle 0x7f9c4de8a700, query id 115425461208 172.17.0.18 p_all_rw cleaning up
---TRANSACTION 421784189025640, not started
MySQL thread id 837226882, OS thread handle 0x7f9d09ab8700, query id 115425692093 172.17.2.110 p_all_rw cleaning up
---TRANSACTION 421784031708264, not started
MySQL thread id 837207140, OS thread handle 0x7f9c9377d700, query id 115425614752 172.17.2.110 p_all_rw cleaning up
---TRANSACTION 421783680752488, not started
MySQL thread id 837224980, OS thread handle 0x7f9d51470700, query id 115425766518 172.17.0.18 p_all_rw cleaning up
---TRANSACTION 421782625298792, not started
MySQL thread id 3119496, OS thread handle 0x7f9c8e6eb700, query id 115425776345 10.16.30.2 p_all_rw cleaning up
---TRANSACTION 421784092718184, not started
MySQL thread id 3118717, OS thread handle 0x7f9d0637a700, query id 115425770254 172.17.0.242 p_all_rw cleaning up
---TRANSACTION 421782712610152, not started
MySQL thread id 1105674492, OS thread handle 0x7f9c8e051700, query id 115425643361 172.17.2.110 p_all_rw cleaning up
---TRANSACTION 421784095082344, not started
MySQL thread id 837214565, OS thread handle 0x7f9c8e7ef700, query id 115425678968 172.17.2.110 p_all_rw cleaning up
---TRANSACTION 421783618248296, not started
MySQL thread id 3108690, OS thread handle 0x7fa4110b1700, query id 115425472912 172.17.0.242 p_all_rw cleaning up
---TRANSACTION 421783085569384, not started
MySQL thread id 1105683262, OS thread handle 0x7f9c5ff8e700, query id 115425769099 172.17.0.18 p_all_rw cleaning up
---TRANSACTION 421784189036392, not started
MySQL thread id 2985129, OS thread handle 0x7fa342dfb700, query id 115425566409 10.16.30.2 p_all_rw cleaning up
---TRANSACTION 421784092696680, not started
MySQL thread id 837203215, OS thread handle 0x7f9c92fff700, query id 115425748857 172.17.2.110 p_all_rw cleaning up
---TRANSACTION 421783791745128, not started
MySQL thread id 837214735, OS thread handle 0x7f9db5cf7700, query id 115425748867 172.17.2.110 p_all_rw cleaning up
---TRANSACTION 421782467533160, not started
MySQL thread id 1105679682, OS thread handle 0x7f9d514f2700, query id 115425702641 10.16.16.17 p_all_rw cleaning up
---TRANSACTION 421783791712872, not started
MySQL thread id 1105682789, OS thread handle 0x7f9c60430700, query id 115425767785 172.17.0.18 p_all_rw cleaning up
---TRANSACTION 421784733374824, not started
MySQL thread id 1105677704, OS thread handle 0x7f9c4e430700, query id 115425585545 172.17.2.110 p_all_rw cleaning up
---TRANSACTION 421783174658920, not started
MySQL thread id 1105675009, OS thread handle 0x7f9d2b0ab700, query id 115425679823 172.17.2.110 p_all_rw cleaning up
---TRANSACTION 421782712645992, not started
MySQL thread id 1105661245, OS thread handle 0x7fa277dfb700, query id 115425680071 172.17.2.110 p_all_rw cleaning up
---TRANSACTION 421782480099944, not started
MySQL thread id 837206657, OS thread handle 0x7f9d0b273700, query id 115425702175 10.16.16.17 p_all_rw cleaning up
---TRANSACTION 421784092714600, not started
MySQL thread id 837203908, OS thread handle 0x7f9db5e3c700, query id 115425754639 172.17.2.110 p_all_rw cleaning up
---TRANSACTION 421784087497576, not started
MySQL thread id 3067979, OS thread handle 0x7fa412db5700, query id 115425600665 10.16.30.2 p_all_rw cleaning up
---TRANSACTION 421782414292840, not started
MySQL thread id 837204262, OS thread handle 0x7fa412c70700, query id 115425775599 172.17.0.18 p_all_rw cleaning up
---TRANSACTION 421782480270440, not started
MySQL thread id 837191330, OS thread handle 0x7f9d8a0b5700, query id 115425645216 172.17.2.110 p_all_rw cleaning up
---TRANSACTION 421783791412840, not started
MySQL thread id 1105633547, OS thread handle 0x7f9f4bdfb700, query id 115425645200 172.17.2.110 p_all_rw cleaning up
---TRANSACTION 421783087404136, not started
MySQL thread id 837197912, OS thread handle 0x7f9cb27ff700, query id 115425756381 172.17.0.18 p_all_rw cleaning up
---TRANSACTION 421783596751464, not started
MySQL thread id 1105651722, OS thread handle 0x7fa40a574700, query id 115425563264 172.17.2.110 p_all_rw cleaning up
---TRANSACTION 421784092687720, not started
MySQL thread id 1105635621, OS thread handle 0x7fa40a678700, query id 115425635443 172.17.0.18 p_all_rw cleaning up
---TRANSACTION 421783596735336, not started
MySQL thread id 1105647782, OS thread handle 0x7f9c7c9f7700, query id 115425713966 172.17.0.18 p_all_rw cleaning up
---TRANSACTION 421783220317544, not started
MySQL thread id 837193700, OS thread handle 0x7f9c6f619700, query id 115425766495 172.17.0.18 p_all_rw cleaning up
---TRANSACTION 421783618251880, not started
MySQL thread id 837187104, OS thread handle 0x7fa4199eb700, query id 115425704750 172.17.2.110 p_all_rw cleaning up
---TRANSACTION 421783364784488, not started
MySQL thread id 837189949, OS thread handle 0x7f9c6f6dc700, query id 115425142446 172.17.0.18 p_all_rw cleaning up
---TRANSACTION 421782095601512, not started
MySQL thread id 837189928, OS thread handle 0x7f9c6fb6d700, query id 115424871295 172.17.0.18 p_all_rw cleaning up
---TRANSACTION 421782716165736, not started
MySQL thread id 3032728, OS thread handle 0x7f9f4bcf7700, query id 115425770371 172.17.0.236 p_all_rw cleaning up
---TRANSACTION 421784732844136, not started
MySQL thread id 1105650255, OS thread handle 0x7fa016c75700, query id 115425723148 172.17.2.110 p_all_rw cleaning up
---TRANSACTION 421784787328872, not started
MySQL thread id 837187250, OS thread handle 0x7fa413d68700, query id 115425774661 172.17.0.18 p_all_rw cleaning up
---TRANSACTION 421783085592680, not started
MySQL thread id 837187492, OS thread handle 0x7fa412f3b700, query id 115425766771 172.17.0.18 p_all_rw cleaning up
---TRANSACTION 421783971313512, not started
MySQL thread id 1105649288, OS thread handle 0x7fa41acf4700, query id 115425585787 172.17.0.18 p_all_rw cleaning up
---TRANSACTION 421783591945576, not started
MySQL thread id 837162937, OS thread handle 0x7f9c4e534700, query id 115425706606 172.17.2.110 p_all_rw cleaning up
---TRANSACTION 421784092739688, not started
MySQL thread id 3013742, OS thread handle 0x7f9c5fc00700, query id 115425764332 172.17.0.18 p_all_rw cleaning up
---TRANSACTION 421783085574760, not started
MySQL thread id 1105641725, OS thread handle 0x7f9d2a3fe700, query id 115425712932 172.17.2.110 p_all_rw cleaning up
---TRANSACTION 421782363954024, not started
MySQL thread id 837164185, OS thread handle 0x7f9d2b06a700, query id 115425701883 172.17.0.18 p_all_rw cleaning up
---TRANSACTION 421783054639720, not started
MySQL thread id 3005011, OS thread handle 0x7f9d292b9700, query id 115425776937 172.17.0.242 p_all_rw cleaning up
---TRANSACTION 421783289748840, not started
MySQL thread id 1105643027, OS thread handle 0x7fa342e7d700, query id 115425770732 172.17.0.18 p_all_rw cleaning up
---TRANSACTION 421783220321128, not started
MySQL thread id 837169592, OS thread handle 0x7fa412f7c700, query id 115425469641 172.17.0.18 p_all_rw cleaning up
---TRANSACTION 421783289747048, not started
MySQL thread id 1105630987, OS thread handle 0x7fa4122b8700, query id 115425680275 172.17.2.110 p_all_rw cleaning up
---TRANSACTION 421784086905960, not started
MySQL thread id 1105631411, OS thread handle 0x7fa4113bd700, query id 115425768497 172.17.0.18 p_all_rw cleaning up
---TRANSACTION 421783790483048, not started
MySQL thread id 837165785, OS thread handle 0x7f9f4beff700, query id 115425751479 172.17.2.110 p_all_rw cleaning up
---TRANSACTION 421783083154024, not started
MySQL thread id 2969040, OS thread handle 0x7f9cb68b2700, query id 115425474092 172.17.0.236 p_all_rw cleaning up
---TRANSACTION 421783147778920, not started
MySQL thread id 2944231, OS thread handle 0x7f9c7cbff700, query id 115425663458 172.17.0.236 p_all_rw cleaning up
---TRANSACTION 421784787535208, not started
MySQL thread id 2928811, OS thread handle 0x7f9d0b2f5700, query id 115425318762 10.16.30.2 p_all_rw cleaning up
---TRANSACTION 421784086914920, not started
MySQL thread id 2875149, OS thread handle 0x7f9d2a237700, query id 115425663459 172.17.0.236 p_all_rw cleaning up
---TRANSACTION 421784092730728, not started
MySQL thread id 1105577303, OS thread handle 0x7f9c6eaac700, query id 115425759448 172.17.0.18 p_pay_rw cleaning up
---TRANSACTION 421784189047144, not started
MySQL thread id 837110191, OS thread handle 0x7f9c6f209700, query id 115425682270 172.17.0.18 p_all_rw cleaning up
---TRANSACTION 421783597426024, not started
MySQL thread id 2848763, OS thread handle 0x7f9c70aaa700, query id 115425250270 10.16.30.2 p_all_rw cleaning up
---TRANSACTION 421782095594344, not started
MySQL thread id 2847963, OS thread handle 0x7f9c6ecb4700, query id 115425770255 172.17.0.242 p_all_rw cleaning up
---TRANSACTION 421783596781928, not started
MySQL thread id 2838492, OS thread handle 0x7f9c92db6700, query id 115425472913 172.17.0.242 p_all_rw cleaning up
---TRANSACTION 421783289718376, not started
MySQL thread id 1105538765, OS thread handle 0x7f9cbe33c700, query id 115425336808 172.17.1.105 p_all_rw cleaning up
---TRANSACTION 421783364743272, not started
MySQL thread id 1105538762, OS thread handle 0x7fa41233a700, query id 115425273516 172.17.1.105 p_all_rw cleaning up
---TRANSACTION 421783174388584, not started
MySQL thread id 1105538758, OS thread handle 0x7f9c6e75f700, query id 115425273517 172.17.1.105 p_all_rw cleaning up
---TRANSACTION 421782095574632, not started
MySQL thread id 1105538761, OS thread handle 0x7f9c6f75e700, query id 115425302369 172.17.1.105 p_all_rw cleaning up
---TRANSACTION 421783618233960, not started
MySQL thread id 1105538764, OS thread handle 0x7f9d02b3a700, query id 115425735212 172.17.1.105 p_all_rw cleaning up
---TRANSACTION 421784413897320, not started
MySQL thread id 2744851, OS thread handle 0x7f9d02ab8700, query id 115425661742 172.17.0.242 p_all_rw cleaning up
---TRANSACTION 421782625300584, not started
MySQL thread id 2586834, OS thread handle 0x7fa342c75700, query id 115425526144 172.17.0.242 p_all_rw cleaning up
---TRANSACTION 421783663741800, not started
MySQL thread id 2576782, OS thread handle 0x7f9c6f105700, query id 115425774938 172.17.0.242 p_all_rw cleaning up
---TRANSACTION 421783083175528, not started
MySQL thread id 1104966939, OS thread handle 0x7f9c4e5f7700, query id 115425615765 172.17.2.39 p_all_rw cleaning up
---TRANSACTION 421782480121448, not started
MySQL thread id 1104966935, OS thread handle 0x7f9c3d2aa700, query id 115425557897 172.17.2.39 p_all_rw cleaning up
---TRANSACTION 421783971300968, not started
MySQL thread id 16257345, OS thread handle 0x7f9d5177c700, query id 115425603824 172.17.0.18 p_all_rw cleaning up
---TRANSACTION 421782099616360, not started
MySQL thread id 9646408, OS thread handle 0x7fa41ac72700, query id 115425759870 172.17.1.232 p_baijiacloud_ro cleaning up
---TRANSACTION 421783130750824, not started
MySQL thread id 9646399, OS thread handle 0x7f9d042b7700, query id 115425760347 172.17.1.232 p_baijiacloud_ro cleaning up
---TRANSACTION 421782099605608, not started
MySQL thread id 9646415, OS thread handle 0x7fa0e1dba700, query id 115425760421 172.17.1.232 p_baijiacloud_ro cleaning up
---TRANSACTION 421782625106536, not started
MySQL thread id 9646386, OS thread handle 0x7f9c8e628700, query id 115425760936 172.17.1.232 p_baijiacloud_ro cleaning up
---TRANSACTION 421784066056040, not started
MySQL thread id 9646378, OS thread handle 0x7f9db5dba700, query id 115425777427 172.17.1.232 p_baijiacloud_ro cleaning up
---TRANSACTION 421783618239336, not started
MySQL thread id 9646370, OS thread handle 0x7f9c6ffbe700, query id 115425760209 172.17.1.232 p_baijiacloud_ro cleaning up
---TRANSACTION 421783618298472, not started
MySQL thread id 9646384, OS thread handle 0x7f9d0b0ac700, query id 115425760353 172.17.1.232 p_baijiacloud_ro cleaning up
---TRANSACTION 421784092005736, not started
MySQL thread id 9646402, OS thread handle 0x7f9c8e871700, query id 115425761078 172.17.1.232 p_baijiacloud_ro cleaning up
---TRANSACTION 421783626111848, not started
MySQL thread id 9646413, OS thread handle 0x7f9c6e926700, query id 115425760348 172.17.1.232 p_baijiacloud_ro cleaning up
---TRANSACTION 421782099607400, not started
MySQL thread id 9646563, OS thread handle 0x7f9e80e7d700, query id 115425760184 172.17.1.209 p_baijiacloud_ro cleaning up
---TRANSACTION 421783063957352, not started
MySQL thread id 9646571, OS thread handle 0x7f9c60010700, query id 115425761625 172.17.1.209 p_baijiacloud_ro cleaning up
---TRANSACTION 421783971354728, not started
MySQL thread id 9646379, OS thread handle 0x7f9c6fb2c700, query id 115425777447 172.17.0.125 p_baijiacloud_ro cleaning up
---TRANSACTION 421783110702440, not started
MySQL thread id 9646551, OS thread handle 0x7f9c8e565700, query id 115425760698 172.17.1.209 p_baijiacloud_ro cleaning up
---TRANSACTION 421784102714216, not started
MySQL thread id 9646566, OS thread handle 0x7f9d0b1b0700, query id 115425760198 172.17.1.209 p_baijiacloud_ro cleaning up
---TRANSACTION 421783591976040, not started
MySQL thread id 9646539, OS thread handle 0x7f9cb26ba700, query id 115425760856 172.17.1.209 p_baijiacloud_ro cleaning up
---TRANSACTION 421784733358696, not started
MySQL thread id 9646357, OS thread handle 0x7f9cb4638700, query id 115425777445 172.17.0.125 p_baijiacloud_ro cleaning up
---TRANSACTION 421782114900584, not started
MySQL thread id 9646546, OS thread handle 0x7f9c602db700, query id 115425761586 172.17.1.209 p_baijiacloud_ro cleaning up
---TRANSACTION 421782414316136, not started
MySQL thread id 9646541, OS thread handle 0x7f9c5fcc3700, query id 115425761650 172.17.1.209 p_baijiacloud_ro cleaning up
---TRANSACTION 421784140036456, not started
MySQL thread id 9646372, OS thread handle 0x7f9d062f8700, query id 115425760467 172.17.0.125 p_baijiacloud_ro cleaning up
---TRANSACTION 421784428616040, not started
MySQL thread id 9646388, OS thread handle 0x7f9c8e0d3700, query id 115425764536 172.17.0.125 p_baijiacloud_ro cleaning up
---TRANSACTION 421784095071592, not started
MySQL thread id 9646400, OS thread handle 0x7f9c704d3700, query id 115425777446 172.17.0.125 p_baijiacloud_ro cleaning up
---TRANSACTION 421783972701544, not started
MySQL thread id 9646385, OS thread handle 0x7f9c7c4e3700, query id 115425760241 172.17.0.125 p_baijiacloud_ro cleaning up
---TRANSACTION 421784091991400, not started
MySQL thread id 9646556, OS thread handle 0x7fa40d070700, query id 115425760970 172.17.1.209 p_baijiacloud_ro cleaning up
---TRANSACTION 421783063901800, not started
MySQL thread id 9646367, OS thread handle 0x7f9cf0da3700, query id 115425760375 172.17.0.125 p_baijiacloud_ro cleaning up
---TRANSACTION 421783211210344, not started
MySQL thread id 9646534, OS thread handle 0x7f9bcfe38700, query id 115425760792 172.17.1.209 p_baijiacloud_ro cleaning up
---TRANSACTION 421783054691688, not started
MySQL thread id 9646528, OS thread handle 0x7f9c7069a700, query id 115425760326 172.17.1.209 p_baijiacloud_ro cleaning up
---TRANSACTION 421782625128040, not started
MySQL thread id 9646349, OS thread handle 0x7f9c6fa28700, query id 115425761261 172.17.0.125 p_baijiacloud_ro cleaning up
---TRANSACTION 421784092732520, not started
MySQL thread id 9646363, OS thread handle 0x7f9c3e123700, query id 115425777514 172.17.1.232 p_baijiacloud_ro cleaning up
---TRANSACTION 421783289754216, not started
MySQL thread id 9646353, OS thread handle 0x7f9d8a2bd700, query id 115425777448 172.17.0.125 p_baijiacloud_ro cleaning up
---TRANSACTION 421783083188072, not started
MySQL thread id 9646396, OS thread handle 0x7f9cb6b3c700, query id 115425760376 172.17.0.125 p_baijiacloud_ro cleaning up
---TRANSACTION 421782414300008, not started
MySQL thread id 7361309, OS thread handle 0x7f9c6fefb700, query id 115374544708 10.16.16.17 p_all_rw cleaning up
---TRANSACTION 421784413866856, not started
MySQL thread id 1088188806, OS thread handle 0x7fa40a4f2700, query id 115425716071 172.17.16.219 epona_rw cleaning up
---TRANSACTION 421783972574568, not started
MySQL thread id 878833, OS thread handle 0x7f9d8a2fe700, query id 115425765052 172.17.0.18 p_all_rw cleaning up
---TRANSACTION 421784092693096, not started
MySQL thread id 809126629, OS thread handle 0x7fa342cb6700, query id 115425716026 172.17.16.219 epona_rw cleaning up
---TRANSACTION 421783211215720, not started
MySQL thread id 10101227, OS thread handle 0x7f9c1bfff700, query id 115286370297 10.16.16.17 p_all_rw cleaning up
---TRANSACTION 421783364748648, not started
MySQL thread id 1077192708, OS thread handle 0x7fa41237b700, query id 115409602242 172.17.16.219 p_all_rw cleaning up
---TRANSACTION 421783211156584, not started
MySQL thread id 2910498, OS thread handle 0x7f9c70fff700, query id 115423976195 114.67.227.123 p_baijiacloud_ro cleaning up
---TRANSACTION 421783626702184, not started
MySQL thread id 1060350736, OS thread handle 0x7f9c7075d700, query id 115425601898 172.17.16.219 p_all_rw cleaning up
---TRANSACTION 421783087393384, not started
MySQL thread id 1326684066, OS thread handle 0x7f9d283fe700, query id 115411939532 172.17.16.219 epona_rw cleaning up
---TRANSACTION 421783087836776, not started
MySQL thread id 995790618, OS thread handle 0x7f9c6eefd700, query id 115425774795 172.17.2.110 scrm cleaning up
---TRANSACTION 421783087362920, not started
MySQL thread id 1240152743, OS thread handle 0x7f9d09a36700, query id 115425768923 172.17.0.18 p_all_rw cleaning up
---TRANSACTION 421782099645032, not started
MySQL thread id 1147494940, OS thread handle 0x7f9d04276700, query id 115425772251 10.16.16.17 p_all_rw cleaning up
---TRANSACTION 421782625095784, not started
MySQL thread id 6260627, OS thread handle 0x7f9c3e7be700, query id 115425766207 172.17.0.18 p_all_rw cleaning up
---TRANSACTION 421783656985960, not started
MySQL thread id 6260592, OS thread handle 0x7f9cf0fec700, query id 115425765211 172.17.0.18 p_all_rw cleaning up
---TRANSACTION 421784031740520, not started
MySQL thread id 6260583, OS thread handle 0x7fa277e7d700, query id 115425765113 172.17.0.18 p_all_rw cleaning up
---TRANSACTION 421783791380584, not started
MySQL thread id 6260578, OS thread handle 0x7fa413d27700, query id 115425765157 172.17.0.18 p_all_rw cleaning up
---TRANSACTION 421784180817256, not started
MySQL thread id 6260555, OS thread handle 0x7f9c6fbef700, query id 115425765232 172.17.0.18 p_all_rw cleaning up
---TRANSACTION 421783665334632, not started
MySQL thread id 6260547, OS thread handle 0x7f9d29237700, query id 115425765167 172.17.0.18 p_all_rw cleaning up
---TRANSACTION 421783609593960, not started
MySQL thread id 6260541, OS thread handle 0x7fa016cb6700, query id 115425765021 172.17.0.18 p_all_rw cleaning up
---TRANSACTION 421782712656744, not started
MySQL thread id 6260505, OS thread handle 0x7f9cec5af700, query id 115425765346 172.17.0.18 p_all_rw cleaning up
---TRANSACTION 421784032806504, not started
MySQL thread id 6260500, OS thread handle 0x7f9cec6b3700, query id 115425765085 172.17.0.18 p_all_rw cleaning up
---TRANSACTION 421784124174184, not started
MySQL thread id 6260498, OS thread handle 0x7f9d515b5700, query id 115425765192 172.17.0.18 p_all_rw cleaning up
---TRANSACTION 421784124188520, not started
MySQL thread id 6260493, OS thread handle 0x7f9c6fbae700, query id 115425765210 172.17.0.18 p_all_rw cleaning up
---TRANSACTION 421784732811880, not started
MySQL thread id 1130683260, OS thread handle 0x7fa277cf7700, query id 115425769718 10.16.16.17 p_all_rw cleaning up
---TRANSACTION 421783650469992, not started
MySQL thread id 1078445947, OS thread handle 0x7f9c8e7ae700, query id 115424872733 172.17.2.110 scrm cleaning up
---TRANSACTION 421783650457448, not started
MySQL thread id 809831193, OS thread handle 0x7f9c60575700, query id 115328501875 172.17.16.219 scrm cleaning up
---TRANSACTION 421783792712552, not started
MySQL thread id 1078297904, OS thread handle 0x7f9c1a279700, query id 115328502145 172.17.16.219 scrm cleaning up
---TRANSACTION 421782625131624, not started
MySQL thread id 809747150, OS thread handle 0x7f9cf0ea7700, query id 115425634986 172.17.2.110 scrm cleaning up
---TRANSACTION 421784206444136, not started
MySQL thread id 808848164, OS thread handle 0x7f9e80cf7700, query id 115425729836 172.17.2.110 p_all_rw cleaning up
---TRANSACTION 421783054661224, not started
MySQL thread id 1075661460, OS thread handle 0x7f9c3ecf3700, query id 115425729875 172.17.2.110 p_all_rw cleaning up
---TRANSACTION 421783054693480, not started
MySQL thread id 9426746, OS thread handle 0x7f9c93471700, query id 115425770669 172.17.0.18 p_all_rw cleaning up
---TRANSACTION 421782464565864, not started
MySQL thread id 15761455, OS thread handle 0x7f9c70596700, query id 115425769650 172.17.0.233 p_baijiacloud_ro cleaning up
---TRANSACTION 421784104290664, not started
MySQL thread id 15761467, OS thread handle 0x7fa40a470700, query id 115425766215 172.17.0.233 p_baijiacloud_ro cleaning up
---TRANSACTION 421783972605032, not started
MySQL thread id 15761462, OS thread handle 0x7f9cb3e38700, query id 115425771247 172.17.0.233 p_baijiacloud_ro cleaning up
---TRANSACTION 421783643334248, not started
MySQL thread id 15761479, OS thread handle 0x7f9d09a77700, query id 115425775831 172.17.0.233 p_baijiacloud_ro cleaning up
---TRANSACTION 421784104283496, not started
MySQL thread id 15761464, OS thread handle 0x7f9c21da6700, query id 115425775832 172.17.0.233 p_baijiacloud_ro cleaning up
---TRANSACTION 421783085615976, not started
MySQL thread id 15761471, OS thread handle 0x7f9c4e575700, query id 115425774084 172.17.0.233 p_baijiacloud_ro cleaning up
---TRANSACTION 421784744922472, not started
MySQL thread id 15761459, OS thread handle 0x7f9c1f894700, query id 115425774695 172.17.0.233 p_baijiacloud_ro cleaning up
---TRANSACTION 421783972576360, not started
MySQL thread id 9178348, OS thread handle 0x7f9f4bdba700, query id 115425777541 172.17.1.239 p_baijiacloud_ro cleaning up
---TRANSACTION 421783643400552, not started
MySQL thread id 9178353, OS thread handle 0x7f9c4e35d700, query id 115425763110 172.17.1.239 p_baijiacloud_ro cleaning up
---TRANSACTION 421782625297000, not started
MySQL thread id 9178361, OS thread handle 0x7f9c6e5d9700, query id 115425762292 172.17.1.239 p_baijiacloud_ro cleaning up
---TRANSACTION 421784206449512, not started
MySQL thread id 9178370, OS thread handle 0x7f9c3eefb700, query id 115425773605 172.17.1.239 p_baijiacloud_ro cleaning up
---TRANSACTION 421783663750760, not started
MySQL thread id 9178352, OS thread handle 0x7f9c6ed77700, query id 115425770167 172.17.1.239 p_baijiacloud_ro cleaning up
---TRANSACTION 421783663766888, not started
MySQL thread id 9178365, OS thread handle 0x7f9d51533700, query id 115425762235 172.17.1.239 p_baijiacloud_ro cleaning up
---TRANSACTION 421784568605544, not started
MySQL thread id 9178349, OS thread handle 0x7fa4113fe700, query id 115425766314 172.17.1.239 p_baijiacloud_ro cleaning up
---TRANSACTION 421783147761000, not started
MySQL thread id 9178350, OS thread handle 0x7f9c3c2cd700, query id 115425776698 172.17.1.239 p_baijiacloud_ro cleaning up
---TRANSACTION 421783597255016, not started
MySQL thread id 9178367, OS thread handle 0x7f9cb3f7d700, query id 115425774226 172.17.1.239 p_baijiacloud_ro cleaning up
---TRANSACTION 421784797342568, not started
MySQL thread id 9178358, OS thread handle 0x7f9c6e8e5700, query id 115425767113 172.17.1.239 p_baijiacloud_ro cleaning up
---TRANSACTION 421784788341352, not started
MySQL thread id 15761476, OS thread handle 0x7fa016eff700, query id 115425765267 172.17.0.233 p_baijiacloud_ro cleaning up
---TRANSACTION 421783085617768, not started
MySQL thread id 15761465, OS thread handle 0x7f9cb01f7700, query id 115425760890 172.17.0.233 p_baijiacloud_ro cleaning up
---TRANSACTION 421784206472808, not started
MySQL thread id 15761453, OS thread handle 0x7fa277c75700, query id 115425771347 172.17.0.233 p_baijiacloud_ro cleaning up
---TRANSACTION 421787297334120, not started
MySQL thread id 361400, OS thread handle 0x7f9c3e000700, query id 115425769624 10.110.5.104 p_baijiacloud_ro cleaning up
---TRANSACTION 421784166027624, not started
MySQL thread id 361894, OS thread handle 0x7fa40d174700, query id 115425773921 10.110.5.104 p_baijiacloud_ro cleaning up
---TRANSACTION 421784497725288, not started
MySQL thread id 361970, OS thread handle 0x7f9c4e3df700, query id 115425773550 10.110.5.104 p_baijiacloud_ro cleaning up
---TRANSACTION 421784329877096, not started
MySQL thread id 361725, OS thread handle 0x7f9c1f484700, query id 115425769862 10.110.5.104 p_baijiacloud_ro cleaning up
---TRANSACTION 421783614313320, not started
MySQL thread id 361471, OS thread handle 0x7f9c3efff700, query id 115425766450 10.110.5.104 p_baijiacloud_ro cleaning up
---TRANSACTION 421783589477736, not started
MySQL thread id 361587, OS thread handle 0x7f9cbe0f3700, query id 115425762891 10.110.5.104 p_baijiacloud_ro cleaning up
---TRANSACTION 421785106635880, not started
MySQL thread id 361820, OS thread handle 0x7f9cb6bbe700, query id 115425764964 10.110.5.104 p_baijiacloud_ro cleaning up
---TRANSACTION 421783130772328, not started
MySQL thread id 361653, OS thread handle 0x7f9c22030700, query id 115425766826 10.110.5.104 p_baijiacloud_ro cleaning up
---TRANSACTION 421784413888360, not started
MySQL thread id 361528, OS thread handle 0x7f9d516fa700, query id 115425774981 10.110.5.104 p_baijiacloud_ro cleaning up
---TRANSACTION 421783057470824, not started
MySQL thread id 361321, OS thread handle 0x7f9f4be7d700, query id 115425766493 10.110.5.104 p_baijiacloud_ro cleaning up
---TRANSACTION 421787923732584, not started
MySQL thread id 11446361, OS thread handle 0x7f9cb6bff700, query id 115425775389 172.17.0.233 p_baijiacloud_ro cleaning up
---TRANSACTION 421786846597992, not started
MySQL thread id 11446359, OS thread handle 0x7f9d0b3f9700, query id 115425770400 172.17.0.233 p_baijiacloud_ro cleaning up
---TRANSACTION 421786985944936, not started
MySQL thread id 11446341, OS thread handle 0x7f9cb477d700, query id 115425762394 172.17.0.233 p_baijiacloud_ro cleaning up
---TRANSACTION 421786866002280, not started
MySQL thread id 11446357, OS thread handle 0x7f9c7c7ef700, query id 115425761799 172.17.0.233 p_baijiacloud_ro cleaning up
---TRANSACTION 421786748211048, not started
MySQL thread id 11446337, OS thread handle 0x7f9cb03ff700, query id 115425769512 172.17.0.233 p_baijiacloud_ro cleaning up
---TRANSACTION 421786864679784, not started
MySQL thread id 11446342, OS thread handle 0x7f9c8e3df700, query id 115425769511 172.17.0.233 p_baijiacloud_ro cleaning up
---TRANSACTION 421786819913320, not started
MySQL thread id 11446352, OS thread handle 0x7f9d51678700, query id 115425772500 172.17.0.233 p_baijiacloud_ro cleaning up
---TRANSACTION 421786802168936, not started
MySQL thread id 11446354, OS thread handle 0x7f9cec56e700, query id 115425769813 172.17.0.233 p_baijiacloud_ro cleaning up
---TRANSACTION 421786765932392, not started
MySQL thread id 11446334, OS thread handle 0x7f9c7c6aa700, query id 115425775909 172.17.0.233 p_baijiacloud_ro cleaning up
---TRANSACTION 421787984269928, not started
MySQL thread id 11446339, OS thread handle 0x7f9d0b377700, query id 115425761406 172.17.0.233 p_baijiacloud_ro cleaning up
--------
FILE I/O
--------
----------------
Async MDL Thread
----------------
-------------------------------------
INSERT BUFFER AND ADAPTIVE HASH INDEX
-------------------------------------
Ibuf: size 1, free list len 2010, seg size 2012, 0 merges
merged operations:
insert 0, delete mark 0, delete 0
discarded operations:
insert 0, delete mark 0, delete 0
AHI PARTITION 1: Hash table size 6375037, node heap has 0 buffer(s)
AHI PARTITION 2: Hash table size 6375037, node heap has 0 buffer(s)
AHI PARTITION 3: Hash table size 6375037, node heap has 0 buffer(s)
AHI PARTITION 4: Hash table size 6375037, node heap has 0 buffer(s)
AHI PARTITION 5: Hash table size 6375037, node heap has 0 buffer(s)
AHI PARTITION 6: Hash table size 6375037, node heap has 0 buffer(s)
AHI PARTITION 7: Hash table size 6375037, node heap has 0 buffer(s)
AHI PARTITION 8: Hash table size 6375037, node heap has 0 buffer(s)
0.00 hash searches/s, 19727.25 non-hash searches/s
---
LOG
---
Log sequence number 5191714701766
Log flushed up to 5191714701766
Pages flushed up to 5191328155573
Last checkpoint at 5191328107395
Log applied up to 3203082741263
0 pending log flushes, 0 pending chkp writes
4060585591 log i/o's done, 36.15 log i/o's/second
----------------------
BUFFER POOL AND MEMORY
----------------------
Total memory allocated 26684948480; in additional pool allocated 0
Dictionary memory allocated 10742256
Buffer pool size 1572864
Free buffers 16379
Database pages 1556485
Old database pages 574403
Modified db pages 39354
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 2951228683, not young 55924205839
24.31 youngs/s, 93.76 non-youngs/s
Pages read 1422383571, created 26593264, written 322647105
14.77 reads/s, 0.08 creates/s, 0.23 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: 1556485, unzip_LRU len: 0
I/O sum[7992]:cur[48], unzip sum[0]:cur[0]
----------------------
INDIVIDUAL BUFFER POOL INFO
----------------------
---BUFFER POOL 0
Buffer pool size 196608
Free buffers 2046
Database pages 194562
Old database pages 71801
Modified db pages 4675
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 369381070, not young 7348349914
2.92 youngs/s, 5.38 non-youngs/s
Pages read 179076385, created 3323669, written 41218838
1.54 reads/s, 0.00 creates/s, 0.00 writes/s
Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 1 / 1000
Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
LRU len: 194562, unzip_LRU len: 0
I/O sum[999]:cur[6], unzip sum[0]:cur[0]
---BUFFER POOL 1
Buffer pool size 196608
Free buffers 2048
Database pages 194560
Old database pages 71800
Modified db pages 5201
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 353438575, not young 6872346844
3.23 youngs/s, 12.92 non-youngs/s
Pages read 175671245, created 3314034, written 40567506
1.77 reads/s, 0.00 creates/s, 0.08 writes/s
Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 3 / 1000
Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
LRU len: 194560, unzip_LRU len: 0
I/O sum[999]:cur[6], unzip sum[0]:cur[0]
---BUFFER POOL 2
Buffer pool size 196608
Free buffers 2047
Database pages 194561
Old database pages 71801
Modified db pages 4932
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 374030928, not young 7030221786
3.38 youngs/s, 5.31 non-youngs/s
Pages read 178851145, created 3330316, written 39828781
1.54 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: 194561, unzip_LRU len: 0
I/O sum[999]:cur[6], unzip sum[0]:cur[0]
---BUFFER POOL 3
Buffer pool size 196608
Free buffers 2048
Database pages 194560
Old database pages 71800
Modified db pages 4771
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 369072370, not young 6685744631
4.15 youngs/s, 5.54 non-youngs/s
Pages read 178353319, created 3352721, written 40607341
1.85 reads/s, 0.00 creates/s, 0.00 writes/s
Buffer pool hit rate 1000 / 1000, young-making rate 1 / 1000 not 1 / 1000
Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
LRU len: 194560, unzip_LRU len: 0
I/O sum[999]:cur[6], unzip sum[0]:cur[0]
---BUFFER POOL 4
Buffer pool size 196608
Free buffers 2048
Database pages 194560
Old database pages 71800
Modified db pages 5403
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 358364473, not young 6908019386
2.54 youngs/s, 13.92 non-youngs/s
Pages read 174801349, created 3317575, written 39966987
2.23 reads/s, 0.08 creates/s, 0.08 writes/s
Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 1 / 1000
Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
LRU len: 194560, unzip_LRU len: 0
I/O sum[999]:cur[6], unzip sum[0]:cur[0]
---BUFFER POOL 5
Buffer pool size 196608
Free buffers 2048
Database pages 194560
Old database pages 71800
Modified db pages 4911
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 373589552, not young 7347802982
2.62 youngs/s, 33.84 non-youngs/s
Pages read 177484083, created 3320040, written 40670247
2.23 reads/s, 0.00 creates/s, 0.08 writes/s
Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 1 / 1000
Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
LRU len: 194560, unzip_LRU len: 0
I/O sum[999]:cur[6], unzip sum[0]:cur[0]
---BUFFER POOL 6
Buffer pool size 196608
Free buffers 2048
Database pages 194560
Old database pages 71800
Modified db pages 4676
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 379285226, not young 6785967876
3.15 youngs/s, 8.31 non-youngs/s
Pages read 179455481, created 3316628, written 39736553
1.69 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: 194560, unzip_LRU len: 0
I/O sum[999]:cur[6], unzip sum[0]:cur[0]
---BUFFER POOL 7
Buffer pool size 196608
Free buffers 2046
Database pages 194562
Old database pages 71801
Modified db pages 4785
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 374066489, not young 6945752420
2.31 youngs/s, 8.54 non-youngs/s
Pages read 178690564, created 3318281, written 40050852
1.92 reads/s, 0.00 creates/s, 0.00 writes/s
Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 1 / 1000
Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
LRU len: 194562, unzip_LRU len: 0
I/O sum[999]:cur[6], unzip sum[0]:cur[0]
--------------
ROW OPERATIONS
--------------
0 queries inside InnoDB, 0 queries in queue
60 read views open inside InnoDB
Main thread process no. 8869, id 140312169137920, state: sleeping
Number of rows inserted 1944071555, updated 1418310612, deleted 208324958, read 15636392922485
4.15 inserts/s, 9.08 updates/s, 0.23 deletes/s, 108534.34 reads/s
----------------------------
END OF INNODB MONITOR OUTPUT
============================
|
+--------+------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
1 row in set (0.00 sec)
查看Mysql正在执行的事务、锁、等待 MySQL大无语事件:一次生产环境的死锁事故,看看我怎么排查 面对数据库死锁差点跪
查看分析锁原因
SELECT
ENGINE,
ENGINE_TRANSACTION_ID,
OBJECT_SCHEMA,
OBJECT_NAME,
INDEX_NAME,
LOCK_TYPE,
LOCK_MODE,
LOCK_STATUS,
LOCK_DATA
FROM performance_schema.data_locks;
Understand the basics of locks and deadlocks in MySQL (Part II)
Comments