------------------------------------------------------------------------
  r6521 | marko | 2010-01-27 10:49:01 +0200 (Wed, 27 Jan 2010) | 17 lines

  branches/zip: Drop temporary tables at startup.
  This addresses the third aspect of Bug #41609.

  row_mysql_drop_temp_tables(): New function, to drop all temporary
  tables. These can be distinguished by the least significant bit of
  MIX_LEN. However, we will skip ROW_FORMAT=REDUNDANT tables, because in
  the records for those tables, that bit may be garbage.

  recv_recovery_from_checkpoint_finish(): Invoke
  row_mysql_drop_temp_tables().  Normally, if the .frm files for the
  temporary tables exist at startup, MySQL will ask InnoDB to drop the
  temporary tables.  However, if the files are deleted, for instance, by
  the boot scripts of the operating system, the tables would remain in
  the InnoDB data dictionary unless someone digs them up by
  innodb_table_monitor and creates .frm files for dropping the tables.

  rb://221 approved by Sunny Bains.
  ------------------------------------------------------------------------
  r6525 | marko | 2010-01-28 16:23:15 +0200 (Thu, 28 Jan 2010) | 11 lines

  branches/zip: buf_LRU_invalidate_tablespace(): Do not unnecessarily
  acquire the block_mutex for every block in the LRU list. Only acquire
  it when holding buf_pool_mutex is not sufficient. This should speed up
  the function and considerably reduce traffic on the memory bus and
  caches.

  I noticed this deficiency when working on Issue #157.
  This deficiency popped up again in Issue #449 (Bug #35077),
  which this fix does not fully address.

  rb://78 revision 1 approved by Heikki Tuuri.
  ------------------------------------------------------------------------
  r6526 | jyang | 2010-01-28 18:12:40 +0200 (Thu, 28 Jan 2010) | 8 lines

  branches/zip: Add index translation table to map mysql index
  number to InnoDB index structure directly. Fix Bug #47622:
  "the new index is added before the existing ones in MySQL,
  but after one in SE".

  rb://215, approved by Marko
  ------------------------------------------------------------------------
  r6527 | vasil | 2010-01-29 14:39:48 +0200 (Fri, 29 Jan 2010) | 6 lines

  branches/zip:

  Extend the comment about row_mysql_handle_errors().

  Suggested by:	Heikki
  ------------------------------------------------------------------------
  r6533 | calvin | 2010-01-29 23:31:59 +0200 (Fri, 29 Jan 2010) | 4 lines

  branches/zip: remove duplicated copyright and license info.
  ------------------------------------------------------------------------
  r6534 | sunny | 2010-01-29 23:42:49 +0200 (Fri, 29 Jan 2010) | 15 lines

  branches/zip: Two changes to fix the problem:

  1. First scan the joining transaction's locks and check if no other
  transaction is waiting for a lock held by the joining transaction.
  If no other transaction is waiting then  no deadlock an occur and
  we avoid doing an exhaustive search.

  2. Change the direction of the lock traversal from backward to forward.
  Previously we traversed backward from the lock that has to wait, the function
  to that fetched the previous node was very inefficient resulting in O(n^2)
  access to the rec lock list.

  Fix Bug #49047 InnoDB deadlock detection is CPU intensive with many locks on a single row.

  rb://218
  ------------------------------------------------------------------------
  r6539 | marko | 2010-02-01 11:31:12 +0200 (Mon, 01 Feb 2010) | 75 lines

  branches/zip: Merge revisions 6471:6538 from branches/5.1:

    ------------------------------------------------------------------------
    r6488 | sunny | 2010-01-21 02:55:08 +0200 (Thu, 21 Jan 2010) | 2 lines
    Changed paths:
       M /branches/5.1/mysql-test/innodb-autoinc.result
       M /branches/5.1/mysql-test/innodb-autoinc.test

    branches/5.1: Factor out test for bug#44030 from innodb-autoinc.test
    into a separate test/result files.
    ------------------------------------------------------------------------
    r6489 | sunny | 2010-01-21 02:57:50 +0200 (Thu, 21 Jan 2010) | 2 lines
    Changed paths:
       A /branches/5.1/mysql-test/innodb-autoinc-44030.result
       A /branches/5.1/mysql-test/innodb-autoinc-44030.test

    branches/5.1: Factor out test for bug#44030 from innodb-autoinc.test
    into a separate test/result files.
    ------------------------------------------------------------------------
    r6492 | sunny | 2010-01-21 09:38:35 +0200 (Thu, 21 Jan 2010) | 1 line
    Changed paths:
       M /branches/5.1/mysql-test/innodb-autoinc-44030.test

    branches/5.1: Add reference to bug#47621 in the comment.
    ------------------------------------------------------------------------
    r6535 | sunny | 2010-01-30 00:08:40 +0200 (Sat, 30 Jan 2010) | 11 lines
    Changed paths:
       M /branches/5.1/handler/ha_innodb.cc

    branches/5.1: Undo the change from r6424. We need to return DB_SUCCESS even
    if we were unable to initialize the tabe autoinc value. This is required for
    the open to succeed. The only condition we currently treat as a hard error
    is if the autoinc field instance passed in by MySQL is NULL.

    Previously if the table autoinc value was 0 and the next value was requested
    we had an assertion that would fail. Change that assertion and treat a value
    of 0 to mean that the autoinc system is unavailable. Generation of next
    value will now return failure.

    rb://237
    ------------------------------------------------------------------------
    r6536 | sunny | 2010-01-30 00:13:42 +0200 (Sat, 30 Jan 2010) | 6 lines
    Changed paths:
       M /branches/5.1/handler/ha_innodb.cc
       M /branches/5.1/mysql-test/innodb-autoinc.result
       M /branches/5.1/mysql-test/innodb-autoinc.test

    branches/5.1: Check *first_value everytime against the column max
    value and  set *first_value to next autoinc if it's > col max value.
    ie.  not rely on what is passed in from MySQL.

    [49497] Error 1467 (ER_AUTOINC_READ_FAILED) on inserting a negative value
    rb://236
    ------------------------------------------------------------------------
    r6537 | sunny | 2010-01-30 00:35:00 +0200 (Sat, 30 Jan 2010) | 2 lines
    Changed paths:
       M /branches/5.1/handler/ha_innodb.cc
       M /branches/5.1/mysql-test/innodb-autoinc.result
       M /branches/5.1/mysql-test/innodb-autoinc.test

    branches/5.1: Undo r6536.
    ------------------------------------------------------------------------
    r6538 | sunny | 2010-01-30 00:43:06 +0200 (Sat, 30 Jan 2010) | 6 lines
    Changed paths:
       M /branches/5.1/handler/ha_innodb.cc
       M /branches/5.1/mysql-test/innodb-autoinc.result
       M /branches/5.1/mysql-test/innodb-autoinc.test

    branches/5.1: Check *first_value every time against the column max
    value and  set *first_value to next autoinc if it's > col max value.
    ie.  not rely on what is passed in from MySQL.

    [49497] Error 1467 (ER_AUTOINC_READ_FAILED) on inserting a negative value
    rb://236
    ------------------------------------------------------------------------
  ------------------------------------------------------------------------
  r6540 | marko | 2010-02-01 11:35:13 +0200 (Mon, 01 Feb 2010) | 1 line

  branches/zip: ChangeLog: Document the merge of 6471:6538 from branches/5.1.
  ------------------------------------------------------------------------
  r6546 | jyang | 2010-02-03 11:05:24 +0200 (Wed, 03 Feb 2010) | 9 lines

  branches/zip: Relax assertion on the number of index defined
  in InnoDB must be comparable with that of MySQL to tolerate
  possible dictionary inconsistency. Fix Mantis issue #455,
  "UNIV_DEBUG+ assert ha_innodb.cc:3152 ib_num_index >=
  mysql_num_index".

  rb://248 Approved by Marko.
  ------------------------------------------------------------------------
  r6547 | marko | 2010-02-03 14:43:38 +0200 (Wed, 03 Feb 2010) | 14 lines

  branches/zip: Clean up CHECK TABLE error handling. (Issue #220)

  ha_innobase::change_active_index(): Clean up code formatting.

  ha_innobase::check(): Incorporate the code from
  row_check_table_for_mysql().  Report errors to the client connection
  instead of writing them to the error log.

  row_check_table_for_mysql(): Remove.

  row_check_index_for_mysql(): Renamed from row_scan_and_check_index().
  Let the caller initialize prebuilt, and assume that the index is usable.

  rb://178 approved by Sunny Bains
  ------------------------------------------------------------------------
  r6548 | marko | 2010-02-03 15:01:39 +0200 (Wed, 03 Feb 2010) | 11 lines

  branches/zip: buf_LRU_invalidate_tablespace(): Ensure that prev_bpage
  is not relocated when freeing a compressed block.  This avoids the
  costly rescan of the LRU list.  (Bug #35077, Issue #449)

  At most one buffer-fix will be active at a time, affecting two blocks:
  the buf_page_t and the compressed page frame. This should not block
  the memory defragmentation in buf0buddy.c too much.  In fact, it may
  avoid unnecessary copying if also prev_bpage belongs to the tablespace
  that is being invalidated.

  rb://240
  ------------------------------------------------------------------------
  r6559 | marko | 2010-02-04 13:21:18 +0200 (Thu, 04 Feb 2010) | 14 lines

  branches/zip: Pass the file name and line number of the caller of the
  b-tree cursor functions to the buffer pool requests, in order to make
  the latch diagnostics more accurate.

  buf_page_optimistic_get_func(): Renamed to buf_page_optimistic_get().

  btr_page_get_father_node_ptr(), btr_insert_on_non_leaf_level(),
  btr_pcur_open(), btr_pcur_open_with_no_init(), btr_pcur_open_on_user_rec(),
  btr_pcur_open_at_rnd_pos(), btr_pcur_restore_position(),
  btr_cur_open_at_index_side(), btr_cur_open_at_rnd_pos():
  Rename the function to _func and add the parameters file, line.
  Define wrapper macros with __FILE__, __LINE__.

  btr_cur_search_to_nth_level(): Add the parameters file, line.
  ------------------------------------------------------------------------
  r6560 | sunny | 2010-02-04 16:11:23 +0200 (Thu, 04 Feb 2010) | 7 lines

  branches/zip: Remove the additional check introduced in r6534 which tries
  to check if the joining transaction has any other transactions waiting on
  its locks. This optimization results in excessive deadlocks when running
  Sysbench with a large number of threads. The function seems to return
  FALSE positives.

  rb://250
  ------------------------------------------------------------------------