Roman, ----- Alkuperäinen viesti ----- Lähettäjä: "Roman Neuhauser" <[EMAIL PROTECTED]> Vastaanottaja: "Heikki Tuuri" <[EMAIL PROTECTED]> Kopio: <[EMAIL PROTECTED]> Lähetetty: Wednesday, January 07, 2004 8:05 PM Aihe: Re: innodb_buffer_pool_size / *_buffer_size relation
> # [EMAIL PROTECTED] / 2004-01-06 10:57:52 +0200: > > From: "Roman Neuhauser" <[EMAIL PROTECTED]> > > > My first question is: what is the interaction between MySQL's > > > *_buffer_size and InnoDB's innodb_buffer_pool_size? > > > IOW, are *_buffer_size tunables applicable to InnoDB tables? Would I > > > need to tune e. g. key_buffer_size in a server with only InnoDB tables? > > > > set-variable = sort_buffer_size=1M > > set-variable = read_buffer_size=1M > > set-variable = read_rnd_buffer_size=1M > > > > are relevant also for InnoDB. > > > > Only a small > > > > key_buffer > > > > for MyISAM is normally needed. MySQL's system tables are always MyISAM type, > > and in some rare cases MySQL may create MyISAM type temporary tables when > > processing DISTINCT or ORDER BY. > > I take it key_buffer_size is only applicable to MyISAM tables, yes, but there are always at least some small MyISAM tables in a MySQL installation. > sort_buffer_size, read_buffer_size and read_rnd_buffer_size are > relevant to InnoDB, Yes. > but the above could also be read as "you should > set them to 1M if you use InnoDB". That is a good value for all table types. > Also, the question about the relation remains without answer. What relation? Best regards, Heikki Innobase Oy http://www.innodb.com InnoDB - transactions, row level locking, and foreign keys for MySQL InnoDB Hot Backup - a hot backup tool for InnoDB which also backs up MyISAM tables Order MySQL support from http://www.mysql.com/support/index.html -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
