mysql errors

[alabamatoy]

Seeings lots of these in both my ZM installs:

Code: Select all

2017-12-11T20:46:55.096064Z 293 [Note] Aborted connection 293 to db: 'zm' user: 'zmuser' host: 'localhost' (Got timeout reading communication packets)
2017-12-11T22:47:18.321857Z 300 [Note] Aborted connection 300 to db: 'zm' user: 'zmuser' host: 'localhost' (Got an error reading communication packets)

Most of the time when I see one of these, it will correspond to a particular monitor losing its connection to a camera. Sometimes this connection loss is only a few seconds, but sometimes it is much longer.

Where do I begin to troubleshoot?

[bbunge]

Check the number of connections MySQL uses. If I remember it is set to a low number by default and with several cameras or several PC's watching monitors you may need to up the connections to 500 or so. Use mysqltuner to see what you need to change in my.cnf