MySQL Forums
Forum List  »  Performance

Re: InnoDB configuration problem
Posted by: Peter Zaitsev
Date: December 31, 2004 01:22AM

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.

Options: ReplyQuote

Written By
December 26, 2004 08:45PM
December 29, 2004 09:12PM
Re: InnoDB configuration problem
December 31, 2004 01:22AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.