Hello!
When I open our Piwik 1.5.1 admin interface in my browser, then Zabbix monitoring software we use here sends e-mail and SMS message to me and the rest admins… It’s because of noticed problem with MySQL table locks. Please look at the peak at attached graph.
I grepped an access log of Apache server on our Piwik server and it seems that the browser sends 121 requests per 1 minute. When Piwik panel is open, then the browser sends “only” 48 requests:
# grep '09/Aug/2011:09:39' access.log |grep ^my_IP_addr |wc -l
0
# grep '09/Aug/2011:09:40' access.log |grep ^my_IP_addr |wc -l
121
# grep '09/Aug/2011:09:41' access.log |grep ^my_IP_addr |wc -l
48
# grep '09/Aug/2011:09:42' access.log |grep ^my_IP_addr |wc -l
48
# grep '09/Aug/2011:09:43' access.log |grep ^my_IP_addr |wc -l
48
Is it a way to fix it?