Cheat Sheet logoCheat Sheet Today
MySQL Indexes, EXPLAIN, and Performance Cheatsheet/Explain a currently running connection

Obtain the plan for a statement running in another session.

Back to sheetBrowse commands
Sign in to save
Section: explain and analysis

Explain a currently running connection

sql
sql
EXPLAIN FOR CONNECTION 12345;
Explanation

Helpful during live troubleshooting when you have the blocking or long-running connection id.

View in sheet →

Learn the surrounding workflow

Compare similar commands or jump into common fixes when this command is part of a bigger troubleshooting path.

Compare commandsView fixes

Related commands

Same sheet · prioritizing explain and analysis
Explain a SELECT query
View the optimizer's execution plan.
OpenIn sheetsqlsame section
Run EXPLAIN ANALYZE
Execute the query and include actual timing information.
OpenIn sheetsqlsame section
Refresh table statistics
Update optimizer statistics for a table.
OpenIn sheetsqlsame section
Optimize a table
Reorganize table storage and update index statistics for supported engines.
OpenIn sheetsqlsame section
Create a simple index
Add an index for a frequently filtered column.
OpenIn sheetsql
Create a composite index
Index multiple columns in left-to-right order.
OpenIn sheetsql