Blog

No Picture
PostgreSQL Internals

Find When was a table last changed in PostgreSQL?

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 [...]
No Picture
MySQL Performance

How disk I/O influence MySQL performance?

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 [...]
No Picture
PostgreSQL DBA

How pg_dump is different in PostgreSQL 16?

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 […]
No Picture
MySQL Performance

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 […]
No Picture
MySQL Internals

How does checkpointing work in MySQL?

How does checkpointing work in MySQL? In MySQL, checkpointing is the process of flushing dirty pages from the buffer pool to disk, in order to ensure that the data on disk is in a consistent […]