Mastering ClickHouse with Flink: Table Engine Choices, Performance Tuning, and Real‑World Lessons

This article details how JDQ+Flink+Elasticsearch was extended with ClickHouse for real‑time reporting, covering table‑engine selection, Flink sink implementation, query optimization techniques, high‑CPU shard analysis, and practical strategies to ensure high concurrency and stable performance in production.

ClickHouseDistributedTablesFlink

0 likes · 46 min read

Mastering ClickHouse with Flink: Table Engine Choices, Performance Tuning, and Real‑World Lessons

Code Ape Tech Column

Mar 30, 2021 · Databases

Unlock MySQL Performance: Deep Dive into B+Tree Indexes and Optimization

This article explains the fundamentals of MySQL indexes, the B+Tree data structure, differences between MyISAM and InnoDB implementations, practical tips for creating effective composite indexes, and essential server configuration and SQL tuning techniques to dramatically improve query performance.

B+TreeDatabaseOptimizationIndexDesign

0 likes · 29 min read

Unlock MySQL Performance: Deep Dive into B+Tree Indexes and Optimization