Should I use InnoDB support with my Zabbix mysql database?

[misterdan]

Hello everybody.

I have been using Zabbix for around 7-8 months now and remember reading in one of Alexei's posts to the forum that maybe I should be using InnoDB with my mysql install.

I have done a little research in to this type of database but was wondering if anyone had any experience of InnoDB with Zabbix. For example, how do I make my Zabbix db use InnoDB tables? Do I need to re-create a blank Zabbix database after enabling InnoDB support in mysql or would my existing database just start taking advantage of its features? Finally, would InnoDB improve the performance of my database and thus speed up the display of graphs etc?

Thanks to anyone who can advise me.

[Alexei]

I have done a little research in to this type of database but was wondering if anyone had any experience of InnoDB with Zabbix. For example, how do I make my Zabbix db use InnoDB tables?

By default, ZABBIX MySQL schema takes advantage of InnoDB. If InnoDB is not supported it just creates standard MyIsam tables. Note type=InnoDB in the schema.

Do I need to re-create a blank Zabbix database after enabling InnoDB support in mysql or would my existing database just start taking advantage of its features? Finally, would InnoDB improve the performance of my database and thus speed up the display of graphs etc?

I honestly don't know.

InnoDB in my experience is much more CPU intensive. If you have fast CPU then you may try to get some advantage using InnoDB. Also, InnoDB has lots of tunable parameters which may be used to get max possible performance. From the other hand, InnoDB is complex, requires more maintenance, and sometimes slow (depends on fragmentation very much). InnoDB increases parallelism as it does not lock tables though.

Try both and see!

[misterdan]

Thanks Alexei. I may do some experimentation when i get a chance.