slow SQL queries "INSERT INTO option
... ON DUPLICATE KEY UPDATE" in some rare cases
#12400
Labels
c: Performance
For when we could improve the performance / speed of Matomo.
not-in-changelog
For issues or pull requests that should not be included in our release changelog on matomo.org.
Creating this issue to document a rare occurence of slow yet often-executed queries, so far experience on the
option
table only. Ouroption
table usually contains a couple thousands records at most and is therefore very small. Queries on the table take only a few milliseconds. But in some cases they take like 1 min to run, and we couldn't explain it.Example 1: this query was running for 50 seconds+:
Example 2: this other query was running for many seconds as well:
If anyone has any idea why these queries could be so slow, please leave a comment!
The text was updated successfully, but these errors were encountered: