mysql 設定 innodb_print_all_deadlocks=ON, 儲存死結日誌

標籤：ted   mic   error log   class   and   oss   info   dev   border   

Introduced	5.6.2
Command-Line Format	--innodb-print-all-deadlocks=#
System Variable	Name	innodb_print_all_deadlocks
	Scope	Global
	Dynamic	Yes
Permitted Values	Type	boolean
	Default	OFF

When this option is enabled, information about all deadlocks in InnoDB user transactions is recorded in the mysqld error log. Otherwise, you see information about only the last deadlock, using the SHOW ENGINE INNODB STATUS command. 

 

開啟配置時，死結日誌存放到error_log配置的檔案裡面

mysql 設定 innodb_print_all_deadlocks=ON, 儲存死結日誌