Gearman provides a generic application framework to farm out work to other machines or processes that are better suited to do the work. It allows you to do work in parallel, to load balance processing, and to call functions between languages. It can be used in a variety of applications, from high-availability web sites to the transport of database replication events. In other words, it is the nervous system for how distributed processing communicates.
Read More

Why does everything in MySQL have a charset/collation?
Read More

Good (but old) article why not to use stored procedures in combination with PHP applications.
Read More

Saved me a lot of time:

SELECT COUNT(*), column1, column2 FROM tablename
GROUP BY column1, column2
HAVING COUNT(*)>1;


Source: http://lists.mysql.com/mysql/204859

Need to know for all developers…

Get a basic idea of how sql injections work: http://ferruh.mavituna.com/sql-injection-cheatsheet-oku

MySQL has a nice tool called ‘mysqldumpslow’. It parses and summarizes the MySQL slow query log.

An interesting tool, however in most cases you’ll want to solve slow queries which reoccur the most, thus sorting the slow query log by count.
Read More