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 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 | |
READ COMMITTED |
REPEATABLE READ |
|
| InnoDB | Success | Success |
| 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
lz4andzstdstatically linked libraries.
Compression¶
The supported compression algorithms are the following:
| Compression Algorithm | Percona MyRocks | Facebook MyRocks |
|---|---|---|
| Zlib | Yes | Yes |
| LZ4 | Yes | Yes |
| ZStd | Yes | Yes |
| None | Yes | Yes |
| Snappy | No | Yes |
| Bzip | No | Yes |
Last update:
2022-09-27