1. 20 Nov, 2008 1 commit
  2. 19 Nov, 2008 1 commit
  3. 12 Nov, 2008 1 commit
  4. 11 Nov, 2008 4 commits
    • inaam's avatar
      branches/innodb+ rb://48 · 914923fe
      inaam authored
      This patch is to improve recovery performance in InnoDB+.
      It includes introduction of red-black tree for sorted insertion into
      the flush_list and couple of other quirks. More can be found
      at: https://svn.innodb.com/innobase/Recovery_Performance_Improvements
      
      Reviewed by: Marko
      
      914923fe
    • marko's avatar
      branches/innodb+: Merge revisions 2867:2986 from branches/zip: · 810efe12
      marko authored
        ------------------------------------------------------------------------
        r2867 | marko | 2008-10-24 10:24:17 +0300 (Fri, 24 Oct 2008) | 2 lines
      
        branches/zip: ChangeLog: Document r2763, r2794, r2683, r2799, r2809, r2866.
        ------------------------------------------------------------------------
        r2869 | vasil | 2008-10-24 11:14:16 +0300 (Fri, 24 Oct 2008) | 4 lines
      
        branches/zip:
      
        White space cleanup in ChangeLog
        ------------------------------------------------------------------------
        r2870 | vasil | 2008-10-24 13:36:14 +0300 (Fri, 24 Oct 2008) | 8 lines
      
        branches/zip:
      
        Remove a statement that causes the innodb-index test to fail.
      
        The change in behavior was introduced in MySQL BZR-r2738.
      
        Suggested by:	Marko
        ------------------------------------------------------------------------
        r2871 | vasil | 2008-10-24 13:48:38 +0300 (Fri, 24 Oct 2008) | 5 lines
      
        branches/zip:
      
        Adjust mysql-test/patches/innodb-index.diff after the change to
        mysql-test/innodb-index.(test|result) in r2870.
        ------------------------------------------------------------------------
        r2878 | calvin | 2008-10-27 11:05:42 +0200 (Mon, 27 Oct 2008) | 8 lines
      
        branches/zip: port the fix of Bug#19424 - InnoDB: Possibly a memory
        overrun of the buffer being freed with 64-bit Microsoft Visual C++.
      
        The changed file:
      
        CMakeLists.txt: Removing Win64 compiler optimizations for all 
        innodb/mem/* files.
        ------------------------------------------------------------------------
        r2884 | vasil | 2008-10-27 11:48:46 +0200 (Mon, 27 Oct 2008) | 7 lines
      
        branches/zip:
      
        ChangeLog:
      
        Add entry for the fix of Bug#19424 InnoDB: Possibly a memory overrun of
        the buffer being freed (64-bit Visual C)
        ------------------------------------------------------------------------
        r2886 | calvin | 2008-10-27 22:39:11 +0200 (Mon, 27 Oct 2008) | 8 lines
      
        branches/zip: This patch is to solve the issue that file handles can
        not cross DLL/EXE boundaries on Windows. In builtin InnoDB, it makes
        call to MySQL server for creating tmp files. innobase_mysql_tmpfile
        is now rewritten for the plugin. 
      
        rb://5
      
        Approved by:	Marko
        ------------------------------------------------------------------------
        r2887 | calvin | 2008-10-27 22:48:29 +0200 (Mon, 27 Oct 2008) | 44 lines
      
        branches/zip: implement the delayloading of externals for the plugin
        on Windows, which includes:
      
         * Load mysqld.map and insert all symbol/address pairs into hash for
           quick access
         * Resolves all external data variables. The delayloading mechanism
           in MSVC does not support automatic imports of data variables.
           A workaround is to explicitly handle the data import using the delay
           loader during the initialization of the plugin.
         * Resolves all external functions during run-time, by implementing
           the delayed loading helper function delayLoadHelper2, which is
           called by run-time as well as HrLoadAllImportsForDll. 
      
        The delay loader reuses the hash implementation in InnoDB. The normal
        hash_create (in hash0hash.c) creates hash tables in buffer pool. But
        the delay loader is invoked before the engine is initialized, and 
        buffer pools are not ready yet. Instead, the delay loader has its own
        implementation of hash_create() and hash_table_free(), called
        wdl_hash_create() and wdl_hash_table_free().
      
        This patch should be used with other two patches in order to build
        a dynamically linked plugin on Windows:
         * patch for tmpfile functions (r2886)
         * patch for "build" files (to be committed)
      
        The list of file changed:
      
        handler/handler0vars.h: new file, defines a list of external data
        variables (no external functions).
      
        handler/win_delay_loader.cc: new file, the implementation of the delay
        loader for Windows plugin.
      
        handler/ha_innodb.cc: add a header file, and changes for copying the
        system variables.
      
        handler/handler0alter.cc: add a header file
      
        handler/i_s.cc: add a header file
      
        rb://27
      
        Reviewed by:	Sunny, Marko
        Approved by:	Sunny
        ------------------------------------------------------------------------
        r2888 | calvin | 2008-10-28 01:51:49 +0200 (Tue, 28 Oct 2008) | 25 lines
      
        branches/zip: for building dynamic plugin on Windows, ha_innodb.dll,
        when INNODB_DYNAMIC_PLUGIN is specified.
      
        The changes are:
      
        CMakeLists.txt: add project ha_innodb for dynamic plugin on Windows.
        ha_innodb depends on project mysqld.
      
        ha_innodb.def: a new file with standard exports for a dynamic plugin.
      
        Two new files will be added:
         * sql/mysqld.def:	.def file for 32-bit compiler
         * sql/mysqld_x64.def:	.def file for x64 compiler
      
        It is also required to apply a patch to the MySQL source tree. The 
        patch is described in win-plugin/README:
      
        win-plugin/win-plugin.diff - a patch to be applied to MySQL source
        tree. When applied, the following files will be modified:
         * CMakeLists.txt:	add INNODB_DYNAMIC_PLUGIN and _USE_32BIT_TIME_T
         * sql/CMakeLists.txt:	add mysqld.def or mysqld_x64.def for mysqld
         * win/configure.js:	add INNODB_DYNAMIC_PLUGIN
         * win/build-vs71.bat:	provide an option to specify CMAKE_BUILD_TYPE
         * win/build-vs8.bat:	provide an option to specify CMAKE_BUILD_TYPE
         * win/build-vs8_x64.bat: provide an option to specify CMAKE_BUILD_TYPE
        ------------------------------------------------------------------------
        r2894 | marko | 2008-10-28 08:36:39 +0200 (Tue, 28 Oct 2008) | 4 lines
      
        branches/zip: dict_str_starts_with_keyword(): Removed this unused function.
      
        Spotted by Sunny.
        ------------------------------------------------------------------------
        r2895 | vasil | 2008-10-28 08:40:45 +0200 (Tue, 28 Oct 2008) | 6 lines
      
        branches/zip:
      
        ChangeLog:
      
        add entry for the Windows plugin.
        ------------------------------------------------------------------------
        r2917 | marko | 2008-10-28 23:53:23 +0200 (Tue, 28 Oct 2008) | 3 lines
      
        branches/zip: innodb_plugin_init(): Do not copy session variables,
        even when the variable is a global variable in the built-in InnoDB.
        ------------------------------------------------------------------------
        r2918 | calvin | 2008-10-29 00:08:11 +0200 (Wed, 29 Oct 2008) | 2 lines
      
        branches/zip: fix a problem introduced in r2917 - dyn is not
        initialized. Move the check into for().
        ------------------------------------------------------------------------
        r2922 | calvin | 2008-10-29 08:29:01 +0200 (Wed, 29 Oct 2008) | 16 lines
      
        branches/zip: fix issue #102 - Windows plugin: resolve dbug functions
        during run-time.
      
        Implement wrapper functions in the plugin. The plugin will get the
        function entries from mysqld.exe during the init, and invoke the
        corresponding functions (in mysqld.exe). The list of functions are:
      
        	_db_pargs_
        	_db_doprnt_
        	_db_enter_
        	_db_return_
        	_db_dump_
      
        rb://38
      
        Approved by:	Marko
        ------------------------------------------------------------------------
        r2923 | marko | 2008-10-29 09:52:30 +0200 (Wed, 29 Oct 2008) | 1 line
      
        branches/zip: ChangeLog: Mention Bug #27276.
        ------------------------------------------------------------------------
        r2925 | calvin | 2008-10-29 10:09:41 +0200 (Wed, 29 Oct 2008) | 16 lines
      
        branches/zip: change function names in sql/mysqld.def in order
        to work with 5.1.29-rc.
      
        In 5.1.29, the following function names are changed:
          _hash_init
          hash_free
          hash_search
          hash_delete
      
        changed to
          _my_hash_init
          my_hash_free
          my_hash_search
          my_hash_delete
      
        Approved by:	Marko (on IM)
        ------------------------------------------------------------------------
        r2927 | marko | 2008-10-29 11:43:23 +0200 (Wed, 29 Oct 2008) | 4 lines
      
        branches/zip: ha_innodb.cc: Make some functions static, so that they will
        not be compiled as weak global symbols.  These functions must not be
        redirected to the built-in InnoDB.
        ------------------------------------------------------------------------
        r2928 | michael | 2008-10-29 19:20:10 +0200 (Wed, 29 Oct 2008) | 4 lines
      
        Remove unnecessary assert
      
        Approved by: Heikki, over IM
        ------------------------------------------------------------------------
        r2930 | marko | 2008-10-29 21:39:24 +0200 (Wed, 29 Oct 2008) | 33 lines
      
        branches/zip: Merge revisions 2854:2929 from branches/5.1,
        except r2924, which was merged from branches/zip r2866 to branches/5.1
        and except r2879 which was merged separately by Calvin:
      
          ------------------------------------------------------------------------
          r2902 | vasil | 2008-10-28 12:10:25 +0200 (Tue, 28 Oct 2008) | 10 lines
      
          branches/5.1:
      
          Fix Bug#38189 innodb_stats_on_metadata missing
      
          Make the variable innodb_stats_on_metadata visible to the users and
          also settable at runtime. Previously it was only "visible" as a command
          line startup option to mysqld.
      
          Approved by:    Marko (https://svn.innodb.com/rb/r/36)
          ------------------------------------------------------------------------
          r2929 | marko | 2008-10-29 21:26:14 +0200 (Wed, 29 Oct 2008) | 13 lines
      
          branches/5.1: dtype_get_sql_null_size(): return the correct storage
          size of a SQL NULL column. (Bug #40369)
      
          When MySQL Bug #20877 was fixed in r834, this function was
          accidentally modified to return 0 or 1. Apparently, the only impact of
          this bug is that fixed-length columns cannot be updated in-place from
          or to SQL NULL, even in ROW_FORMAT=REDUNDANT.  After this fix,
          fixed-length columns in ROW_FORMAT=REDUNDANT will have a constant
          storage size as they should, no matter if NULL or non-NULL.  The bug
          caused fixed-length NULL columns to occupy 1 byte.
      
          rb://37 approved by Heikki over IM.
          ------------------------------------------------------------------------
      
        ------------------------------------------------------------------------
        r2931 | vasil | 2008-10-29 22:10:40 +0200 (Wed, 29 Oct 2008) | 4 lines
      
        branches/zip:
      
        Add 2 ChangeLog entries for the 2 bugfixes that were merged from branches/5.1.
        ------------------------------------------------------------------------
        r2935 | vasil | 2008-10-30 12:17:23 +0200 (Thu, 30 Oct 2008) | 17 lines
      
        branches/zip:
      
        Fix "Bug#40360 Binlog related errors with binlog off" in InnoDB code in order
        to have a Bug#40360-free InnoDB Plugin 1.0.2.
      
        The fix does check whether binary logging is enabled in MySQL by accessing the
        opt_bin_log global variable that is defined in sql/mysqld.cc.
      
        In case MySQL does develop another solution to this via Bug#40360 then we can
        revert this patch (except the mysql-tests).
      
        The windows-plugin part of this fix will be committed as a separate commit to
        ease eventual merge into branches/5.1 [note from the future: the separate
        commit went into r2936].
      
        Approved by:	Marko (https://svn.innodb.com/rb/r/39)
        ------------------------------------------------------------------------
        r2936 | vasil | 2008-10-30 12:24:09 +0200 (Thu, 30 Oct 2008) | 7 lines
      
        branches/zip:
      
        Followup to r2935: add the Windows Delay Loader stuff for the MySQL
        variable that we are accessing. If someday we have another solution for
        Bug#40360 Binlog related errors with binlog off
        then this should also be reverted.
        ------------------------------------------------------------------------
        r2937 | vasil | 2008-10-30 12:28:47 +0200 (Thu, 30 Oct 2008) | 4 lines
      
        branches/zip:
      
        Add ChangeLog entry for Bug#40360 Binlog related errors with binlog off
        ------------------------------------------------------------------------
        r2938 | vasil | 2008-10-30 12:33:28 +0200 (Thu, 30 Oct 2008) | 5 lines
      
        branches/zip:
      
        Non-functional change: convert handler/handler0vars.h and
        handler/win_delay_loader.cc from \r\n (dos) to \n (unix) line terminators.
        ------------------------------------------------------------------------
        r2939 | marko | 2008-10-30 12:38:18 +0200 (Thu, 30 Oct 2008) | 2 lines
      
        branches/zip: Set svn:eol-style native on some recently added text files.
        ------------------------------------------------------------------------
        r2940 | marko | 2008-10-30 12:46:21 +0200 (Thu, 30 Oct 2008) | 1 line
      
        branches/zip: ChangeLog, ha_innodb.def: Set svn:eol-style native
        ------------------------------------------------------------------------
        r2941 | vasil | 2008-10-30 19:34:27 +0200 (Thu, 30 Oct 2008) | 4 lines
      
        branches/zip:
      
        Increment the InnoDB Plugin version from 1.0.1 to 1.0.2.
        ------------------------------------------------------------------------
        r2943 | sunny | 2008-10-31 09:40:29 +0200 (Fri, 31 Oct 2008) | 15 lines
      
        branches/zip: 
          1. We add a vector of locks to trx_t. This array contains the autoinc
          locks granted to a transaction. There is one per table.
      
          2. We enforce releasing of these locks in the reverse order from the
          one in which they are acquired. The assumption is that since the
          AUTOINC locks are statement level locks. Nested statements introduced
          by triggers are stacked it should hold.
      
        There was some cleanup done to the vector code too by adding const and
        some new functions. Rename dict_table_t::auto_inc_lock to autoinc_lock.
      
        Fix Bug#26316 Triggers create duplicate entries on auto-increment columns
        rb://22
        ------------------------------------------------------------------------
        r2944 | vasil | 2008-10-31 09:44:16 +0200 (Fri, 31 Oct 2008) | 12 lines
      
        branches/zip:
      
        Revert our temporary fix for "Bug#40360 Binlog related errors with binlog off"
        (r2935, r2936) and deploy MySQL's one, but put the function
        mysql_bin_log_is_engaged() inside mysql_addons.cc instead of in mysql's log.cc
        and use a different name for it so there is no collision when MySQL adds this
        function in log.cc.
      
        [note from the future: the windows part of this patch went into r2947]
      
        Approved by:	Marko (https://svn.innodb.com/rb/r/41/)
        ------------------------------------------------------------------------
        r2945 | sunny | 2008-10-31 09:44:45 +0200 (Fri, 31 Oct 2008) | 2 lines
      
        branches/zip: Update ChangeLog with r2943 info.
        ------------------------------------------------------------------------
        r2946 | marko | 2008-10-31 10:18:47 +0200 (Fri, 31 Oct 2008) | 2 lines
      
        branches/zip: Revert the unintended change to univ.i that was made in r2943.
        ------------------------------------------------------------------------
        r2947 | calvin | 2008-10-31 10:38:26 +0200 (Fri, 31 Oct 2008) | 6 lines
      
        branches/zip: Windows plugin part of r2944
      
        r2944 has reference to mysql_bin_log.is_open(), which is new in InnoDB.
        Add two new entries and remove one duplicate in mysqld.def & 
        mysqld_x64.def.
        ------------------------------------------------------------------------
        r2948 | vasil | 2008-10-31 11:39:07 +0200 (Fri, 31 Oct 2008) | 9 lines
      
        branches/zip:
      
        Fix Mantis issue#106 plugin init error:InnoDB: stats_on_metadata in static
        InnoDB (flags=0x2401) differs from stats_on_metadata in dynamic InnoDB (fl
      
        Ignore the NOSYSVAR flag in addition to ignoring the READONLY flag.
      
        Approved by:	Marko (https://svn.innodb.com/rb/r/42/)
        ------------------------------------------------------------------------
        r2949 | vasil | 2008-10-31 11:47:56 +0200 (Fri, 31 Oct 2008) | 4 lines
      
        branches/zip:
      
        White-space cleanup in ChangeLog.
        ------------------------------------------------------------------------
        r2951 | marko | 2008-10-31 14:21:43 +0200 (Fri, 31 Oct 2008) | 4 lines
      
        branches/zip: scripts/install_innodb_plugins_win.sql: New script,
        for installing the InnoDB plugins in Windows.  Copied from
        scripts/install_innodb_plugins.sql.
        ------------------------------------------------------------------------
        r2954 | calvin | 2008-11-04 09:15:26 +0200 (Tue, 04 Nov 2008) | 8 lines
      
        branches/zip: ignore the failure when builtin_innobase_plugin is not
        available.
      
        External variable builtin_innobase_plugin is not available when mysqld
        does not have a builtin InnoDB. The init of the Windows plugin should
        not fail in this case. 
      
        Approved by:	Marko (on IM)
        ------------------------------------------------------------------------
        r2955 | calvin | 2008-11-04 12:43:14 +0200 (Tue, 04 Nov 2008) | 11 lines
      
        branches/zip: windows plugin - fix references to array variables.
      
        This problem surfaced when running new test innodb_bug40360.test. Both
        tx_isolation_names and binlog_format_names are name arrays, and
        should be defined as wdl_tx_isolation_names and wdl_binlog_format_names,
        not *wdl_tx_isolation_names and *wdl_binlog_format_names.
      
        Another array variable is all_charsets, which is already correctly
        defined.
      
        Approved by:	Marko (on IM)
        ------------------------------------------------------------------------
        r2986 | marko | 2008-11-11 09:28:37 +0200 (Tue, 11 Nov 2008) | 11 lines
      
        branches/zip: ha_innobase::create(): Remove the dependences on
        DICT_TF_ZSSIZE_MAX, so that the code can be compiled with a different
        uncompressed page size by redefining UNIV_PAGE_SIZE_SHIFT in univ.i.
        Currently, the allowed values are 12, 13, or 14 (4k, 8k, 16k).
      
        Make the default compressed page size half the uncompressed page size.
        The previous default was 8 kilobytes, which is the same when compiling
        with the default 16k uncompressed page size.
      
        rb://50 approved by Pekka Lampio and Sunny Bains.
        ------------------------------------------------------------------------
      810efe12
    • marko's avatar
      branches/innodb+: ibuf_insert_low(): When buffering an insert or a · 72e3f38f
      marko authored
      delete-mark operation, do not count the buffered records.  The count
      is only relevant for buffering IBUF_OP_DELETE operations.
      
      ibuf_get_volume_buffered(): Do not count the records if n_recs is NULL.
      Do not zero out *n_recs, but let the caller do that.
      
      ibuf_get_volume_buffered_count(): Do nothing if n_recs == NULL.
      72e3f38f
    • marko's avatar
      branches/innodb+: Fix Issue #112, which was introduced in r2962 and · 95d7d87c
      marko authored
      reintroduced in r2970.
      
      ibuf_get_volume_buffered_hash(): Add the parameters "types" and "data".
      The bug was that "types" lacked the offset IBUF_REC_INFO_SIZE, and the
      type information would be read from the wrong place.
      95d7d87c
  5. 07 Nov, 2008 1 commit
    • marko's avatar
      branches/innodb+: Revert some debugging-related changes · 58d342c9
      marko authored
      that were accidentally committed in r2971:
      
      univ.i, ha_innobase::create(): Reduce the uncompressed page size from
      16 to 4 kilobytes.
      
      btr_cur_search_to_nth_level(): Print a diagnostic message when the
      leaf page of a secondary index is being requested from the disk.
      
      buf_read_ahead_random(), buf_read_ahead_linear(): Disable.
      58d342c9
  6. 06 Nov, 2008 4 commits
  7. 05 Nov, 2008 5 commits
    • marko's avatar
      branches/innodb+: ibuf_insert_low(): Ignore the free bits in the · d836a705
      marko authored
      insert buffer bitmap when buffering deletes or delete-marks.
      
      TODO: ibuf_get_volume_buffered() should return only the volume of
      the buffered inserts, not deletes or delete-marks.
      d836a705
    • marko's avatar
      branches/innodb+: ibuf_delete(): Display the space id and page number · dfde1c3b
      marko authored
      when ignoring a buffered delete that would empty a page. (Issue #82)
      dfde1c3b
    • marko's avatar
      branches/innodb+: ibuf0ibuf.c: Revert the patches to Issue #82 · 4115c905
      marko authored
      (r2962, r2865, r2864) and do not refuse to buffer deletes.  The
      problem with refusing to buffer deletes was that no deletes were
      buffered.
      
      Instead, when merging delete requests, disregard a delete request
      if it would make the page empty.  InnoDB tolerates redundant secondary
      index records, but not empty pages.
      
      ibuf_delete(): When merging a delete request, print and ignore the record
      if the page would become empty.
      4115c905
    • marko's avatar
      branches/innodb+: buf_get_volume_buffered(): When estimating the number of · d82c0722
      marko authored
      records on a page, count each unique buffered record at most once.
      
      ibuf_get_volume_buffered_hash(): New function, for inserting a hashed record
      into a bit array.
      
      ibuf_get_volume_buffered_count(): New function, refactored from
      ibuf_get_volume_buffered(), for counting the unique records buffered for
      the page.
      
      ibuf_get_volume_buffered(): Define hash_bitmap, a bit array for identifying
      duplicate records.  Hash collisions do not hurt correctness, only performance.
      If the number of records on the page is estimated as 0, deletes will not be
      buffered.
      
      This patch is just for the record, as is rb://44.  In the tests run so far,
      the function ibuf_get_volume_buffered() always seems to estimate the number
      of records as 0, disabling all buffered deletes.
      d82c0722
    • marko's avatar
      branches/innodb+: ibuf0ibuf.c: Add a compile-time check for IBUF_REC_INFO_SIZE. · 1f0afc58
      marko authored
      ibuf_get_volume_buffered(): Correct the grammar of the function comment.
      1f0afc58
  8. 24 Oct, 2008 1 commit
    • marko's avatar
      branches/innodb+: Merge revisions 2862:2867 from branches/zip: · 937e6971
      marko authored
        ------------------------------------------------------------------------
        r2866 | marko | 2008-10-23 23:25:43 +0300 (Thu, 23 Oct 2008) | 4 lines
      
        branches/zip: ibuf_delete_rec(): When the cursor to the insert buffer record
        cannot be restored, do not complain if the tablespace does not exist.
        This fixes Issue #88.
        ------------------------------------------------------------------------
        r2867 | marko | 2008-10-24 10:24:17 +0300 (Fri, 24 Oct 2008) | 2 lines
      
        branches/zip: ChangeLog: Document r2763, r2794, r2683, r2799, r2809, r2866.
        ------------------------------------------------------------------------
      937e6971
  9. 23 Oct, 2008 3 commits
    • marko's avatar
      branches/innodb+: ibuf_get_volume_buffered(): Do not count insert operations · 923123cd
      marko authored
      when estimating n_recs.  This should finally fix Issue #82.
      923123cd
    • marko's avatar
      branches/innodb+: Refuse to buffer deletes if that could lead to B-tree · 4a7bd430
      marko authored
      pages becoming empty.  Remove work-arounds for empty pages.  This fixes
      Issue #82.
      
      ibuf_get_volume_buffered(): Add the output parameter n_recs, for returning
      the minimum number of records on the page.
      
      ibuf_insert_low(): Refuse to buffer IBUF_OP_DELETE if the page could
      become empty.
      
      btr_page_get_father_node_ptr(): Remove the work-around for the page
      being empty.
      
      page_zip_dir_delete(): Revert to the version from branches/zip.
      Always invoke page_zip_clear_rec().
      4a7bd430
    • marko's avatar
      branches/innodb+: Merge revisions 2835:2862 from branches/zip: · 70f11286
      marko authored
        ------------------------------------------------------------------------
        r2838 | vasil | 2008-10-21 12:49:27 +0300 (Tue, 21 Oct 2008) | 61 lines
      
        branches/zip:
      
        Merge 2744:2837 from branches/5.1 (skipping r2782 and r2826):
      
          ------------------------------------------------------------------------
          r2832 | vasil | 2008-10-21 10:08:30 +0300 (Tue, 21 Oct 2008) | 10 lines
          Changed paths:
             M /branches/5.1/handler/ha_innodb.cc
      
          branches/5.1:
      
          In ha_innobase::info():
      
          Replace sql_print_warning() which prints to mysqld error log with
          push_warning_printf() which sends the error message to the client.
      
          Suggested by: Marko, Sunny, Michael
          Objected by:  Inaam
      
          ------------------------------------------------------------------------
          r2837 | vasil | 2008-10-21 12:07:44 +0300 (Tue, 21 Oct 2008) | 32 lines
          Changed paths:
             M /branches/5.1/mysql-test/innodb-semi-consistent.result
             M /branches/5.1/mysql-test/innodb-semi-consistent.test
             M /branches/5.1/mysql-test/innodb.result
             M /branches/5.1/mysql-test/innodb.test
      
          branches/5.1:
      
          Merge a change from MySQL (this fixes the failing innodb and
          innodb-semi-consistent tests):
      
            revno: 2757
            committer: Georgi Kodinov <kgeorge@mysql.com>
            branch nick: B39812-5.1-5.1.29-rc
            timestamp: Fri 2008-10-03 15:24:19 +0300
            message:
              Bug #39812: Make statement replication default for 5.1 (to match 5.0)
      
              Make STMT replication default for 5.1.
              Add a default of MIXED into the config files
              Fix the tests that needed MIXED replication mode.
            modified:
              mysql-test/include/mix1.inc
              mysql-test/r/innodb-semi-consistent.result
              mysql-test/r/innodb.result
              mysql-test/r/innodb_mysql.result
              mysql-test/r/tx_isolation_func.result
              mysql-test/t/innodb-semi-consistent.test
              mysql-test/t/innodb.test
              mysql-test/t/tx_isolation_func.test
              sql/mysqld.cc
              support-files/my-huge.cnf.sh
              support-files/my-innodb-heavy-4G.cnf.sh
              support-files/my-large.cnf.sh
              support-files/my-medium.cnf.sh
              support-files/my-small.cnf.sh
      
      
          ------------------------------------------------------------------------
      
        ------------------------------------------------------------------------
        r2847 | marko | 2008-10-22 10:07:37 +0300 (Wed, 22 Oct 2008) | 6 lines
      
        branches/zip: page_zip_rec_needs_ext(): Fix a bug that was introduced
        in the fix of Mantis issue #73.  With key_block_size=16, we will also
        have to check the available space on the uncompressed page.
        Otherwise, the clustered index record can be almost 16 kilobytes in
        size, and the undo log record will not fit.
        ------------------------------------------------------------------------
        r2850 | marko | 2008-10-22 13:52:12 +0300 (Wed, 22 Oct 2008) | 2 lines
      
        branches/zip: ibuf_insert_to_index_page(): Discard the local variable block.
        page_cur is always positioned on block, the function parameter.
        ------------------------------------------------------------------------
        r2853 | sunny | 2008-10-23 01:52:09 +0300 (Thu, 23 Oct 2008) | 2 lines
        branches/zip: Add missing UNIV_INTERN.
        ------------------------------------------------------------------------
        r2855 | sunny | 2008-10-23 09:29:46 +0300 (Thu, 23 Oct 2008) | 36 lines
      
        branches/zip:
      
        Merge revisions 2837:2852 from branches/5.1:
      
          ------------------------------------------------------------------------
          r2849 | sunny | 2008-10-22 12:01:18 +0300 (Wed, 22 Oct 2008) | 8 lines
          Changed paths:
             M /branches/5.1/handler/ha_innodb.cc
             M /branches/5.1/include/row0mysql.h
             M /branches/5.1/row/row0mysql.c
      
          branches/5.1: Return the actual error code encountered when allocating
          a new autoinc value. The change in behavior (bug) was introduced in 5.1.22
          when we introduced the new AUTOINC locking model.
      
          rb://31
      
          Bug#40224 New AUTOINC changes mask reporting of deadlock/timeout errors
      
          ------------------------------------------------------------------------
          r2852 | sunny | 2008-10-23 01:42:24 +0300 (Thu, 23 Oct 2008) | 9 lines
          Changed paths:
             M /branches/5.1/handler/ha_innodb.cc
             M /branches/5.1/handler/ha_innodb.h
      
          branches/5.1: Backport r2724 from branches/zip
      
          Check column value against the col max value before updating the table's
          global autoinc counter value. This is part of simplifying the AUTOINC
          sub-system. We extract the type info from MySQL data structures at runtime.
      
          This fixes Bug#37788 InnoDB Plugin: AUTO_INCREMENT wrong for compressed tables
      
          ------------------------------------------------------------------------
      
        ------------------------------------------------------------------------
        r2856 | sunny | 2008-10-23 10:07:05 +0300 (Thu, 23 Oct 2008) | 1 line
      
        Reverting test file changes from r2855
        ------------------------------------------------------------------------
        r2857 | sunny | 2008-10-23 10:24:33 +0300 (Thu, 23 Oct 2008) | 30 lines
      
        branches/zip:
      
        Merge revisions 2852:2854 from branches/5.1:
      
          ------------------------------------------------------------------------
          r2854 | sunny | 2008-10-23 08:30:32 +0300 (Thu, 23 Oct 2008) | 13 lines
          Changed paths:
             M /branches/5.1/dict/dict0dict.c
             M /branches/5.1/dict/dict0mem.c
             M /branches/5.1/handler/ha_innodb.cc
             M /branches/5.1/handler/ha_innodb.h
             M /branches/5.1/include/dict0dict.h
             M /branches/5.1/include/dict0mem.h
             M /branches/5.1/row/row0mysql.c
      
          branches/5.1: Backport changes from branches/zip r2725
      
          Simplify the autoinc initialization code. This removes the
          non-determinism related to reading the table's autoinc value for the first
          time. This change has also reduced the sizeof dict_table_t by sizeof(ibool)
          bytes because we don't need the dict_table_t::autoinc_inited field anymore.
      
          Bug#39830 Table autoinc value not updated on first insert.
          Bug#35498 Cannot get table test/table1 auto-inccounter value in ::info
          Bug#36411 Failed to read auto-increment value from storage engine" in 5.1.24 auto-inc
          rb://16
      
      
          ------------------------------------------------------------------------
      
        ------------------------------------------------------------------------
        r2858 | vasil | 2008-10-23 11:33:43 +0300 (Thu, 23 Oct 2008) | 4 lines
      
        branches/zip:
      
        Update the ChangeLog
        ------------------------------------------------------------------------
        r2861 | marko | 2008-10-23 12:27:15 +0300 (Thu, 23 Oct 2008) | 24 lines
      
        branches/zip: Clean up the file format stamping.
      
        trx_sys_file_format_max_upgrade(): Rename from
        trx_sys_file_format_max_update().  Improve the documentation.  Add a
        const qualifier to the parameter "name".  Replace the parameter
        "flags" with "format_id", because this function should deal with file
        format identifiers, not with table flags.
      
        trx_sys_file_format_max_write(), trx_sys_file_format_max_set(): Add a
        const qualifier to the parameter "name".
      
        ha_innodb.cc: Correct the spelling in some comments: "side effect".
        Remove redundant prototypes for some static callback functions.
      
        innodb_file_format_name_update(), innodb_file_format_check_update():
        Correct the function signature.  Use appropriate pointer type conversions.
      
        MYSQL_SYSVAR_STR(file_format), MYSQL_SYSVAR_STR(file_format_check):
        Remove the type conversions from the callback function pointers.  When
        the function signatures match, no type conversion is needed.  The type
        conversions would only prevent compilation warnings for any mismatch.
      
        Approved by Sunny in rb://25.
        ------------------------------------------------------------------------
        r2862 | marko | 2008-10-23 12:37:42 +0300 (Thu, 23 Oct 2008) | 8 lines
      
        branches/zip: Non-functional changes:
      
        ibuf_get_volume_buffered(): Declare with static linkage.
        This function is private to ibuf0ibuf.c.
      
        btr_cur_pessimistic_delete(): Use the cached result of
        btr_cur_get_index(cursor).
        ------------------------------------------------------------------------
      70f11286
  10. 22 Oct, 2008 1 commit
  11. 21 Oct, 2008 1 commit
    • marko's avatar
      branches/innodb+: Merge revisions 2799:2835 from branches/zip: · 467b0a8d
      marko authored
        ------------------------------------------------------------------------
        r2809 | marko | 2008-10-16 09:41:13 +0300 (Thu, 16 Oct 2008) | 18 lines
      
        branches/zip: Skip the undo log size check on REDUNDANT and COMPACT tables.
      
        In ROW_FORMAT=DYNAMIC and ROW_FORMAT=COMPRESSED, column prefix indexes
        require that prefixes of externally stored columns be written to the
        undo log. This may make the undo log record bigger than the record on
        the B-tree page.  The maximum size of an undo log record is the page
        size.  That must be checked for, in dict_index_add_to_cache().
      
        dict_index_add_to_cache(): Skip the undo log size check for REDUNDANT
        and COMPACT tables. These tables store prefixes of externally stored
        columns locally within the clustered index record.  There are no special
        considerations for the undo log record size.
      
        innodb-index.test: Ensure that the check exists for ROW_FORMAT=DYNAMIC,
        but not for ROW_FORMAT=COMPACT.
      
        This fixes issue #99.  rb://28 approved by Sunny.
        ------------------------------------------------------------------------
        r2810 | vasil | 2008-10-16 19:57:58 +0300 (Thu, 16 Oct 2008) | 12 lines
      
        branches/zip:
      
        Fix Mantis issue#61:
      
        In row_undo_ins_parse_undo_rec(): if we find that a table has no indexes
        (dict_table_get_first_index() returns NULL) do not try to call
        trx_undo_rec_get_row_ref() with a NULL pointer because that would lead to
        a crash. Instead, print a warning and set node->table to NULL just like
        it is done if the .ibd file is missing.
      
        Approved by:    Heikki (via IM)
        ------------------------------------------------------------------------
        r2824 | marko | 2008-10-20 09:58:01 +0300 (Mon, 20 Oct 2008) | 2 lines
      
        branches/zip: rec_convert_dtuple_to_rec_comp(): Relax a too tight assertion.
        Spotted by Sunny.
        ------------------------------------------------------------------------
        r2825 | vasil | 2008-10-20 13:41:04 +0300 (Mon, 20 Oct 2008) | 6 lines
      
        branches/zip:
      
        Print the table name via ut_print_name() and add two spaces before InnoDB.
      
        Suggested by:   Marko
        ------------------------------------------------------------------------
        r2833 | marko | 2008-10-21 10:16:45 +0300 (Tue, 21 Oct 2008) | 2 lines
      
        branches/zip: ibuf_insert_low(): Avoid unnecessarily
        acquiring and releasing ibuf_mutex.
        ------------------------------------------------------------------------
        r2834 | marko | 2008-10-21 10:18:57 +0300 (Tue, 21 Oct 2008) | 1 line
      
        branches/zip: ibuf_delete_rec(): Add debug assertions suggested by Heikki.
        ------------------------------------------------------------------------
        r2835 | marko | 2008-10-21 11:04:06 +0300 (Tue, 21 Oct 2008) | 1 line
      
        branches/zip: ibuf_insert_low(): Simplify a comparison.
        ------------------------------------------------------------------------
      467b0a8d
  12. 15 Oct, 2008 2 commits
    • marko's avatar
      branches/innodb+: Merge revisions 2774:2799 from branches/zip: · a980b544
      marko authored
        ------------------------------------------------------------------------
        r2781 | marko | 2008-10-13 13:40:57 +0300 (Mon, 13 Oct 2008) | 1 line
      
        branches/zip: page_cur_delete_rec(): Call page_zip_validate_low().
        ------------------------------------------------------------------------
        r2783 | vasil | 2008-10-13 18:34:34 +0300 (Mon, 13 Oct 2008) | 9 lines
      
        branches/zip:
      
        Remove mysql-test/patches/bug37312.diff because MySQL "fixed"
        Bug#37312 by removing the test.
      
        http://bugs.mysql.com/37312
        http://lists.mysql.com/commits/54462
        ------------------------------------------------------------------------
        r2784 | marko | 2008-10-13 21:35:30 +0300 (Mon, 13 Oct 2008) | 1 line
      
        branches/zip: Add missing NULL check to the assertion added in r2781.
        ------------------------------------------------------------------------
        r2785 | marko | 2008-10-13 22:29:12 +0300 (Mon, 13 Oct 2008) | 2 lines
      
        branches/zip: page_cur_delete_rec(): Remove the bogus page_zip_validate_low()
        assertion that was added in r2781 and explain why it was bogus.
        ------------------------------------------------------------------------
        r2786 | calvin | 2008-10-14 19:14:47 +0300 (Tue, 14 Oct 2008) | 7 lines
      
        branches/zip: fix Mantis issue #96 Problem compiling ha_innodb.cc
        on 64-bit Windows
      
        Change the definition of srv_replication_delay from ulint to ulong.
        ulint is 64-bit on Win64.
      
        Approved by:	Heikki (on IM)
        ------------------------------------------------------------------------
        r2787 | calvin | 2008-10-14 19:19:41 +0300 (Tue, 14 Oct 2008) | 7 lines
      
        branches/zip: fix compiler warning
      
        Change the definition of add_on from ulint to ullint, to eliminate
        the warning in .\btr\btr0cur.c:
        conversion from 'ullint' to 'ulint', possible loss of data
      
        Approved by:	Heikki (on IM)
        ------------------------------------------------------------------------
        r2793 | marko | 2008-10-15 10:00:06 +0300 (Wed, 15 Oct 2008) | 2 lines
      
        branches/zip: row_create_table_for_mysql(), row_create_index_for_mysql():
        Note that the dictionary object will be freed.
        ------------------------------------------------------------------------
        r2794 | marko | 2008-10-15 10:32:40 +0300 (Wed, 15 Oct 2008) | 9 lines
      
        branches/zip: When invoking page_zip_copy_recs(), update the lock table
        and the adaptive hash index.  This should fix Issue #95 and Issue #87.
      
        page_zip_copy_recs(): Copy PAGE_MAX_TRX_ID as well, to have similar behavior
        to page_copy_rec_list_start() and page_copy_rec_list_end().
      
        btr_root_raise_and_insert(), btr_page_split_and_insert(), btr_lift_page_up():
        Update the lock table and the adaptive hash index.
        ------------------------------------------------------------------------
        r2797 | marko | 2008-10-15 13:21:54 +0300 (Wed, 15 Oct 2008) | 3 lines
      
        branches/zip: Introduce UNIV_ZIP_COPY for invoking page_zip_copy_recs()
        more often in B-tree operations.
        ------------------------------------------------------------------------
        r2799 | marko | 2008-10-15 14:27:42 +0300 (Wed, 15 Oct 2008) | 25 lines
      
        branches/zip: When the server crashes while freeing an externally stored
        column of a compressed table, the BTR_EXTERN_LEN field in the BLOB pointer
        will be written as 0.  Tolerate this in the functions that deal with
        externally stored columns.  This fixes Issue #80 and was posted at rb://26.
      
        Note that the clustered index record is always deleted or purged last,
        after any secondary index records referring to it have been deleted.
      
        btr_free_externally_stored_field(): On an uncompressed table, zero out
        the BTR_EXTERN_LEN, so that half-deleted BLOBs can be detected after
        crash recovery.
      
        btr_copy_externally_stored_field_prefix(): Return 0 if the BLOB has been
        half-deleted.
      
        row_upd_ext_fetch(): Assert that the externally stored column exists.
      
        row_ext_cache_fill(): Allow btr_copy_externally_stored_field_prefix()
        to return 0.
      
        row_sel_sec_rec_is_for_blob(): Return FALSE if the BLOB has been half-deleted.
        This is correct, because the clustered index record would have been deleted
        or purged last, after any secondary index records referring to it had been
        deleted.
        ------------------------------------------------------------------------
      a980b544
    • marko's avatar
      branches/innodb+: btr_cur_search_to_nth_level(): Add a TODO comment that · d6d6f656
      marko authored
      when encountering an empty leaf page, we should advance to the right
      siblings until a non-empty page is found.  Move the initialization of
      cursor->ibuf_cnt to a better place.
      d6d6f656
  13. 11 Oct, 2008 1 commit
  14. 02 Oct, 2008 1 commit
  15. 01 Oct, 2008 1 commit
  16. 30 Sep, 2008 5 commits
    • marko's avatar
      branches/innodb+: row_search_index_entry(): Clean up the call interface · 769969cc
      marko authored
      and add assertions to callers.  Remove the added ibool* parameter and
      return enum row_search_result instead of ibool, to reflect the four
      different outcomes: record found, not found, buffered, and status unknown
      (record not in the buffer pool).
      
      rb://6
      769969cc
    • marko's avatar
      branches/innodb+: ibuf_rec_get_size(): Correct some bugs. rb://17 · 33b5eef5
      marko authored
      This function was created when the delete buffering code was merged from
      branches/fts in r2324.
      
      ibuf_rec_get_size(): Rename the parameter new_format to pre_4_1.  Use
      the correct offsets and accessors for both values of pre_4_1.
      
      ibuf_rec_get_info(): Note that the record must be in 4.1 or later format.
      33b5eef5
    • marko's avatar
      branches/innodb+: page_zip_dir_delete(): Do not clear the last record on · 99d69263
      marko authored
      a secondary index leaf page, because that could break delete buffering.
      
      btr_page_get_father_node_ptr(): Remove a TODO comment regarding this.
      99d69263
    • marko's avatar
      branches/innodb+: Minor cleanup. · 104979bf
      marko authored
      ibuf_set_entry_counter(): Turn a ut_ad() assertion into ut_a().
      
      ibuf_set_del_mark(), ibuf_delete(): Add const qualifiers to read-only
      parameters.
      104979bf
    • marko's avatar
      branches/innodb+: Non-functional changes: · e1580c30
      marko authored
      ibuf_get_entry_counter_low(): Rename from ibuf_set_entry_counter_low().
      This function only reads the counter.  Add const qualifier to the
      rec parameter.
      
      ibuf_set_entry_counter(): Document the entry parameter as in/out.
      e1580c30
  17. 29 Sep, 2008 1 commit
  18. 26 Sep, 2008 1 commit
    • marko's avatar
      branches/innodb+: Minor cleanup. · 5a6b9cf2
      marko authored
      ibuf_rec_get_info(): Eliminate the local variable "mod".  Use switch-case
      instead of if-else if-else.
      
      ibuf_rec_get_op_type(), ibuf_add_ops(), ibuf_print_ops():
      Add const qualifiers to read-only parameters.
      
      ibuf_rec_get_volume(): Remove empty line at end of block.
      5a6b9cf2
  19. 25 Sep, 2008 2 commits
  20. 24 Sep, 2008 3 commits