Piwik archive.php und Login extrem langsam


#1

Seit dem Update auf Version 2 (und damit verbundenem Umzug von einem VPS auf einen Root-Server), läuft sowohl der Archivierungs-Prozess als auch der Login extrem langsam.

Eingesetzt wird ein Root-Server mit 32 GB RAM, i7-4770 Quad-Core Haswell und einem RAID1 2 x 2 TB. Software ist Apache, php-fpm und MySQL-Server 5.5 unter Debian 7.4.

Hier mal ein Logfile von Archivierungs-Vorgang:


INFO [2014-03-12 09:05:01] [1c46d] ---------------------------
INFO [2014-03-12 09:05:01] [1c46d] INIT
INFO [2014-03-12 09:05:01] [1c46d] Querying Piwik API at: http://[GELÖSCHT]/index.php
INFO [2014-03-12 09:05:01] [1c46d] Running Piwik 2.1.0 as Super User: [GELÖSCHT]
INFO [2014-03-12 09:05:01] [1c46d] ---------------------------
INFO [2014-03-12 09:05:01] [1c46d] NOTES
INFO [2014-03-12 09:05:01] [1c46d] - Reports for today will be processed at most every 3600 seconds. You can change this value in Piwik UI > Settings > General Settings.
INFO [2014-03-12 09:05:01] [1c46d] - Reports for the current week/month/year will be refreshed at most every 3600 seconds.
INFO [2014-03-12 09:05:01] [1c46d] - Archiving was last executed without error 59 min 59s ago
INFO [2014-03-12 09:05:01] [1c46d] - Will process 5 websites with new visits since 59 min 59s , IDs: 3, 10, 11, 18, 20
INFO [2014-03-12 09:05:01] [1c46d] ---------------------------
INFO [2014-03-12 09:05:01] [1c46d] START
INFO [2014-03-12 09:05:12] [1c46d] Archived website id = 3, period = day, Time elapsed: 10.802s
INFO [2014-03-12 09:05:32] [1c46d] Archived website id = 3, period = week, 171 visits, Time elapsed: 19.604s
INFO [2014-03-12 09:05:51] [1c46d] Archived website id = 3, period = month, 1358 visits, Time elapsed: 19.751s
INFO [2014-03-12 09:07:38] [1c46d] Archived website id = 3, period = year, 7071 visits, Time elapsed: 106.409s
INFO [2014-03-12 09:07:38] [1c46d] Archived website id = 3, today = 15 visits, 4 API requests, Time elapsed: 156.567s [1/5 done]
INFO [2014-03-12 09:07:43] [1c46d] Archived website id = 10, period = day, Time elapsed: 5.338s
INFO [2014-03-12 09:07:51] [1c46d] Archived website id = 10, period = week, 46 visits, Time elapsed: 7.551s
INFO [2014-03-12 09:07:59] [1c46d] Archived website id = 10, period = month, 317 visits, Time elapsed: 7.932s
INFO [2014-03-12 09:08:12] [1c46d] Archived website id = 10, period = year, 1526 visits, Time elapsed: 13.418s
INFO [2014-03-12 09:08:12] [1c46d] Archived website id = 10, today = 4 visits, 4 API requests, Time elapsed: 34.240s [2/5 done]
INFO [2014-03-12 09:08:17] [1c46d] Archived website id = 11, period = day, Time elapsed: 5.256s
INFO [2014-03-12 09:08:25] [1c46d] Archived website id = 11, period = week, 34 visits, Time elapsed: 7.308s
INFO [2014-03-12 09:08:33] [1c46d] Archived website id = 11, period = month, 298 visits, Time elapsed: 8.591s
INFO [2014-03-12 09:08:44] [1c46d] Archived website id = 11, period = year, 1441 visits, Time elapsed: 10.992s
INFO [2014-03-12 09:08:44] [1c46d] Archived website id = 11, today = 2 visits, 4 API requests, Time elapsed: 32.148s [3/5 done]
INFO [2014-03-12 09:08:56] [1c46d] Archived website id = 18, period = day, Time elapsed: 11.882s
INFO [2014-03-12 09:09:25] [1c46d] Archived website id = 18, period = week, 3100 visits, Time elapsed: 28.601s
INFO [2014-03-12 09:10:10] [1c46d] Archived website id = 18, period = month, 23972 visits, Time elapsed: 44.850s
INFO [2014-03-12 09:12:51] [1c46d] Archived website id = 18, period = year, 117420 visits, Time elapsed: 161.233s
INFO [2014-03-12 09:12:51] [1c46d] Archived website id = 18, today = 101 visits, 4 API requests, Time elapsed: 246.568s [4/5 done]
INFO [2014-03-12 09:13:09] [1c46d] Archived website id = 20, period = day, Time elapsed: 17.814s
INFO [2014-03-12 09:14:22] [1c46d] Archived website id = 20, period = week, 2661 visits, Time elapsed: 73.676s
INFO [2014-03-12 09:15:50] [1c46d] Archived website id = 20, period = month, 2661 visits, Time elapsed: 87.960s
INFO [2014-03-12 09:17:16] [1c46d] Archived website id = 20, period = year, 2661 visits, Time elapsed: 85.992s
INFO [2014-03-12 09:17:16] [1c46d] Archived website id = 20, today = 182 visits, 4 API requests, Time elapsed: 265.443s [5/5 done]
INFO [2014-03-12 09:17:16] [1c46d] Starting Piwik reports archiving...
INFO [2014-03-12 09:17:16] [1c46d] Done archiving!
INFO [2014-03-12 09:17:16] [1c46d] ---------------------------
INFO [2014-03-12 09:17:16] [1c46d] SUMMARY
INFO [2014-03-12 09:17:16] [1c46d] Total daily visits archived: 304
INFO [2014-03-12 09:17:16] [1c46d] Archived today's reports for 5 websites
INFO [2014-03-12 09:17:16] [1c46d] Archived week/month/year for 5 websites
INFO [2014-03-12 09:17:16] [1c46d] Skipped 12 websites: no new visit since the last script execution
INFO [2014-03-12 09:17:16] [1c46d] Skipped 0 websites day archiving: existing daily reports are less than 3600 seconds old
INFO [2014-03-12 09:17:16] [1c46d] Skipped 0 websites week/month/year archiving: existing periods reports are less than 3600 seconds old
INFO [2014-03-12 09:17:16] [1c46d] Total API requests: 20
INFO [2014-03-12 09:17:16] [1c46d] done: 5/5 100%, 304 v, 5 wtoday, 5 wperiods, 20 req, 734968 ms, no error
INFO [2014-03-12 09:17:16] [1c46d] Time elapsed: 734.968s
INFO [2014-03-12 09:17:16] [1c46d] ---------------------------
INFO [2014-03-12 09:17:16] [1c46d] SCHEDULED TASKS
INFO [2014-03-12 09:17:16] [1c46d] Starting Scheduled tasks...
INFO [2014-03-12 09:17:16] [1c46d]  No task to run
INFO [2014-03-12 09:17:16] [1c46d] done
INFO [2014-03-12 09:17:16] [1c46d] ---------------------------

Archiviert wird alls 60 Minuten per Cronjob. Die Datenbank ist in Ordnung.

Die benötigte Zeit von knapp 735 Sekunden stellt eine Verzehnfachung(!) gegenüber des Setups des VPS dar. Vorher lief der Prozess in max. 80 Sekunden durch. Eigentlich sollte mit dem aktuellen Setup alles rasend schnell sein. Außerdem braucht der Login bis zu einer Minute. Es scheint, als würden die aktuellen Berichte erst dann bearbeitet. Einmal eingeloggt, ist bis auf die Widgets alles recht zügig, wenn auch nicht annähernd wie die Hardware es erwarten ließe.

Hat irgendwer eine Idee, wie ich Piwik auf eine benutzbare Geschwindigkeit bekomme?


#2

Hallo… Schaue mal in den Einstellungen / Systemprüfung ob dort im Punkt Datenbankfähigkeit ein Hinweis auf
LOAD DATA INFILE erscheint.
Gruß