The Ultimate Guide to High Availability with MariaDB
This is a read-only copy of the MariaDB Knowledgebase generated on 2024-11-21. For the latest, interactive version please visit https://mariadb.com/kb/.

About PBXT

Contents

  1. xtstat
  2. More information

PBXT was a storage engine that was included in the MariaDB source and binaries by default until MariaDB 5.3.

Since MariaDB 5.5, the PBXT storage engine has been disabled by default and must be explicitly built to use it. The reason is that PBXT is not actively maintained anymore. It has a few bugs that are not fixed and it's not actively used.

The PBXT versions in various releases are:

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.

xtstat

The included xtstat program can be used to monitor all internal activity of PBXT. See xtstat for more information.

More information

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

Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.