MORE secrets of ClickHouse Query Performance

By Robert Hodges on May 13th, 2020

MORE secrets of ClickHouse Query Performance

ClickHousePerformance

May 27, 2020
with Robert Hodges

ClickHouse is famously fast, but a small amount of extra work makes it much faster. Join us for the latest version of our popular talk on single-node ClickHouse performance. We start by examining the system log to see what ClickHouse queries are doing. Then we introduce standard tricks to increase speed: adding CPUs, reducing I/O with filters, restructuring joins, adding indexes, and using materialized views, plus many more. In each case we show how to measure the results of your work. There will as usual be time for questions as well at the end. Sign up now to polish your ClickHouse performance skills!

Speaker Bio: Robert Hodges is CEO of Altinity, which offers enterprise support for ClickHouse. He has over three decades of experience in data management spanning 20 different DBMS types. ClickHouse is his current favorite. 😉

 

More Webinars

ClickHouse Unleashed 2020: Our Favorite New Features for Your Analytical Applications

August 6, 2020 with Alexander Zaitsev and Robert Hodges Curious what's new in ClickHouse? This talk is for you! Join us to learn about new features of ClickHouse, ranging from tiered storage to compact MergeTree format to SQL join improvements. We'll also preview new features like object storage and LDAP support planned for the remainder of 2020. Finally, we'll discuss Altinity Stable Releases and how they help you decide when features are ready for production use. Don't miss this opportunity to get current on ClickHouse improvements to help you build even better analytics!

Adventures in Observability: How In-House ClickHouse Deployment Enabled Instana to Build Better Monitoring for Users

July 9, 2020 with Marcel Birkner, Yoann Buch and Robert Hodges Instana is an Application Performance Monitoring solution that provides complete visibility into complex distributed systems, including ClickHouse servers. In this webinar, we welcome Marcel Birkner and Yoann Buch of Instana. They describe how the Instana team uses ClickHouse to power their solution, lessons they have learned, and how they integrated them back into Instana's own ClickHouse monitoring features. Along the way, you'll learn how to set up Instana on ClickHouse, what important metrics you should track, how ClickHouse is integrated in end-to-end distributed tracing, and what level of automation is available for root cause analysis and alerting.

Big Data and Beautiful Video: How ClickHouse enables Mux to Deliver Content at Scale

June 23, 2020 with Adam Brown and Robert Hodges Mux.com enables content providers to stream video to vast audiences while maintaining pin-point control over performance. Join us as Adam Brown, a co-founder of Mux and video expert, explains the role that ClickHouse plays in content delivery. We'll start with an overview of the Mux platform and the importance of real-time feedback. We'll then discuss key features of ClickHouse that enable it to ingest live session data and provide real-time dashboards to Mux users. Finally, we'll talk a bit about the Mux journey to ClickHouse and lessons learned along the way about how data enables content delivery networks.