(Shlomi Noach) Today I have released common_schema, a utility schema for MySQL which includes many views and functions, and is aimed to be installed on any MySQL server.

(Cédric Peintre) I’ve used the OPTIMIZE command for a long time, in particular for disk space problems.

This is a beginner tutorial that will show you how to perform MySQL backups and restoration.

(Baron Schwartz) If you need to change MySQL’s innodb_log_file_size parameter (see How to calculate a good InnoDB log file size), you can’t just change the parameter in the my.cnf file and restart the server.

(Ovais Tariq) The purpose of this post is to describe what covering indexes are and how they can be used to improve the performance of queries. People mostly use indexes to filter or sort the results but not much thought is given to actually reduce the disk reads by using proper indexes.

(Rene Cannao) … or at least, not completely!

(scott_liu) My company has the need to synchronize data on a real time basis from MS SQL Server 2008 to MySQL database. At first I thought that it could be done with table triggers after setting up a linked server to MySQL table, and then it would not be a big problem.

(Ilan Hazan) Even if you think you know everything about LEFT JOIN, I bet you will learn something or two in this post!

(Shlomi Noach) Listing some useful sed / awk liners to use with MySQL. I use these on occasion.

(Alejandro Gervasio) In this MySQL database tutorial, you will be learning how to avoid duplicate records using “Primary Key” and the “Insert Ignore” SQL statement.