I have run into a situation where the MySQL database is filling up more quickly than the cleanup process can handle and as such, I just have mysqld.exe hanging in Task Manager and no subsequent jobs submitted are going through because the query is going to take 100 years to finish.
I am aware that this is a known issue hopefully to be resolved in later releases but is there a workaround in the meantime to clear the DB manually by truncating certain tables?
Managed to solve it myself.
For anyone wishing to do this, please follow the steps below.
- Stop OLConnect_Server service.
- Open elevated Command Prompt (cmd.exe) - right-click, run as Administrator.
- Type: cd C:\Program Files\Objectif Lune\OL Connect\MySQL Product\MySQL\bin
- Type: mysql -u root -p
- Enter the password you set up as the MySQL root password when you installed OL Connect.
- Once you’re logged into MySQL instance, type: drop schema objectiflune;
- Type: quit
- Start the OLConnect_Server service and it will now start with a clean database.
WARNING: This will remove all the data that is in the MySQL database so only do this if you database has clogged up with unwanted records and you don’t need the data.
1 Like