I) What is parallel replication? Parallel replication is a nice feature introduced in MariaDB 10.0, and which allows to run in parallel some queries on a slave. Basically, by default (the conservative mode), it runs in parallel transactions that couldn’t have any conflict. Note you have to enable GTID to use this feature. Starting with […]

I) Why using TokuDB? I have been playing with TokuDB since 2013. Although it’s a really good storage engine, it’s sometimes full of surprises. Initially I migrated one of my customer from InnoDB to TokuDB because it was solving all their issues : their DB has been growing to more then 1TB, and they were facing […]

I – Table Statistics – Why? When you execute a SQL query that uses an index, creates a join, or another complex operation, MySQL will read the statistics linked to these tables, which will allows it to chose the optimal plan of execution. For InnoDB for example, this behaviour is controlled by innodb_stats_% type variables: show variables LIKE […]