SonarQube:如何减小measures_data.ibd的大小? [英] SonarQube : How to reduce size of measures_data.ibd?

问题描述

我已经使用SonarQube/Sonar几年了，measures_data.idb的大小已经增长到了惊人的114GB，是的.

I've been using SonarQube/Sonar for a few years now and the measures_data.idb size has grown to a wopping 114GB, yes gig.

我已经设置了默认的客房清洁设置.

I've got the default house keeping settings set.

我正在使用MySql 5.6(每个文件的默认设置)

I'm using MySql 5.6 (with default per file setting)

我正在使用Sonar 4.0.

I'm using Sonar 4.0.

我尝试从mysql导出数据库，然后再次导入.但大小相同. 它确实有状态.

I've tried exporting the db from mysql and then importing it again. but its the same size. It does state..

note     : Table does not support optimize, doing recreate + analyze instead
status   : OK 

我已经从Sonar的批量删除"选项中删除了几个旧项目，但是文件大小相同.

I've deleted a couple of old projects from Sonar's "Bulk Deletion" option, but the file is the same size.

任何人都可以给我一些有关下一步尝试的建议吗?

Can anyone give me some advice on what to try next?

谢谢 杰夫·波特

推荐答案

最后的解决方案很简单.

The solution in the end was simple.

从MySQL 5.5导出. (导出文件为114 GB)

Export from MySQL 5.5. (export file is 114 GB)

卸载MySQL 5.5(删除所有数据文件)

Uninstall MySQL 5.5 (remove all data files)

安装MySQL 5.6

Install MySQL 5.6

导入数据

从MySQL 5.6导出(导出文件现在为13 GB)

Export from MySQL 5.6 (export file is now 13 GB)

卸载MySQL 5.6(删除所有数据文件)

Uninstall MySQL 5.6 (remove all data files)

安装MySQL 5.6

Install MySQL 5.6

导入数据

这篇关于SonarQube:如何减小measures_data.ibd的大小?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！