Zabbix database tables

[GeorgeKup]

When a zabbix server is installed, then in MySQL we deal only with Innodb tables and, accordingly, with the settings for these tables. But for some reason, in a number of examples, I present settings for both Innodb tables and Mysiam tables. Can someone explain why?

[GeorgeKup]

For example, for Mysiam there are such parameters: key_buffer_size, sort_buffer_size, read_buffer, write_buffer.

[tim.mooney]

I don't understand what you mean by this question:

in a number of examples, I present settings for both Innodb tables and Mysiam tables. Can someone explain why?

Please remember that even if your 'zabbix' database is only using InnoDB storage engine, MySQL/MariaDB still has some MyISAM tables for its own tables, like mysql.host, mysql.user, etc.

If I run the following query on my MariaDB 10.2.22 server that is used only for Zabbix:

select table_schema as database_name, table_name, engine
    from information_schema.tables
where  table_schema not in ('performance_schema')
order by table_schema, table_name;

The output shows that many of the MySQL/MariaDB "internal" tables still use MyISAM.