728x90
SELECT * FROM INFORMATION_SCHEMA.PROCESSLIST where time > 10 and info is not null;
how to customize `show processlist` in mysql? 2009.05.30
http://stackoverflow.com/questions/929612/how-to-customize-show-processlist-in-mysql
Chapter 23 The INFORMATION_SCHEMA PROCESSLIST Table
https://dev.mysql.com/doc/mysql-infoschema-excerpt/5.1/en/processlist-table.html
728x90
'mysql' 카테고리의 다른 글
복제 Replication (0) | 2018.12.19 |
---|---|
샤딩 sharding (0) | 2018.12.19 |
트랜잭션 Transcation, 락 Lock, 격리수준 IsolationLevel (0) | 2018.12.18 |
파티셔닝 Partitioning (0) | 2018.12.17 |
Azure Linux VM에서 MySQL 성능 최적화 (0) | 2016.06.16 |
댓글