… like InnoDB. However, PBXT‘s log-based architecture makes performance characteristics different to both MyISAM and InnoDB/XtraDB. Tests show that PBXT‘s performance is similar to InnoDB but…
Post: Choosing innodb_buffer_pool_size
November 3, 2007 By 38 Comments
My last post about Innodb Performance Optimization got a lot of comments choosing proper innodb_buffer_pool_size and indeed I oversimplified things… write a bit better description. Innodb Buffer Pool is by far the most important option for Innodb Performance and it must be set… I only described Innodb Buffer Pool selection for dedicated Innodb system. If you have fair amount of MyISAM, Archive, PBXT, Falcon or other…
Post: PBXT benchmarks
April 8, 2007 By 14 Comments
… I understand PBXT will not support clustering and will not able to reach InnoDB results, but I hope PBXT team will improve performance to make the difference a bit better. Unfortunately InnoDB shows bad… think InnoDB team should solve this problem, I do not know Oracle plans about. It is also interesting to check PBXT performance on…
Page: Presentations
May 3, 2006 By
… looks into PBXT, Falcon and SolidDB Storage engines and compares them in terms of performance and behavior to Innodb. Pre-release …parameters affect MySQL Performance in DBT2 benchmark. Focuses mostly on Innodb but many findings are generally valid. Download MySQL/Innodb Performance: Server and …
Post: Innodb Caching (part 2)
May 10, 2011 By 7 Comments
… overhead needed for page decompression) if this is the policy innodb would have chosen. In reality however results are a lot… reasonable as the target. With such definitions 16K provides acceptable performance with 9216 keys touched, 4K with 27518 and 16K compressed… look more about performance of different storage engines in this regard. I’m very curious how PBXT and TokuDB would perform in this…
Post: UC2007 Presentation and Notes
May 2, 2007 By 5 Comments
…conference this year was “Storage Engines” – There were talks about PBXT, Falcon, Innodb, NDB, Solid, NitroDB, ScaleDB as well as related …published PDFs for these: MySQL Server Settings Tuning MySQL Performance Cookbook Innodb Performance Optimization Last one was presented by me and Heikki together…
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… in terms of performance properties and transaction implementation details Falcon is unlikely to be easy drop-in replacement for Innodb but for… if performance will be adequate. Solid also has clustering by primary key and unlike Innodb has key compression (one of major Innodb problems…
Post: Countless storage engines
May 3, 2007 By 6 Comments
…. InnoDB On the conference InnoDB presented two new interesting features – transparent ZIP of pages stored on disk. Potentially it can imporove performance of… going to test PBXT in write workload, though currently comparison with InnoDB will not be fair, as PBXT do not perform fsync() after commit…
Post: The Doom of Multiple Storage Engines
May 8, 2010 By 22 Comments
… kinds of combination such as running multi-table update joining PBXT and Innodb tables. Operations Things like backup and monitoring becomes a…deal with balancing – allocating resources to different storage engines and performance tuning becomes more complicated. Now what is interesting for probably…
Comment: Would you like to ask a question about PBXT?
November 13, 2009 By 5 Comments
… remember 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?
