hello!
I’m in the process to migrate from 3.8.7. to 4.2.9
and I change the Server at the same time. Till now
the tests worked like a charm
Now I want to test if we could clean up the data
in this procedure.
We want to use
- shrink_cgm_table.pl
- shrink_transactions_table.pl
- rt-validator
My first question is could I start these tools on my old 3.8.7 instance,
before I migrate or should I run them on the new host.
My second question I started on my RT4.2.9 test instance (filled with
my 30GB production db) the rt-validator and first It proceed quickly
but now it slows down (in progress, runtime now 20h)
In mysql-slow.log I see
…
Time: 141204 11:52:51
User@Host: rt_user[rt_user] @ localhost []
Query_time: 642.958995 Lock_time: 0.000079 Rows_sent: 0 Rows_examined: 2573918
SET timestamp=1417690371;
UPDATE Attachments SET Creator = ‘9976’ WHERE Creator = ‘9977’;
Time: 141204 12:02:17
User@Host: rt_user[rt_user] @ localhost []
Query_time: 565.100590 Lock_time: 0.000074 Rows_sent: 0 Rows_examined: 2573918
SET timestamp=1417690937;
UPDATE Attachments SET Creator = ‘6214’ WHERE Creator = ‘6215’;
…
My VM has only has 16GB and innodb_buffer_pool_size is only 3GB.
- Is it harmful to run rt-validator while we are in production?
- Could I speedup the process (make an index on Creator?)
best regards!
Sven