MinervaDB Blog: Mastering WebScale Database Infrastructure

How expensive SQLs can impact MySQL Performance?

How expensive SQLs can impact MySQL Performance? Expensive SQLs can have a significant impact on MySQL performance, as they consume a lot of resources and can slow down the entire system. Here are a few [...]

PostgreSQL Kill: How to Kill a Process from Inside PostgreSQL

How to Kill an PostgreSQL process from inside PostgreSQL? In PostgreSQL, you can use the pg_terminate_backend() function to kill a specific process. This function takes a single argument, the process ID of the process you [...]

MySQL Table Change: Find When a Table Was Last Changed

Find When was a table last changed in MySQL? In MySQL, you can use the information_schema.tables table to determine when a table was last changed. The information_schema.tables table contains metadata about all tables in the [...]

PostgreSQL Table Change: Find When a Table Was Last Changed

Find When was a table last changed in PostgreSQL? In PostgreSQL, you can use the pg_class system catalog table to determine when a table was last changed. The pg_class table contains metadata about all tables [...]

PostgreSQL Chained Rows: How to Detect Chained and Migrated Rows

How do you think you could detect chained and migrated rows in PostgreSQL? Chained and migrated rows occur in PostgreSQL when rows are updated and cannot fit in their original block due to space constraints, [...]

MySQL Disk I/O Performance: How Disk I/O Influences MySQL

How disk I/O influence MySQL performance? Disk I/O can greatly influence MySQL performance, as it is a critical component in the overall performance of a database system. The disk I/O rate, disk latency and disk [...]

Python script to monitor Linux Disk I/O matrix and save information in ClickHouse

Python script to monitor Linux Disk I/O matrix and save information in ClickHouse Here is a sample Python script that monitors the disk I/O usage of Linux and saves the information in a ClickHouse database: [...]

Monitor Linux Memory: Python Script to Track Process Memory in ClickHouse

Python script to monitor Linux Process Memory matrix and save information in ClickHouse Here is a sample Python script that monitors the memory usage of Linux processes and saves the information in a ClickHouse database: […]

PostgreSQL 16 pg_Dump: What’s Different

How pg_dump is different in PostgreSQL 16? The pg_dump command is a tool used to export data from a PostgreSQL database into a file. The tool has been included in PostgreSQL since version 7.0 and […]

How MySQL optimizer works?

How does MySQL optimizer work? The MySQL optimizer is responsible for determining the most efficient way to execute a SQL statement. It evaluates different query execution plans and chooses the one that it estimates will […]