how to discard aware bsv multiple domain versions in mysql

If you have questions or if you want to share your opinion about Aware IM post your message on this forum
Post Reply
swiftinitpvtltd
Posts: 370
Joined: Sat Apr 28, 2018 3:33 am
Location: India
Contact:

how to discard aware bsv multiple domain versions in mysql

Post by swiftinitpvtltd »

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
cleanup.png (17.72 KiB) Viewed 3316 times
chris29
Posts: 173
Joined: Sat Feb 06, 2010 1:45 am
Location: Australia

Re: how to discard aware bsv multiple domain versions in mys

Post by chris29 »

Use

optimize table domainversions;
Version 8.5 - Windows using MySql 8 and SQL Server - 64bit
Post Reply