Thanks Giving Challenge: How to detect replication context

Happy Thanksgiving and little holiday challenge for you.
Say you have a trigger on the slave which you would like to work differently, depending on whenever update is executed via replication thread vs updating table locally ? This can be helpful for example for auditing updates which were done directly instead of coming […]

Read more

The patches are going to Launchpad

After some discussions on the OpenSQLCamp 2008 conference we decided to move our development to Launchpad, to be in stream with other MySQL related projects.
We published our patches there https://code.launchpad.net/percona-patches, it is supposed to be main repository for the patches.
We advise to use Launchpad bug system to report bugs and also for feature requests.

Read more

Adaptive checkpointing

Do you know that there are two limits about dirty (modified but not flushed to disk) blocks of InnoDB buffer pool? One is the limit of “amount”. The other is the limit of “age”.
— limit of “amount” —
As you know, buffer pool of InnoDB works as write-back cache of its datafiles. If the buffer […]

Read more