SQL Row Store vs Data Warehouse: Which Is Right for Your Application?

on YouTube ↗30m

" summary

Compares MySQL row store and ClickHouse column store using MySQL and ClickHouse examples and concrete numbers. MySQL handles millions‑per‑second tiny transactions and high concurrency with single‑server scope. ClickHouse stores columns, compresses ~75% on the airline dataset of 173 million rows, uses codecs and vectorized parallel execution to get 50–100x speedups and materialized views that shrink scans from 14.59GB → 2.31MB. ClickHouse shards linearly, reads sparse index blocks of ~8k rows, has slower updates and eventual consistency.

AI-written summary · about

" chapters (19)

1. 0:00Intro
2. 0:34Presenter Bio
3. 1:53Key Features of MySQL
4. 3:42Airline flight management in MySQL
5. 5:26How row data is organized
6. 11:35Airline ontime table definition CREATE TABLE airline.ontime
7. 15:38There is no longer a penalty for wide tables
8. 17:27We make data even smaller by compressing
9. 19:04Data reductions from real data Effects of Codecs and Compression
10. 20:35We can speed up queries using more CPUs
11. 21:44Materialized views reduce data still more...
12. 22:10Materialized views restructure/reduce data 50-100x query speed-up 2.31 MiB
13. 23:12Still not fast enough? Add more servers! Replicas
14. 23:54ClickHouse distributes queries automatically
15. 24:35Strengths and weaknesses of ClickHouse OLTP ("Online Transaction Processing")
16. 26:40Where MySQL shines - transaction processing
17. 27:18Where ClickHouse shines - analytic apps
18. 27:51A parting question...
19. 28:59Conclusions Row stores like MySQL are great for transaction processing

" related talks

• 40mData warehouse or conventional database: Which is right for you?Robert Hodges · Data Con LA 2020
• 42mClickHouse: what is behind the fastest columnar databaseOlena Kutsenko · Berlin Buzzwords 2023
• 28mColumnstore RevolutionPeter Zaitsev, Hannes Mühleisen, Alexy Milovidov · Percona Live Amsterdam 2026
• 30mReplicating Data from MySQL to ClickHouseVladislav Klimenko, Valeriy Panov · HighLoad++ Siberia 2018
• 34mClickHouse® - What is Behind the Fastest Columnar Database?Olena Kutsenko · OSA Con 2022
• 45mClickHouse: what is behind the fastest columnar databaseOlena Kutsenko · Devoxx Ukraine 2023: AI – Friend or Foe?
• 42mBuilding an Analytic Extension to MySQL with ClickHouse® and Open SourceVadim Tkachenko, Kanthi Subramanian · OSA Con 2022
• 51mWhat You Need to Know About ClickHouse ArchitectureAleksey Zatelepin · РИТ++ 2017