MySQL Common commands

View InnoDB Transaction Table Innodb_trx If there is a transaction thread being locked

SELECT * from INFORMATION_SCHEMA. Innodb_trx;

If the ID exists in the sleep thread inside show full processlist, you need to remove the thread manually

To manually delete a thread:

KILL 616694;

Then view the current database thread condition:

SHOW full processlist;

To view the setting database isolation level:

SELECT @ @tx_isolation;

SELECT @ @global. tx_isolation;

SELECT @ @session. tx_isolation;

Isolation level:

1) READ UNCOMMITTED: Read data that has not yet been committed: no problem is solved

2) Read Committed: Reads the data that has been submitted: can resolve dirty read----Oracle Default

3) Repeatable READ: Reread read: Can resolve dirty read and non-repeatable read---mysql default

4) Serializable: Serialization: Can resolve dirty read non-repeatable read and virtual read---equivalent to the lock table

Set tx_isolation= ' read-committed ';

Show Engine InnoDB Status

MySQL Common commands