MySQL Forums
Forum List  »  Performance

mysql commit slow,please help me
Posted by: jw maple
Date: July 27, 2016 02:11AM

this is my mysql binlog, insert or update sql is fast but the last commit take 34 sencond. and it not every time happend.

BEGIN
/*!*/;
# at 1479647
# at 1479679
#160727 15:19:15 server id 1 end_log_pos 1479679 CRC32 0xf4f86a3e Intvar
SET INSERT_ID=730032/*!*/;
#160727 15:19:15 server id 1 end_log_pos 1481460 CRC32 0xe81195e4 Query thread_id=1479 exec_time=0 error_code=0
use `nubia_portal_dev`/*!*/;
SET TIMESTAMP=1469603955/*!*/;
INSERT INTO nubia_portal_dev.Orders (`siteId`,`source`,`orderSn`,`couponAmount`,`creditAmount`,`shippingId`,`shippingName`,`paymentCode`,`bankCode`,`selfcollectionCode`,`codAmount`,`shippingAmount`,`productAmount`,`cashCouponAmount`,`orderAmount`,`minusAmount`,`discountAmount`,`paymentFee`,`memberId`,`memberEmail`,`paymentName`,`promotionIds`,`receiptInfo`,`postscript`,`remark`,`installmentCnt`,`installmentDue`,`flag`,`creditReturn`,`consignee`,`regionId`,`regionName`,`address`,`zipcode`,`mobile`,`phone`,`shippingTime`,`addTime`,`reverseOrderSn`,`payTime`,`shipTime`,`orderStatus`,`paymentStatus`,`shippingStatus`,`statusDesc`,`promotionCodeAmount`,`paidAmount`,`refundAmount`,`invoiceNumber`,`regionPath`,`caseId`,`agent`,`srNumber`,`masterId`,`wmsOrderId`,`payInfo`,`refundInfo`,`expressName`,`expressId`,`expressUrl`,`finishTime`,`orderType`,`orgOrderSn`,`tradeSn`,`orderSource`,`sourceOrderSn`,`delayShipTime`,`shippingNode`,`hasGetShippingNodeCount`,`creditId`,`earnestAmount`,`thirdCreditAmount`,`alipayPointAmount`,`pccAmount`,`recyleAmount`,`giftAmount`) VALUES ('201','16','AP160727151926788125','0','0','3','快递','alipay','','','0','0','1499','0','1499','0','0','0','4023','fff@qq.com','支付宝','180','a:3:{s:5:\"title\";s:6:\"个人\";s:7:\"content\";s:6:\"明细\";s:11:\"needReceipt\";i:1;}','','','0','0','','1499','郡王','143','福建省 福州市 鼓楼区','华林路155号新华兴大厦18层努比亚技术有限公司','','18650397495','','WorkingDay','1469603966','521887629151727061PA','0','0','120','130','150','未确认','0','0','0','','/141/142/143/','0','','','0','','','','','0','','0','0','','','','','0','','0','0','0','0','0','0','0','0')
/*!*/;
# at 1481460
# at 1481492
#160727 15:19:15 server id 1 end_log_pos 1481492 CRC32 0x48b4e505 Intvar
SET INSERT_ID=2870898/*!*/;
#160727 15:19:15 server id 1 end_log_pos 1481861 CRC32 0xb609faa2 Query thread_id=1479 exec_time=0 error_code=0
SET TIMESTAMP=1469603955/*!*/;
INSERT INTO nubia_portal_dev.OrderOperateLogs (`siteId`,`orderId`,`shippingStatus`,`orderStatus`,`paymentStatus`,`operator`,`changeLog`,`remark`,`logTime`) VALUES ('201','730032','150','120','130','APP用户','s:24:\"订单来源:APP订单\";','APP下单','1469603966')
/*!*/;
# at 1481861
# at 1481893
#160727 15:19:15 server id 1 end_log_pos 1481893 CRC32 0x9055eb47 Intvar
SET INSERT_ID=1303754/*!*/;
#160727 15:19:15 server id 1 end_log_pos 1482421 CRC32 0x81493e5f Query thread_id=1479 exec_time=0 error_code=0
SET TIMESTAMP=1469603955/*!*/;
INSERT INTO nubia_portal_dev.OrderProducts (`siteId`,`sku`,`price`,`number`,`productId`,`productName`,`productType`,`brandId`,`cateId`,`imageId`,`orderId`,`salePrice`,`parentId`,`additional`,`url`,`discountPrice`,`lineDiscountAmount`,`minusPrice`) VALUES ('201','NX511J-DCC-304BB-G02','1499','1','645','nubia Z9 mini(精英版 黑色)','0','4','17','pic/144651982093.png','730032','1499','0','0','nubiaz9mini/pro','0','0','0')
/*!*/;
# at 1482421
#160727 15:19:15 server id 1 end_log_pos 1482613 CRC32 0x33cd625a Query thread_id=1479 exec_time=0 error_code=0
SET TIMESTAMP=1469603955/*!*/;
UPDATE nubia_portal_dev.ProductStocks SET stock=stock-1 WHERE `ProductStocks`.`specId` = '645'
/*!*/;
# at 1482613
#160727 15:19:15 server id 1 end_log_pos 1482835 CRC32 0x8a1f638f Query thread_id=1479 exec_time=0 error_code=0
SET TIMESTAMP=1469603955/*!*/;
UPDATE nubia_portal_dev.ProductSpecs SET stock=stock-1 WHERE `ProductSpecs`.`siteId` = '201' AND `ProductSpecs`.`id` = '645'
/*!*/;
# at 1482835
# at 1482867
#160727 15:19:15 server id 1 end_log_pos 1482867 CRC32 0xf7c77bcf Intvar
SET INSERT_ID=442026/*!*/;
#160727 15:19:15 server id 1 end_log_pos 1483101 CRC32 0xbf72eca3 Query thread_id=1479 exec_time=0 error_code=0
SET TIMESTAMP=1469603955/*!*/;
INSERT INTO nubia_portal_dev.Cases (`siteId`,`workflowId`,`caseStatus`,`startTime`,`endTime`) VALUES ('201','6','open','1469603966','0')
/*!*/;
# at 1483101
#160727 15:19:15 server id 1 end_log_pos 1485088 CRC32 0x565d5fb7 Query thread_id=1479 exec_time=0 error_code=0
SET TIMESTAMP=1469603955/*!*/;
UPDATE nubia_portal_dev.Orders SET `siteId` = '201',`source` = '16',`orderSn` = 'AP160727151926788125',`couponAmount` = '0',`creditAmount` = '0',`shippingId` = '3',`shippingName` = '快递',`paymentCode` = 'alipay',`bankCode` = '',`selfcollectionCode` = '',`codAmount` = '0',`shippingAmount` = '0',`productAmount` = '1499',`cashCouponAmount` = '0',`orderAmount` = '1499',`minusAmount` = '0',`discountAmount` = '0',`paymentFee` = '0',`memberId` = '4023',`memberEmail` = 'fff@qq.com',`paymentName` = '支付宝',`promotionIds` = '180',`receiptInfo` = 'a:3:{s:5:\"title\";s:6:\"个人\";s:7:\"content\";s:6:\"明细\";s:11:\"needReceipt\";i:1;}',`postscript` = '',`remark` = '',`installmentCnt` = '0',`installmentDue` = '0',`flag` = '',`creditReturn` = '1499',`consignee` = '郡王',`regionId` = '143',`regionName` = '福建省 福州市 鼓楼区',`address` = '华林路155号新华兴大厦18层努比亚技术有限公司',`zipcode` = '',`mobile` = '18650397495',`phone` = '',`shippingTime` = 'WorkingDay',`addTime` = '1469603966',`reverseOrderSn` = '521887629151727061PA',`payTime` = '0',`shipTime` = '0',`orderStatus` = '120',`paymentStatus` = '130',`shippingStatus` = '150',`statusDesc` = '未确认',`promotionCodeAmount` = '0',`paidAmount` = '0',`refundAmount` = '0',`invoiceNumber` = '',`regionPath` = '/141/142/143/',`caseId` = '442026',`agent` = '',`srNumber` = '',`masterId` = '0',`wmsOrderId` = '',`payInfo` = '',`refundInfo` = '',`expressName` = '',`expressId` = '0',`expressUrl` = '',`finishTime` = '0',`orderType` = '0',`orgOrderSn` = '',`tradeSn` = '',`orderSource` = '',`sourceOrderSn` = '',`delayShipTime` = '0',`shippingNode` = '',`hasGetShippingNodeCount` = '0',`creditId` = '0',`earnestAmount` = '0',`thirdCreditAmount` = '0',`alipayPointAmount` = '0',`pccAmount` = '0',`recyleAmount` = '0',`giftAmount` = '0' WHERE `Orders`.`siteId` = '201' AND `Orders`.`id` = '730032'
/*!*/;
# at 1485088
# at 1485120
#160727 15:19:15 server id 1 end_log_pos 1485120 CRC32 0xe59c0081 Intvar
SET INSERT_ID=248135/*!*/;
#160727 15:19:15 server id 1 end_log_pos 1485372 CRC32 0xe9cc61fc Query thread_id=1479 exec_time=0 error_code=0
SET TIMESTAMP=1469603955/*!*/;
INSERT INTO nubia_portal_dev.Tokens (`caseId`,`placeId`,`tokenStatus`,`enabledTime`,`cancelledTime`,`consumedTime`) VALUES ('442026','44','2','0','0','0')
/*!*/;
# at 1485372
#160727 15:19:15 server id 1 end_log_pos 1485664 CRC32 0x2f7ee88a Query thread_id=1479 exec_time=0 error_code=0
SET TIMESTAMP=1469603955/*!*/;
UPDATE nubia_portal_dev.Tokens SET `caseId` = '442026',`placeId` = '44',`tokenStatus` = '1',`enabledTime` = '1469603966',`cancelledTime` = '0',`consumedTime` = '0' WHERE `Tokens`.`id` = '248135'
/*!*/;
# at 1485664
# at 1485696
#160727 15:19:16 server id 1 end_log_pos 1485696 CRC32 0x7e475524 Intvar
SET INSERT_ID=689444/*!*/;
#160727 15:19:16 server id 1 end_log_pos 1486077 CRC32 0x72f8b287 Query thread_id=1479 exec_time=0 error_code=0
SET TIMESTAMP=1469603956/*!*/;
INSERT INTO nubia_portal_dev.WorkItems (`caseId`,`transitionId`,`transitionTrigger`,`taskId`,`workItemStatus`,`enabledTime`,`cancelledTime`,`finishedTime`,`deadline`) VALUES ('442026','95','1','Applications\\Oss\\Shop\\Workflow\\Pecorder\\FreelyReceive','1','1469603966','0','0','0')
/*!*/;
# at 1486077
# at 1486109
#160727 15:19:16 server id 1 end_log_pos 1486109 CRC32 0xbcc403f4 Intvar
SET INSERT_ID=689445/*!*/;
#160727 15:19:16 server id 1 end_log_pos 1486486 CRC32 0xdfcf12f2 Query thread_id=1479 exec_time=0 error_code=0
SET TIMESTAMP=1469603956/*!*/;
INSERT INTO nubia_portal_dev.WorkItems (`caseId`,`transitionId`,`transitionTrigger`,`taskId`,`workItemStatus`,`enabledTime`,`cancelledTime`,`finishedTime`,`deadline`) VALUES ('442026','85','1','Applications\\Oss\\Shop\\Workflow\\Pecorder\\manualPay','1','1469603966','0','0','0')
/*!*/;
# at 1486486
# at 1486518
#160727 15:19:16 server id 1 end_log_pos 1486518 CRC32 0x569c4917 Intvar
SET INSERT_ID=689446/*!*/;
#160727 15:19:16 server id 1 end_log_pos 1486895 CRC32 0x0c17cbec Query thread_id=1479 exec_time=0 error_code=0
SET TIMESTAMP=1469603956/*!*/;
INSERT INTO nubia_portal_dev.WorkItems (`caseId`,`transitionId`,`transitionTrigger`,`taskId`,`workItemStatus`,`enabledTime`,`cancelledTime`,`finishedTime`,`deadline`) VALUES ('442026','60','3','Applications\\Oss\\Shop\\Workflow\\Pecorder\\PayOnline','1','1469603966','0','0','0')
/*!*/;
# at 1486895
# at 1486927
#160727 15:19:16 server id 1 end_log_pos 1486927 CRC32 0x09b61d1d Intvar
SET INSERT_ID=689447/*!*/;
#160727 15:19:16 server id 1 end_log_pos 1487301 CRC32 0x9ffed492 Query thread_id=1479 exec_time=0 error_code=0
SET TIMESTAMP=1469603956/*!*/;
INSERT INTO nubia_portal_dev.WorkItems (`caseId`,`transitionId`,`transitionTrigger`,`taskId`,`workItemStatus`,`enabledTime`,`cancelledTime`,`finishedTime`,`deadline`) VALUES ('442026','59','1','Applications\\Oss\\Shop\\Workflow\\Pecorder\\Cancel','1','1469603966','0','0','0')
/*!*/;
# at 1487301
# at 1487333
#160727 15:19:16 server id 1 end_log_pos 1487333 CRC32 0xecd45df4 Intvar
SET INSERT_ID=689448/*!*/;
#160727 15:19:16 server id 1 end_log_pos 1487704 CRC32 0x2afb7e12 Query thread_id=1479 exec_time=0 error_code=0
SET TIMESTAMP=1469603956/*!*/;
INSERT INTO nubia_portal_dev.WorkItems (`caseId`,`transitionId`,`transitionTrigger`,`taskId`,`workItemStatus`,`enabledTime`,`cancelledTime`,`finishedTime`,`deadline`) VALUES ('442026','58','1','Applications\\Oss\\Shop\\Workflow\\Pecorder\\Pay','1','1469603966','0','0','0')
/*!*/;
# at 1487704
# at 1487736
#160727 15:19:16 server id 1 end_log_pos 1487736 CRC32 0x37fb843f Intvar
SET INSERT_ID=689449/*!*/;
#160727 15:19:16 server id 1 end_log_pos 1488114 CRC32 0x9f517fd3 Query thread_id=1479 exec_time=0 error_code=0
SET TIMESTAMP=1469603956/*!*/;
INSERT INTO nubia_portal_dev.WorkItems (`caseId`,`transitionId`,`transitionTrigger`,`taskId`,`workItemStatus`,`enabledTime`,`cancelledTime`,`finishedTime`,`deadline`) VALUES ('442026','57','1','Applications\\Oss\\Shop\\Workflow\\Pecorder\\CadConfirm','1','1469603966','0','0','0')
/*!*/;
# at 1488114
#160727 15:19:16 server id 1 end_log_pos 1488742 CRC32 0x328f3910 Query thread_id=1479 exec_time=0 error_code=0
SET TIMESTAMP=1469603956/*!*/;
UPDATE nubia_portal_dev.OrderProducts SET `siteId` = '201',`orderId` = '730032',`productType` = '0',`productId` = '645',`productName` = 'nubia Z9 mini(精英版 黑色)',`imageId` = 'pic/144651982093.png',`sku` = 'NX511J-DCC-304BB-G02',`parentId` = '0',`price` = '1499',`salePrice` = '1499',`number` = '1',`lineDiscountAmount` = '0',`cateId` = '17',`brandId` = '4',`additional` = '0',`url` = 'nubiaz9mini/pro',`discountPrice` = '0',`minusPrice` = '0' WHERE `OrderProducts`.`siteId` = '201' AND `OrderProducts`.`id` = '1303754'
/*!*/;
# at 1488742
#160727 15:19:16 server id 1 end_log_pos 1490729 CRC32 0xe1d19c45 Query thread_id=1479 exec_time=0 error_code=0
SET TIMESTAMP=1469603956/*!*/;
UPDATE nubia_portal_dev.Orders SET `siteId` = '201',`source` = '16',`orderSn` = 'AP160727151926788125',`couponAmount` = '0',`creditAmount` = '0',`shippingId` = '3',`shippingName` = '快递',`paymentCode` = 'alipay',`bankCode` = '',`selfcollectionCode` = '',`codAmount` = '0',`shippingAmount` = '0',`productAmount` = '1499',`cashCouponAmount` = '0',`orderAmount` = '1499',`minusAmount` = '0',`discountAmount` = '0',`paymentFee` = '0',`memberId` = '4023',`memberEmail` = 'fff@qq.com',`paymentName` = '支付宝',`promotionIds` = '180',`receiptInfo` = 'a:3:{s:5:\"title\";s:6:\"个人\";s:7:\"content\";s:6:\"明细\";s:11:\"needReceipt\";i:1;}',`postscript` = '',`remark` = '',`installmentCnt` = '0',`installmentDue` = '0',`flag` = '',`creditReturn` = '1499',`consignee` = '郡王',`regionId` = '143',`regionName` = '福建省 福州市 鼓楼区',`address` = '华林路155号新华兴大厦18层努比亚技术有限公司',`zipcode` = '',`mobile` = '18650397495',`phone` = '',`shippingTime` = 'WorkingDay',`addTime` = '1469603966',`reverseOrderSn` = '521887629151727061PA',`payTime` = '0',`shipTime` = '0',`orderStatus` = '120',`paymentStatus` = '130',`shippingStatus` = '150',`statusDesc` = '未确认',`promotionCodeAmount` = '0',`paidAmount` = '0',`refundAmount` = '0',`invoiceNumber` = '',`regionPath` = '/141/142/143/',`caseId` = '442026',`agent` = '',`srNumber` = '',`masterId` = '0',`wmsOrderId` = '',`payInfo` = '',`refundInfo` = '',`expressName` = '',`expressId` = '0',`expressUrl` = '',`finishTime` = '0',`orderType` = '0',`orgOrderSn` = '',`tradeSn` = '',`orderSource` = '',`sourceOrderSn` = '',`delayShipTime` = '0',`shippingNode` = '',`hasGetShippingNodeCount` = '0',`creditId` = '0',`earnestAmount` = '0',`thirdCreditAmount` = '0',`alipayPointAmount` = '0',`pccAmount` = '0',`recyleAmount` = '0',`giftAmount` = '0' WHERE `Orders`.`siteId` = '201' AND `Orders`.`id` = '730032'
/*!*/;
# at 1490729
#160727 15:19:16 server id 1 end_log_pos 1490760 CRC32 0x79a8a9c8 Xid = 19573
COMMIT/*!*/;
# at 1490760
#160727 15:19:50 server id 1 end_log_pos 1490863 CRC32 0x46c98360 Query thread_id=1479 exec_time=0 error_code=0

Options: ReplyQuote


Subject
Views
Written By
Posted
mysql commit slow,please help me
817
July 27, 2016 02:11AM


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

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