The size of the live_measures.ibd file in our mysql database has grown too large. We are looking for a solution but cannot find it. We shortened the duration of db cleaning operations on sonar, but the database size did not decrease.
Version 7.4 (build 18908)
SonarQube 7.4 is an old, unsupported version and mysql is no longer a supported database engine for SonarQube.
Your priority should be to upgrade to the currently supported version e.g. 8.9 LTS. I would suggest you:
- do the manual housekeeping by identifying inactive projects e.g. with
api/projects/search?analyzedBefore=YYYY-MM-DDand delete them to liberate space
- perform a migration to one of the currently supported DB engines (SQL Server, Postgres or Oracle) using mysql-migrator
- upgrade to 8.9 LTS