zabbix can not insert data into mysql when mysql drop partition or create partition

XMLWordPrintable

    • Type: Change Request
    • Resolution: Unresolved
    • Priority: Trivial
    • None
    • Affects Version/s: 5.4.11
    • Component/s: Server (S)
    • None
    • Environment:
      os: Linux 1 4.14.141-1.el7.x86_64 #1 SMP Tue Sep 3 14:17:45 CST 2019 x86_64 x86_64 x86_64 GNU/Linux

      server version: 5.4.11

      mysql version : 8.0.2

      Steps to reproduce:

      1. mysql drop partipion
      2. server log display lock

      Result:

      MySQL creates and deletes partitions in the early morning of every Monday. When mysql is executed in the early morning, there will be a situation where zabbix cannot write data

      I found this article: https://mp.weixin.qq.com/s/H8zRWCJHEG1n13RbCawk7Q

      Expected:
      zabbix can cache data when mysql MDL 

            Assignee:
            Oleksii Zagorskyi
            Reporter:
            yinyaliang
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

              Created:
              Updated: