ClickHouse® Performance Master Class – Tools and Techniques to Speed up any ClickHouse App | Webinar
Have burning ClickHouse® questions? Get a free consultation with Altinity.
No pressure, no sales talk. Just answers to your questions. Book a free help session: https://hubs.la/Q02qr1RZ0
______________________________
ClickHouse gives impressive performance out of the box. Our webinar will show you how to make it amazing. We start by providing a framework for performance that includes basic drivers like I/O and compute, as well as ClickHouse structures like compression and indexes. We also discuss tools to evaluate performance including ClickHouse system tables and EXPLAIN. We then demonstrate how to evaluate and improve performance for common query use cases ranging from MergeTree data on block storage to Parquet files in data lakes. Watch our webinar to become a master at diagnosing query bottlenecks and curing them quickly.
========================
CHAPTERS
========================
00:00 Introduction
05:31 Overview of ClickHouse
07:42 Understanding Performance Issues
11:07 Tools for Query Optimization
22:10 Finding Slow Queries
26:07 I/O: Key Metric for Performance
29:40 Using Indexes and EXPLAIN statements
35:28 Fixing Full Scan
39:04 Efficient Data Reading Strategies
44:12 Aggregation and Group By Optimization
52:03 JOIN Optimization Techniques
56:50 Distributed Query Optimization
59:21 New Query Analyzer in ClickHouse 24.3
01:02:16 RAM and Cache Management
01:09:03 Optimization for Concurrency
01:17:10 Additional Resources and Closing Remarks
========================
PRESENTATION SLIDES
========================
* https://altinity.com/wp-content/uploa...
==================================
MANAGED CLOUD FOR CLICKHOUSE
==================================
* https://altinity.com/managed-clickhouse/
====================
RESOURCES
====================
* Altinity Knowledge Base for ClickHouse: https://kb.altinity.com/
* Altinity Documentation for ClickHouse: https://docs.altinity.com
* Altinity Stable Builds for ClickHouse: https://altinity.com/altinity-stable/
* Training for ClickHouse: https://altinity.com/clickhouse-train...
* Altinity vs other ClickHouse vendors: https://altinity.com/altinity-cloud-v...
====================
COMMUNITY
====================
🧑🏽💻 Join the Community: https://www.altinity.com/slack
🙋🏽 Get Support on Slack: https://www.altinity.com/slack
⭐️ Star on GitHub: https://github.com/Altinity/
🌐 Connect on LI: / 10955938
🌐 Follow on 𝕏: / altinitydb
🌐 Say Hi on Reddit: / clickhouse
#clickhouse #datawarehouse #cloud #devops #realtimedata #databasemanagement #dbms #realtimeanalytics #webinar #Altinity #dataanalytics #parquet #opensource