MariaDB management on synology

1

Hi,

I recently moved my db to my NAS with mariaDB. This works perfectly and my ha is much faster. I’m reading through the recorder section in the website and can figure some things out. I would like to have a couple of things included.

  1. I would like to keep a history of 30 days.

  2. for temperature sensors, defined variables I use for yearly lowest temp and such I would like to keep at least a year.

Before I experiment with the settings I want to be sure I don’t mess up and lose data.

Is the above possible and yes can someone provide an example of the code I need to use.

Thanks