[rt-users] rt-validator questions!

[Sternberger, Sven]

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 at 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 at 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