So what could be the main causes of mariadb not being available (it is still running) without reporting anything in the logs?
It looks normal because mysqldump loads data into memory. as long as you dont exceed values for buffer pool, open files limit and open tables limit the data and/or handlers will be cached.
BTW, if you run mysqldump in a locking way it could affect your application.
I am currently also running the mysqld_exporter
what I notice is that, the backup mysql_dump is the only event that seems to cause 'load', and then:
- mysql intern memory overview seems to increase at the backup time, but does not seem to be released.
- mysql open files seems to increase at the backup time, but does not seem to be released.
- mysql open tables seems to increase at the backup time, but does not seem to be released.
- mysql open table definitions seems to increase at the backup time, but does not seem to be released.
Should not at least something go down after the backup/mysql_dump event?
PS I did not verify anything of the grafana dashboard I am using