(Cédric PEINTRE) I’m currently working on a new project about the explain command output.

(Shinguz) Important: Before you start any operation mentioned below do a proper file system backup of your XFS file system you want to resize. If MySQL is running on this mount point do this with a stopped mysqld. Alternatively you can also use mysqldump to do the MySQL backup but test the restore t

(Sheeri K. Cabral) Twice last week, a developer wanted to convert the existing datetime values in a database to UTC. The datetime values were the default for the server, which was the US/Pacific time zone, which is subject to Daylight Saving Time changes.

(Christian Wenz) When simple variables are just not good enough, arrays come into play (or objects, but that’s another topic). The array section in the PHP manual, available at http://php.net/array, lists approximately 80 functions that are helpful.

(Jay Janssen) This is not necessarily going to be a comprehensive post, but I learned somethings about MySQL SSL today that I thought would be worth sharing.

(Leo Hsu and Regina Obe) Issue: Ever had the situation where you decided to delete a table or some other function or type but you weren’t absolutely sure if other functions in the database depended on these.

(Gavin Towey) A common task in sharded database environments is to copy some chunk of production data from one physical server to another in a way which is transparent for users who may be actively making changes.

(Sergey Petrunia) One of the optimizations we have introduced in MariaDB 5.5 is Extended keys. The idea behind it is rather simple. Inside InnoDB, every secondary index has an invisible suffix of primary key columns.

(Leo Hsu and Regina Obe) We’ve been fighting to get clients we have thinking of upgrading or creating new apps to also choose PostgreSQL in the process. Here I’ll just itemize some of the obstacles we’ve run into in making the sale. All of these fall under the It is not Database X line item.

(Greg Sabino Mullane) A common situation for database-backed applications is the need to change the attributes of a column. One can change the data type, or more commonly, only the size limitation, e.g. VARCHAR(32) gets changed to VARCHAR(42).