Commit_interval

Hi All,

Is there a way to change the commit_interval by any service?
I use google backup. This Add-On turn off MariaDB to backup correct way.

That moment HA can’t write to the db. Would be nice to set commit_interval to a longer period for example 300 or 600 seconds. Then start the google backup and after that bring back the interval to 30 seconds.

Then hopefully I don’t see errors, and all the collected information will be written after the backup in db.

Cheers,
Peter