All sites tab Dashboard very slow loading


#1

Hi all,

I run the latest update of Piwik,
But from the begining of the new Piwik 2.0 the All sites tab with realtime visitors,
loads very very slow. some times its over 4 minutes to load the today overview.

I have 28 websites on mij Piwik dashboard so that must not be the problem.


#2

Try deleting your temp folder contents and after that if still slow try deleting and readding each widget back again to the dashboard.


(Matthieu Aubry) #3

Setup this: How to Set up Auto-Archiving of Your Reports - Analytics Platform - Matomo


(hightechguy) #4

Hi,

Same thing here - “All Websites” screen loads about 4(!) minutes. I’ve made several settings changes to speed things up (see below)- no luck.
Can anyone help? Piwik cannot be this slow, it must be something wrong in configuration!

Here is my configuration information:

Websites: ~400
Total visits/month: ~8k
Total pageviews/month: ~17k

Piwik configuration:

Version - latest (2.1.0)
“Real time” - off
Regularly delete old visitor logs from the database (older then 6 month): yes
Third party plugins activated: 0

Hosting data:

Hosting type: shared
Memory: no info
PHP Version 5.4.24 with memory_limit=512 MB
PHP Cache (APC) usage: no info
Web Server: Apache 2.2.26
Load balancing: no
SSD drive: no

mySQL configuration

Total DB size: ~160 MB
Mysql tables type: MyISAM (not InnoDB )
MySQl innodb_buffer_pool_size param: 1,073,741,824
innodb_flush_log_at_trx_commit=0 (not 2)


(Matthieu Aubry) #5

please use latest beta version,
Then setup: How to Set up Auto-Archiving of Your Reports - Analytics Platform - Matomo


(hightechguy) #6

Hi, Matt

I’ve installed the latest 2.2.0 version. 400 site “All sites” report loads after about two minutes, weekly & more does not show up at all.
I’ve made all the optimization I could find on this forum - no luck

Jacob.


(Matthieu Aubry) #7

To make it load fast, follow instructions to setup the cron in: How to Set up Auto-Archiving of Your Reports - Analytics Platform - Matomo


(hightechguy) #8

Hi, Matt

Cron works and creates the expected output(see below), but weekly reports fail anyway.
Piwik made a record in the error_log file : “Maximum execution time of 30 seconds exceeded in /home1/cleopat1/public_html/piwik/core/DataTable/Manager.php on line 104”

Any ideas?

Jacob.

