Re: bulk_insert_buffer_size and InnoDB

2005-05-10 Thread Sergei Golubchik 
Hi!

On May 10, Jan Pieter Kunst wrote:
 Dear all,
 
 I read the following on this page
 http://dev.mysql.com/doc/mysql/en/server-system-variables.html:
 
  bulk_insert_buffer_size
 
  MyISAM uses a special tree-like cache to make bulk inserts faster for
  INSERT ... SELECT, INSERT ... VALUES (...), (...), ..., and LOAD DATA
  INFILE. This variable limits the size of the cache tree in bytes per
  thread. Setting it to 0 disables this optimization. Note: This cache is
  used only when adding data to a non-empty table. The default value is
  8MB. This variable was added in MySQL 4.0.3. This variable previously
  was named myisam_bulk_insert_tree_size.
 
 I take this to mean that bulk_insert_buffer_size has no bearing on
 InnoDB tables, only on MyISAM tables. Is this correct?

Yes.
 
Regards,
Sergei

-- 
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /   Sergei Golubchik [EMAIL PROTECTED]
 / /|_/ / // /\ \/ /_/ / /__  MySQL AB, Senior Software Developer
/_/  /_/\_, /___/\___\_\___/  Osnabrueck, Germany
   ___/  www.mysql.com

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

bulk_insert_buffer_size and InnoDB

2005-05-09 Thread Jan Pieter Kunst 
Dear all,

I read the following on this page
http://dev.mysql.com/doc/mysql/en/server-system-variables.html:

 bulk_insert_buffer_size

 MyISAM uses a special tree-like cache to make bulk inserts faster for
 INSERT ... SELECT, INSERT ... VALUES (...), (...), ..., and LOAD DATA
 INFILE. This variable limits the size of the cache tree in bytes per
 thread. Setting it to 0 disables this optimization. Note: This cache is
 used only when adding data to a non-empty table. The default value is
 8MB. This variable was added in MySQL 4.0.3. This variable previously
 was named myisam_bulk_insert_tree_size.

I take this to mean that bulk_insert_buffer_size has no bearing on
InnoDB tables, only on MyISAM tables. Is this correct?

Thanks in advance,

Jan Pieter Kunst

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]