Good morning –
I am in the process of moving a very large site with thousands of tracked sites to a new server. I exported all tables except the archives, and uploaded the .sql file to the new server. I manually executed the cron script for the first time, and after 8 hours processing, the system has only rebuilt archives for 76/10,000+ sites. Are there any suggestions on how to speed this up? The server has 16GB RAM, I used MySQL Tuner, and raised the PHP memory limit trying to optimize the operation.
If we have to let it continue to run for days/weeks, will statistics be gathered while archiving is performed? Keeping our old data is important to us.