(Kevin Lewis) The new InnoDB Labs release contains the ability to create and use independent multi-table general tablespaces.

(Arunjith Aravindan) Percona Toolkit’s pt-table-checksum performs an online replication consistency check by executing checksum queries on the master, which produces different results on replicas that are inconsistent with the master – and the tool pt-table-sync synchronizes data efficiently betwee

(Daniël van Eeden) It is possible to disallow users from using old_passwords=1. This can be done by adding ‘maximum-old_passwords=0’ to your my.cnf

(Sergey Petrunia) MariaDB 5.5 and then MySQL 5.6 got Index Condition Pushdown (ICP) optimization (initially coded by yours truly). The idea of ICP is simple: after reading the index record, check the part of WHERE condition that can be computed using index columns, and only then read the table recor

(Peter Zaitsev) MySQL has information_schema.tables that contain information such as “data_length” or “avg_row_length.” Documentation on this table however is quite poor, making an assumption that those fields are self explanatory – they are not when it comes to tables that employ compression.

(Dmitry Lenev) The MySQL Server 5.7.5 Development Milestone Release, which was published recently, contains some significant changes to the metadata locking (MDL) subsystem and to the usage of the THR_LOCK manager for InnoDB tables.

(John Potocny) The EXPLAIN command is one of MySQL’s most useful tools for understanding query performance. When you EXPLAIN a query, MySQL will return the plan created by the query optimizer.

(Shinguz) This week we did some migrations from MariaDB 10.0 to Percona Server 5.6 at the IT department of a big German bank.

(Ike Walker) Since I recently wrote about both MySQL error 1071 and error 1070 I decided to continue the pattern with a quick note on MySQL error 1069. In case you’ve never seen it before, this is MySQL error 1069:

(Muhammad Irfan) MySQL replication is a core process for maintaining multiple copies of data – and replication is a very important aspect in database administration. In order to synchronize data between master and slaves you need to make sure that data transfers smoothly, and to do so you need