i had a error in the .js tracking code and tried to import from my log files. I imported just 1 day of logs (~5k hits).
I followed http://piwik.org/faq/log-analytics-tool/faq_17994/ and set the date exactly as in the faq.
Now he is trying to archiv every site with every period for years back in time
After one day work he aborts:
INFO CoreConsole[2015-01-27 16:23:31] Archived website id = 2, period = year, 2327969 visits in last last6 years, 6883 visits this year, Time elapsed: 95772.945s
ERROR CoreConsole[2015-01-27 16:23:31] SQLSTATE[HY000]: General error: 2006 MySQL server has gone away
How can is set this “working period” back to just a few days?
After weeks i managed to get one run complete. My SQL instance is stable now and i tried everything i can image.
Archiving took more than 7 days for one site and period year. It took one week again to achive the same site a few days later. It is impossible to archive it completly again. It took over two weeks for a full archiving
i fixed(?) it before. I dropped all piwik_archive tables and made a complete run on a freshly installed machine with the newest versions of all. it took a while but completed, and now processing is just taking about 8 minutes every hour.
Also the database shrink a lot: