About Can Sayn
Can Sayın is experienced Database Administrator in open source relational and NoSql databases, working in complicated infrastructures. Over 5 years industry experience, he gain managing database systems. He is working at ChistaDATA Inc. His areas of interest are generally on open source systems.
Contact: Website

Solving ClickHouse Server Connection Problem

1- Ensure that the clickhouse-server is running   systemctl status clickhouse-server   You can check that by looking for the Ready for connections line in /var/log/clickhouse-server/clickhouse-server.log ( Information log-level needed)   2- Ensure you use the proper […]

Overview of information_schema Tables In Clickhouse

Image Source ClickHouse is an open-source columnar database management system that is designed for real-time data processing and analytics. One of the unique features of ClickHouse is its use of the information_schema database, which provides […]

Convert MergeTree to Replicated In ClickHouse

To convert a MergeTree table to a Replicated table in ClickHouse, you can use the ALTER TABLE statement with the ENGINE clause. Here is an example: ALTER TABLE original_table ENGINE = ReplicatedMergeTree(‘/clickhouse/tables/{database}/{table}’, ‘{replica}’) ORDER BY […]

Benchmarking ClickHouse Using clickhouse-benchmark

Image Source ClickHouse is a popular open-source analytical database management system that is designed to handle massive amounts of data. It has been adopted by many companies for its excellent performance, low latency, and scalability. […]

ClickHouse Server Logs In JSON Format

Image Source ClickHouse is a fast, open-source column-oriented database used to analyze large amounts of data. One of the key features of ClickHouse is its support for logging server activity in JSON format, which allows […]

Examining CPU Killer Processes In ClickHouse

To examine CPU-intensive processes in a ClickHouse database, you can use the system table system.processes to view information about currently running queries and their resource usage. You can run the following query to view the […]

Overview of Clickhouse-compressor

Image Source ClickHouse is an open-source column-oriented database management system developed by Yandex. One of the critical features of ClickHouse is its ability to compress data in order to save storage space and increase query […]

Configuration Parameters of ClickHouse

ClickHouse is a column-oriented database management system that is designed for high-performance analytics. One of the critical features of ClickHouse is its ability to handle large amounts of data quickly and efficiently. This is made […]

Troubleshooting ClickHouse Performance

Troubleshooting ClickHouse Performance – Monitoring ClickHouse for Performance Monitoring ClickHouse Events Performance In this article you will learn how to check following operations in ClickHouse; Monitoring Expensive Query Operations In ClickHouse Expensive Queries In ClickHouse […]

1 2 3 4 5 7