(wubayou) This tutorial will show you how you can use the ALTER TABLE statement to tweak table structures in MySQL.

(Chuck Bell) The mysqldiff and mysqldbcompare utilities were designed to produce a difference report for objects and in the case of mysqldbcompare the data. Thus, you can compare two databases and produce a report of the differences in both object definitions and data rows.

(Cédric PEINTRE) I would like to share this story based on a true event about the temporary files behavior in MySQL.

(Maciej Dobrzanski) No space left on device – this can happen to anyone. Sooner or later you may face the situation where a database either has already or is only minutes away from running out of disk space. What many people do in such cases, they just start looking for semi-random things to remove

(Peter Zaitsev) One of the very frequent cases with performance problems with MySQL is what they happen every so often or certain times. Investigating them we find out what the cause is some batch jobs, reports and other non response time critical activities are overloading the system causing user e

(Jørgen Løland) A short while after I fixed the legacy bug that prevented temporary MyISAM tables from using the dynamic record format, I got an email from Davi Arnaut @ Twitter. It turned out that Twitter needed to fix the very same problem, but for the case when INFORMATION_SCHEMA temporary tables

(Sean Hull) Hot backups are an excellent way to backup MySQL. They can run without blocking your application, and save tons on restore time. Percona’s xtrabackup tool is a great way to do this. We wrote a howto on using xtrabackup for hotbackups.

(Kedar) Ever come accoss a situation where you have to load a flat text file into MySQL with data provided in single column!

(Baron Schwartz) The recording of yesterday’s webinar, as well as a PDF of my slide deck, is now available. You can watch the recording and get the slides here.

(Shlomi Noach) I’ve written before I prefer to do a manual install of MySQL over a repository one. I still do: I typically install from binary tarball or by compiling from source.