show engine innodb status\G 查看最近死锁信息
网上有人说用show engine innodb status\G 可以查看最近死锁信息,可是我的mysql是5.5.15,执行的时候报sql错误You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'show engine innodb status G' at line 1
如果用show engine innodb status却是空的信息,可程序中却明明提示deadlock
有没有其他或者更好的记录死锁日志信息的方法,多谢指教!