# [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,
sort_buffer_size, read_buffer_size and read_rnd_buffer_size are
relevant to InnoDB, but the above could also be read as "you should
set them to 1M if you use InnoDB".
Also, the question about the relation remains without answer.
--
If you cc me or remove the list(s) completely I'll most likely ignore
your message. see http://www.eyrie.org./~eagle/faqs/questions.html
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
