xxxxxxxxxx
select * from INFORMATION_SCHEMA.PROCESSLIST where db = 'your_database_name_here';
xxxxxxxxxx
SHOW PROCESSLIST;
xxxxxxxxxx
SHOW FULL PROCESSLIST;
xxxxxxxxxx
DESCRIBE INFORMATION_SCHEMA.PROCESSLIST;
xxxxxxxxxx
SELECT * FROM INFORMATION_SCHEMA.PROCESSLIST;
xxxxxxxxxx
SELECT ID,USER,HOST,DB,TIME,STATE,MEMORY_USED,MAX_MEMORY_USED
FROM INFORMATION_SCHEMA.PROCESSLIST;
xxxxxxxxxx
SELECT ID,TIME,STATE,MEMORY_USED,MAX_MEMORY_USED
FROM INFORMATION_SCHEMA.PROCESSLIST
WHERE DB = `database_name`;
xxxxxxxxxx
SELECT ID,TIME,STATE,MEMORY_USED,MAX_MEMORY_USED
FROM INFORMATION_SCHEMA.PROCESSLIST
WHERE USER = `username`;
xxxxxxxxxx
mysqladmin proc
xxxxxxxxxx
mysql -e 'SHOW PROCESSLIST'
xxxxxxxxxx
mysql -e 'SHOW FULL PROCESSLIST'
xxxxxxxxxx
mysql -e 'SELECT ID,TIME,STATE,MEMORY_USED,MAX_MEMORY_USED
FROM INFORMATION_SCHEMA.PROCESSLIST
WHERE DB = `database_name`;'
xxxxxxxxxx
#Enter into mysql console:
mysql
#Then...
#Access to full query:
SELECT * from INFORMATION_SCHEMA.PROCESSLIST where db = 'your_database_name_here'
#Simplest list
show [full] processlist;
xxxxxxxxxx
# Full query
SELECT * from INFORMATION_SCHEMA.PROCESSLIST where db = 'database_name';
# Running MySQL queries
show [full] processlist;
# Detailed information
SELECT * FROM information_schema.PROCESSLIST p;
SELECT * FROM performance_schema.threads t;