Why is piwik so slow?


(cout12) #1

I dont know why but lately my piwik is so slow.

See WHY is piwik Slow?

So I decided to install the new version on a new database. Its still as slow.

I have like 60 websites and maybe 1000 visitors a day total.

What can I do to make it fast?


(cout12) #2

And also I often get this white page and error which makes my website unavailable for 1 min or so

Internal Server Error

The server encountered an internal error or misconfiguration and was unable to complete your request.

Please contact the server administrator, webmaster@xxxxxxx and inform them of the time the error occurred, and anything you might have done that may have caused the error.

More information about this error may be available in the server error log.

Additionally, a 500 Internal Server Error error was encountered while trying to use an ErrorDocument to handle the request.


(Matthieu Aubry) #3

users had issues with piwik on windows and htaccess… do you use windows? piwik should be very fast with 60 websites and only 1k pages a day…


(Hasenpf0te) #4

Sometimes I have this internal server error, too, when I try to get infos from a bigger range (e.g. all data from this year).


(Thomas Seifert) #5

well, then check your error logs or ask the server administrator.
I guess its some memory limit that’s getting hit.


(shulato) #6

i added more than 60 websites. the following day. my piwik page doesn’t load. i think it’s about the php execution time


(condomsmart) #7

Dude, did you read the msg above you? If you ever need help with any script, ALWAYS include the error msg’s from your server logs. Go to your cpanel or server admin & request a server logs & post here what the error msg are…

Its impossible for anyone to help you with statements like “my piwik page doesn’t load”…just not enough information


(cout12) #8

[quote=condomsmart @ May 30 2010, 11:07 AM]Dude, did you read the msg above you? If you ever need help with any script, ALWAYS include the error msg’s from your server logs. Go to your cpanel or server admin & request a server logs & post here what the error msg are…

Its impossible for anyone to help you with statements like “my piwik page doesn’t load”…just not enough information[/quote]
So I looked that the errors and here’s what they are

[Mon Jun 07 15:03:07 2010] [error] [client 216.110.xxx.xxx] File does not exist: /home/xxx/public_html/500.shtml
[Mon Jun 07 15:03:07 2010] [error] [client 216.110.xxx.xxx] File does not exist: /home/xxx/public_html/500.shtml
[Mon Jun 07 15:03:07 2010] [error] [client 216.110.xxx.xxx] File does not exist: /home/xxx/public_html/500.shtml
[Mon Jun 07 15:03:07 2010] [error] [client 216.110.xxx.xxx] File does not exist: /home/xxx/public_html/500.shtml
[Mon Jun 07 15:03:04 2010] [error] [client 216.110.xxx.xxx] File does not exist: /home/xxx/public_html/500.shtml

I also contacted my hosting and they said the script was taking too much ressources and that I should find a another script


(servertoday) #9

This internal server.
I felt slow.
Because I’m one of Thailand.


(fmaz008) #10

[quote=cout12 @ Jun 7 2010, 08:21 PM]So I looked that the errors and here’s what they are

[Mon Jun 07 15:03:07 2010] [error] [client 216.110.xxx.xxx] File does not exist: /home/xxx/public_html/500.shtml
[Mon Jun 07 15:03:07 2010] [error] [client 216.110.xxx.xxx] File does not exist: /home/xxx/public_html/500.shtml
[Mon Jun 07 15:03:07 2010] [error] [client 216.110.xxx.xxx] File does not exist: /home/xxx/public_html/500.shtml
[Mon Jun 07 15:03:07 2010] [error] [client 216.110.xxx.xxx] File does not exist: /home/xxx/public_html/500.shtml
[Mon Jun 07 15:03:04 2010] [error] [client 216.110.xxx.xxx] File does not exist: /home/xxx/public_html/500.shtml

I also contacted my hosting and they said the script was taking too much ressources and that I should find a another script[/quote]

This look like some sort of apache access log, but what about php error log ?
If something is taking to much ressource, you should have an error like:

Fatal error: Allowed memory size of 8388608 bytes exhausted (tried to allocate 16 bytes) in path/to/file.php on line 41

or

Fatal error: Maximum execution time of 30 seconds exceeded in path/to/file.php on line 593

(Matthieu Aubry) #11

See WHY is piwik Slow?