Roman, 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. Best regards, Heikki Tuuri Innobase Oy http://www.innodb.com Foreign keys, transactions, and row level locking for MySQL InnoDB Hot Backup - a hot backup tool for InnoDB which also backs up MyISAM tables Order MySQL technical support from https://order.mysql.com/ ----- Original Message ----- From: "Roman Neuhauser" <[EMAIL PROTECTED]> Newsgroups: mailing.database.myodbc Sent: Monday, January 05, 2004 4:20 PM Subject: innodb_buffer_pool_size / *_buffer_size relation > I've been trying to tune a MySQL installation a bit, and have a few > questions regarding relations/interactions between InnoDB and MySQL > when it comes to the various buffers... I wanted this mail to be more > specific, but given the lack of info in the manual, I basically don't > have much cannon fodder. > > 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? > > -- > 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] > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]