plugin-SiteMigration icon indicating copy to clipboard operation
plugin-SiteMigration copied to clipboard

Published 20 hours ago • verified publisher icon PiwikPRO

Very slow migration

Open voko opened this issue 9 years ago • 5 comments

I'm migrating a site with log data and archives from a local instance to a WAN/internet host. For e very low traffic site (< 3 k visits over two years), it takes more than 18 hours, which seems a tad too slow.

Any suggestions on where I should look or tune the mysql or other settings?

Config: Source: LAMP with piwik 2.14.3 on centos 6.5 Target: bitnami-piwik 2.14.3 on ubuntu 14.04. LTS

voko avatar Sep 01 '15 11:09 voko

I have problems with migrations and some others shell related tasks when xdebug is enabled. Maybe this can help.

Undergrounder avatar Sep 29 '15 08:09 Undergrounder

Even I have similar issue, what could be the solution pls help.

shivateja-madipalli avatar Oct 25 '15 07:10 shivateja-madipalli

Migrating a site with ~600.000 visits and ~3.000.000 actions runs for 23 hours now and doesn't seem to be finished any time soon. Network throughput between the hosts is more than 50MB/sec, data is coming in at ~ 100k/sec. This doesn't look right.

datenimperator avatar Sep 08 '16 09:09 datenimperator

Be careful with the migration. We lost many data because of this bug (https://github.com/PiwikPRO/plugin-SiteMigration/pull/22).

Undergrounder avatar Sep 08 '16 11:09 Undergrounder

Too late. I did not assume any critical flaws here, given that it's from Piwik Pro. We do have a ~800MB SQL.gz backup of our Piwik database but migration doesn't seem to work nonetheless.

datenimperator avatar Sep 08 '16 12:09 datenimperator