With Paul McCullagh’s PBXT storage engine getting integrated into
MariaDB 5.1,
it’s never been easier to it out. So we have, on a slave off one
of our own production systems which gets lots of inserts from our
Zabbix monitoring system.
That’s possibly an ideal usage profile, since PBXT is a log based
engine (simplistically stated, it indexes its transaction logs,
rather than rewriting data from log into index and indexing that)
so it should require less disk I/O than say InnoDB. And that
means it should be particularly suited to for instance logging,
which have lots of inserts on a sustained basis. Note that for
short insert burst you may not see a difference with InnoDB
because of caching, but sustain it and then you can notice.
Because PBXT has such different/distinct architecture there’s a
lot of learning involved. Together …
[Read more]