MySQL Replication Use Cases

In my last post, I summarized when MySQL replication is typically implemented. I now want to expand on that and talk about MySQL replication use cases. Scaling out using MySQL Replication Let’s take a typical example, the application is read-heavy versus writes. The server is under heavy read load and you want to reduce that. You […]

What is MySQL Replication and How Does It Work?

MySQL replication, a.k.a MySQL database replication provides the facility to make replicas of databases. The ability to make exact copies of databases and keep them in real-time sync as changes are made at the “master” provides a number of advantages. In summary these are: Scaling out a database application Reducing database backup impact Facilitate reporting without affecting […]

10 Database Performance Monitoring Tools You Can Get For Free

Database performance monitoring is something every DBA worth their salt should be doing on a regular basis. It should be adopted as a proactive task to help identify issues early on before they become too serious and be part of a post code deployment monitoring process. Bundled in with linux based operating systems are a heap […]

When are Innodb Table Statistics Updated?

Innodb statistics are used by the query optimizer to assist it in choosing an efficient query execution plan. They are estimated values relating to each Innodb table and index. But what updates them? Let’s take a look. Operations that update Innodb table statistics Typically this happens during metadata statements such as SHOW INDEX or SHOW TABLE STATUS. It […]

How to Kill All MySQL Processes For a Specific User

So here is a scenario, you have a number of poorly performing MySQL database queries which are consuming resources on your server. Users are complaining and you need to do something fast. Having viewed the output of SHOW FULL PROCESSLIST, you can see that they are coming from one user and have been running for a […]