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 MorePosted 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 MorePosted 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 MorePosted 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 MorePosted 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