Cloudron makes it easy to run web apps like WordPress, Nextcloud, GitLab on your server. Find out more or install now.


  • Categories
  • Recent
  • Tags
  • Popular
  • Bookmarks
Skins
  • Light
  • Cerulean
  • Cosmo
  • Flatly
  • Journal
  • Litera
  • Lumen
  • Lux
  • Materia
  • Minty
  • Morph
  • Pulse
  • Sandstone
  • Simplex
  • Sketchy
  • Spacelab
  • United
  • Yeti
  • Zephyr
  • Dark
  • Cyborg
  • Darkly
  • Quartz
  • Slate
  • Solar
  • Superhero
  • Vapor

  • Default (No Skin)
  • No Skin
Collapse

Cloudron Forum

Apps | Demo | Docs | Install

Matomo performance is slow, needs additional property to config.ini.php

Scheduled Pinned Locked Moved Solved Matomo
3 Posts 2 Posters 310 Views
    • Oldest to Newest
    • Newest to Oldest
    • Most Votes
Reply
  • Reply as topic
Log in to reply
This topic has been deleted. Only users with topic management privileges can see it.
  • d19dotcaD Offline
    d19dotcaD Offline
    d19dotca
    wrote on last edited by
    #1

    I haven't been in Matomo as much recently and found it to be incredibly slow the last few times I've been in it. I did some troubleshooting and noticed the time it took to load the "All Websites" page took ~30 seconds -- the same time it takes for the archiving cron to run.

    This needed to be added to the config.ini.php file: enable_browser_archiving_triggering = 0

    I thought that was in the Matomo config before, so I'm not sure when it went missing or maybe it always was... but as soon as I added in this property to the config.ini, it immediately resolved the loading time of the All Websites page.

    The reference for this step came from here: https://matomo.org/faq/new-to-piwik/faq_137/ (and a related page is here: https://matomo.org/faq/on-premise/how-to-configure-matomo-for-speed/)

    I also noticed (but didn't try it yet) from that page their recommendation to add this too, but not sure how important this one would be: enable_sql_optimize_queries = 0

    Also, just my two cents but the cron runs every 15 minutes... seems a little overkill IMO and could be every 30 or 60 minutes instead. That's maybe another topic though all together. 👼

    My ask... could we consider adding in the enable_browser_archiving_triggering = 0 to the config.ini.php file to improve performance since the cron is already used to generate the reports?

    --
    Dustin Dauncey
    www.d19.ca

    nebulonN 1 Reply Last reply
    3
  • nebulonN Offline
    nebulonN Offline
    nebulon Staff
    replied to d19dotca on last edited by
    #2

    @d19dotca thanks for bringing this up. I also think that we can easily run the background tasks less frequently for such an anlytics tool, so for a start I have reduced it to half the time now every 30min.

    Regarding the enable_browser_archiving_triggering we usually lean towards the upstream defaults instead of optimizing for a specific use-case (in your case speed optimization) I don't know the details for this specific one, but mostly the developers have their reasons for why defaults are that way. I am glad though they have written docs on how to shape the app behavior for this use-case specifically.

    d19dotcaD 1 Reply Last reply
    1
  • nebulonN nebulon marked this topic as a question on
  • d19dotcaD Offline
    d19dotcaD Offline
    d19dotca
    replied to nebulon on last edited by
    #3

    @nebulon That's fair. I guess I assumed they were sort of paired together as my understanding for disabling the auto-archiving in the web part was specifically for speed gains which you guys had already done by setting up crons instead for archiving reports, so the KB I linked to seemed relevant to that assumption that we wanted Matomo to be configured for speed instead of convenience. But I can appreciate that you want to keep the amount of customizations to be as slim as possible.

    --
    Dustin Dauncey
    www.d19.ca

    1 Reply Last reply
    0
  • girishG girish has marked this topic as solved on

  • Login

  • Don't have an account? Register

  • Login or register to search.
  • First post
    Last post
0
  • Categories
  • Recent
  • Tags
  • Popular
  • Bookmarks
  • Login

  • Don't have an account? Register

  • Login or register to search.