Posted on Oktober 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…
WeiterlesenPosted 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…
WeiterlesenPosted 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…
WeiterlesenPosted 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,…
WeiterlesenPosted 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…
Weiterlesen