Performance Issues

Support & Bugs
1

We have tried using piwik for meassurement of our website, we have about 3000 simultaneous clients to work on our system. We experienced heavy load on our server using piwik (it almost crashed). the perfomance tipps on FAQ Archive - Analytics Platform - Matomo section did not really help with the issues. Main thing was more then 400 connections on mysql and apache was on limit with 400 max clients,too.

Would be great, if anyone has any idea about optimizing. If you need further info, ask for those.

We use this hardware setup:

INTEL Core 2 Duo
4GB Ram
Apache2.0
APC
Memcached
PHP5.2
MySql 5.1

2

We fixed some of the issues we recognized on our high load with just one simple index operation on the piwik database:

ALTER TABLE `log_action` DROP INDEX `index_type_name`
ALTER TABLE `log_action` ADD INDEX `name` (`name`);
3

Thanks. I’ve added your suggestion to ticket 708.

http://dev.piwik.org/trac/ticket/708