by Sri Sakthivel | Sep 14, 2023 | Insight for DBAs, MySQL
MySQL is an outstanding open source transactional database used by most web-based applications and is very good at handling OLTP workloads. However, modern business is very much dependent on analytical data. ClickHouse is a columnar database that handles analytical...
by Vadim Tkachenko | Oct 13, 2022 | MySQL, Open Source, Percona Software
MySQL is an outstanding database for online transaction processing. With suitable hardware, it is easy to execute more than 1M queries per second and handle tens of thousands of simultaneous connections. Many of the most demanding web applications on the planet are...
by Rachel Pescador | Jul 22, 2020 | Database Trends, Insight for DBAs, MongoDB
Many of us use and love relational databases… until we try and use them for purposes that aren’t their strong point. Queues, caches, catalogs, unstructured data, counters, and many other use cases, can be solved with relational databases, but are better served by...
by Peter Zaitsev | Mar 30, 2020 | Monitoring, MySQL, Percona Software
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...
by Peter Zaitsev | Mar 4, 2020 | Insight for DBAs, MySQL
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...
by Vadim Tkachenko | Feb 3, 2020 | Insight for DBAs, Insight for Developers, 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:...
by Sveta Smirnova | May 7, 2019 | MariaDB, MySQL, Percona Events, Percona Live
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...
by Vadim Tkachenko | Oct 1, 2018 | Insight for DBAs, MySQL
Following my post from a year ago about ClickHouse I wanted to review what happened in ClickHouse since then. There is indeed some interesting news to share. 1. ClickHouse in DB-Engines Ranking. It did not quite get into the top 100, but the gain from position 174 to...
by Peter Zaitsev | Feb 28, 2018 | Insight for DBAs, Monitoring, MySQL
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...
by Alexander Rubin | Feb 19, 2018 | Hardware and Storage, Insight for DBAs, MySQL
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...
by Jervin Real | Jan 16, 2018 | Insight for DBAs, MySQL
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...
by Jervin Real | Jan 9, 2018 | Insight for DBAs, MySQL
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...
by Vadim Tkachenko | Oct 4, 2017 | MySQL
I will be presenting at the ClickHouse MySQL Silicon Valley Meetup on Wednesday, October 25, 2017, at 6:30 PM. ClickHouse is a real-time analytical database system. Even though they’re only celebrating one year as open source software, it has already proved itself...
by Vadim Tkachenko | Oct 2, 2017 | MongoDB, Monitoring, MySQL, PostgreSQL
In this blog, I’ll use ClickHouse and Tabix to look at a new very large dataset for research. It is hard to come across interesting datasets, especially a big one (and by big I mean one billion rows or more). Before, I’ve used on-time airline performance...
by Dave Avery | Sep 27, 2017 | Percona Live, Percona Software
Percona Live Europe provides open source professionals with an opportunity to discuss how various technologies get used in order to solve database problems. Alexander Zaitsev of LifeStreet/Altinity gave one such session: Building Multi-Petabyte Data Warehouses with...
by Lorraine Pocklington, Community Manager | Sep 27, 2017 | Percona Live
Percona Live Europe 2017 keeps providing excellent sessions with useful information on great open source database technologies. Yandex’s Clickhouse was one of these technologies that was well covered at the conference this year. There were several talks that...
by Emily Ikuta | Sep 12, 2017 | Insight for DBAs, Insight for Developers, Monitoring, MySQL, Webinars
Join Percona’s CTO Vadim Tkachenko @VadimTk and Altinity’s Co-Founder, Alexander Zaitsev as they present Supercharge Your Analytics with ClickHouse on Thursday, September 14, 2017, at 10:00 am PDT / 1:00 pm EDT (UTC-7). Reserve Your Spot ClickHouse is a...
by Vadim Tkachenko | Aug 30, 2017 | Insight for DBAs, MySQL, Percona Software
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...
by Vadim Tkachenko | Jul 6, 2017 | Benchmarks, Insight for DBAs, MySQL
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...
by Vadim Tkachenko | Jun 22, 2017 | Benchmarks, Insight for DBAs, MySQL
In this blog post, we’ll look at how ClickHouse performs in a general analytical workload using the star schema benchmark test. We have mentioned ClickHouse in some recent posts (ClickHouse: New Open Source Columnar Database, Column Store Database Benchmarks:...
