All Pages Very Slow - New Install

tonyb · August 24, 2018, 7:19pm

There have been quite a few posts around this topic, but all seem to have very specific issues or very old.

My environment is:

New install - not much activity
version 3.5.1
Dedicated mySQL server, one database (this one) - no other tables or website accessing
php 7.2
Windows 2012, IIS
Behind corporate proxy/firewall

ALL page loads are extremely slow. Excruciatingly slow. As super or normal user (admin is slower).

Examples are warm starts and back of the napkin averages with cached assets.

tracker code: 800ms - 1.5s (LAN, that’s a big deal)

Dashboard: Initial document load, 6.3 seconds - every widget after that is another average of 6 seconds. This can take 2 minutes as an admin.

Settings: This is the worst - luckily we don;t have to come here after setting up - but setup is painful.

46s - ?module=CoreAdminHome&action=home (document)
1.4s - ?module=CoreHome&action=getSystemSummary (xhr)
59s - ?module=CoreHome&action=getDonateForm (xhr)
16s - ?module=Installation&action=getSystemCheck (xhr)
timeout/error - marketplace

I am looking through some of the articles on improving performance, but is this normal for a new install?

tonyb · August 24, 2018, 7:46pm

After going through GitHub, I found this issue https://github.com/matomo-org/matomo/issues/13241 and a few other like it related to the Marketplace. Sure enough, disabling the Marketplace plugin did improve speeds tremendously (if not completely).

What’s going on with the marketplace?

I’m going to do some testing to ensure that this is the issue. I am not sure why the marketplace plugin should affect every single page in the entire app - seems a little heavy handed. What would it add?

As a side note, the marketplace section never worked for me - so this make sense.

This is a great issue and a config setting that really addresses the issue:

github.com/matomo-org/matomo

New setting to disable all outgoing http requests from a Piwik server

opened 10:23AM - 28 Sep 14 UTC

closed 01:51PM - 01 Aug 18 UTC

mattab

Enhancement c: Security c: Privacy c: Platform

The goal of this issue is to let Piwik admins easily disable all outgoing HTTP r…equests which makes Piwik much faster to load on a server that cannot access the Internet. ## Edit: feature is available, [click to see our FAQ](https://matomo.org/faq/troubleshooting/faq_16646/) Imagine the use case of an Intranet where the Piwik server cannot connect to the Internet. Piwik is slow to load as it tries to make requests and requests take a while to timeout. There are many companies including Piwik installing Piwik in such environments. Another good use case is a user that wants to increase privacy of her Piwik server and she can just enable this setting which makes sure the Piwik server does not contact anyone on the Internet. currently it's possible to disable some of the requests via settings as follows: ``` [General] enable_marketplace = 0 enable_auto_update = 0 enable_update_communication = 0 ``` Proposed steps - New setting `enable_internet_features` or similar - this setting is the equivalent of setting other `enable_*` flags as above - when setting is set to 0 then disable the SEO widget (since it uses many web services) - check other uses of Http in piwik in case we missed any Ideally: disabling phoning home and other outgoing HTTP should be one setting away for Piwik users.

Lukas · August 25, 2018, 8:47am

Hi,

The issue is that the marketplace (and some other features) has to connect to the internet to work. But it seems like your server doesn’t have a direct connection to the internet, but every connection Matomo tries to make hangs for a while until it times out.

So you can either get internet to work on your server (maybe you have to configure the proxy or disable all internet features completely with the new option.

tonyb · October 12, 2018, 3:19pm

So, for an update. This internet settings did not help. I shut down internet access, using the following:

enable_trusted_host_check = 0
enable_internet_features = 0
enable_marketplace = 0
enable_auto_update = 0
enable_update_communication = 0

Tracker code runs from 500ms to 1s,
Using the portal is painful. Look at some of these times on the portal. I’;m just not sure if it’s a proxy issue, code, server or mySQL.