I would like to find out why piwik.js never seems to finish loading on my Joomla websites. See screenshot:
If a disable the script, my homepage usually loads below 1.5 seconds, but with the script enabled the loading time shown in Firebug always increases significantly.
In Piwik’s System Check I do see this error message:
LOAD DATA INFILE
Using LOAD DATA INFILE will greatly speed Piwik’s archiving process up. To make it available to Piwik, try updating your PHP & MySQL software and make sure your database user has the FILE privilege.
If your Piwik 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 #1: LOAD DATA INFILE : SQLSTATE: Invalid authorization specification: 1045 Access denied for user ‘xxxxxx’@‘localhost’ (using password: YES)
I don’t have access rights to change the privileges for the database user, so I will have to contact my webhoster for this. Just would like to know if this error could be the cause for Piwik to act as a speed brake. Nevertheless the statistics seem to work properly if the script is enabled. The Piwik database currently is approximately 100 mb.