-
Incident report
-
Resolution: Cannot Reproduce
-
Trivial
-
None
-
4.4.4
-
Linux 3.10.0-1062.4.3.el7.x86_64 #1 SMP Wed Nov 13 23:58:53 UTC 2019 x86_64 x86_64 x86_64 GNU/Linux
CentOS Linux release 7.7.1908 (Core)
mysql Ver 8.0.17 for Linux on x86_64 (Source distribution)
Steps to reproduce:
- In fronted click "Clear history and trends" for host item.
- Start request in "DELETE FROM history_uint WHERE itemid=108521", very slow:
DELETE from history_uint WHERE itemid=108521;
Query OK, 86307 rows affected (7 min 9,25 sec) - During that time database locked and agents start send messages about agents not available. I must restart mysqld and zabbix_server
My configuration:
400 hosts*.* At this time my database ~1,101,808,644 InnoDB utf8_general_ci 79.7 GiB.
All other function work fine at this time.
