firts of all: thanks for this usefull tool!
We’re currently using PIWIK on several domains from 1000 to 450.000 PI’s a day.
Since 2 or 3 month it is not possible to view the reports of the higher traffic sites any more. PIWIK waits about 1 minute and then always shows up an error message like
SQLSTATE[HY000]: General error: 3 Error writing file '/tmp/MYdGVC6y' (Errcode: 28)
The complete database is about 1,5GB for three sites and contains about 27.000.000 entries.
Auto archiving is activated but fails every time with the same error message.
Archiving period = week for idsite = 2... <?xml version="1.0" encoding="utf-8" ?> <result> <error message="SQLSTATE[HY000]: General error: 3 Error writing file '/tmp/MYnqFsfh' (Errcode: 28)" /> </result>
Any idea how to tweak the speed or what this error message could mean?
Using PIWIK 1.1.1, PHP Version 5.2.17,