Hello,
Posting it here for advice and suggestions, can this be listed in optimizations page of site, if this can help or is required.
database.positionsHistoryDays if set deletes the database records. However I believe It might not help in clearning the associated indexes and .ibd data thus. I did some look up and found this option.
innodb_file_per_table should be enabled for the same in MySQL to clear disk space associated with such rows that are truncated.
Please do see if this can be added into optimization or MySQL configuration page as an optional suggestion to enable the variable.
Also do correct me if My understanding of this is wrong.
MySQL documentation says that "innodb_file_per_table" flag is enabled by default.
Hello,
Posting it here for advice and suggestions, can this be listed in optimizations page of site, if this can help or is required.
database.positionsHistoryDaysif set deletes the database records. However I believe It might not help in clearning the associated indexes and .ibd data thus. I did some look up and found this option.innodb_file_per_tableshould be enabled for the same in MySQL to clear disk space associated with such rows that are truncated.Please do see if this can be added into optimization or MySQL configuration page as an optional suggestion to enable the variable.
Also do correct me if My understanding of this is wrong.