When use the SHOW PROCESSLIST vs SELECT * FROM information_schema.PROCESSLIST command?
3
votes
1
answer
129
views
In MySQL 8 server community the two following commands show the same structure:
SHOW PROCESSLIST;
SELECT * FROM information_schema.PROCESSLIST;
**Question**
* When use the SHOW PROCESSLIST
vs SELECT * FROM information_schema.PROCESSLIST
command?
Each command exists for a specific reason, right?
About their outputs I only found two differences for the State
and Info
columns for each command respectively:
State | Info
----------------------------
init | SHOW PROCESSLIST
executing | SELECT * FROM information_schema.PROCESSLIST
The difference of the Info
column is clear because it represents the command itself that was executed **but**:
* Why is different the State
column?
Is clear the executing
value but:
* What does the init
value mean?
Asked by Manuel Jordan
(229 rep)
Apr 17, 2025, 05:24 PM
Last activity: Apr 18, 2025, 04:35 PM
Last activity: Apr 18, 2025, 04:35 PM