Délais d'archivage des données


#1

Bonjour,

J’utilise la version 2.13.1 de Piwik sur lequel j’ai activé l’archivage des données en utilisant un Crontab.
Je suis à la recherche d’optimisation des temps de traitements, en analysant en détail la log d’archivage id par id, j’ai remarqué que la durée de traitement de réponses augmentait dans un ratio de plus de 10 entre Week et Month ce qui parait être anormalement élevé (Autour de 4 à 5 x cela serait plus logique).

[ul]
[li]Archived website id = 57, period = day, 0 segments, 0 visits in last last52 days, 0 visits today, Time elapsed: 0.105s
[/li][li]Archived website id = 57, period = week, 0 segments, 32516555 visits in last last260 weeks, 133483 visits this week, Time elapsed: 66.733s
[/li][li]Archived website id = 57, period = month, 0 segments, 32636426 visits in last last52 months, 615228 visits this month, Time elapsed: 910.636s
[/li][li]Archived website id = 57, period = year, 0 segments, 32636426 visits in last last7 years, 19920498 visits this year, Time elapsed: 12.241s
[/li][/ul]

Le traitement Week dure 66s , le Month 901s et le Year 12s.

Log complète de l’IdSite 57:

INFO CoreConsole[2015-10-14 00:01:17] START
INFO CoreConsole[2015-10-14 00:01:17] Starting Piwik reports archiving…
INFO CoreConsole[2015-10-14 00:01:17] Will pre-process for website id = 57, day period
INFO CoreConsole[2015-10-14 00:01:17] - pre-processing all visits
INFO CoreConsole[2015-10-14 00:05:14] Archived website id = 57, period = day, 0 segments, 0 visits in last last52 days, 0 visits today, Time elapsed: 0.105s
INFO CoreConsole[2015-10-14 00:05:14] Will pre-process for website id = 57, week period
INFO CoreConsole[2015-10-14 00:05:14] - pre-processing all visits
INFO CoreConsole[2015-10-14 00:06:21] Archived website id = 57, period = week, 0 segments, 32516555 visits in last last260 weeks, 133483 visits this week, Time elapsed: 66.733s
INFO CoreConsole[2015-10-14 00:06:21] Will pre-process for website id = 57, month period
INFO CoreConsole[2015-10-14 00:06:21] - pre-processing all visits
INFO CoreConsole[2015-10-14 00:21:32] Archived website id = 57, period = month, 0 segments, 32636426 visits in last last52 months, 615228 visits this month, Time elapsed: 910.636s
INFO CoreConsole[2015-10-14 00:21:32] Will pre-process for website id = 57, year period
INFO CoreConsole[2015-10-14 00:21:32] - pre-processing all visits
INFO CoreConsole[2015-10-14 00:21:44] Archived website id = 57, period = year, 0 segments, 32636426 visits in last last7 years, 19920498 visits this year, Time elapsed: 12.241s
INFO CoreConsole[2015-10-14 00:21:44] Will pre-process for website id = 57, range period
INFO CoreConsole[2015-10-14 00:21:44] - pre-processing all visits
INFO CoreConsole[2015-10-14 00:21:47] Archived website id = 57, period = range, 0 segments, 1856895 visits in last last30 ranges, 1856895 visits this range, Time elapsed: 2.743s
INFO CoreConsole[2015-10-14 00:21:47] Will pre-process for website id = 57, range period
INFO CoreConsole[2015-10-14 00:21:47] - pre-processing all visits
INFO CoreConsole[2015-10-14 00:21:49] Archived website id = 57, period = range, 0 segments, 147234 visits in last last7 ranges, 147234 visits this range, Time elapsed: 1.937s
INFO CoreConsole[2015-10-14 00:21:49] Will pre-process for website id = 57, range period
INFO CoreConsole[2015-10-14 00:21:49] - pre-processing all visits
INFO CoreConsole[2015-10-14 00:21:51] Archived website id = 57, period = range, 0 segments, 194525 visits in last previous7 ranges, 194525 visits this range, Time elapsed: 1.928s
INFO CoreConsole[2015-10-14 00:21:51] Archived website id = 57, 7 API requests, Time elapsed: 1233.519s [1/10 done]

Merci d’avance pour vos réponses