(Baron Schwartz) Quite some time ago, when we added the ability to monitor MySQL query performance statistics from MySQL’s PERFORMANCE_SCHEMA, we learned a number of valuable lessons, still worth sharing. There are definitely right and wrong ways to do it.

(Dave Stokes) PHP and MySQL have had a long intertwined path together. I have been talking with a lot of newbies in the past several months who are trying to become PHP developers but are amazed at all the ancillary parts that go along with PHP such as unit testing, databases, JavaScript, continuous

(Pablo Padua) In this blog post we’ll look at how to move a MySQL partition from one table to another, for MySQL versions before 5.7.

(Rick Pizzi) OK, let me start with saying that a table without a primary key shouldn’t be something that a DBA should ever stumble into.

(Roel Van de Paar) This post discusses the next MySQL development milestone: MySQL 8.0.1.

(Cédric Bruderer) This one is for all MySQL-DBA’s, which are working on macOS. Since the Apple OS has a rather peculiar way of starting and stopping MySQL, compared to Linux, you can run into some issues. These problems occur especially, if you have no access to the GUI.

(Abdel-Mawla Gharieb) MySQL Cluster does an automatic sharding/partitioning to the tables across data nodes, enabling databases to scale horizontally to serve read and write-intensive workloads, but what is the default sharding key used in partitioning the data?

(Rick Golba) This post discusses archiving MySQL and MongoDB data, and determining what, when and how to archive data.

(Tony Darnell) Most users of MySQL utilize the mysqldump utility to backup their database. While mysqldump is handy and easy-to-use (and free), if you have data which is important to your business, then you should take a look at the MySQL Enterprise Edition – and use MySQL Enterprise Backup instead.

(Anastasia Raspopina and Sveta Smirnova) This blog compares how PostgreSQL and MySQL handle millions of queries per second.