A transaction duration tracking audit plugin for MariaDB and MySQL
This plugin logs long running transactions to the server error log when transaction took more than a configurable number of […]
Changing the DEFINER of MySQL stored routines etc.
The question seemed easy enough: We’ve dropped a user, now we want to change the DEFINER on all database objects […]
Building MaxScale from source with Vagrant and Puppet
MaxScale for MariaDB and MySQL hides the complexity of database scaling from the application. To streamline building MaxScale from source […]
A first second look at InnoDB spatial indexes in the MySQL 5.7 april lab release …
Warning: it turned out that I used a full debug build instead of a release one, and that seems to […]
MySQL/MariaDB autoconf macros
I’ve had my own set of autotool macros for building against different MySQL client and server APIs for quite a […]
Real world GIS test data
Ok, this took a bit longer than originally planned for, but if you want to test out recent MariaDB GIS improvements I […]
Nasty InnoDB regression in MySQL 5.5.25
We just ran into a nasty InnoDB bug that only seems to exist in MySQL 5.5.25: An InnoDB update that […]
Adding a case insensitive, distinct unicode collation
Every once in a while questions like the one in MySQL Bug #60843 or Bug #19567 come up: What collation should i use if […]