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

Improve performance of Visitor Log #10568

Merged
merged 2 commits into from Sep 27, 2016
Merged

Improve performance of Visitor Log #10568

merged 2 commits into from Sep 27, 2016

Conversation

tsteur
Copy link
Member

@tsteur tsteur commented Sep 26, 2016

fixes #10567

using same sort order for idsite and visit_last_action_time will allow mysql to use an index

@tsteur tsteur added not-in-changelog For issues or pull requests that should not be included in our release changelog on matomo.org. Needs Review PRs that need a code review labels Sep 26, 2016
@tsteur tsteur added this to the 3.0.0-b2 milestone Sep 26, 2016
@mattab
Copy link
Member

mattab commented Sep 27, 2016

💯

@mattab mattab merged commit 9a2ef80 into 3.x-dev Sep 27, 2016
@mattab mattab modified the milestones: 3.0.0-b1, 3.0.0-b2 Sep 27, 2016
@mattab mattab deleted the 10567 branch September 27, 2016 02:02
@tsteur
Copy link
Member Author

tsteur commented Oct 23, 2016

FYI: To improve this query further and make live queries faster this may help https://www.percona.com/blog/2016/10/20/mysql-8-0-descending-indexes-can-speedup-your-queries/ (index using desc )

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
Needs Review PRs that need a code review not-in-changelog For issues or pull requests that should not be included in our release changelog on matomo.org.
Projects
None yet
Development

Successfully merging this pull request may close these issues.

Improve performance of Visitor Log by tweaking the MySQL query
2 participants