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
