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
So, I wanted to test which alternatives could be efficient to retrieve all the queries during a time lapse.
Test procedure and configuration
I used sysbench 0.5 (with oltp.lua) to make my tests on different configurations and …[Read more]