How can I get the rows from SHOW PROCESSLIST using MySQL Connector for .NET or Dapper?

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");

Answers


The results of most MySQL meta-commands are represented in the INFORMATION_SCHEMA pseudo-database:

SELECT * FROM INFORMATION_SCHEMA.PROCESSLIST

Need Your Help

Error on deploying with Git on Heroku

ruby-on-rails git heroku

I'm not able to deploy in Heroku. I'm getting Permission Denied! everytime. I have my repository already exists.

How to Loop through mulitple MySQL columns and return result in single row?

php mysql function subquery

I'm using MySQL to go through a query to display the games in which a team has recorded two or more DDs.

About UNIX Resources Network

Original, collect and organize Developers related documents, information and materials, contains jQuery, Html, CSS, MySQL, .NET, ASP.NET, SQL, objective-c, iPhone, Ruby on Rails, C, SQL Server, Ruby, Arrays, Regex, ASP.NET MVC, WPF, XML, Ajax, DataBase, and so on.