Differences between Percona MyRocks and Facebook MyRocks¶
The original MyRocks was developed by Facebook and works with their implementation of MySQL. Percona MyRocks is a branch of MyRocks for Percona Server for MySQL and includes the following differences from the original implementation:
- The behavior of the
START TRANSACTION WITH CONSISTENT SNAPSHOTstatement depends on the transaction isolation level.
|Storage Engine||Transaction isolation level|
|Facebook MyRocks||Fail||Success (MyRocks engine only; read-only, as all MyRocks engine snapshots)|
|Percona MyRocks||Fail with any DML which would violate the read-only snapshot constraint||Success (read-only snapshots independent of the engines in use)|
- Percona MyRocks includes the
zstdstatically linked libraries.
Last update: 2023-09-27