Performance optimization, or "performance tuning," is an ongoing process, not a one-time task. After making changes and testing them, continuous monitoring is essential to determine if further adjustments are necessary. This applies to Elasticsearch and...

We have discussed how to configure InnoDB for high performance a while ago, however, we have not yet discussed how we can improve MySQL performance while making use of advanced InnoDB settings. This blog post...

We’re excited to announce the 1.8 release of ClusterControl - the only database management system you’ll ever need to take control of your open source database infrastructure.  ClusterControl has always allowed our users to manage...

Performance issues are common problems when administering MySQL databases. Sometimes these problems are, in fact, due to slow queries. In this blog, we'll deal with slow queries and how to identify these. Checking Your Slow...

The management of database performance is an area that businesses when administrators often find themselves contributing more time to than they expected. Monitoring and reacting to the production database performance issues is one of the...

(Updated on 17 September 2024) 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...

The database backend affects the application, which can then impact organizational performance. When this happens, those in charge tend to want a quick fix. There are many different roads to improve performance in MySQL. As...

As soon as you start running a database server and your usage grows, you are exposed to many types of technical problems, performance degradation, and database malfunctions.  Each of these could lead to much bigger...

Using logical backup programs like mysqldump is a common practice performed by MySQL admins for backup and restore (the process of moving a database from one server to another) and is also the most efficient...

MySQL 8.0 brought enormous changes and modifications that were pushed by the Oracle MySQL Team. Physical files have been changed. For instance, *.frm, *.TRG, *.TRN, and *.par no longer exist. Tons of new features have...

Did you ever wonder what triggers the advice in ClusterControl that your disk is filling up? Or the advice to create primary keys on InnoDB tables if they don’t exist? These advisors are mini scripts...

Thanks to everyone who participated in this week’s popular webinar on MySQL Database Performance Tuning, which looked at answering the following questions: You’re running MySQL as backend database, how do you tune it to make...