In this blog post, we’ll look at nested data structures in ClickHouse and how this can be used with PMM to look at queries. Nested structures are not common in Relational Database Management Systems. Usually, it’s just flat tables. Sometimes it would be convenient to store unstructured information in structured databases. We are working to adapt ClickHouse […]
Read More
In this blog, we’ll look at ClickHouse on its one year anniversary. It’s been a year already since the Yandex team released ClickHouse as open source software. I’ve had an interest in this project from the very start, as I didn’t think there was an open source analytical database that could compete with industry leaders […]
Read More
The slides and videos from the Percona Live Open Source Database Conference 2017 are available for viewing and download. The videos and slides cover the keynotes, breakout sessions and MySQL and MongoDB 101 sessions. To view slides, go to the Percona Live agenda, and select the talk you want slides for from the schedule, and […]
Read More
This blog shares some column store database benchmark results, and compares the query performance of MariaDB ColumnStore v. 1.0.7 (based on InfiniDB), Clickhouse and Apache Spark. I’ve already written about ClickHouse (Column Store database). The purpose of the benchmark is to see how these three solutions work on a single big server, with many CPU cores and large amounts of […]
Read More