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.
Website Facebook Twitter LinkedIn
No Picture
clickhouse troubleshooting

Troubleshooting Disk I/O Performance in ClickHouse

Shiv Iyer
Introduction Disk I/O performance is an absolutely critical element of high performance of ClickHouse servers & systems. Troubleshooting disk I/O performance upon observation of any anomalies is helpful in sustaining performance of your system. Runbook […]
Monitoring Load on ClickHouse Server
ClickHouse Monitoring

Monitoring Load on ClickHouse Server

Shiv Iyer
Introduction Load can significantly impact the performance of a ClickHouse server. The load on a server is a measure of how busy it is, and it can be represented by several different metrics such as […]
How data compression is implemented in ClickHouse?
ClickHouse Compression

ClickHouse Data Compression Algorithms Explained

Shiv Iyer
Introduction ClickHouse implements data compression in several ways to reduce storage space and improve query performance. Here are a few examples of how data compression is implemented in ClickHouse: (1) Dictionary encoding ClickHouse uses dictionary […]