From: Date: March 11 2007 7:31pm Subject: bk commit into 5.1 tree (holyfoot:1.2477) BUG#26527 List-Archive: http://lists.mysql.com/commits/21693 X-Bug: 26527 Message-Id: <20070311183100.966B12C380B7@hfmain.localdomain> Below is the list of changes that have just been committed into a local 5.1 repository of hf. When hf does a push these changes will be propagated to the main repository and, within 24 hours after the push, to the public repository. For information on how to access the public repository see http://dev.mysql.com/doc/mysql/en/installing-source-tree.html ChangeSet@stripped, 2007-03-11 22:30:54+04:00, holyfoot@stripped +1 -0 Bug #26527 LOAD DATA INFILE extremely slow with partitioned table mysql_load calls hander::start_bulk_insert(0) to prepare caches for big inserts. As ha_partition didn't allow these caches for underlaying tables, the inserts were much slower sql/ha_partition.cc@stripped, 2007-03-11 22:30:51+04:00, holyfoot@stripped +1 -6 allow using caches for BIG inserts # This is a BitKeeper patch. What follows are the unified diffs for the # set of deltas contained in the patch. The rest of the patch, the part # that BitKeeper cares about, is below these diffs. # User: holyfoot # Host: hfmain.(none) # Root: /home/hf/work/26527/my51-26527 --- 1.86/sql/ha_partition.cc 2007-03-11 22:31:00 +04:00 +++ 1.87/sql/ha_partition.cc 2007-03-11 22:31:00 +04:00 @@ -2865,12 +2865,7 @@ void ha_partition::start_bulk_insert(ha_ handler **file; DBUG_ENTER("ha_partition::start_bulk_insert"); - if (!rows) - { - /* Avoid allocation big caches in all underlaying handlers */ - DBUG_VOID_RETURN; - } - rows= rows/m_tot_parts + 1; + rows= rows ? rows/m_tot_parts + 1 : 0; file= m_file; do {