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