Sample Header Ad - 728x90

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