SHOW FULL PROCESSLIST state code example

Example: myswql show full processlist

select * from INFORMATION_SCHEMA.PROCESSLIST where db = 'your_database_name_here';