-
Problem report
-
Resolution: Fixed
-
Critical
-
5.0.30
-
None
-
Sprint 95 (Dec 2022), Sprint 96 (Jan 2023)
-
0.5
Let's take a quite loaded installation.
The proxy sends data (due to some problems) that is older than the current hour.
The server recalculates trends => these are heavy queries => busy history syncers, database performance problems
48010:20221222:050526.705 slow query: 44.008837 sec, "select distinct itemid from trends_uint where clock>=1671678000 and (itemid in XX) ...... 48010:20221222:050618.124 slow query: 51.351171 sec, "select distinct itemid from trends_uint where clock>=1671678000 and (itemid in XX) ..... 48010:20221222:050716.513 slow query: 58.368658 sec, "select distinct itemid from trends_uint where clock>=1671678000 and (itemid in XX}
