i’m running a site with 300,000 hits per day on a remote server. Piwik is crashing mysql and apache on windows (different machine)… mysql just dies because too many connections are still open even after piwik finished to register the log, apache because of no more memory as mysql takes all of it with too many processes…
i’ve on the same piwik i’ve another site (remote on another server) that registers only 15/20 hits per day and never gave me troubles.
I just want to know (if possible) if there is any report of piwik working under such high stress or not. as i’m thinking to get a dedicated machine just for piwik running on linux where apache+php+mysql are much more stable.