Using SYS.SESSION as an alternative to SHOW PROCESSLIST

A modern MySQL server contains a lot of useful meta-data in information_schema and performance_schema, which can help bring visibility into what is happening inside of your database server. However, sometimes this data is quite fine grained, and needs some finessing in order to get to that point :)

MySQL 5.7 includes a new SYS schema installed by default.…

Source: mysqlserverteam.com

About KENNETH 19688 Articles
지락문화예술공작단

Be the first to comment

Leave a Reply

Your email address will not be published.


*


이 사이트는 스팸을 줄이는 아키스밋을 사용합니다. 댓글이 어떻게 처리되는지 알아보십시오.