OL Learn

MySQL datacolumnschema.ibd file is almost 40 GB

On our system, the MySQL C:\ProgramData\Objectif Lune\OL Connect\MySQL\data\objectiflune\datacolumnschema.ibd file is almost 40 GB and the MySQL C:\ProgramData\Objectif Lune\OL Connect\MySQL\data\objectiflune\datavalue.ibd is over 4 GB . We are running into drive space issues.

What can be done to reduce the amount of space these MySQL files take?

Sounds like the cleanup service has been turned off, or set to an incorrect schedule. Have you tried opening up the Connect Server Configuration app and clicking the Run Now option in the Clean-Up Service section?

If running the cleanup service yields no significant difference, make sure the Database Partitioning option is turned on. It will help speed up the cleanup service, which will in turn ensure it runs properly and regularly. Allow a couple of days to elapse after turning the option on to witness the full effect of partitioning.