Blog - Page 54 of 60 - The WebScale Database Infrastructure Architecture, Engineering and Operations Company

How slow queries affect MySQL performance?

How slow queries affect MySQL performance? Slow queries can have a significant impact on the performance of a MySQL server. When a query takes a long time to execute, it can consume a large amount [...]

How expensive SQLs can impact PostgreSQL Performance?

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

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

How to Kill an PostgreSQL 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 [...]

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

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

How to detect chained and migrated rows in PostgreSQL?

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

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

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

Python script to monitor Linux Process Memory matrix and save information 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: […]