ESX: MySQL influence to graph jitter?

Help
1

Hi Folks,
for months I had been running LibreNMS inside a VM including the RRD directory as also the MySQL server.
I didn’t have been cheap with 32GB of RAM, 32 Cores and a decent SSD backed ZFS store.

I had seen contention inside the Linux disc queue therefore I moved the RRD directory out of the VMDK into a dedicated NFS mount which improved the situation a lot but sometimes it still took forever to get graphs showing up primary related to millions of entries withing the syslog and device_perf tables.

Finally I truncated these tables and moved do a dedicated physical MySQL server and now I am really surprised by seeing this change inside all of my graphs.
e.g. this graph has nothing to do with the I/O of my LibreNMS VM, it’s just a quiet router!

Screen Shot 2017-05-07 at 09.34.15AM.jpg1572×738 268 KB

Just wonder if someone has an explanation or an idea?
Thank you,
Wolfgang

2

Do any of the individual ports show they weren’t graphing?

3

not I am aware of. As far as I remember I didn’t miss a port graph but it’s hard to say as switches have a lot of ports. The only surprising thing had been that graphs change from spiky to smooth.