MySQL Application tips

1. View MySQL deadlock

SELECT * from INFORMATION_SCHEMA. Innodb_trx;

2. Viewing transactions that are being locked

SELECT * from INFORMATION_SCHEMA.  Innodb_locks; 3. Viewing a transaction waiting for a lockSELECT * from INFORMATION_SCHEMA. Innodb_lock_waits; 4. View current system timeselect Sysdate (); 5. End the thread ID for a transactionkill thread ID;6. View the default encoding for MySQL databaseShow variables like ' char% '; #or enter: status on the command line;7. View the number of connections, statusshow Processlist; #默认只列出100条, show full processlist is required to use all forms;Show status; #可使用show status like '% variable% ';

MySQL Application tips