Ignition data from MySQL

Ignition
1

Hello guys,

I have a question regarding the MySQL default database that is connected to Ignition. Our database server is very low on disk and we want to delete some data.

mysql%20conn%20ignition
mysql%20conn%20ignition1067×913 109 KB

mysql%20conn
mysql%20conn1360×290 33.2 KB

I noticed that the “ProgramData” folder from MySQL saves data month by month in form of: .IBD, .FRM

back-up%20mysql
back-up%20mysql718×568 77 KB

My question is:

This data is the historical data for each month? Or is the data for all the months from the beggining?

Can I delete this data or copy them on another server and acces them only if we need to?

Thank you!!

2

Why not setup pruning, let Ignition delete on it’s own? Pruning is turned off by default, turn it on and then set the age to what you think you will need.

https://www.inductiveuniversity.com/video/data-partitioning-and-pruning/7.9

1 Like