----- Original Message ----- > From: "Kamil Paral" <kpa...@redhat.com> > To: "Fedora QA Development" <qa-devel@lists.fedoraproject.org> > Sent: Friday, November 25, 2016 2:58:03 PM > Subject: Re: ResultsDB 2.0 - DB migration on DEV > > > > > So, I have performed the migration on DEV - there were some problems with it > going out of memory, so I had to tweak it a bit (please have a look at > D1059, that is what I ended up using by hot-fixing on DEV). > > There still is a slight problem, though - the migration of DEV took about 12 > hours total, which is a bit unreasonable. Most of the time was spent in > `alembic/versions/dbfab576c81_change_schema_to_v2_0_step_2.py` lines 84-93 > in D1059. The code takes about 5 seconds to change 1k results. That would > mean at least 15 hours of downtime on PROD, and that, I think is unreal... > > And since I don't know how to make it faster (tips are most welcomed), I > suggest that we archive most of the data in STG/PROD before we go forward > with the migration. I'd make a complete backup, and deleted all but the data > from the last 3 months (or any other reasonable time span). > > If we can't make it faster, I think this is reasonable. >
+1 _______________________________________________ qa-devel mailing list -- qa-devel@lists.fedoraproject.org To unsubscribe send an email to qa-devel-le...@lists.fedoraproject.org