Hello,

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.

Le mar. 14 nov. 2023 à 11:33, Marc <[email protected]> a écrit :

> 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
>
>
_______________________________________________
discuss mailing list -- [email protected]
To unsubscribe send an email to [email protected]

Reply via email to