Tag - ClickHouse

Advanced Query Analysis in Percona Monitoring and Management with Direct ClickHouse Access

query analysis clickhouse PMM

In my Webinar on Using Percona Monitoring and Management (PMM) for MySQL Troubleshooting, I showed how to use direct queries to ClickHouse for advanced query analysis tasks. In the followup Webinar Q&A, I promised to describe it in more detail and share some queries, so here it goes.
PMM uses ClickHouse to store query performance […]

Read more

ClickHouse Versus MySQL Handling of Double Quotes

ClickHouse MySQL Double Quotes

If you’re a MySQL user trying ClickHouse, one thing which is likely to surprise – and annoy you – is the handling of Double Quotes. In MySQL, you can use both double quotes and single quotes to quote strings, and as an example, these two queries are equivalent:

Shell

mysql> select * from performance_schema.global_variables where variable_name=’max_connections’;
+—————–+—————-+
| […]

Read more

ClickHouse and MySQL – Better Together

clickhouse and mysql

It’s been a while since I wrote about ClickHouse, there are a lot of new features that are worth mentioning, and for this, I recommend to follow the Altinity Blog but today I want to look at the improved integration of ClickHouse and MySQL.
There are two features:

Using MySQL protocol and MySQL client to connect […]

Read more

MariaDB Track at Percona Live

MariaDB track at Percona Live 2019

Less than one month left until Percona Live. This time the Committee work was a bit unusual. Instead of having one big committee for the whole conference we had a few mini-committees, each responsible for a track. Each independent mini-committee, in turn, had a leader who was responsible for the whole process. I led […]

Read more