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.

How to make Bulk Data Changes in ClickHouse

Shiv Iyer

Introduction Bulk data changes in ClickHouse can be made using the INSERT INTO or the INSERT INTO SELECT statements. The INSERT INTO statement is used to insert data into a specific table, while the INSERT […]

How are Locks and Wait Events implemented in ClickHouse?

Shiv Iyer

Introduction In ClickHouse, locks and wait events are implemented using a combination of a lock manager and a wait queue. The lock manager is responsible for managing the state of locks and the wait queue […]

Monitoring ClickHouse for Blocked Queries

Shiv Iyer

Introduction Blocked queries in ClickHouse can negatively impact performance by causing delays in query execution. When a query is blocked, it is not able to proceed until the resource it is waiting for is released […]

Identifying top 50 Expensive Query Operations by Disk I/O

ClickHouse Troubleshooting: How to identify Top 50 Expensive Query Operations by Disk I/O

Shiv Iyer

Introduction Disk I/O performance can greatly impact ClickHouse performance because ClickHouse stores data on disk and relies on disk I/O to read and write data. If disk I/O performance is slow, it can cause queries […]

Runbook to Identify & Monitor Corrupted Indexes

Troubleshooting Corrupted Indexes in ClickHouse

Shiv Iyer

Introduction To troubleshoot index corruption in ClickHouse, you can follow these steps: Check the error logs: Look for any error messages related to index corruption in the ClickHouse logs. This can give you a clue […]

ClickHouse Monitoring: Analysing ClickHouse Performance with strace

Shiv Iyer

How to use strace in ClickHouse strace can also be used to analyze the behavior of a ClickHouse server and identify performance bottlenecks. Here are some steps to use strace for analyzing ClickHouse: Identify the […]

How is ClickHouse Authentication implemented with LDAP and Kerberos?

Shiv Iyer

Introduction ClickHouse supports external authentication methods such as LDAP and Kerberos. Here’s an overview of how authentication can be implemented with these protocols. Overview of LDAP and Kerberos LDAP Authentication: To authenticate users with LDAP, […]

How to implement Data Governance and Security in ClickHouse

Shiv Iyer

Introduction Data governance and security in ClickHouse can be implemented through a combination of built-in features and external tools. Here are some examples of how data governance and security can be implemented in ClickHouse. Data […]

Migrating from Hadoop to ChistaDATA's ClickHouse

Hadoop vs ClickHouse: Comparison of Key Features

Shiv Iyer

Introduction Hadoop and ClickHouse are both big data processing platforms, but they have different design goals and use cases. Here is a comparison of some key features. Hadoop vs ClickHouse: Comparison of Key Features Data […]

Vertica vs ClickHouse: Comparison of Key Features

Shiv Iyer

Introduction ClickHouse and Vertica are both columnar databases that are optimized for analytical queries and real-time analytics. However, there are some key differences between the two that make ClickHouse better suited for real-time analytics. Comparative […]

ChistaDATA Inc.

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

Articles by Shiv Iyer

How to make Bulk Data Changes in ClickHouse

How are Locks and Wait Events implemented in ClickHouse?

Monitoring ClickHouse for Blocked Queries

ClickHouse Troubleshooting: How to identify Top 50 Expensive Query Operations by Disk I/O

Troubleshooting Corrupted Indexes in ClickHouse

ClickHouse Monitoring: Analysing ClickHouse Performance with strace

How is ClickHouse Authentication implemented with LDAP and Kerberos?

How to implement Data Governance and Security in ClickHouse

Hadoop vs ClickHouse: Comparison of Key Features

Vertica vs ClickHouse: Comparison of Key Features