[Piwik-hackers] Piwik very slow for whatever reasons

[Pelle Boese]

Yeah, I already set the indexes from bug #150, that helped a bit, but
the massive load comes through apache, not mysql, so it must be
something else... but i really have no clue

2008/4/7, Matthieu Aubry <matthieu.aubry at gmail.com>:
> Hi
> Have you installed piwik from a fresh 0.1.3 or did you update from a old
> version?
>
> Please check that your mysql table log_link_visit_action has an index
> index_idvisit
> Also the log_visit table should have index_visit_server_date index.
>
> If it doesn't, execute:
> CREATE INDEX index_idvisit ON log_link_visit_action (idvisit);
> CREATE INDEX index_idaction ON log_action (idaction);
> CREATE INDEX index_idsite ON log_visit (idsite);
>
> CREATE INDEX index_visit_server_date ON log_visit (visit_server_date);
> (see http://dev.piwik.org/trac/ticket/150)
>
>
>
> On Mon, Apr 7, 2008 at 4:17 PM, Pelle Boese <pelle at concept08.com> wrote:
>
> >
> > Cheers,
> >
> > I'm using piwik for a bit now and for sites with more than like 5.000
> > unique visitors per day it's almost impossible to get the statistics
> > as it takes too much time to load them. I'm running the latest beta
> > (0.1.3) on a quite bored quad xeon with 4gb ram and a scsi raid, so
> > the hardware is definitely not the bottleneck. As soon as I open the
> > piwik dashboard for this month (stats for one day work), my 'top'
> > looks like that:
> >
> > 17713 www-data  25   0  214m  72m 9572 R  100  1.9   1:00.00 apache2
> > 1343 mysql     15   0  128m  52m 5868 S    2  1.4 420:21.34 mysqld
> >
> > after 30 seconds I get one of the following errors for all widgets
> > while the flash loads forever:
> >
> > Fatal error: Maximum execution time of 30 seconds exceeded in
> > /var/www/stats/piwik/modules/DataTable.php on line 861
> >
> > Fatal error: Maximum execution time of 30 seconds exceeded in
> > /var/www/stats/piwik/modules/DataTable/Row.php on line
> 153
> >
> > As the apache2 child uses 100% CPU, it's probably not a database
> > problem, but something else going completely wrong in the code.
> >
> > Any suggestions on that problem?
> >
> > I'm btw running the following setup:
> >
> > Debian Sarge
> > Apache 2.2.3 with mpm_prefork
> > PHP 5.2.0 with suhosin
> > MySQL 5.0.32
> >
> > Cheers, Pelle.
> >
> > --
> > Pelle Boese
> > Online Marketing
> >
> > Concept08 GmbH
> > Grüngürtelstrasse 77
> > 50996 Köln
> >
> > Tel:      0172 373.94.56
> > E-Mail: pelle at concept08.com
> > Web:   http://www.concept08.com/
> > _______________________________________________
> > Piwik-hackers mailing list
> > Piwik-hackers at piwik.org
> >
> http://lists.piwik.org/cgi-bin/mailman/listinfo/piwik-hackers
> >
>
>
> _______________________________________________
>  Piwik-hackers mailing list
>  Piwik-hackers at piwik.org
> http://lists.piwik.org/cgi-bin/mailman/listinfo/piwik-hackers
>
>


-- 
Pelle Boese
Online Marketing

Concept08 GmbH
Grüngürtelstrasse 77
50996 Köln

Tel:      0172 373.94.56
E-Mail: pelle at concept08.com
Web:   http://www.concept08.com/