… with INSERTS and UPDATES (but not SELECTS). That would make PBXT very interesting for non-SELECT-intensive applications (finance, production management… implemented by PBXT using an MVCC-based consistent snapshot. Does PBXT have a maintenance thread like InnoDB’s main thread? PBXT has several… important. What is the page size in PBXT, and can it be tuned? PBXT uses 16K pages for the index data and…
Post: PBXT in tpcc-like benchmark
June 2, 2010 By 10 Comments
… to checkpoint activity. The final results are also better for PBXT: 5785.567 TpmC vs 4905.967 TpmC ( XtraDB) For 16… can see that the maximal throughput is about identical, while PBXT spends more time in drops area. Again it looks like… with checkpoint activity and I am looking PBXT addresses this problem also. Beside this issue PBXT looks pretty good and in next…
Post: MySQL Storage Engines - PBXT
May 14, 2007 By 6 Comments
… for bad. At its current state (as of the conference) PBXT does not offer Durable transactions (meaning you can lose committed… of the blobs which are never fragmented and handled efficiently. PBXT team even leads the project to add scalable blob streaming… – with disk IO situation can be rather different. Looking at PBXT architecture there is small row pointer file which is expected…
Post: PBXT benchmarks
April 8, 2007 By 14 Comments
… The mysql.start script with startup parameters for InnoDB and PBXT http://www.mysqlperformanceblog.com/files/benchpbxt/mysql.start and script… will not able to reach InnoDB results, but I hope PBXT team will improve performance to make the difference a bit…. It is also interesting to check PBXT performance on INSERT/UPDATE queries taking into account PBXT way to handle such queries, I…
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…
Comment: MySQL Storage Engines - PBXT
May 14, 2007 By 6 Comments
… following. We are evaluating usage of PBXT for one of our project. To my understanding PBXT engine writes to only one file and there is no transaction log file in the PBXT engine which will maintain the history of transactions. In this… please let me know whether the following is possible using PBXT storage engine, a. Fetching a row using its version number…
Comment: PBXT in tpcc-like benchmark
June 2, 2010 By 10 Comments
… for the single-threaded case: Engine 95thR 95thStDev 99thR 99thStDev —— ——– ——– ——– ——– PBXT 0.030120 0.003456 0.103093 0.010471 XtraDB 0… for the 16-thread case, Engine 95thR 95thStDev 99thR 99thStDev —— ——– ——– ——– ——– PBXT 0.002293 0.050770 0.001988 0.049775 XtraDB 0…
Comment: Would you like to ask a question about PBXT?
November 13, 2009 By 5 Comments
… with INSERTS and UPDATES (but not SELECTS). That would make PBXT very interesting for non-SELECT-intensive applications (finance, production management… here? Are there any recent benchmarks in this respect? Also PBXT is very easy to handle for user as has very… for organisations with less internal IT-expertise. Actually I think PBXT is the only ENGINE that would make MySQL based solutions…
Comment: Countless storage engines
May 4, 2007 By 6 Comments
… link to previous row version. I think the assumption in PBXT is to have fixed row portion small and so this file fits in memory. In general PBXT seems to be very optimized for Blobs handling and handling long rows in general. Also worth to note currently PBXT really treats different databases as different instances which can cause…
Comment: PBXT in tpcc-like benchmark
June 3, 2010 By 10 Comments
… also about your observations: was I/O load higher on PBXT vs XtraDB? if yes, how much? Did you try other PBXT settings/tuning? did Paul work with you here? may we consider the current PBXT configuration setting as optimal? any other observation you may to…
