(Dave Stokes) Occasionally at conference or a Meetup, someone will approach me and ask me for help with a MySQL problem. Eight out of ten times their difficulty includes a sub query. “I get an error message about a corrugated or conflabugated sub query or some such,” they say, desperate for help.

(Jaime Crespo) After learning about Meltdown and Spectre, I waited patiently to get a fix from my OS vendor.

(David Ducos) In this post, we’ll look at how to improve queries using generated columns and ProxySQL instead of implementing a referenced table.

(Preetam Jinka) I couldn’t find a simple slow query log parser in Go so I decided to write one. The two I found are:

(Rathish Kumar) As a Database Administrator(DBA), your job want you to know the most atomic details of databases in your server. It happens for me many times, my boss/ delivery manager asking me, what is the size of a specific database or specific table, in this kind of situation, producing the righ

(Guilhem Bichot) User variables, even though not part of standard SQL, are great objects in MySQL. They allow to keep some “state” for the life of a session: a session can execute a statement to compute a value, store that value in a user variable, and use it in all next statements.

(Ashraf Sharif) Galera Cluster’s automatic node provisioning simplifies the complexity of scaling out a database cluster with guaranteed data consistency. SST and IST improve the usability of initial data synchronization without the need to manually backup the database and copy it to the new node.

(Frederic Descamps) The major engine for MySQL is InnoDB, it complies with the ACID properties for a transactional database engine. Even if InnoDB is the most recommended engine for MySQL, it has also some caveats. The biggest criticism lies in the amount of disk space used. And even when we remove

(kabilesh) Multi-channel replication is one of the great feature shipped with MySQL 5.7, With allowed the capability of slave to have many masters, having a channel for each master by which they replicate.

(Krunal Bauskar) In this blog post, we’ll look at how sequence numbers work in Percona XtraDB Cluster.