April 19, 2014

Would you like to ask a question about PBXT?

In the next week, I’ll be interviewing Paul McCullagh, the architect behind the PBXT storage engine. If you have any questions for Paul, please post them here by Monday 16th November.

Note: The idea for this interview was inspired by a previous interview with Heikki Tuuri – creator of InnoDB. You can see the answers here and here.

About Morgan Tocker

Morgan is the Director of Training at Percona. He was formerly a Technical Instructor for MySQL and Sun Microsystems. He has also previously worked in the MySQL Support Team, and provided DRBD support.

Comments

  1. Patrick Casey says:

    What’s the “ideal” use case for the PBXT engine?

    When would I use PBXT instead of, say, myISAM or INNODB?

  2. I think I 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 non-SELECT-intensive applications (finance, production management etc.) in my opinion.

    So first question is: what is status here? Are there any recent benchmarks in this respect?

    Also PBXT is very easy to handle for user as has very few configuration parameters. That could make it interesting for organisations with less internal IT-expertise. Actually I think PBXT is the only ENGINE that would make MySQL based solutions compete in the market segment (a huge one!) where SQL server dominates (InnoDB is too complex).

    2nd question: any comment to that?

  3. Jason Clifton says:

    How does the online backup work (especially from a user perspective) IE how do I go about running an online backup vs regular backup. And will the data be consistent…

  4. Matic says:

    - How does PBXT compare with XtraDB in terms of performance, especially write performance?
    - What kind of usage was PBXT designed to have?
    - What is PBXT’s purpose?

  5. David says:

    - Does PBXT use main thread to do the most of task like in InnoDB ?
    - Does it support clustered index ?
    - Does it support online backup and increment backup ?
    - Page size in PBXT , and can this value be tuned ?
    - The advantage in PBXT than InnoDB ? We do need two almost same functional storage engine, sometimes it makes user confused.

Speak Your Mind

*