[Piwik-hackers] Piwik very slow for whatever reasons

[Matthieu Aubry]

Ok, download piwik 0.1.4 and try in the command line:
/usr/bin/php index.php -- 
"module=API&method=VisitsSummary.getVisits&idSite=1&period=year&date=today&format=original"

If you still have the 30s error, then increase the max_execution_time in 
your php.ini


Pelle Boese wrote:
> 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
>>
>>
>>     
>
>
>   
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.piwik.org/pipermail/piwik-hackers/attachments/20080407/3dffa58f/attachment.htm