Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Demo Mysql server slow from time to time #5340

Closed
mattab opened this issue Jun 12, 2014 · 0 comments
Closed

Demo Mysql server slow from time to time #5340

mattab opened this issue Jun 12, 2014 · 0 comments
Labels
Bug For errors / faults / flaws / inconsistencies etc. worksforme The issue cannot be reproduced and things work as intended.
Milestone
Backlog (Help wan...

Comments

@mattab
Copy link
Member

mattab commented Jun 12, 2014

We got a problem on the demo that the server queues up queries from time to time.

The particular query posing problems is:


SELECT sub.* FROM ( SELECT log_visit.* FROM piwik_log_visit AS log_visit WHERE log_visit.idsite in ('7') ORDER BY idsite, visit_last_action_time DESC LIMIT 0, 1 ) AS sub GROUP BY sub.idvisit ORDER BY sub.visit_last_action_time DESC

I'm not sure if this is a software problem or hardware, or mysql server configuration, but this is a new issue.
@mattab mattab added this to the 2.5.0 - Piwik 2.5.0 milestone Jul 8, 2014
@mattab mattab closed this as completed Dec 1, 2014
@mattab mattab added the worksforme The issue cannot be reproduced and things work as intended. label Dec 1, 2014
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
Bug For errors / faults / flaws / inconsistencies etc. worksforme The issue cannot be reproduced and things work as intended.
Projects
None yet
Milestone
Backlog (Help wanted)
Development

No branches or pull requests
1 participant
@mattab