SonarQube MySQL Database Cleanup Issue

[ramudonikana (Ramu)]

Hi All,
I implemented some script to call SonarQube REST API to delete old branches(somehow my old branches scan not deleted using Sonar long-lived and short-lived configurations on ‘Database Cleaner’), My Script successfully deleting old feature/bugfix/etc branches scan as expected. But It’s not clearing database space. Can someone suggest me, whether I have to perform some purge operation to reclaim database space?

SonarQube 6.7.5
MySQL database

[ganncamp (G Ann Campbell)]

Hi,

You may find these helpful:

Sonarque DB cleaner Issue

Srikanth, SonarQube will mark data as deleted, but it is up to the database engine to reclaim free space (like a postgres vaccum). Colin

For SonarQube Microsoft SQL Server Database optimization

You need to do standard SQL Server database maintenance. There’s nothing about this that’s a Sonarqube issue. The minimum maintenance for a SQL database is: Run backups - this allows Shrink to recover space in the transaction logs Shrink the database Re-index the database - rebuild the indexes to defragment and order/align them These are all SQL DBA tasks. Do you have a full-time DBA? They should know how to do this. Google “SQL Server Database Maintenance”. There are any number of writeups …

 
Ann

[ramudonikana (Ramu)]

We are using MySQL database. We don’t have any index, re-index options. Can you please suggest a solution which works on ‘MySQL’ database.

[felipebz (Felipe Zorzo)]

Take a look at https://www.thegeekstuff.com/2016/04/mysql-optimize-table

[ramudonikana (Ramu)]

mysqlcheck -o <db_schema_name>

Helped me in reclaiming entire space, My database size was 80 GB now it optimized to 30 GB.

Thanks for your help