Understanding changes and changesets

Added by Mandy S 3 months ago

Hi Everyone,

I am new to Redmine, but got it installed and working on my server.

I have been able to attach it to svn and git repos.

However, as I am not from the ruby world, I am trying to understand what is really happening when I am clicking the Repositories tab.

My SVN repo is huge ( about 1/2 mn revisions ) and is still in sync with main repo ( located elsewhere ).

Whenever I click the repo tab, the cpu usage shoots up to 90% and a ruby process is run.

I logged into the db and ran,
SELECT table_schema as `Database`, table_name AS `Table`, roun
d(((data_length + index_length) / 1024 / 1024), 2) `Size in MB` FROM information_schem
a.TABLES ORDER BY (data_length + index_length) DESC;

And found the following tables were being written to-

---------------------------------------------------------+------------+
Database Table Size in MB
---------------------------------------------------------+------------+
bitnami_redmine changes 84.05
bitnami_redmine changesets 70.02

Obviously they keep growing as sync is in progress.

I am assuming Redmine is reading svn info from file/disk and storing it in these tables ?

What's it storing ?

Is it going to store the entire 1/2 million revisions ?

I understand I can setup a cron and keep it updated from time to time.

But, I want to know what's going on and when mysql might become a bottleneck.

Could someone explain the internals ?
I can open the ruby code but as I am not from ruby world, it will take me time figuring out what it's trying to do -

Assuming its calling
/opt/bitnami/apps/redmine/htdocs/app/controllers/repositories_controller.rb or projects_controller.rb based on some routing... ?

Thanks.