(Simon J Mudd) MySQL, like a lot of other software, has many knobs you can tweak. Most of these knobs may affect behaviour, but more importantly most affect the memory usage of the server, so getting these settings right is very important.

(Baron Schwartz) Sometimes you might hear people talk about full backups, and differential backups versus incremental backups. What is the difference?

(Brian Buchalter) If you’re using MySQL replication, then you’re probably counting on it for some fairly important need. Monitoring via Nagios is generally considered a best practice.

(Baron Schwartz) With the recent release of Percona XtraDB Cluster, I am increasingly being asked about MySQL’s semi-synchronous replication. I find that there are often a number of misconceptions about how semi-synchronous replication really works. I think it is very important to understand what gu

(Dimitri) Last week I was faced to a strange problem while benchmarking MySQL 5.6: some of my user sessions become “frozen” periodically and finally my whole test was not valid.

(Tamas Kozak) Backing up binary logs are essential part of creating good backup infrastructure as it gives you the possibility for point in time recovery. After restoring a database from backup you have the option to recover changes that happend after taking a backup. The problem with this approach

(Dathan Pattishall) MySQL is awesome at converting strings to integers when comparing column lvalues with converted rvalues. So much so that many of us take this fact for granted. When does this assumption break down? When does passing in the wrong value cause problems in mySQL?

(Lorna Jane Mitchell) I recently wrote a post about inner and outer joins, and a couple of people asked what the difference is between USING and ON.

(Arjun Panwar) The concept of the null value is a common source of problems for an outsider; null is the same thing as an empty string in MySQL server does nothing to disallow null as the value of a distribute expression, whether it is a column value or the value of a user supplied expression. Null

(Kris Hadlock) The jQuery Mobile framework is a quick and easy way to create mobile websites. However, you might not know that the framework has a decent API that you can use to extend the basic functionality. This article provides an overview of some of the most useful features in the API and gives