We are having about 1050 projects in our SonarQube 6 community edition instance and a DB size of 33 GB. Previously we had around 2000+ projects. Unfortunately we did not check the DB size before deleting all those projects. We then also lowered some of the db cleaner settings.
I am not sure if 33 GB is a lot, but I’d like to reduce the size as much as possible for a pending DB migration.
My questions are as follows:
- As far as I understood the automatic DB cleaner is only triggered after a project was analyzed. Does the user need admin permissions to trigger the cleanup?
- If I manually delete projects via administration - manage projects - bulk delete, does this automatically mean that I also delete rows in the DB?
- Can I manually trigger any cleanup jobs?
- Do I have any other means to identify orphaned entries?
Hope you guys can help me