I’m monitoring two MySQL slaves A and B whose masters both run the pt-heartbeat daemon.
For slave A I see the value of mysql_heartbeat_timediff_sec in PMM, for B I don’t.
What I’ve checked so far:
- According to VMUI only the A pmm exporter is exporting a mysql_heartbeat_timediff_sec value. Other mysql_ metrics are exported by both servers.
- Both slaves show “mysqld_exporter … --collect.heartbeat” in the process list.
- The updates from the master to the percona.heartbeat tables are being replicated to both slaves.
- MySQL versions are 5.7.40 (A) and 5.7.41 (B). Both slaves have PMM in version 2.34.0, PMM Server is version 2.34.0 too.
The only difference I see in the configurations (aside from the slightly different MySQL versions) is that B is running mysqld_exporter with “–disable-tablestats” (which can’t be omitted because of a very high number of tables).
Would “–disable-tablestats” also disable the collector for heartbeat? Any suggestions what I could try for server B to make it export mysql_heartbeat_timediff_sec?