(Michael “Monty” Widenus) I just finished my last MariaDB 5.3 feature before we go beta:

(Haidong Ji) I’ve done some benchmark testing of 2 Python modules for MySQL data retrieval: MySQLdb and pyhs. MySQLdb uses MySQL’s client libraries, whereas pyhs, which uses HandlerSocket that bypasses MySQL’s client layer and interfaces Innodb storage engine’s files directly. In my testing, Handler

(Martin Farach-Colton) Indexes can reduce the amount of data your query touches by orders of magnitude. This results in a proportional query speedup. So what happens when you define a nice set of indexes and you don’t get the performance pop you were expecting?

(Shinguz) We did recently a review of one of our customers systems and we found that the Query Cache was disabled even thought it had significant more read than write queries.

(Sergey Petrunia) Three years ago MySQL has got @@optimizer_switch variable. It was introduced in MySQL 5.1.34, that is, we needed it so much that we’ve added it into the stable release.

(Marc Alff) One of the most important question users ask before deciding to use the performance schema is: what is the overhead ? The underlying concern of course is to make sure deploying the performance schema does not negatively impact production (“First, do no harm”).

(Mark Callaghan) We want to use large transaction log files for InnoDB to reduce page writes done for fuzzy checkpoints. The sum of the sizes for log files is 4G in official MySQL and much larger in Percona XtraDB.

(Lachlan Mulcahy) I have now committed the changes for the new Backup Strategies feature to trunk! In addition, I’m pretty much finished on implementing the majority of the Materialized Snapshot feature/option.

(Alejandro Gervasio) Being one of the big pillars of Object-Oriented Design, The Interface Segregation Principle (ISP) permits you to define fine-grained contracts that provide client classes with the functionality to perform a set of well-defined tasks.

(Daniël van Eeden) This is a response on MySQL security: inconsistencies and Less known facts about MySQL user grants.