In this blog post, I’ll look at how you can analyze raw MySQL query logs with ClickHouse.
For typical query performance analyses, we have an excellent tool in Percona Monitoring and Management. You may want to go deeper, though. You might be longing for the ability to query raw MySQL “slow” query logs with SQL.
There are a number of tools to load the MySQL slow query logs to a variety of data stores. For example, you can find posts showing how to do it with LogStash. While very flexible, these solutions always look too complicated and limited in functionality to me.
By far the best solution to parse and load MySQL slow query logs (among multiple log types supported) is Charity …[Read more]