Wrong Index choosen by MySQL #4740
Labels
c: Performance
For when we could improve the performance / speed of Matomo.
Task
Indicates an issue is neither a feature nor a bug and it's purely a "technical" change.
Milestone
On my MySQL installation
5.5.31-0+wheezy1-log (Debian)
The query regarding the custom var aggregation are using thw wrong index.
Here the Explain
https://gist.github.com/RoyBellingan/9170698
The choosen index is a three column index
idsite
config_id
visit_last_action_time
If a "hint" to use the index_idsite_datetime (two column), a very good improvement can be seen.
https://gist.github.com/anonymous/9170625
The text was updated successfully, but these errors were encountered: