(Dimitri Kravtchuk) Pretty often I was asked by many people about solutions I’m using while analyzing MySQL performance issues and generating various graphs presented in my reports and blog posts..

(Mike Benshoof) I recently worked through an issue with a client trying to detect data drift across some servers that were located in different timezones. Unfortunately, several of the tables had timestamp fields and were set to a default value of CURRENT_TIMESTAMP. From the manual, here is how My

(Andrew Morgan) If you’re a user of MySQL Workbench then you may have noticed a pocket knife icon appear in the top right hand corner – click on that and a terminal opens which gives you access to the MySQL utilities.

(depesz) Recent release of new versions of PostgreSQL suggests that you do reindex of all indexes. But this will take a while, and since we don’t actually have ‘REINDEX CONCURRENTLY’ command – it’s a bit tricky.

(Baron Schwartz) Have you seen Damn Cool Algorithms: Cardinality Estimation yet? If not, take a few minutes and read through it. Now, what if we try using that approach instead of COUNT(DISTINCT) in MySQL to see how many distinct values there are in a column?

(domas mituzas) With large enough infrastructure it gets a bit more and more complicated to detect whether an incident or a problem is real systems problem or a monitoring glitch. This is a story of one such investigation.

(Mike Chapple) With the release of MySQL 5.0, the popular open source database platform added one of the most long-awaited features: the ability to use stored procedures. Long a staple of commercial database systems, such as Microsoft SQL Server and Oracle, stored procedures provide database develop

(Michael McLaughlin) At present, you can’t use the MySQL Workbench migration tool to migrate MySQL 5.0 to MySQL 5.5, as documented in Bug 66861. The only documentation reference that I could find for the mysql.proc table. Since the physical definition of the mysql.proc table changes across the MySQL

(Stewart Smith) So, what impact does enabling the slow query log have on MySQL?

(Robert Hodges) There have been a number of excellent articles about the pros and cons of automatic database failover triggered by Baron’s post on the GitHub database outage. In the spirit of Peter Zaitsev’s article "The Math of Automated Failover," it seems like a good time to point out that datab