Piwik 1.7|Upgrade|Tracker Slow

After upgrade tracking url became very slow, changing the phps to older version fixed the problem.

most of select queries from tracker stay as sorting state on mysql

There is at icket with a quick fix for this issue: Performance regression in tracker for high traffic website · Issue #2951 · matomo-org/matomo · GitHub

I will try to release 1.7.1 quickly to deal with this issue.