Inspect current client connections and statements.
Section: script-friendly client patterns
Show active sessions
sql
sql
SHOW PROCESSLIST;Explanation
Helpful when diagnosing blocked queries or long-running sessions.
Learn the surrounding workflow
Compare similar commands or jump into common fixes when this command is part of a bigger troubleshooting path.
Related commands
Same sheet · prioritizing script-friendly client patterns
Use batch mode for parsable output
Reduce formatting for machine-friendly results.
Log an interactive session to a file
Write statements and output to a transcript file.
Show connection status in the mysql client
Display host, connection id, server version, and current database.