Issue after removing unwanted hosts

[Davidus]

Just a suggestion, but you should really look at tuning your MySQL configuration even though your problem is gone. The defaults are anything but optimized for anything more than a very small Zabbix installation.

Hi,
I have been collecting data for over two years now. Size of my zabbix database never exceeded 15GB

mysql> SHOW STATUS LIKE 'qcache%';
+-------------------------+-------+
| Variable_name           | Value |
+-------------------------+-------+
| Qcache_free_blocks      | 0     |
| Qcache_free_memory      | 0     |
| Qcache_hits             | 0     |
| Qcache_inserts          | 0     |
| Qcache_lowmem_prunes    | 0     |
| Qcache_not_cached       | 0     |
| Qcache_queries_in_cache | 0     |
| Qcache_total_blocks     | 0     |
+-------------------------+-------+
8 rows in set (0.00 sec)

I’m not fast growing user. Therefore, I’m not planning to add enormous amount of hosts, items etc. to zabbix nearest future. What do you think, do I still need performance tuning?

Thank you for response in advance!

[BDiE8VNy]

In the past (before moving to PostgreSQL) I used to use at least the mentioned Performance Tuning Primer Script after a reasonable run time for any MySQL database.

Finally it's your decision.

[Davidus]

In the past (before moving to PostgreSQL) I used to use at least the mentioned Performance Tuning Primer Script after a reasonable run time for any MySQL database.

Finally it's your decision.

Got it
Thank you for advice!