Re: InnoDB configuration problem

[Peter Zaitsev]

key_buffer_size, read_buffer_size, read_rnd_buffer_size apply to MyISAM tables only, however you might use MyISAM tables even if all of your tables are Innodb - MySQL internal temporary tables which do not fit to memory are always MyISAM. You can check in
SHOW STATUS how large value of created_tmp_disk_tables do you have and how large are they.

Typically for box with 1G of memory key_buffer=16M works good if only Innodb tables are used directly.

read_buffer_size and read_rnd_buffer_size are allocated only upon need so if you set them a bit too large it should not impact you a lot. For example values 1M and 8M make good sence for 1GB box if you do not have more than 10 connections which will be sorting on MyISAM (or Temporary MyISAM) tables.

In general option settings is very load dependent and it is very hard to advice without knowing at least basic application type.