mysql - Clear transaction deadlock? -

Using "show engines show Inrodb position 'I think that WordPress has two deadlock I would like to clear these, But I do not see an active process for any one of these CMDS (ie some 'kill' and hopefully compels a rollback).

I can see the thread ID, query

edit: this is the (relevant?) Part of the situation:

P >

  ------------------------ Latest Decked Deadlocks --------------- - -------- 110,327 10:54:14 *** (1) transactions: transactions 9 FDA 0 99 e, active 0 seconds, operation start number 14207, OS thread ID 1228433728 index 1, lock 1 lock Read mysql table Wait 2 lock struct (s), stack size 376, 1 row lock (s) MySQL thread ID 12,505,112, query id 909492,800 Juno .... edu 129 .... 54 wor Where Remove from dpress_user update wp_options OPTION_NAME = '' _site_transient_timeout_theme_roots '' *** (1) it offered waiting to lock record locks space ID 4951009 page no 4 n bits 384 index `table Ke` option_name` wordpress_work` .`wp_options` TRX ID 9FBA099E lock_ mode x waiting record lock, heap 309 physical record: n_fields 2; Compact format; Info bits 32 0: lane 30; Hex 5f736974655f7472616e7369656e745f74696d656f75745f7468656d655f; Asc _site_transient_timeout_theme_; (Total 35 bytes); 1: lane 8; Hex 0000000000002b6d; ASK + M ;; *** (2) Transaction: Transaction 9FBA0995, active 0 seconds, the process is not 14207, OS thread ID 1230031168 initial index, using 3 lock struct (s 1 reading mysql table 1), heap size 1248, 2 row lock has stopped (s) MySQL thread ID 12505095, query ID 909492789 Juno .... edu 129 ..... 54 Where wordpress_user wp_options OPTION_NAME = '' _site_transient_timeout_theme_roots '' *** (2) lock (s) Remove from update: RECORD locks space ID 4951009 page no 4 n bits 384 index `` option_name` of the table` TRX id 9FBA0995 lock_mode xh Take REC but not record difference wordpress_work`. `Wp_options`, stack no 309 physical records: n_fields 2; Compact format; Info bits 32 0: lane 30; Hex 5f736974655f7472616e7369656e745f74696d656f75745f7468656d655f; Asc _site_transient_timeout_theme_; (Total 35 bytes); 1: lane 8; Hex 0000000000002b6d; ASK + M ;; *** (2) is to be provided Awaiting lock record locks space ID 4951009 page waiting a 4 n bits 384 index `table Ke` option_name` wordpress_work`.`wp_options` TRX ID 9FBA0995 lock_mode X record locking, Stack no 309 physical record: n_fields 2; Compact format; Info bits 32 0: lane 30; Hex 5f736974655f7472616e7369656e745f74696d656f75745f7468656d655f; Asc _site_transient_timeout_theme_; (Total 35 bytes); 1: lane 8; Hex 0000000000002b6d; ASK + M ;; *** We use rollback transaction (1)    
 
 
 some 'inaudible position' output In this way:  
  --- Transfer 0 0, did not start, not process 1024, OS thread ID 140386055603968, MySQL thread ID 197, query ID 771 localhost mark show inaudub status < / Code>  
 you want to  
  kill QUERY 771   
 to kill one of the deadly two questions He will kill the query, but the Let Kshn left open. If you want to kill the connection, then you want to  kill 197 .