From Askmonty.org

TOC

MariaDB 5.1 Reference Manual: PBXT storage engine

Index

The PBXT storage engine version 1.0.08d is included in the MariaDB source and binaries by default. This is the RC2 version.

Currently available from PrimeBase web-site is the RC 3 version: 1.0.09d.

The major difference between RC2 and RC3, is that RC3 includes online backup and XA support.

PBXT is a general purpose transactional storage engine. PBXT is fully "ACID" compliant, which means it can be used as an alternative to other MariaDB transactional engines (such as XtraDB or InnoDB).

PBXT features include the following:

• MVCC Support: MVCC stands for Multi-version Concurrency Control. MVCC allows reading the database without locking.
• Fully ACID compliant: This means that all transactions are: atomic, consistent, isolated and durable.
• Row-level locking: When updating, PBXT uses row-level locking. Row-level locking is also used during SELECT FOR UPDATE.
• Fast Rollback and Recovery: PBXT uses a specialized method to identify garbage which makes "undo" unnecessary. This make both rollback of transactions and recovery after restart very fast.
• Deadlock Detection: PBXT identifies all kinds of deadlocks immediately.
• Write-once: PBXT uses a log-based storage which makes it possible to write transactional data directly to the database, without first being writen to the transaction log.
• Referential Integrity: PBXT supports foreign key definitions, including cascaded updates and deletes.
• BLOB streaming: In combination with the BLOB Streaming engine PBXT can stream binary and media directly in and out of the database.

PBXT will not take any resources (disk space or CPU processing) until you create your first PBXT table.

Further documentation can be found here: http://www.primebase.org/documentation