For a long time we’ve been dissatisfied with the fact that we had two separate tools to do the same thing: Top Processes and Top Queries rank processes and queries respectively by a metric of your choice. For example you may rank queries by frequency, or rank databases by total execution time. There’s a lot of shared functionality and at the same time there’s so much more we could do with the metrics we’re capturing from your systems.
Today we are releasing a new tool called Profiler to replace Top Queries and Top Processes, so now we have one tool to do the job of two. Simplifying is always a good thing.
If you are wondering what the Profiler can rank, you’ll be glad to see that not only we still rank Users, Databases, Hosts, Queries, Verbs, Tags and Processes, but we also added Tables, Network Sockets, MySQL Commands and MySQL Processlist Queries. And many more are coming soon of course; this tool is not limited to that set, so if you want to rank things that we don’t have now, don’t hesitate to drop us a line.
Additionally, the metrics which you can rank by, have been increased: so far you could for instance, rank databases by total time and frequency, but you can choose between 13 combinations now, including Warnings, Errors, Affected Rows, Missing Indexes and Slow Queries. There are many more additions, so please go ahead and play with the tool to find out!
But wait, there’s more! The Profiler uses much faster APIs, so if you are one of our customers with a gazillion different queries, who used to wait several seconds while loading the top 10 queries, you’ll be happy to see that the Profiler loads the data much faster.
We are going to add many more features to this tool, to ease finding what you and your team are looking for. Stay tuned for more, and sign up for a free trial if you are interested in a monitoring solution that goes deeper to provide meaningful insight.
Topics: Product Features