I need to parse the running queries on my MySQL server. What is the easiest way to retrieve the result of SHOW PROCESSLIST from within MySQL Connector for .NET, or using Dapper?
Maybe something like (with Dapper):
var rows = connection.Query("SHOW PROCESSLIST");
The results of most MySQL meta-commands are represented in the INFORMATION_SCHEMA
pseudo-database:
SELECT * FROM INFORMATION_SCHEMA.PROCESSLIST