For example, you might like to know, for a given InnoDB transaction I the corresponding MySQL session ID and name of the session that may be holding a lock, and thus blocking other transactions. How to examine and kill MySQL client A useful MySQL comman when it comes to keeping track of client-server transactions, is SHOW PROCESSLIST. The LIMIT rowcount clause may be given to limit the output to rowcount rows. Introduction to MySQL SHOW INDEXES command To query the index information of a table, you use the SHOW INDEXES statement as follows: crayon-5db11b7252e To get the index of a table, you specify the. MySQL : MySQL Reference Manual : Id.
MySQL SHOW PROCESSLIST If you do not use the FULL keyword in the SHOW PROCESSLIST comman then only the first 1characters of each statement are returned in the Info column.
MySQL SHOW PROCESSLIST
The MySQL user who issued the statement. MySQL : MySQL Reference Manual : Sometimes it is useful to correlate internal InnoDB locking information with the session-level information maintained by MySQL.