Understanding changes and changesets
Added by Mandy S over 4 years 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.