Question about most sensible table format

[krusty]

Hi,

can somebody told me which table format is the best format for zabbix. I am using mysql with innodb. I know that one colleague use myisam with zabbix. I want to have the best performance so which format is the best? Sorry about my stupid question.

[pdwalker]

According to the documentation, innodb is the better format.

Innodb allows for concurrent writes and reads which the myisam format does not. This difference allows the innodb table format to scale better when you have multiple reads and writes.

Either way, you can test it yourself and see what you prefer. Tables in mysql can be converted on the fly between innodb and myisam format via the following commands:

alter table <tablename> type = myisam
alter table <tablename> type = innodb

Just remember that your table will be mostly inaccessble during this conversion process.

- Paul

[krusty]

thanks paul for your execution.

I want to choos innodb. If i look into the my.cnf file i see some commented lines regarding innodb. Need i to uncomment this lines to use innodb with mysql?

This are the lines:
# Uncomment the following if you are using InnoDB tables
#innodb_data_home_dir = /var/lib/mysql/
#innodb_data_file_path = ibdata1:10M:autoextend
#innodb_log_group_home_dir = /var/lib/mysql/
#innodb_log_arch_dir = /var/lib/mysql/
# You can set .._buffer_pool_size up to 50 - 80 %
# of RAM but beware of setting memory usage too high
#innodb_buffer_pool_size = 16M
#innodb_additional_mem_pool_size = 2M
# Set .._log_file_size to 25 % of buffer pool size
#innodb_log_file_size = 5M
#innodb_log_buffer_size = 8M
#innodb_flush_log_at_trx_commit = 1
#innodb_lock_wait_timeout = 50

[pdwalker]

Basically? yes.

Uncomment those lines and restart mysql.

If you want more information on what those parameters mean and how to configure them for your needs, see http://dev.mysql.com/doc/refman/4.1/en/innodb.html for details.

- Paul