innodb stauts中lock信息

------------------------
LATEST DETECTED DEADLOCK
------------------------
111011  9:31:58
*** (1) TRANSACTION:
TRANSACTION 0 266498554, ACTIVE 95 sec, process no 26254, OS thread id 1162017088 starting index read
mysql tables in use 1, locked 1
LOCK WAIT 18 lock struct(s), heap size 3024, undo log entries 39
MySQL thread id 789341, query id 151820807 Updating
update v3_orders set obj_version=28, states='Shipped' where orders_id=2201390 and obj_version=27
*** (1) WAITING FOR THIS LOCK TO BE GRANTED:
RECORD LOCKS space id 0 page no 7296424 n bits 96 index `PRIMARY` of table `products_center_v1/v3_orders` trx id 0 266498554 lock_mode X locks rec but not gap waiting
Record lock, heap no 25 PHYSICAL RECORD: n_fields 82; compact format; info bits 0
 0: len 4; hex 8021972e; asc  ! .;; 1: len 6; hex 00000fe27131; asc     q1;; 2: len 7; hex 00006e00020bc2; asc   n    ;; 3: len 4; hex 8000001b; asc     ;; 4: len 4; hex 80912d37; asc   -7;; 5: len 4; hex 80000001; asc     ;; 6: len 4; hex 80000001; asc     ;; 7: len 4; hex 80000001; asc     ;; 8: len 11; hex 4f726465724c6f636b6564; asc OrderLocked;; 9: len 4; hex 80000000; asc     ;; 10: len 7; hex 31383630333934; asc 1860394;; 11: len 7; hex 32313235343231; asc 2125421;; 12: len 11; hex 64696e612074617279616c; asc dina taryal;; 13: len 0; hex ; asc ;; 14: len 14; hex 34313420656c6d20636972636c65; asc 414 elm circle;; 15: len 0; hex ; asc ;; 16: len 8; hex 6368616c666f6e74; asc chalfont;; 17: len 5; hex 3138393134; asc 18914;; 18: len 12; hex 50656e6e73796c76616e6961; asc Pennsylvania;; 19: len 13; hex 556e6974656420537461746573; asc United States;; 20: len 12; hex 3733322d3330362d31363730; asc 732-306-1670;; 21: len 17; hex 6474617279616c40676d61696c2e636f6d; asc [e-mail];; 22: len 4; hex 80000002; asc     ;; 23: len 11; hex 64696e612074617279616c; asc dina taryal;; 24: len 0; hex ; asc ;; 25: len 14; hex 34313420656c6d20636972636c65; asc 414 elm circle;; 26: len 0; hex ; asc ;; 27: len 8; hex 6368616c666f6e74; asc chalfont;; 28: len 5; hex 3138393134; asc 18914;; 29: len 12; hex 50656e6e73796c76616e6961; asc Pennsylvania;; 30: len 13; hex 556e6974656420537461746573; asc United States;; 31: len 14; hex 312d3733322d3330362d31363730; asc 1-732-306-1670;; 32: len 4; hex 80000002; asc     ;; 33: len 11; hex 64696e612074617279616c; asc dina taryal;; 34: len 0; hex ; asc ;; 35: len 14; hex 34313420656c6d20636972636c65; asc 414 elm circle;; 36: len 0; hex ; asc ;; 37: len 8; hex 6368616c666f6e74; asc chalfont;; 38: len 5; hex 3138393134; asc 18914;; 39: len 12; hex 50656e6e73796c76616e6961; asc Pennsylvania;; 40: len 13; hex 556e6974656420537461746573; asc United States;; 41: len 14; hex 312d3733322d3330362d31363730; asc 1-732-306-1670;; 42: len 4; hex 80000002; asc     ;; 43: len 20; hex 437265646974206f722044656269742043617264; asc Credit or Debit Card;; 44: len 13; hex 676c6f62616c636f6c6c656374; asc globalcollect;; 45: len 4; hex 37d708b5; asc 7   ;; 46: len 4; hex 4e8a697b; asc N i{;; 47: len 4; hex 4e727c4b; asc Nr|K;; 48: len 4; hex 00000000; asc     ;; 49: len 4; hex 4e72ae7b; asc Nr {;; 50: len 4; hex 4e728184; asc Nr  ;; 51: len 4; hex 4e843af2; asc N : ;; 52: len 9; hex 457870656469746564; asc Expedited;; 53: len 8; hex 6368696e61757073; asc chinaups;; 54: len 0; hex ; asc ;; 55: len 3; hex 555344; asc USD;; 56: len 7; hex 80000001000000; asc        ;; 57: len 7; hex 800000e90d9490; asc        ;; 58: len 7; hex 80000000000000; asc        ;; 59: len 13; hex 37312e3138352e33322e313231; asc 71.185.32.121;; 60: SQL NULL; 61: len 30; hex 312e313331363132353539342e382e382e75746d67636c69643d434c6a42; asc 1.1316125594.8.8.utmgclid=CLjB;...(truncated); 62: len 24; hex 4141414141453570416b6c4a6d45337a4132435441673d3d; asc AAAAAE5pAklJmE3zA2CTAg==;; 63: SQL NULL; 64: len 7; hex 8000001f0dd504; asc        ;; 65: len 7; hex 800000c70f1b30; asc       0;; 66: len 30; hex 333020e785a7e78987e8af81e5ae9ee5b8a6e5ad90e6bc8fe58f91efbc9b; asc 30                            ;...(truncated); 67: len 4; hex 80000000; asc     ;; 68: len 7; hex 800000e90d9490; asc        ;; 69: len 4; hex 80000000; asc     ;; 70: len 0; hex ; asc ;; 71: len 0; hex ; asc ;; 72: len 7; hex 800000e90d9490; asc        ;; 73: len 4; hex 80000000; asc     ;; 74: SQL NULL; 75: SQL NULL; 76: SQL NULL; 77: len 4; hex 80000000; asc     ;; 78: len 4; hex 00000000; asc     ;; 79: len 4; hex 80000000; asc     ;; 80: SQL NULL; 81: len 4; hex 4e939e56; asc N  V;;

*** (2) TRANSACTION:
TRANSACTION 0 266498470, ACTIVE 118 sec, process no 26254, OS thread id 1169844544 starting index read, thread declared inside InnoDB 398
mysql tables in use 5, locked 5
216146 lock struct(s), heap size 19838960
MySQL thread id 789918, query id 151819264 172.16.0.8 db_admin Copying to tmp table
CREATE TEMPORARY TABLE chen_delivery_country_order
SELECT o.orders_id,
 o.merchant_orders_id,
 o.delivery_country,
 o.order_payment_confirm_time,
 i.orders_products_sku,
 i.orders_lsin,
 info.product_name,
 info.sku_attr,
 i.products_qty,
 i.products_price,
 i.products_amount,
 i.states,
 o.promise_deliver_time,
 i.matched_inventory_id
 FROM v3_orders o
 JOIN v3_orders_items i
 ON i.orders_id=o.orders_id
 JOIN v3_sku_info info
 ON info.sku=i.orders_products_sku
 JOIN categories c
 ON info.category_id=c.categories_id
WHERE order_payment_confirm_time>=@starttime
AND order_payment_confirm_time<@endtime
AND delivery_country IN('France, DOM-TOM R鵮ion','Czech Republic')
AND c.categories_no LIKE '01%'
GROUP BY o.orders_id
*** (2) HOLDS THE LOCK(S):
RECORD LOCKS space id 0 page no 7296424 n bits 96 index `PRIMARY` of table `products_center_v1/v3_orders` trx id 0 266498470 lock mode S locks rec but not gap
Record lock, heap no 2 PHYSICAL RECORD: n_fields 82; compact format; info bits 0
 0: len 4; hex 80219729; asc  ! );; 1: len 6; hex 00000dcda85e; asc      ^;; 2: len 7; hex 000053a9eb153b; asc   S   ;;; 3: len 4; hex 80000003; asc     ;; 4: len 4; hex 80912d1f; asc   - ;; 5: len 4; hex 80000001; asc     ;; 6: len 4; hex 80000004; asc     ;; 7: len 4; hex 80000001; asc     ;; 8: len 7; hex 50656e64696e67; asc Pending;; 9: len 4; hex 80000000; asc     ;; 10: len 7; hex 31383630333839; asc 1860389;; 11: len 7; hex 32313235343430; asc 2125440;; 12: len 10; hex 486f616e67205068616d; asc Hoang Pham;; 13: len 0; hex ; asc ;; 14: len 17; hex 4e75657274696e6765727374722e203430; asc Nuertingerstr. 40;; 15: len 0; hex ; asc ;; 16: len 10; hex 426f65626c696e67656e; asc Boeblingen;; 17: len 5; hex 3731303332; asc 71032;; 18: len 16; hex 426164656e2d57727474656d62657267; asc Baden-Wrttemberg;; 19: len 7; hex 4765726d616e79; asc Germany;; 20: len 10; hex 37303331393838383230; asc 7031988820;; 21: len 15; hex 7068616d64756e6740676d782e6465; asc [e-mail];; 22: len 4; hex 80000005; asc     ;; 23: len 10; hex 486f616e67205068616d; asc Hoang Pham;; 24: len 0; hex ; asc ;; 25: len 17; hex 4e75657274696e6765727374722e203430; asc Nuertingerstr. 40;; 26: len 0; hex ; asc ;; 27: len 10; hex 426f65626c696e67656e; asc Boeblingen;; 28: len 5; hex 3731303332; asc 71032;; 29: len 16; hex 426164656e2d57727474656d62657267; asc Baden-Wrttemberg;; 30: len 7; hex 4765726d616e79; asc Germany;; 31: len 13; hex 34392d37303331393838383230; asc 49-7031988820;; 32: len 4; hex 80000005; asc     ;; 33: len 10; hex 486f616e67205068616d; asc Hoang Pham;; 34: len 0; hex ; asc ;; 35: len 17; hex 4e75657274696e6765727374722e203430; asc Nuertingerstr. 40;; 36: len 0; hex ; asc ;; 37: len 10; hex 426f65626c696e67656e; asc Boeblingen;; 38: len 5; hex 3731303332; asc 71032;; 39: len 16; hex 426164656e2d57727474656d62657267; asc Baden-Wrttemberg;; 40: len 7; hex 4765726d616e79; asc Germany;; 41: len 13; hex 34392d37303331393838383230; asc 49-7031988820;; 42: len 4; hex 80000005; asc     ;; 43: len 10; hex 50617970616c2049504e; asc Paypal IPN;; 44: len 6; hex 70617970616c; asc paypal;; 45: len 4; hex 37d708b5; asc 7   ;; 46: len 4; hex 00000000; asc     ;; 47: len 4; hex 4e727bf0; asc Nr{ ;; 48: len 4; hex 00000000; asc     ;; 49: len 4; hex 00000000; asc     ;; 50: len 4; hex 00000000; asc     ;; 51: len 4; hex 00000000; asc     ;; 52: len 9; hex 457870656469746564; asc Expedited;; 53: len 8; hex 6368696e61757073; asc chinaups;; 54: len 0; hex ; asc ;; 55: len 3; hex 455552; asc EUR;; 56: len 7; hex 800000000b7434; asc      t4;; 57: len 7; hex 8000008a0a3930; asc      90;; 58: len 7; hex 80000000000000; asc        ;; 59: len 14; hex 39352e3131352e3134322e323338; asc 95.115.142.238;; 60: SQL NULL; 61: len 30; hex 312e313331363033373339332e31302e392e75746d6373723d6d625f4b65; asc 1.1316037393.10.9.utmcsr=mb_Ke;...(truncated); 62: len 24; hex 414141414145357632724b61386b7a4742426b6c41673d3d; asc AAAAAE5v2rKa8kzGBBklAg==;; 63: SQL NULL; 64: len 7; hex 800000250edf6c; asc    %  l;; 65: len 7; hex 800000620ad570; asc    b  p;; 66: SQL NULL; 67: len 4; hex 80000000; asc     ;; 68: len 7; hex 8000008a0a3930; asc      90;; 69: len 4; hex 80000000; asc     ;; 70: len 0; hex ; asc ;; 71: len 0; hex ; asc ;; 72: len 7; hex 80000000000000; asc        ;; 73: len 4; hex 80000000; asc     ;; 74: SQL NULL; 75: SQL NULL; 76: SQL NULL; 77: SQL NULL; 78: len 4; hex 00000000; asc     ;; 79: len 4; hex 80000000; asc     ;; 80: SQL NULL; 81: len 4; hex 4e73f4f6; asc Ns  ;;