0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 551787966, ACTIVE 942 sec inserting, thread declared inside InnoDB 5000 mysql tables in use 1, locked 1 1 lock struct(s), heap size 1136, 0 row lock(s) MySQL thread id 717917, OS thread handle 140315486152448, query id 3160890469 10.103.22.58 developer update insert into pay_record(orderid,payamount,paystatus,paychannel,paytype,createtime,innerorderid,merchantid) values ('p1513406072466741022237',5.0,1,1,6,'2017-12-16 14:34:32','ed2c5258-c34f-4942-8192-5fd8b15f164b',102) ---TRANSACTION 551787961, ACTIVE 942 sec inserting, thread declared inside InnoDB 5000 mysql tables in use 1, locked 1 1 lock struct(s), heap size 1136, 0 row lock(s) MySQL thread id 718615, OS thread handle 140306289600256, query id 3160889798 10.103.22.177 developer update insert into pay_record(orderid,payamount,paystatus,paychannel,paytype,createtime,innerorderid,merchantid) values ('p1513406073232468181579',2.0,1,1,6,'2017-12-16 14:34:33','1e9fc20c-e366-40b6-bace-52bde7e04e38',102) ---TRANSACTION 551787948, ACTIVE 942 sec inserting, thread declared inside InnoDB 5000 mysql tables in use 1, locked 1 1 lock struct(s), heap size 1136, 0 row lock(s), undo log entries 1 MySQL thread id 718240, OS thread handle 140306187093760, query id 3160889454 10.103.22.176 developer update insert into pay_record(orderid,payamount,paystatus,paychannel,paytype,createtime,innerorderid,merchantid) values ('p1513406071869846623684',4.0,1,1,6,'2017-12-16 14:34:31','dbe8a48a-8b24-4466-be2e-15588a09e37d',102) -------- FILE I/O --------
Create Table: CREATE TABLE `pay_record` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `orderid` varchar(255) DEFAULT NULL COMMENT '??ID', `transactionid` varchar(255) DEFAULT NULL COMMENT '????ID', `payamount` decimal(10,2) DEFAULT NULL COMMENT '????', `paystatus` tinyint(3) unsigned DEFAULT '1' COMMENT '?????1-????2-????3-???', `paychannel` tinyint(4) unsigned DEFAULT NULL COMMENT '?????1-?????2-????3-????4-????', `paytype` tinyint(4) unsigned DEFAULT NULL COMMENT '?????1-???2-???3-????4-??', `payresult` varchar(3000) DEFAULT NULL COMMENT '?????', `createtime` datetime DEFAULT NULL, `updatetime` datetime DEFAULT NULL, `innerorderid` varchar(255) DEFAULT NULL COMMENT '????ID', `merchantid` tinyint(4) DEFAULT NULL COMMENT '?????: 1-??????2-??APP?3-???APP?4-????5-??????6-????????7-??????', PRIMARY KEY (`id`), UNIQUE KEY `orderid` (`orderid`), UNIQUE KEY `idx_payrecord_innerorderid` (`innerorderid`), KEY `idx_payrecord_createtime` (`createtime`), KEY `idx_payrecord_transactionid` (`transactionid`) ) ENGINE=InnoDB AUTO_INCREMENT=37500995 DEFAULT CHARSET=utf8
0 lock struct(s), heap size 1136, 0 row lock(s) orderid, payamount, paystatus, paychannel, paytype, createtime, innerorderid, merchantid) values ('p151340607246 6741022237' ,5.0,1, 1,6,'2017- 12-16 14:34:32' ,'ed2c5258- c34f-4942- 8192-5fd8b15f16 4b',102) orderid, payamount, paystatus, paychannel, paytype, createtime, innerorderid, merchantid) values ('p151340607323 2468181579' ,2.0,1, 1,6,'2017- 12-16 14:34:33' ,'1e9fc20c- e366-40b6- bace-52bde7e04e 38',102) orderid, payamount, paystatus, paychannel, paytype, createtime, innerorderid, merchantid) values ('p151340607186 9846623684' ,4.0,1, 1,6,'2017- 12-16 14:34:31' ,'dbe8a48a- 8b24-4466- be2e-15588a09e3 7d',102)
---TRANSACTION 551787966, ACTIVE 942 sec inserting, thread declared inside InnoDB 5000
mysql tables in use 1, locked 1
1 lock struct(s), heap size 1136, 0 row lock(s)
MySQL thread id 717917, OS thread handle 140315486152448, query id 3160890469 10.103.22.58 developer update
insert into pay_record(
---TRANSACTION 551787961, ACTIVE 942 sec inserting, thread declared inside InnoDB 5000
mysql tables in use 1, locked 1
1 lock struct(s), heap size 1136, 0 row lock(s)
MySQL thread id 718615, OS thread handle 140306289600256, query id 3160889798 10.103.22.177 developer update
insert into pay_record(
---TRANSACTION 551787948, ACTIVE 942 sec inserting, thread declared inside InnoDB 5000
mysql tables in use 1, locked 1
1 lock struct(s), heap size 1136, 0 row lock(s), undo log entries 1
MySQL thread id 718240, OS thread handle 140306187093760, query id 3160889454 10.103.22.176 developer update
insert into pay_record(
--------
FILE I/O
--------
Create Table: CREATE TABLE `pay_record` ( ????2-? ???3-?? ?', ?????2- ????3-? ???4-?? ??', ???2-?? ?3-???? 4-??', ?2-??APP? 3-???APP? 4-????5- ??????6- ??????? ?7-???? ??', innerorderid` (`innerorderid`), createtime` (`createtime`), transactionid` (`transactionid`) 37500995 DEFAULT CHARSET=utf8
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`orderid` varchar(255) DEFAULT NULL COMMENT '??ID',
`transactionid` varchar(255) DEFAULT NULL COMMENT '????ID',
`payamount` decimal(10,2) DEFAULT NULL COMMENT '????',
`paystatus` tinyint(3) unsigned DEFAULT '1' COMMENT '?????1-
`paychannel` tinyint(4) unsigned DEFAULT NULL COMMENT '?????1-
`paytype` tinyint(4) unsigned DEFAULT NULL COMMENT '?????1-
`payresult` varchar(3000) DEFAULT NULL COMMENT '?????',
`createtime` datetime DEFAULT NULL,
`updatetime` datetime DEFAULT NULL,
`innerorderid` varchar(255) DEFAULT NULL COMMENT '????ID',
`merchantid` tinyint(4) DEFAULT NULL COMMENT '?????: 1-?????
PRIMARY KEY (`id`),
UNIQUE KEY `orderid` (`orderid`),
UNIQUE KEY `idx_payrecord_
KEY `idx_payrecord_
KEY `idx_payrecord_
) ENGINE=InnoDB AUTO_INCREMENT=