Articles by Shiv Iyer

About Shiv Iyer

Open Source Database Systems Engineer with a deep understanding of Optimizer Internals, Performance Engineering, Scalability and Data SRE. Shiv currently is the Founder, Investor, Board Member and CEO of multiple Database Systems Infrastructure Operations companies in the Transaction Processing Computing and ColumnStores ecosystem. He is also a frequent speaker in open source software conferences globally.

ClickHouse Caches: Monitoring Query Plans in Library Cache

Shiv Iyer

Introduction The Library Cache in ClickHouse is a cache of the compiled and optimized query plans used to execute queries. The purpose is to store frequently used query plans to reduce the overhead of parsing, […]

Monitoring Key Activities by ClickHouse Users

Shiv Iyer

Introduction Monitoring key user activity in ClickHouse is quite essential to system health and performance. In this article, we discuss means of doing this, and simple SQL scripts that may be helpful for this purpose. […]

Monitoring ClickHouse Server CPU Usage

Shiv Iyer

Introduction ClickHouse is designed to be highly optimized for performance and scalability, with a focus on efficient use of system resources, including CPU usage. Understanding the CPU usage by a ClickHouse server can be important […]

ClickHouse Redo Operations for Data Reliability

Shiv Iyer

Introduction In ClickHouse, Redo logs are implemented as a write-ahead log (WAL) system, which is used to ensure data consistency and reliability in the event of a system failure. The Redo log records all changes […]

Monitoring Query I/O Patterns in ClickHouse

Shiv Iyer

Introduction To analyze the query IO patterns and behavior of ClickHouse, you can use the following methods. How to Monitor Query I/O Patterns in ClickHouse Conclusion In conclusion, to analyze the query IO patterns and […]

ClickHouse Performance: How to Optimize Record Access Order

Shiv Iyer

Introduction In ClickHouse, the Record Access Order refers to the order in which rows of data are accessed when executing a query. The order can be determined by a variety of factors such as the […]

Improving Fragmented ClickHouse Database Performance

How to Troubleshoot Performance of Fragmented ClickHouse Databases?

Shiv Iyer

Introduction A fragmented ClickHouse database can impact performance in several ways: Increased disk I/O: When a database is fragmented, the data is stored in multiple parts across the disk, so it takes more time […]

How to Use Indexes in ClickHouse - A Practical Guide

Practical Guide to Using Indexes in ClickHouse

Shiv Iyer

Introduction Indexes in ClickHouse are implemented as a separate data structure that is stored on disk alongside the table data. The index data structure is used to quickly locate the specific data rows that match […]

Real-time Analytics for Digital Transformation with ChistaDATA’s ClickHouse

Shiv Iyer

Introduction Real-time analytics is becoming increasingly popular as a way to gain insights into business operations, customer behavior, and other important metrics. This is due to the growing need for organizations to make data-driven decisions […]

Tuning ClickHouse for Performance after Installation

How to Tune ClickHouse for Performance immediately after Installation

Shiv Iyer

Introduction There are several things that you can do to tune ClickHouse performance immediately after installation: Configure the memory settings: Make sure that the configuration parameter max_memory_usage is set to a value that is appropriate […]

ChistaDATA Inc.

Enterprise-class 24*7 ClickHouse Consultative Support and Managed Services

Articles by Shiv Iyer

ClickHouse Caches: Monitoring Query Plans in Library Cache

Monitoring Key Activities by ClickHouse Users

Monitoring ClickHouse Server CPU Usage

ClickHouse Redo Operations for Data Reliability

Monitoring Query I/O Patterns in ClickHouse

ClickHouse Performance: How to Optimize Record Access Order

How to Troubleshoot Performance of Fragmented ClickHouse Databases?

Practical Guide to Using Indexes in ClickHouse

Real-time Analytics for Digital Transformation with ChistaDATA’s ClickHouse

How to Tune ClickHouse for Performance immediately after Installation