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
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.