(Giuseppe Maxia) MySQL 5.6.8 was announced a few days ago. You can download it from the MySQL downloads page.

(Keith Larson) Being a MySQL DBA is more than just being able to understand the explain command to optimize a query. The best optimized queries in the world are worthless with the database is down.

(gbi) There may be the situation that you have to monitor a MySQL server remotely. There are some linux tools to do performance and query monitoring locally, and these tools can also used to monitor remotely – but only unencrypted!

(Dave Stokes) VISUAL EXPLAIN will be come a standard tool in your DBA toolbox but you will need later versions of both MySQL Workbench and MySQL Server. The examples here were created with Workbench 5.2.44 and MySQL 5.6.8, the latest Release Candidate of MySQL 5.6.

(Sheeri K. Cabral) We have a backup server that, from time to time, gets errors when doing mysqldump backups (we do physical backups and logical backups, but the physical backups work fine). The errors look like this:

(Todd Farmer) I recently had a need to import a bunch of data into MySQL, and for reasons I won’t get into here, LOAD DATA INFILE wasn’t working for me. I was in a hurry to get the data into MySQL so that I could filter it, and didn’t have time to work through my LOAD DATA INFILE issues. Looking […]

(Todd Farmer) I’ve noted previously that the new transportable tablespaces for InnoDB in MySQL 5.6 are a big step forward, and newly-released 5.6.9-rc makes importing tablespaces a bit easier. In previous versions, you had to have a .cfg file to import the InnoDB tablespace.

Learn how easy it is to deploy a MySQL Cluster database that has been configured to best meet your application’s needs within your environment. See how the installer automatically detects the resources available on your target hosts and then combines that with the application requirements that you s

This guide is a practical overview to help you begin migrating your existing PHP code from using the older MySQL extension to the newer PDO database abstraction extension. I won’t go into all of the features available to you with PDO, but I will share with you the basic methods you will need to know

(wcdev) My web application keeps giving the error “#1153 – Got a packet bigger than ‘max_allowed_packet’ bytes” and fails.