We are very pleased to announce the public release of SSM 126.96.36.199.5.3.
In addition to a number of of bug fixes, there are a number of improvements and new features.
- compatibility improvements with RDS to cover changes in AWS APIs and responses
- Slow log harvesting via slow log which is more thorough (e.g. it includes prepared statements) than harvesting queries from performance_schema
- compatibility improvements with MySQL 8 (e.g. log buffer readings now work)
- Userspace updated to EL 8.8
- Prometheus updated to 2.45 LTS
- QAN database now uses 64KB data pages (unless it is being upgraded)
- QAN database now uses LZ4 compression unless it detects running on ZFS (which is likely already compressed)
- QAN now tries to infer the correct schema when slow log doesn’t explicitly include it on Oracle MySQL
- QAN query parser improvements
- For stored procedure calls, QAN now displays the procedure definition
- InnoDB buffer pool hit rate is now shown on the InnoDB Buffer Pool Requests graph to provide a cross-check of whether the buffer pool is dramatically underspecified.
- From this release we include production .deb packages, in addition to .rpm packages
- Repositories and release packages are available to make future updates easier.
- Monitoring services now use configuration files, which allows us to use static service scripts.
- SNMP remote monitoring
The SNMP support was added for cases where you need to monitor a remote server to which you don’t have SSH access and cannot install ssm-client package on, but does expose SNMP telemetry. SNMP telemetry isn’t as comprehensive as what node_exporter provides, but it is better than no OS level telemetry at all.
Reminder – SSM is a fork of Percona’s PMM v1 with additional fixes and improvements.
Direct in-place upgrade from PMM v1 to SSM is supported.
We have full SSM documentation available to get you up and running. If you are already familiar with PMM v1, you should feel right at home, everything you are used to is present with at most minimal changes (and in most cases no changes).
Please take it for a spin and report any bugs you find so that we can fix them. Happy monitoring.