[quote=dali]I presume you already have a PHP accelerator (I use Xcache), that makes a huge difference.
Dali[/quote]
I use APC but yes PHP Accelerators make a huge amount of difference. We recently load tested our infrastructure and part of that included Piwik. I hadn’t set up the infrastructure so when the guy who was working on it was reporting poor Piwik performance, I asked if he’d set up PHP caching which he hadn’t. After getting that up and running everything was much better and we didn’t have to throw endless hardware at the servers.
[quote=matt]
Go to Settings > System check. If the line LOAD DATA INFILE is green then Piwik uses LOAD DATA INFILE.[/quote]
Yup it’s showing up as green on the Piwik server I’m working on
We have another Piwik infrastructure set up for a different product which we can’t get to show this. I’m not sure if this is because the DB and APP are on separate servers, or if it’s an issue with the particular version of PHP on that server, Ubuntu 12.04 LTS, because INFILE has been manually tested as working in the folder on the DB server.
Yup we’ve been through that and the only thing outstanding is upgrading PHP to a later version. If you say that it should work on Ubuntu 12.04LTS then I think it may be because we’re testing from an application server which is remotely connected to the DB on another server. We’re going to test locally on the DB server later.