INFO CoreConsole[2014-05-05 03:30:09] [69388] ---------------------------
INFO CoreConsole[2014-05-05 03:30:09] [69388] INIT
INFO CoreConsole[2014-05-05 03:30:09] [69388] Piwik is installed at: http://piwik.mysite.com/index.php
INFO CoreConsole[2014-05-05 03:30:09] [69388] Running Piwik 2.2.0 as Super User
INFO CoreConsole[2014-05-05 03:30:10] [69388] ---------------------------
INFO CoreConsole[2014-05-05 03:30:10] [69388] NOTES
INFO CoreConsole[2014-05-05 03:30:10] [69388] - If you execute this script at least once per hour (or more often) in a crontab, you may disable ‘Browser trigger archiving’ in Piwik UI > Settings > General Settings.
INFO CoreConsole[2014-05-05 03:30:10] [69388] See the doc at: How to Set up Auto-Archiving of Your Reports - Analytics Platform - Matomo
INFO CoreConsole[2014-05-05 03:30:10] [69388] - Reports for today will be processed at most every 20 seconds. You can change this value in Piwik UI > Settings > General Settings.
INFO CoreConsole[2014-05-05 03:30:10] [69388] - Reports for the current week/month/year will be refreshed at most every 3600 seconds.
INFO CoreConsole[2014-05-05 03:30:11] [69388] - Will process 362 websites with new visits since 7 days 0 hours , IDs: 1, 3, 4, 5, 6, 7, 8, 9, 10, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 26, 27, 28, 29, 30, 31, 33, 34, 35, 36, 37, 38, 39, 41, 42, 43, 45, 47, 48, 49, 51, 52, 53, 54, 55, 56, 58, 59, 61, 62, 64, 65, 68, 69, 70, 71, 72, 74, 75, 76, 77, 78, 79, 80, 81, 82, 85, 86, 87, 88, 89, 91, 92, 93, 94, 95, 96, 97, 98, 99, 100, 101, 102, 103, 104, 105, 106, 107, 108, 109, 110, 111, 112, 113, 114, 115, 116, 117, 118, 119, 120, 121, 125, 126, 127, 128, 130, 131, 132, 133, 134, 135, 136, 139, 140, 141, 142, 143, 145, 147, 148, 149, 150, 151, 152, 154, 155, 156, 157, 158, 159, 160, 161, 162, 164, 165, 166, 167, 168, 169, 170, 172, 175, 176, 177, 178, 179, 180, 181, 182, 183, 184, 185, 187, 189, 190, 191, 193, 194, 195, 196, 197, 198, 199, 200, 201, 202, 203, 204, 205, 206, 207, 208, 209, 210, 211, 213, 214, 215, 216, 217, 218, 219, 220, 221, 222, 223, 224, 225, 226, 227, 228, 229, 230, 231, 232, 233, 234, 236, 237, 238, 239, 240, 241, 242, 243, 244, 245, 246, 247, 248, 249, 250, 251, 252, 253, 254, 255, 256, 258, 259, 261, 262, 263, 264, 266, 267, 268, 269, 270, 273, 274, 276, 277, 278, 279, 280, 281, 283, 284, 285, 286, 287, 288, 289, 290, 292, 293, 294, 295, 297, 298, 299, 301, 302, 304, 305, 306, 307, 308, 311, 312, 313, 314, 315, 316, 317, 319, 320, 321, 323, 324, 325, 326, 327, 328, 329, 330, 331, 332, 333, 335, 336, 337, 338, 340, 341, 342, 343, 344, 345, 346, 347, 348, 349, 350, 352, 354, 355, 356, 357, 358, 359, 360, 361, 362, 364, 365, 366, 367, 368, 369, 370, 371, 372, 373, 374, 375, 376, 378, 379, 380, 381, 382, 383, 384, 386, 388, 389, 390, 391, 392, 393, 394, 397, 398, 399, 400, 401, 402, 403, 404, 406, 407, 409, 410, 411, 412, 413, 414, 415, 416, 418, 419, 420, 421, 422, 423, 424, 425
INFO CoreConsole[2014-05-05 03:30:11] [69388] - Will process 62 other websites because the last time they were archived was on a different day (in the website’s timezone) , IDs: 11, 25, 32, 40, 44, 46, 50, 57, 60, 63, 66, 67, 73, 83, 84, 90, 122, 123, 124, 129, 137, 138, 144, 146, 153, 163, 171, 173, 174, 186, 188, 192, 212, 235, 257, 260, 265, 271, 272, 275, 282, 291, 296, 300, 303, 309, 310, 318, 322, 334, 339, 351, 353, 363, 377, 385, 387, 395, 396, 405, 408, 417
INFO CoreConsole[2014-05-05 03:30:11] [69388] ---------------------------
INFO CoreConsole[2014-05-05 03:30:11] [69388] START
INFO CoreConsole[2014-05-05 03:30:11] [69388] Starting Piwik reports archiving…
INFO CoreConsole[2014-05-05 03:30:30] [69388] Archived website id = 1, period = day, 2515 visits in last 52 days, 2 visits today, Time elapsed: 18.831s


(Matthieu Aubry) #9

See faq Piwik reports this error and doesn't continue: "Fatal error: Maximum execution time of 30 seconds exceeded in ..." - Analytics Platform - Matomo


(hightechguy) #10

Bingo!

As it figured out, it was PHP version issue with the hosting, cron run with old PHP 5.2 and as a result archiving was not done properly.
Now runs just fine and I can get monthly reports during 15-20sec.

Thanks a lot, Matt !

P.S. Unrelated, but still as a general feedback - All Websites dashboard revenue column sorting is not correct - see 2014-05-06_0055


(Matthieu Aubry) #11

All Websites dashboard revenue column sorting is not correct - see 2014-05-06_0055
This may be fixed in latest RC from: Index of /
maybe you could try it