No Picture
MySQL Performance

Find When was a table last changed in MySQL?

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 [...]
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 […]