Comment 6 for bug 1738526

Revision history for this message
tuna (ant750505) wrote :

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