Disclaimer: I’m not specially an expert of benchmarking, this post is to compare different options. All comments and advices are welcome.
I’m not telling you anything new, the show processlist command is a fantastic command line tool for instant check.
But what about monitor your databases with this command embedded in a tool?
Just have a look at this graph:
With 5K queries per seconds, how much will be hidden with a show processlist executed every seconds? Probably a lot.
So, I wanted to test which alternatives could be efficient to retrieve all the queries during a time lapse.