Tag - ClickHouse

Analyze Your Raw MySQL Query Logs with ClickHouse

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 […]

Read more

Archiving MySQL Tables in ClickHouse

Archiving MySQL Tables in ClickHouse

In this blog post, I will talk about archiving MySQL tables in ClickHouse for storage and analytics.
Why Archive?
Hard drives are cheap nowadays, but storing lots of data in MySQL is not practical and can cause all sorts of performance bottlenecks. To name just a few issues:

The larger the table and index, the slower the performance […]

Read more

Updating/Deleting Rows From Clickhouse (Part 2)

ClickHouse

In this post, we’ll look at updating and deleting rows with ClickHouse. It’s the second of two parts.
In the first part of this post, we described the high-level overview of implementing incremental refresh on a ClickHouse table as an alternative support for UPDATE/DELETE. In this part, we will show you the actual steps and […]

Read more

Updating/Deleting Rows with ClickHouse (Part 1)

ClickHouse

In this post, we’ll look at updating and deleting rows with ClickHouse. It’s the first of two parts.
You can see Part 2 of this post here.
ClickHouse is fast
Blazing fast! It’s quite easy to pick up, and with ProxySQL integrating with existing applications already using MySQL, it’s way less complex than using other analytics options. However, […]

Read more