[Piwik-hackers] Database-Bottlenecks

[Robert Klikics]

Hello,

I've just installed Piwik and added it to one high-traffic-site. It's 
very cool :) But there's a problem:

Piwik runs on a dedicated linuxbox with Quad-Opteron (2,8 GHz) and 16 
GBytes of RAM (Apache2, PHP5.2 and MySql 5.0: keybuffer is set to 8 GBytes).

It seems the DB can't handle the number of querys coming in from Piwik 
(~200 querys per sec) for a long time. After 2 hours running there are 
hundreds of thousends entrys in the DB and the load gets higher and 
higher. Atm there is a load average of 5.xx on the box and counting.

"always_archive_data" is set to false, a cronjob with archive.sh has 
been added. I thougt the piwik_log_* tables will be flushed if the cron 
runs, but nothing happened.

I think in a few hours or days I'll not be able to user Piwik any longer 
because of the high database load.

Any suggestions except more/better hardware or MySql-cluster? :)

Regards,
Rob