Dyego, ----- Original Message ----- From: "Dyego Souza do Carmo" <[EMAIL PROTECTED]> Newsgroups: mailing.database.mysql Sent: Monday, September 16, 2002 10:26 PM Subject: The my.cnf and InnoDB tables
> > The options in my.cnf > > record_buffer > join_buffer > sort_buffer > key_buffer > > are used by InnoDB ? record_buffer - yes join_buffer -yes sort_buffer -yes key_buffer - no, except that some temporary tables are MyISAM type and they use key_buffer. Note that MySQL uses record_buffer, join_buffer, and sort_buffer on per-thread basis. Be careful that mysqld does not exceed the Linux x86 memory limit 2 GB. key_buffer is global, not per-thread. > ------------------------------------------------------------------------- > ++ Dyego Souza do Carmo ++ Dep. Desenvolvimento > ------------------------------------------------------------------------- Best regards, Heikki Tuuri Innobase Oy --- InnoDB - transactions, hot backup, and foreign key support for MySQL See http://www.innodb.com, download MySQL-Max from http://www.mysql.com > E S C R I B A I N F O R M A T I C A > ------------------------------------------------------------------------- > The only stupid question is the unasked one (somewhere in Linux's HowTo) > Linux registred user : #230601 > -- > $ look into "my eyes" > look: cannot open my eyes > ------------------------------------------------------------------------- > Reply: [EMAIL PROTECTED] > > sql,query --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php