Details
-
Problem report
-
Status: Closed
-
Critical
-
Resolution: Fixed
-
5.0.30
-
None
-
Team A
-
Sprint 95 (Dec 2022), Sprint 96 (Jan 2023)
-
0.5
Description
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}
Attachments
Issue Links
- caused by
-
ZBX-7006 deleted/disabled item data never removed from trend cache
-
- Closed
-