search

PiwikPRO / plugin-SiteMigration

Migrate websites and website data between two Piwik installations
17 stars 3 forks source link

Very slow migration #15

Open voko opened 8 years ago

voko commented 8 years ago

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

Undergrounder commented 8 years ago

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

shivateja-madipalli commented 8 years ago

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

datenimperator commented 7 years ago

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.

Undergrounder commented 7 years ago

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

datenimperator commented 7 years ago

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.