Skip to main content

SHOW PROCESSLIST & SHOW ENGINE INNODB STATUS

Learn SHOW PROCESSLIST & SHOW ENGINE INNODB STATUS (MySQL Performance Tuning, MySQL) with worked examples, diagrams and interview questions. Free on JavaSchoolLab.

Introduction SHOW PROCESSLIST lists every connection and what it is doing now. SHOW ENGINE INNODB STATUS prints an InnoDB snapshot: latest deadlock, transactions, semaphores, buffer pool and log state.

More lessons in MySQL Performance Tuning