I have tried using piwik this morning for about 3 hours. During that time, the webserver, which was specially set up on a dedicated server with the piwik mysql server (no more database access) recorded more than 400k hits.
Server hardware is a quad core xeon 5420, 2.5Ghz, 4GB RAM and a 4 disk RAID 10 SAS 15k rpm.
OS is Ubuntu server 9.04 and mysql is 5.0.77 using percona and google patches. I was using Cherokee web server 0.99.15 but i experienced the same situation last week using apache 2.2.
My worry is that after that 3 hours of running, server load was near 4.80 and had been growing slowly since i set up the server.
Are there any optimizations that i may have missed that could lower the server load? Anyone with experience in using piwik with that number of hits?
Any help will be appreciated.