Webinar: Secrets of ClickHouse Query Performance

By Robert Hodges on August 30th, 2019

Webinar: Secrets of ClickHouse Query Performance

ClickHousePerformance

September 11 or 17, 2019 with Robert Hodges

 

ClickHouse is famous for speed. That said, you can almost always make it faster! This webinar uses examples to teach you how to deduce what queries are actually doing by reading the system log and system tables. We’ll then explore standard ways to increase query speed: data types and encodings, filtering, join reordering, skip indexes, materialized views, session parameters, to name just a few. In each case we’ll circle back to query plans and system metrics to demonstrate changes in ClickHouse behavior that explain the boost in performance. We hope you’ll enjoy the first step to becoming a ClickHouse performance guru!

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. 😉

You can find slides for this webinar HERE

Please register below to watch webinar recording.

 

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.