We are running Zabbix 5.4 with MySQL 8.0 & PHP 7.3 on RedHat 8.
Recently we tried upgrade to Zabbix 6.0.1. RPM package upgrade process went fine but as importing data after enabling primary keys on history tables took more time (very slow).
3 Database upgrade to primary keys (zabbix.com)
Question:
1. Is enabling primary keys on history tables must for Zabbix upgrade in existing installations?
2. What could be reason for importing using mysqlsh is slow (exporting data was fast)?
We tried increasing memory, CPU & high performance disks, but still same.
Recently we tried upgrade to Zabbix 6.0.1. RPM package upgrade process went fine but as importing data after enabling primary keys on history tables took more time (very slow).
3 Database upgrade to primary keys (zabbix.com)
Question:
1. Is enabling primary keys on history tables must for Zabbix upgrade in existing installations?
2. What could be reason for importing using mysqlsh is slow (exporting data was fast)?
We tried increasing memory, CPU & high performance disks, but still same.