Monthly Archives - October 2008

A quest for the full InnoDB status

When running InnoDB you are able to dig into the engine internals, look at various gauges and counters, see past deadlocks and the list of all open transactions. This is in your reach with one simple command —

Shell

SHOW ENGINE InnoDB STATUS

1

SHOW ENGINE InnoDB STATUS

. On most occasions it works beautifully. The problems appear […]

Read more

Mirrored Binlogs patch

Google patches V1 contain interesting patch to mirror binary log on slave. Although Google is preparing GlobalTransactionId patch, which going to be replacement for MirroredBinlogs, we still think mirroring binary logs is very useful for:

Backup of binary logs in real time
High availability, to switch master load to slave with mirrored binary logs

By request […]

Read more

Percona’s patches spread to a wider audience

Percona’s patches are now available to a wider audience via OurDelta, a community effort to provide  builds with features (Percona patches, Google patches, etc) and storage engines (PBXT, Sphinx, etc) that aren’t in the main MySQL server. Arjen Lentz is really the brainchild behind this. Kudos Arjen!
What does this mean for the […]

Read more