Ad Widget

Collapse

Delay lasted data zabbix 6 mysql8

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • raul.recinosm
    Junior Member
    • Jun 2018
    • 8

    #1

    Delay lasted data zabbix 6 mysql8

    ​ Hi, we have some issue after clean install for zabbix 6 LTS on Ubuntu 22.04

    We are experience delay data about 5-20 minutes, we restart zabbix-server process but this take a while for continue whit same behavior, has any one experience same issue?

    OS: Ubuntu 22.03
    Zabbix 6
    Mysql 8.0.3, database are partition
    vcpu: 8
    Ram: 16Gb
    Data base is running on same server

    zabbix server config:
    StartPollers=50
    StartPreprocessors=10
    StartPollersUnreachable=20
    StartPingers=20​
    StartEscalators=2
    CacheSize=10G
    CacheUpdateFrequency=300
    StartDBSyncers=10
    HistoryCacheSize=2G
    HistoryIndexCacheSize=2G
    TrendCacheSize=2G
    ValueCacheSize=2G

    System information
    Yes localhost:10051
    858 776 / 82
    325
    123912 111952 / 1201 / 10759
    61068 59582 / 1486 [1565 / 58017]
    183 11
    755.42
    Disabled
    root@zabbix-ict:/# zabbix_server -R diaginfo
    == history cache diagnostic information ==
    Items:102534 values:721589 time:0.024797
    Memory.data:
    size: free:2091892776 used:39749848
    chunks: free:6729 used:983312 min:40 max:2088920336
    buckets:
    40:41
    48:631
    56:258
    64:53
    72:33
    80:28
    88:17
    96:314
    104:198
    112:59
    120:11
    128:4
    136:15
    144:6
    152:61
    160:58
    168:10
    176:16
    184:4
    192:7
    200:3
    208:19
    216:15
    224:24
    232:8
    240:8
    248:4
    256+:4824
    Memory.index:
    size: free:2138147064 used:7689976
    chunks: free:350 used:102539 min:24 max:2137591472
    buckets:
    24:1
    40:2
    256+:347
    Top.values:
    itemid:50169 values:35
    itemid:77692 values:35
    itemid:47642 values:35
    itemid:79744 values:35
    itemid:77511 values:35
    itemid:49552 values:35
    itemid:79854 values:35
    itemid:62381 values:35
    itemid:77689 values:35
    itemid:61883 values:35
    itemid:48534 values:35
    itemid:62378 values:35
    itemid:77744 values:35
    itemid:47639 values:35
    itemid:49697 values:35
    itemid:62326 values:35
    itemid:49663 values:35
    itemid:79799 values:35
    itemid:72852 values:35
    itemid:50172 values:35
    itemid:62268 values:35
    itemid:77802 values:35
    itemid:61828 values:35
    itemid:49737 values:35
    itemid:50117 values:35
    ==
    == preprocessing diagnostic information ==
    Values:0 done:0 queued:0 processing:0 pending:0 time:0.025356
    Top.values:
    Top.oldest.preproc.values:
    ==
    == locks diagnostic information ==
    Locks:
    ZBX_MUTEX_LOG:0x7fbd509f8000
    ZBX_MUTEX_CACHE:0x7fbd509f8028
    ZBX_MUTEX_TRENDS:0x7fbd509f8050
    ZBX_MUTEX_CACHE_IDS:0x7fbd509f8078
    ZBX_MUTEX_SELFMON:0x7fbd509f80a0
    ZBX_MUTEX_CPUSTATS:0x7fbd509f80c8
    ZBX_MUTEX_DISKSTATS:0x7fbd509f80f0
    ZBX_MUTEX_VALUECACHE:0x7fbd509f8118
    ZBX_MUTEX_VMWARE:0x7fbd509f8140
    ZBX_MUTEX_SQLITE3:0x7fbd509f8168
    ZBX_MUTEX_PROCSTAT:0x7fbd509f8190
    ZBX_MUTEX_PROXY_HISTORY:0x7fbd509f81b8
    ZBX_MUTEX_MODBUS:0x7fbd509f81e0
    ZBX_MUTEX_TREND_FUNC:0x7fbd509f8208
    ZBX_RWLOCK_CONFIG:0x7fbd509f8230
    ZBX_RWLOCK_CONFIG_HISTORY:0x7fbd509f8268
    ZBX_RWLOCK_VALUECACHE:0x7fbd509f82a0
    ==
    == value cache diagnostic information ==
    Items:86541 values:396484 mode:0 time:0.060657
    Memory:
    size: free:2120489592 used:22475480
    chunks: free:6483 used:275905 min:24 max:2114236440
    buckets:
    24:14
    32:1218
    40:12
    48:1031
    56:5
    96:1
    256+:4202
    Top.values:
    itemid:44652 values:72 request.values:61
    itemid:44653 values:72 request.values:61
    itemid:180874 values:70 request.values:2
    itemid:180877 values:70 request.values:2
    itemid:180883 values:70 request.values:2
    itemid:180879 values:70 request.values:2
    itemid:180875 values:70 request.values:2
    itemid:180868 values:70 request.values:2
    itemid:180880 values:70 request.values:2
    itemid:180872 values:70 request.values:2
    itemid:180882 values:70 request.values:2
    itemid:180878 values:70 request.values:2
    itemid:180873 values:70 request.values:2
    itemid:180876 values:69 request.values:2
    itemid:180869 values:69 request.values:2
    itemid:180871 values:69 request.values:2
    itemid:180870 values:69 request.values:2
    itemid:180881 values:69 request.values:2
    itemid:81181 values:68 request.values:1
    itemid:44654 values:65 request.values:61
    itemid:161576 values:36 request.values:2
    itemid:161570 values:36 request.values:2
    itemid:161392 values:36 request.values:1
    itemid:161577 values:36 request.values:2
    itemid:161572 values:36 request.values:2
    Top.request.values:
    itemid:44652 values:72 request.values:61
    itemid:44653 values:72 request.values:61
    itemid:44654 values:65 request.values:61
    itemid:44633 values:20 request.values:16
    itemid:44632 values:19 request.values:16
    itemid:44631 values:19 request.values:16
    itemid:44634 values:17 request.values:16
    itemid:23664 values:16 request.values:11
    itemid:23264 values:15 request.values:11
    itemid:23274 values:15 request.values:11
    itemid:23271 values:15 request.values:11
    itemid:23620 values:15 request.values:11
    itemid:35275 values:15 request.values:11
    itemid:23265 values:15 request.values:11
    itemid:23275 values:15 request.values:11
    itemid:23252 values:15 request.values:11
    itemid:39823 values:15 request.values:11
    itemid:23255 values:15 request.values:11
    itemid:25371 values:15 request.values:11
    itemid:23269 values:14 request.values:11
    itemid:33026 values:14 request.values:11
    itemid:23260 values:14 request.values:11
    itemid:25668 values:14 request.values:11
    itemid:23256 values:14 request.values:11
    itemid:25667 values:14 request.values:11
    ==
    == LLD diagnostic information ==
    Rules:0 values:0 time:0.025462
    Top.values:
    ==
    == alerting diagnostic information ==
    Alerts:0 time:0.000545
    Media.alerts:
    Source.alerts:
    ==
    zz0.igmdqda3huzz



    zz0.x1ywyowgh2ozz​​

    Click image for larger version

Name:	image.png
Views:	304
Size:	390.9 KB
ID:	464213
    Click image for larger version

Name:	image.png
Views:	187
Size:	165.2 KB
ID:	464214
  • roy_li
    Junior Member
    • Nov 2022
    • 10

    #2
    Showing the image of Utilization of data collectors will be helpful for analysis. Please make sure that the Utilization of poller data collector processes indicator of the zabbix server is consistently 100%, if it is, you should adjust the StartPollers parameter of the server. You can try to adjust this parameter until the usage of the metric Utilization of poller data collector processes stays below 75%.

    Comment

    Working...