(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.
Tag: Open Source
PHP and MySQL Basics
(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
How to Move a MySQL Partition from One Table to Another
(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.
Galera Cluster: adding a primary key to a MySQL table which lacks it… without downtime
(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.
MySQL 8.0.1: The Next Development Milestone
(Roel Van de Paar) This post discusses the next MySQL development milestone: MySQL 8.0.1.
Reset MySQL 5.7 password on macOS over the command line
(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.
What is the default sharding key in MySQL Cluster?
(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?
Archiving MySQL and MongoDB Data
(Rick Golba) This post discusses archiving MySQL and MongoDB data, and determining what, when and how to archive data.
Easy-to-use Perl scripts to backup your MySQL database with mysqldump and FTP the files to a remote server
(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.
Millions of Queries per Second: PostgreSQL and MySQL’s Peaceful Battle at Today’s Demanding Workloads
(Anastasia Raspopina and Sveta Smirnova) This blog compares how PostgreSQL and MySQL handle millions of queries per second.
