Blog Author

Hartmut Holzgraefe

Principal Support Engineer, MariaDB

Hartmut has a long experience of MariaDB and MySQL.

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 seconds. https://github.com/hholzgra/transaction_time_audit Motivation A customer was looking for a solution…

Read More

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 that currently have it set to this dropped user? This…

Read More

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 and running the test suite, you can automate the process…

Read More

Customized MySQL LOAD DATA LOCAL INFILE handlers with libmysqlclient

One of the lesser known (and used) MySQL Client API calls seems to be mysql_set_local_infile_handler() which allows to override the default LOAD DATA LOCAL INFILE behavior on the client side,…

Read More

A first second look at InnoDB spatial indexes in the…

Warning: it turned out that I used a full debug build instead of a release one, and that seems to make a hell of a difference … most numbers have…

Read More

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 while. Originally created as part of my code generator projects…

Read More

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 now have finished importing OpenStreetMap data extracts for most countries in Europe…

Read More

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 modifies a rows primary key can trigger some recursive behavior…

Read More

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 i want case insensitive behavior but also want all accented…

Read More