OLTP means Online Transaction Processing and OLAP means Online Analytical Processing. OLTP (Online Transaction Processing) OLTP databases supports the day to day transactions. It’s a scenario database for storing day to day sales, people coming in, l...

Henlo frens We discussed till LSM-tree in the last blog, had to break it down into 2 cause this chapter has too much information. Many databases use B-trees, it has become the standard. LSM-tree and B-tree both keep the key value pair sorted, but bot...

Changing the data type of a column in ClickHouse, like in many database systems, is a sensitive operation and needs careful planning, especially in a production environment. Directly altering a column's data type isn't supported as a single operation...

Restricting new connections to a PostgreSQL database is essential during maintenance periods or to manage system resources effectively. Here are several methods to achieve this: 1. Modify max_connections Setting The max_connections setting in the pos...

MySQL date columns come with certain default behaviors that, if not properly understood or managed, can lead to significant performance degradation in queries. Here's an overview of some "deadly defaults" associated with MySQL date columns and how th...

Leaf block contention in InnoDB tables can significantly impact the performance of your MySQL database, especially under high concurrency. This situation typically occurs when multiple transactions are trying to modify or lock rows in the same leaf b...

Generating disk I/O patterns from a ClickHouse server and converting them to a flame graph involves multiple steps. You need to capture the disk I/O activity, process the data, and then visualize it as a flame graph. Here's a Python script outline to...
