Hi Matomo team,
So a few things...
I'm having the following error in the system checks page:
Using LOAD DATA INFILE will greatly speed Matomo's archiving process up. To make it available to Matomo, try updating your PHP & MySQL software and make sure your database user has the FILE privilege. If your Matomo server tracks high traffic websites (eg. > 100,000 pages per month), we recommend to try fix this problem. Error: LOAD DATA INFILE failed... Error was: Try <a href='/1'>#1</a>: LOAD DATA INFILE : SQLSTATE[HY000]: General error: 13 Can't get stat of '/usr/share/matomo/tmp/assets/piwik_option-66adb5e071910f7e2ebfe96f50fdcc2a.csv' (Errcode: 2 - No such file or directory), Try <a href='/2'>#2</a>: LOAD DATA LOCAL INFILE : SQLSTATE: Syntax error or access violation: 1148 The used command is not allowed with this MySQL version
is there a way to avoid this warning/error being displayed on the system check page when Matomo and the DB aren't hosted on the same server?
CSVfile in a separate location, outside of Matomo existing folder. That would play nicely with
multi_server_environment=1, but that will also break other things (https://matomo.org/faq/new-to-piwik/faq_134/). I don't know why they decided to reuse this setting for disabling that function (https://github.com/matomo-org/matomo/pull/12710#issuecomment-382178870). Maybe @mattab can say something about this?
Should definitely take advantage of
multi_server_environment config here.