From: Date: May 10 2005 8:47am
Subject: Re: bulk_insert_buffer_size and InnoDB
List-Archive: http://lists.mysql.com/mysql/183850
Message-Id: <20050510064758.GA31969@sergbook.mysql.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii

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 <serg@stripped>
 / /|_/ / // /\ \/ /_/ / /__  MySQL AB, Senior Software Developer
/_/  /_/\_, /___/\___\_\___/  Osnabrueck, Germany
       <___/  www.mysql.com