One of the most exciting features shipped in the Percona Monitoring and Management 1.3.0 (PMM) release is support for MyRocks metrics via a new Metrics Monitor dashboard titled MySQL MyRocks Metrics. The support in PMM follows the recent Percona Server for MySQL release 5.7.19 from September 6, where Percona delivered an EXPERIMENTAL version of MyRocks for non-Production usage.
The MyRocks storage engine from Facebook is based on RocksDB, a persistent key-value store for fast storage environments. MyRocks is optimized for fast storage and combines outstanding space and write efficiency with acceptable read performance. As a result, MyRocks has the following advantages compared to other storage engines (if your workload uses fast storage, such as SSD):
- Requires less storage space
- Provides more storage endurance
- Ensures better IO capacity
MyRocks Database Operations
This graph will help you visualize MyRocks database operations of Next and Seek attributes:
MyRocks Cache Activity
We also have a graph to help you visualize the count of Hits and Misses on the MyRocks cache:
MyRocks Cache Data Bytes Read/Write
Finally, another important MyRocks graph will help you understand the volume of data read and written to the MyRocks cache:
Please note that the MyRocks storage engine is not suitable (yet) for production workloads, but if you are testing this technology take a moment to install PMM in order to take advantage of our new MySQL MyRocks Metrics dashboard!
In PMM, you can view the metrics provided by the information schema as well as various data reported by the RocksDB engine’s status used by your MySQL database instance.