Brief note of PBXT engine

 

pbxt engine is very dynamic storage engine and gives key features for developers like Row level locking Truly pluggable ,Short auto recovery ,Transactional

The Primebase Transaction engine (PBXT) was the fi rst truly pluggable engine and leverages underlying internal MyISAM data structure to achieve a greater compatibility with MySQL.

 

 

Key features of PBXT engine:

Row level locking
Truly pluggable
Short auto recovery
Transactional
ACID compliant
Logged based design aligns well with SSD technology

 

Limitations of PBXT engine:

Long development lifecycle
Almost solely developed by one individual

 

Important Parameters of PBXT engine:

pbxt_index_cache_size: The amount of memory assigned for index caching.
pbxt_record_cache_size: The amount of memory assigned for caching the table record data.
pbxt_log_cache_size: The amount of memory assigned for the transaction log data.
pbxt_checkpoint_frequency: The time for a checkpoint of the data written to the transaction
log file. This affects the performance of MySQL during a disaster recovery.
pbxt_data_log_threshold: The size of an internal data log file. This affects the maximum amount of data possible in the data tablespace.

 

 

Fast storage engines used in our databases:

 

Inno DB
CSV
Merge
Blackhole
Federated
eBay Memory Engine
Maria
PBXT
MySQL storage engines
NitroEDB
XtraDB
eBay Memory Engine
Solid