Database/Basic
[MySql] SHOW FULL PROCESSLIST 를 더 명확하게~!
CJ.Ree
2016. 12. 7. 12:49
# Before
SHOW FULL PROCESSLIST;
# After
SELECT * FROM INFORMATION_SCHEMA.PROCESSLIST;
SELECT * FROM INFORMATION_SCHEMA.PROCESSLIST WHERE USER = 'chang-jae.lee';
SELECT * FROM INFORMATION_SCHEMA.PROCESSLIST ORDER BY TIME DESC;
참고 : http://stackoverflow.com/questions/929612/how-to-customize-show-processlist-in-mysql