# [EMAIL PROTECTED] / 2004-01-08 13:26:26 +0200:
> Lähettäjä: "Roman Neuhauser" <[EMAIL PROTECTED]>
> > # [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.
I know that, and didn't imply there weren't.
> > sort_buffer_size, read_buffer_size and read_rnd_buffer_size are
> > relevant to InnoDB,
>
> Yes.
Well, and my question is: How? How does InnoDB use them?
> > 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.
Is taht a good value for all table sizes, all indexes, all resultset
sizes, for all query types? I don't think so, but the documentation
contains very little (next to no) glue on finding the right values
for a server.
> > Also, the question about the relation remains without answer.
>
> What relation?
You are the author, so *you* tell *me*. :) How does
innodb_buffer_pool_size influence use of the other buffers, and vice
versa? This question quite probably makes very little sense, but
that only shows that the documentation needs improvements like a pig
needs scratching (as the local saying goes).
--
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]
