How to Fix a Lock Wait Timeout Exceeded Error in MySQL
One of the most common InnoDB errors is InnoDB lock wait timeout exceeded, for example: SQLSTATE[HY000]: General error: 1205 Lock wait timeout exceeded; try restarting transaction The above simply means the transaction has reached the...
How High CPU Utilization Effects Database Performance
One of the indicators to see if our database is experiencing performance issues is by looking at the CPU utilization. High CPU usage is directly proportional to disk I/O (where data is either read or...
What to Look for if Your PostgreSQL Replication is Lagging
Replication lag issues in PostgreSQL is not a widespread issue for most setups. Although, it can occur and when it does it can impact your production setups. PostgreSQL is designed to handle multiple threads, such...
How to Identify PostgreSQL Performance Issues with Slow Queries
When working with OLTP (OnLine Transaction Processing) databases, query performance is paramount as it directly impacts the user experience. Slow queries mean that the application feels unresponsive and slow and this results in bad conversion...
My PostgreSQL Database is Out of Disk Space
Disk space is a demanding resource nowadays. You usually will want to store data as long as possible, but this could be a problem if you don’t take the necessary actions to prevent a potential...
What to Check if MySQL Memory Utilisation is High
One of the key factors of a performant MySQL database server is having good memory allocation and utilization, especially when running it in a production environment. But how can you determine if the MySQL utilization...
Steps to Take if You Have a MySQL Outage
A MySQL outage simply means your MySQL service is not accessible or unresponsive from the other's perspective. Outages can be originated by a bunch of possible causes.. Network issue - Connectivity issue, switch, routing, resolver,...
What to Look for if Your MySQL Replication is Lagging
A master/slave replication cluster setup is a common use case in most organizations. Using MySQL Replication enables your data to be replicated across different environments and guarantees that the information gets copied. It is asynchronous...
My MySQL Database is Out of Disk Space
When the MySQL server ran out of disk space, you would see one of the following errors in your application (as well as in the MySQL error log): ERROR 3 (HY000) at line 1: Error...
What to Monitor in MySQL 8.0
Monitoring is a must in all environments, and databases aren’t the exception. Once you have your database infrastructure up-and-running, you’ll need to keep tabs on what’s happening. Monitoring is a must if you want to...
Why Did My MySQL Database Crash? Get Insights with the New MySQL Freeze Frame
In case you haven't seen it, we just released ClusterControl 1.7.5 with major improvements and new useful features. Some of the features include Cluster Wide Maintenance, support for version CentOS 8 and Debian 10, PostgreSQL...
Database Performance Tuning for MariaDB
Ever since MySQL was originally forked to form MariaDB it has been widely supported and adopted quickly by a large audience in the open source database community. Originally a drop-in replacement, MariaDB has started to...