Does anybody know if the Tag Historian feature/module is compatible with the “ARCHIVE” MySQL Engine? Maybe with some tweaking?
I was hoping that I could shrink my database size…
Disclaimer: I’ve tried but it doesn’t seem to like it.
I have a similar question. I am planning out a new system and would like to archive any data older than 3 months. If I set up the historian to partition by month on a mysql database, it looks like I’ll get tables named sqlt_data_#######.
Can I convert these tables (for months older than 3) to use the archive engine instead of the default innodb without messing up ignitions ability to read the data from the remaining innodb tables (data 3 months and newer)?
Can ignition read the archived data as is (as historian tags)?