how to discard aware bsv multiple domain versions in mysql
-
- Posts: 370
- Joined: Sat Apr 28, 2018 3:33 am
- Location: India
- Contact:
how to discard aware bsv multiple domain versions in mysql
When you create new version in aware it adds size to the disk in domainversions.ibd file as attached. So after sometime the file increases to 3 to 4 GB. Even if you delete the versions via aware this file remains intact. How do we safely reduce these files. I see 7 GB of version data in my sql between test and basdb.
- Attachments
-
- cleanup.png (17.72 KiB) Viewed 3530 times
Re: how to discard aware bsv multiple domain versions in mys
Use
optimize table domainversions;
optimize table domainversions;
Version 8.5 - Windows using MySql 8 and SQL Server - 64bit