sonarqube-4.5 mysql db file ibdata1 does not decrease in size after using sonarqube delete option to remove several projects

Question

I have used the individual project as well as bulk deletion options in SonarQube 4.5.7 to remove old projects from the MySql database. After doing this the /var/lib/mysql/ibdata1 data file does not get any smaller. It has continued to grow to well over a hundred gigabytes. What can I do that will cause this file to shrink back down, but yet not cause a data problem for SonarQube 4.5.7?

Thanks in advance for your answers. Doug

Answer 1

The size of MySQL data files won't shrink. This is not related to SonarQube but to MySQL.

The only way to shrink data files is to recreate the database: export DB in dump file, drop DB, recreate DB, import dump file into new DB. It's obviously a requirement that before this operation you actually remove some data (which you've already done).