Здравствуйте, . Hi all, i have some strange records in InnoDB status, what does they all mean?
*** (2) TRANSACTION: TRANSACTION 0 139334621, ACTIVE 1 sec, process no 594, OS thread id 2725583792 fetching rows, thread declared inside InnoDB 425 mysql tables in use 1, locked 1 1815 lock struct(s), heap size 142656 MySQL thread id 383044, query id 11693546 localhost asg updating DELETE FROM xxxx WHERE download_id='1021022' AND transport_type='0' *** (2) HOLDS THE LOCK(S): RECORD LOCKS space id 0 page no 1391087 n bits 240 index `PRIMARY` of table `xxx/xxxxx` trx id 0 139334621 lock_mode X Record lock, heap no 1 PHYSICAL RECORD: n_fields 1; compact format; info bits 0 0: len 8; hex 73757072656d756d; asc supremum;; Record lock, heap no 2 PHYSICAL RECORD: n_fields 15; compact format; info bits 0 0: len 4; hex 0152c540; asc R @;; 1: len 4; hex 000f5a93; asc Z ;; 2: len 4; hex 80000001; asc ;; 3: len 4; hex 00000000; asc ;; 4: len 6; hex 00000826da0b; asc & ;; 5: len 7; hex 8000064007384b; asc @ 8K;; 6: len 8; hex 8000123ec0841ace; asc > ;; 7: len 4; hex 8 0000462; asc b;; 8: len 8; hex 0000000000000000; asc ;; 9: len 8; hex 0000000000000000; asc ;; 10: len 8; hex 000000000000000 0; asc ;; 11: len 8; hex 0000000000000000; asc ;; 12: len 8; hex 0000000000000000; asc ;; 13: len 3; hex 757364; asc usd ;; 14: len 1; hex 00; asc ;; Record lock, heap no 3 PHYSICAL RECORD: n_fields 15; compact format; info bits 0 0: len 4; hex 0152c54c; asc R L;; 1: len 4; hex 000f5a74; asc Zt;; 2: len 4; hex 80000001; asc ;; 3: len 4; hex 00000000; asc ;; 4: len 6; hex 00000826da0b; asc & ;; 5: len 7; hex 80000640073868; asc @ 8h;; 6: len 8; hex 8000123ec083c571; asc > q;; 7: len 4; hex 8 0000437; asc 7;; 8: len 8; hex 0000000000000000; asc ;; 9: len 8; hex 0000000000000000; asc ;; 10: len 8; hex 000000000000000 0; asc ;; 11: len 8; hex 0000000000000000; asc ;; 12: len 8; hex 0000000000000000; asc ;; 13: len 3; hex 727572; asc rur ;; 14: len 1; hex 00; asc ;; -- С уважением, Vitaliy mailto:[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
