Unqualified COUNT(*) speed PBXT vs InnoDB

So this is about a SELECT COUNT(*) FROM tblname without a WHERE clause. MyISAM has an optimisation for that since it maintains a rowcount for each table. InnoDB and PBXT can’t do that (at least not easily) because of their multi-versioned nature… different transactions may see a different number of rows for the table table! [...]

Filed under: Good practice / Bad practice by arjen on Thursday, May 27, 2010 | Social tagging: > > > > > > >
4 Comments »

PBXT early impressions in production use

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 [...]

Filed under: Software and tools by arjen on Thursday, May 27, 2010 | Social tagging: > > > > >
1 Comment »

MariaDB 5.1 packages for Debian/Ubuntu

See the OurDelta blog for details of this release. RHEL/CentOS packages also coming.

Filed under: Software and tools by arjen on Saturday, October 31, 2009 | Social tagging: > > > > >
No Comments »