A transaction duration tracking audit plugin for MariaDB and MySQL
Posted on October 27, 2014 by Hartmut Holzgraefe
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 MoreChanging the DEFINER of MySQL stored routines etc.
Posted on September 22, 2014 by Hartmut Holzgraefe
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 MoreBuilding MaxScale from source with Vagrant and Puppet
Posted on August 19, 2014 by Hartmut Holzgraefe
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 MoreCustomized MySQL LOAD DATA LOCAL INFILE handlers with libmysqlclient
Posted on April 30, 2014 by Hartmut Holzgraefe
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 MoreA first second look at InnoDB spatial indexes in the…
Posted on April 16, 2014 by Hartmut Holzgraefe
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