… like InnoDB. However, PBXT‘s log-based architecture makes performance characteristics different to both MyISAM and InnoDB/XtraDB. Tests show that PBXT‘s… is implemented by PBXT using an MVCC-based consistent snapshot. Does PBXT have a maintenance thread like InnoDB‘s main thread? PBXT has several…
Post: PBXT benchmarks
April 8, 2007 By 14 Comments
… MyISAM / InnoDB and pbxt-0.9.85-beta.tar.gz Compilation parameters: For MyISAM / InnoDB ./configure –prefix=/usr/local/mysqltest/mysql- –with-innodb Method… by range of PK values. PBXT is much worse here because of InnoDB clustering by primary key. InnoDB does not need an extra…, as I understand PBXT will not support clustering and will not able to reach InnoDB results, but I hope PBXT team will improve…
Post: PBXT in tpcc-like benchmark
June 2, 2010 By 10 Comments
… in PBXT is about 1.5x better XtraDB, but there periodical drops which are very similar to periodical drops in InnoDB without adaptive checkpointing, and I guess it is also related to checkpoint activity. The final results are also better for PBXT… with checkpoint activity and I am looking PBXT addresses this problem also. Beside this issue PBXT looks pretty good and in next…
Comment: PBXT benchmarks
April 9, 2007 By 14 Comments
… did a few tests re. speed of INSERTs to compare InnoDB, PBXT, MyISAM (and Archive and CSV). These were all single thread… than MyISAM, PBXT was in all cases relatively very close as compared to InnoDB. Also, whereas the difference between PBXT and MyISAM remained quite constant as more rows where inserted (I went up to 4G rows) InnoDB seemed to…
Post: Would you like to ask a question about PBXT?
November 12, 2009 By 5 Comments
…, I’ll be interviewing Paul McCullagh, the architect behind the PBXT storage engine. If you have any questions for Paul, please… inspired by a previous interview with Heikki Tuuri – creator of InnoDB. You can see the answers here and here.
Post: Choosing innodb_buffer_pool_size
November 3, 2007 By 38 Comments
…. You do not want OS to cache what Innodb is caching already. Innodb cache is more efficient compared to OS cache because… other things and if you will not make Innodb to bypass OS buffering Innodb TableSpace IO will wipe out cache because it… I only described Innodb Buffer Pool selection for dedicated Innodb system. If you have fair amount of MyISAM, Archive, PBXT, Falcon or other…
Post: Innodb Caching (part 2)
May 10, 2011 By 7 Comments
… disappointment. The compressed .idb file was only 620MB so if Innodb would chose to keep only compressed pages in memory it… overhead needed for page decompression) if this is the policy innodb would have chosen. In reality however results are a lot… storage engines in this regard. I’m very curious how PBXT and TokuDB would perform in this kind of benchmark. I…
Post: Reality of Innodb Caching
April 21, 2011 By 8 Comments
I have mentioned few times Innodb caches data in pages and even if you have working … would fair better, so I would expect better results with PBXT. I also should check with smaller page sizes available in…
Comment: Countless storage engines
May 4, 2007 By 6 Comments
… handling long rows in general. Also worth to note currently PBXT really treats different databases as different instances which can cause… databases. 3) Solid – this one is actually better positioned as “Innodb Replacement” as it has much more close architecture and applications… has clustering by primary key and unlike Innodb has key compression (one of major Innodb problems in my opinion). The problems with…
Comment: Would you like to ask a question about PBXT?
November 13, 2009 By 5 Comments
… reports that PBXT (at an early stage) out performed InnoDB with INSERTS and UPDATES (but not SELECTS). That would make PBXT very interesting… for organisations with less internal IT-expertise. Actually I think PBXT is the only ENGINE that would make MySQL based solutions… the market segment (a huge one!) where SQL server dominates (InnoDB is too complex). 2nd question: any comment to that?
