Skip to content

Instantly share code, notes, and snippets.

@jabarrioss

jabarrioss/mysql_debug_queries.sql

Created November 2, 2023 17:44
Show Gist options
  • Save jabarrioss/a7dd80d9415803f23dd8c6bc4c005b85 to your computer and use it in GitHub Desktop.
Save jabarrioss/a7dd80d9415803f23dd8c6bc4c005b85 to your computer and use it in GitHub Desktop.
Download ZIP
MySQL debug queries
Raw
mysql_debug_queries.sql
SHOW OPEN TABLES WHERE In_use > 0;
SELECT * FROM `information_schema`.`innodb_trx` ORDER BY `trx_started`;
SELECT * FROM `information_schema`.`innodb_locks`;
SHOW FULL PROCESSLIST;
SHOW ENGINE InnoDB STATUS;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment