An error occurred fetching the project authors.
  1. 10 Aug, 2006 1 commit
    • unknown's avatar
      BUG#19914 SELECT COUNT(*) sometimes returns MAX_INT on cluster tables · e34496e5
      unknown authored
      allow handler::info to return an error code (that will be returned to the user)
      
      
      sql/ha_berkeley.cc:
        update handler::info interface to return int
      sql/ha_berkeley.h:
        update handler::info interface to return int
      sql/ha_heap.cc:
        update handler::info interface to return int
      sql/ha_heap.h:
        update handler::info interface to return int
      sql/ha_innodb.cc:
        update handler::info interface to return int
      sql/ha_innodb.h:
        update handler::info interface to return int
      sql/ha_myisam.cc:
        update handler::info interface to return int
      sql/examples/ha_archive.cc:
        update handler::info interface to return int
      sql/examples/ha_archive.h:
        update handler::info interface to return int
      sql/examples/ha_example.cc:
        update handler::info interface to return int
      sql/examples/ha_example.h:
        update handler::info interface to return int
      sql/examples/ha_tina.cc:
        update handler::info interface to return int
      sql/examples/ha_tina.h:
        update handler::info interface to return int
      sql/ha_myisam.h:
        update handler::info interface to return int
      sql/ha_myisammrg.cc:
        update handler::info interface to return int
      sql/ha_myisammrg.h:
        update handler::info interface to return int
      sql/ha_ndbcluster.cc:
        update handler::info interface to return int
      sql/ha_ndbcluster.h:
        update handler::info interface to return int
      sql/handler.h:
        update handler::info interface to return int
      sql/opt_sum.cc:
        If we get an error when using handler::info to get count(*),
        print and return the error.
      sql/sql_select.cc:
        if error, set fatal error.
      e34496e5
  2. 04 May, 2005 1 commit
    • unknown's avatar
      BUG#10241 cygwin port: invalid pragma interface directives · 9ab5f614
      unknown authored
       - Introduce ifdefs so we can control when to use #pragma interface on cygwin
      
      
      include/my_global.h:
        Turn on use of #pragma implementation and #pragma interface if compiled with GCC and platform != Cygwin
      include/raid.h:
        replace __GNUC__ with USE_PRAGMA_INTERFACE
      sql/examples/ha_archive.h:
        replace __GNUC__ with USE_PRAGMA_INTERFACE
      sql/examples/ha_example.h:
        replace __GNUC__ with USE_PRAGMA_INTERFACE
      sql/field.h:
        replace __GNUC__ with USE_PRAGMA_INTERFACE
      sql/ha_berkeley.h:
        replace __GNUC__ with USE_PRAGMA_INTERFACE
      sql/ha_blackhole.h:
        replace __GNUC__ with USE_PRAGMA_INTERFACE
      sql/ha_heap.h:
        replace __GNUC__ with USE_PRAGMA_INTERFACE
      sql/ha_innodb.h:
        replace __GNUC__ with USE_PRAGMA_INTERFACE
      sql/ha_isam.h:
        replace __GNUC__ with USE_PRAGMA_INTERFACE
      sql/ha_isammrg.h:
        replace __GNUC__ with USE_PRAGMA_INTERFACE
      sql/ha_myisam.h:
        replace __GNUC__ with USE_PRAGMA_INTERFACE
      sql/ha_myisammrg.h:
        replace __GNUC__ with USE_PRAGMA_INTERFACE
      sql/ha_ndbcluster.h:
        replace __GNUC__ with USE_PRAGMA_INTERFACE
      sql/handler.h:
        replace __GNUC__ with USE_PRAGMA_INTERFACE
      sql/item.h:
        replace __GNUC__ with USE_PRAGMA_INTERFACE
      sql/item_cmpfunc.h:
        replace __GNUC__ with USE_PRAGMA_INTERFACE
      sql/item_func.h:
        replace __GNUC__ with USE_PRAGMA_INTERFACE
      sql/item_geofunc.h:
        replace __GNUC__ with USE_PRAGMA_INTERFACE
      sql/item_strfunc.h:
        replace __GNUC__ with USE_PRAGMA_INTERFACE
      sql/item_subselect.h:
        replace __GNUC__ with USE_PRAGMA_INTERFACE
      sql/item_sum.h:
        replace __GNUC__ with USE_PRAGMA_INTERFACE
      sql/item_timefunc.h:
        replace __GNUC__ with USE_PRAGMA_INTERFACE
      sql/opt_range.h:
        replace __GNUC__ with USE_PRAGMA_INTERFACE
      sql/procedure.h:
        replace __GNUC__ with USE_PRAGMA_INTERFACE
      sql/protocol.h:
        replace __GNUC__ with USE_PRAGMA_IMPLEMENTATION
      sql/set_var.h:
        replace __GNUC__ with USE_PRAGMA_INTERFACE
      sql/sql_class.h:
        replace __GNUC__ with USE_PRAGMA_INTERFACE
      sql/sql_list.h:
        replace __GNUC__ with USE_PRAGMA_INTERFACE
      sql/sql_select.h:
        replace __GNUC__ with USE_PRAGMA_INTERFACE
      sql/sql_string.h:
        replace __GNUC__ with USE_PRAGMA_INTERFACE
      sql/sql_udf.h:
        replace __GNUC__ with USE_PRAGMA_INTERFACE
      sql/tztime.h:
        replace __GNUC__ with USE_PRAGMA_INTERFACE
      9ab5f614
  3. 07 Apr, 2005 1 commit
    • unknown's avatar
      InnoDB: Prevent ALTER TABLE ... ENGINE=... · f7356d73
      unknown authored
      if there are foreign key constraints on the table. (Bug #5574)
      
      
      sql/ha_innodb.cc:
        Add method can_switch_engines()
      sql/ha_innodb.h:
        Add method can_switch_engines()
      sql/handler.h:
        Add method can_switch_engines()
      sql/sql_table.cc:
        Check handler::can_switch_engines() before switching storage engines
      f7356d73
  4. 01 Mar, 2005 1 commit
    • unknown's avatar
      InnoDB: Commit inserts to the temporary tables created by · 22e0b300
      unknown authored
      CREATE INDEX and DROP INDEX every 10,000 rows,
      similar to ALTER TABLE.
      
      
      sql/ha_innodb.cc:
        Commit inserts to the temporary tables created by
        CREATE INDEX and DROP INDEX every 10,000 rows, similar
        to ALTER TABLE.
      sql/ha_innodb.h:
        Remove duplicate declaration of srv_max_purge_lag.
      22e0b300
  5. 25 Jan, 2005 1 commit
    • unknown's avatar
      InnoDB: Backport innodb_autoextend_increment from 4.1 · f35117ea
      unknown authored
      innobase/include/srv0srv.h:
        Add configuration variable srv_auto_extend_increment
      innobase/srv/srv0srv.c:
        Add configuration variable srv_auto_extend_increment
      sql/ha_innodb.h:
        Add configuration variable srv_auto_extend_increment
      sql/mysqld.cc:
        Add startup option innodb_autoextend_increment
      sql/set_var.cc:
        Add settable global variable innodb_autoextend_increment
      f35117ea
  6. 03 Nov, 2004 1 commit
    • unknown's avatar
      InnoDB: commit after every 10000 rows in ALTER TABLE · d07f96cf
      unknown authored
      innobase/include/lock0lock.h:
        Added function lock_get_ix_table()
      innobase/include/row0mysql.h:
        Added parameter "table" to row_lock_table_for_mysql()
      innobase/lock/lock0lock.c:
        Added function lock_get_ix_table()
      innobase/row/row0mysql.c:
        Added parameter "table" to row_lock_table_for_mysql()
      sql/ha_innodb.cc:
        write_row(): commit every 10000 rows in ALTER TABLE
      sql/ha_innodb.h:
        Added member variable num_write_row
      d07f96cf
  7. 27 Oct, 2004 1 commit
    • unknown's avatar
      Backport innodb_max_purge_lag from 4.1 · 743597ea
      unknown authored
      innobase/include/srv0srv.h:
        Add configuration parameter srv_max_purge_lag.
        Add global variable srv_dml_needed_delay.
      innobase/include/trx0sys.h:
        Add trx_sys->rseg_history_len
      innobase/row/row0mysql.c:
        Add row_mysql_delay_if_needed() for delaying INSERTs, UPDATEs and
        DELETEs for srv_dml_needed_delay microseconds.
      innobase/srv/srv0srv.c:
        Define global variable srv_dml_needed_delay.
        Define configuration parameter srv_max_purge_lag.
      innobase/trx/trx0purge.c:
        Update trx_sys->rseg_history_len.
        trx_purge(): Compute srv_dml_needed_delay from srv_max_purge_lag
        and trx_sys->rseg_history_len.
      innobase/trx/trx0rseg.c:
        Initialize trx_sys->rseg_history_len at InnoDB start-up.
      sql/ha_innodb.h:
        Add configuration parameter srv_max_purge_lag.
      sql/mysqld.cc:
        Add startup option innodb_max_purge_lag,
        with default value 0 (meaning infinite, disabling the feature).
      sql/set_var.cc:
        Add global variable innodb_max_purge_lag.
      743597ea
  8. 13 Oct, 2004 1 commit
    • unknown's avatar
      srv0srv.c, log0log.c, srv0srv.h, ha_innodb.cc, ha_innodb.h: · 7b1f818d
      unknown authored
        Implement innobase_very_fast_shutdown and innobase_start_trx_and_assign_read_view(); these were requested by Guilhem
      
      
      sql/ha_innodb.h:
        Implement innobase_very_fast_shutdown and innobase_start_trx_and_assign_read_view(); these were requested by Guilhem
      sql/ha_innodb.cc:
        Implement innobase_very_fast_shutdown and innobase_start_trx_and_assign_read_view(); these were requested by Guilhem
      innobase/include/srv0srv.h:
        Implement innobase_very_fast_shutdown and innobase_start_trx_and_assign_read_view(); these were requested by Guilhem
      innobase/log/log0log.c:
        Implement innobase_very_fast_shutdown and innobase_start_trx_and_assign_read_view(); these were requested by Guilhem
      innobase/srv/srv0srv.c:
        Implement innobase_very_fast_shutdown and innobase_start_trx_and_assign_read_view(); these were requested by Guilhem
      7b1f818d
  9. 30 Sep, 2004 2 commits
    • unknown's avatar
      InnoDB: implement innodb_max_purge_lag · 927179ec
      unknown authored
      innobase/include/srv0srv.h:
        Added srv_max_purge_lag and srv_dml_needed_delay
      innobase/include/trx0sys.h:
        Added trx_sys->rseg_history_len
      innobase/row/row0mysql.c:
        Added row_mysql_delay_if_needed()
      innobase/srv/srv0srv.c:
        Added srv_max_purge_lag and srv_dml_needed_delay
      innobase/trx/trx0purge.c:
        Update trx_sys->rseg_history_len.
        Calculate srv_dml_needed_delay from srv_max_purge_lag
        and trx_sys->rseg_history_len.
      innobase/trx/trx0rseg.c:
        Initialize trx_sys->rseg_history_len
      sql/ha_innodb.h:
        Add srv_max_purge_lag
      sql/mysqld.cc:
        Add parameter innodb_max_purge_lag
      sql/set_var.cc:
        Add global variable innodb_max_purge_lag
      927179ec
    • unknown's avatar
      Made innodb_autoextend_increment accessible as a global variable. · 1dbc71af
      unknown authored
      sql/ha_innodb.cc:
        Removed variable innobase_auto_extend_increment
        (access srv_auto_extend_increment directly)
      sql/ha_innodb.h:
        Removed variable innobase_auto_extend_increment
        (access srv_auto_extend_increment directly)
      sql/mysqld.cc:
        Moved innodb_autoextend_increment to alphabetically correct position.
        Replaced innobase_auto_extend_increment with srv_auto_extend_increment.
      sql/set_var.cc:
        Added innodb_autoextend_increment
      1dbc71af
  10. 13 Sep, 2004 1 commit
    • unknown's avatar
      Fix for BUG#5117: · b28118ab
      unknown authored
       * Renamed handler::estimate_number_of_rows to handler::estimate_rows_upper_bound function, which can also return "unknown"
       * made filesort to use full sort buffer if number of rows to sort is not known.
      
      
      sql/examples/ha_tina.h:
        Renamed estimate_number_of_rows -> estimate_rows_upper_bound
      sql/filesort.cc:
         * Fix for BUG#5117: made filesort() to use full sort buffer if number of rows to sort is not known.
         * Comments and assertion added
      sql/ha_berkeley.cc:
        Renamed estimate_number_of_rows -> estimate_rows_upper_bound
      sql/ha_berkeley.h:
        Renamed estimate_number_of_rows -> estimate_rows_upper_bound
      sql/ha_innodb.cc:
        Renamed estimate_number_of_rows -> estimate_rows_upper_bound
      sql/ha_innodb.h:
        Renamed estimate_number_of_rows -> estimate_rows_upper_bound
      sql/handler.h:
        Renamed estimate_number_of_rows -> estimate_rows_upper_bound
      b28118ab
  11. 07 Sep, 2004 1 commit
    • unknown's avatar
      InnoDB: Add configuration option innodb_autoextend_increment · 13f8420a
      unknown authored
      innobase/include/srv0srv.h:
        Add srv_auto_extend_increment and make SRV_AUTO_EXTEND_INCREMENT
        configureable by it
      innobase/srv/srv0srv.c:
        Add srv_auto_extend_increment
      sql/ha_innodb.cc:
        Add innobase_auto_extend_increment and srv_auto_extend_increment
      sql/ha_innodb.h:
        Add innobase_auto_extend_increment
      sql/mysqld.cc:
        Add "innodb_autoextend_increment" configuration option
      13f8420a
  12. 03 Sep, 2004 1 commit
    • unknown's avatar
      Fixed unique prefix key bug for multibyte character sets (BUG #4521) for · bbd402dc
      unknown authored
      InnoDB. This fixes also a second part of the same problem with prefix keys
      on a multibyte string column for InnoDB.
      
      
      innobase/btr/btr0btr.c:
        Multibyte character set prefix indexes are not any more fixed size. Therefore,
        we have to chect that length of the index field in not greater than
        prefix length.
      innobase/rem/rem0cmp.c:
        Remove unnecessary changes.
      innobase/row/row0ins.c:
        Fixed unique prefix key or prefix key using multibyte character set bugs for
        InnoDB (BUG #4521). For prefix keys we have to get the storage length
        for the prefix length of characters in the key.
      innobase/row/row0row.c:
        Fixed unique prefix key or prefix key using multibyte character set bugs for
        InnoDB (BUG #4521). For prefix keys we have to get the storage length
        for the prefix length of characters in the key.
      innobase/row/row0sel.c:
        Fixed unique prefix key or prefix key using multibyte character set bugs for
        InnoDB (BUG #4521). For prefix keys we have to get the storage length
        for the prefix length of characters in the key.
      innobase/row/row0upd.c:
        Fixed unique prefix key or prefix key using multibyte character set bugs for
        InnoDB (BUG #4521). For prefix keys we have to get the storage length
        for the prefix length of characters in the key.
      mysql-test/r/ctype_utf8.result:
        Added utf8 character test cases for InnoDB.
      mysql-test/t/ctype_utf8.test:
        Added utf8 character expected test results for InnoDB.
      sql/ha_innodb.cc:
        Added function innobase_get_at_most_n_mbchars to return position of
        the nth character in the multibyte character string.
      sql/ha_innodb.h:
        Remove unnecessary changes.
      bbd402dc
  13. 06 Aug, 2004 1 commit
    • unknown's avatar
      InnoDB: Add option for disabling innodb_status.<pid> files. · fc4364e3
      unknown authored
      InnoDB: Implement tmpfile() differently on Windows (Bug #3998)
      
      
      innobase/dict/dict0dict.c:
        Check the return value of os_file_create_tmpfile(),
        as it can now return NULL
      innobase/include/os0file.h:
        Note that os_file_create_tmpfile() can now return NULL
      innobase/include/srv0srv.h:
        Add a new server flag (srv_innodb_status) to disable
        the creation of innodb_status.<pid> files
      innobase/lock/lock0lock.c:
        Check the return value of os_file_create_tmpfile(),
        as it can now return NULL
      innobase/os/os0file.c:
        os_file_create_tmpfile(): separate implementation for Win32;
        errors will be reported but will not cause assertion failure
      innobase/srv/srv0srv.c:
        Add a new server flag (srv_innodb_status) to disable
        the creation of innodb_status.<pid> files
      innobase/srv/srv0start.c:
        innobase_start_or_create_for_mysql(): create srv_monitor_file
        with tmpfile() or with a visible name "innodb_status.<pid>",
        depending on the setting of the flag srv_innodb_status.
      sql/ha_innodb.cc:
        innobase_init(): initialize srv_innodb_status
        update_table_comment(), get_foreign_key_create_info(): replace
        tmpfile() with os_file_create_tmpfile()
      sql/ha_innodb.h:
        Add new Boolean flag, innobase_create_status_file.
      sql/mysqld.cc:
        Add new Boolean flag, innodb_status_file
      fc4364e3
  14. 20 Jul, 2004 1 commit
    • unknown's avatar
      Added innodb_locks_unsafe_for_binlog option. This option turns off Innodb · 238b226f
      unknown authored
        next-key locking. Using this option the locks InnoDB sets on index 
        records do not affect the ``gap'' before that index record. Thus, this option
        allows phantom problem.
      
      
      innobase/include/srv0srv.h:
        Added srv_locks_unsafe_for_binlog for innodb_locks_unsafe_for_binlog option.
      innobase/row/row0sel.c:
        If innodb_locks_unsafe_for_binlog option is used, we lock only the record, i.e. 
        next-key locking is not used. Therefore, setting lock to the index record
        do not affect the ``gap'' before that index record. Thus, this option
        allows phantom problem, because concurrent insert operations are allowed inside 
        the select range.
      innobase/srv/srv0srv.c:
        Added srv_locks_unsafe_for_binlog for innodb_locks_unsafe_for_binlog option.
      sql/ha_innodb.cc:
        Added innobase_locks_unsafe_for_binlog and srv_locks_unsafe_for_binlog for 
        innodb_locks_unsafe_for_binlog option.
      sql/ha_innodb.h:
        Added innobase_locks_unsafe_for_binlog for innodb_locks_unsafe_for_binlog option.
      sql/mysqld.cc:
        Added OPT_INNODB_LOCKS_UNSAFE_FOR_BINLOG, innobase_locks_unsafe_for_binlog for
        innodb_locks_unsafe_for_binlog option.
      sql/set_var.cc:
        Added innodb_locks_unsafe_for_binlog and innobase_locks_unsafe_for_binlog for
        innodb_locks_unsafe_for_binlog option.
      BitKeeper/etc/logging_ok:
        Logging to logging@openlogging.org accepted
      238b226f
  15. 08 Jul, 2004 1 commit
    • unknown's avatar
      New handler::index_flags() definition to make it easy to check the full used... · a23fbc06
      unknown authored
      New handler::index_flags() definition to make it easy to check the full used key and a specific key part.
      Added key part to optimize_range() to fix problems when using fields in key parts.
      
      
      
      sql/examples/ha_archive.h:
        New handler::index_flags() definition
      sql/examples/ha_example.h:
        New handler::index_flags() definition
      sql/field.cc:
        New optimize_range() definition
      sql/field.h:
        New optimize_range() definition
      sql/ha_berkeley.cc:
        New handler::index_flags() definition
      sql/ha_berkeley.h:
        New handler::index_flags() definition
      sql/ha_heap.h:
        New handler::index_flags() definition
      sql/ha_innodb.h:
        New handler::index_flags() definition
      sql/ha_isam.h:
        New handler::index_flags() definition
      sql/ha_isammrg.h:
        New handler::index_flags() definition
      sql/ha_myisam.h:
        New handler::index_flags() definition
      sql/ha_myisammrg.h:
        New handler::index_flags() definition
      sql/ha_ndbcluster.cc:
        New handler::index_flags() definition
      sql/ha_ndbcluster.h:
        New handler::index_flags() definition
      sql/handler.h:
        New handler::index_flags() definition
      sql/log.cc:
        Fixed compiler warnings
      sql/log_event.cc:
        Fixed compiler warnings (and renamed short variable name)
      sql/opt_range.cc:
        New handler::index_flags() definition
      sql/opt_sum.cc:
        New handler::index_flags() definition
      sql/set_var.cc:
        Removed compiler warnings
      sql/sql_db.cc:
        Removed compiler warnings
      sql/sql_select.cc:
        New handler::index_flags() definition
      sql/sql_show.cc:
        Removed compiler warnings
      sql/sql_update.cc:
        Removed compiler warnings
      sql/table.cc:
        New handler::index_flags() definition
      a23fbc06
  16. 25 Jun, 2004 1 commit
    • unknown's avatar
      Added missing root user to mysql.user on windows. (Bug #4242) · 4e664e3e
      unknown authored
      Set default max_allowed_packet to be able to read help tables even if an my.cnf file with this option is present. (Bug #3938)
      Don't use default arguments for ha_rnd_init()
      Simple code cleanups since last pull
      
      
      
      scripts/fill_func_tables.sh:
        Change mode to -rw-rw-r--
      scripts/make_win_src_distribution.sh:
        Safer remove of SCCS directories
      scripts/mysql_create_system_tables.sh:
        Added missing root user to mysql.user on windows. (Bug #4242)
      scripts/mysql_install_db.sh:
        Set default max_allowed_packet to be able to read help tables even if an my.cnf file with this option is present. (Bug #3938)
      sql/filesort.cc:
        Don't use default arguments for ha_rnd_init()
      sql/ha_berkeley.cc:
        Better to use #ifdef than // to disable code
        Removed not needed setting of active_index (It's set in index_end)
      sql/ha_berkeley.h:
        Don't use default arguments for ha_rnd_init()
      sql/ha_heap.h:
        Don't use default arguments for ha_rnd_init()
      sql/ha_innodb.h:
        Don't use default arguments for ha_rnd_init()
      sql/ha_isam.h:
        Don't use default arguments for ha_rnd_init()
      sql/ha_isammrg.h:
        Don't use default arguments for ha_rnd_init()
      sql/ha_myisam.cc:
        Fixed wrong previous patch (New code used 'and' between two conditions when it should be 'or' as in original code)
      sql/ha_myisam.h:
        Don't use default arguments for ha_rnd_init()
      sql/ha_myisammrg.h:
        Don't use default arguments for ha_rnd_init()
      sql/ha_ndbcluster.h:
        Don't use default arguments for ha_rnd_init()
      sql/handler.cc:
        Code cleanup
      sql/handler.h:
        Keep bool variables together (better alignment)
      sql/records.cc:
        Don't use default arguments for ha_rnd_init()
      sql/sql_select.cc:
        Don't use default arguments for ha_rnd_init()
      4e664e3e
  17. 23 Jun, 2004 1 commit
    • unknown's avatar
      handler interface cleanups: · 9a554b47
      unknown authored
        more logical table/index_flags
        return  HA_ERR_WRONG_COMMAND instead of abstract methods where appropriate
        max_keys and other limits renamed to max_supported_keys/etc
        max_keys/etc are now wrappers to max_supported_keys/etc 
        ha_index_init/ha_rnd_init/ha_index_end/ha_rnd_end are now wrappers to real {index,rnd}_{init,end} to enforce strict pairing
      
      
      include/myisam.h:
        increasing myisam_max_temp_file_length
      include/my_base.h:
        handler interface cleanup
      myisam/mi_static.c:
        warning removed
      mysql-test/Makefile.am:
        followup
      mysql-test/r/fulltext.result:
        fulltext indexes are not ordered
      mysql-test/r/rpl_user_variables.result:
        followup
      sql/field.cc:
        index_flags
      sql/filesort.cc:
        rnd_init -> ha_rnd_init
        rnd_end -> ha_rnd_end
      sql/ha_berkeley.cc:
        cleanup
      sql/ha_berkeley.h:
        table/index_flags revamped
      sql/ha_heap.cc:
        ensure index is accessed only after index_init (esp. important for temp tables)
      sql/ha_heap.h:
        table/index_flags revamped
      sql/ha_innodb.cc:
        don't workaround MySQL sloppiness
      sql/ha_innodb.h:
        table/index_flags revamped
      sql/ha_isam.h:
        table/index_flags revamped
      sql/ha_isammrg.h:
        table/index_flags revamped
      sql/ha_myisam.cc:
        ensure index is accessed only after index_init (esp. important for temp tables)
      sql/ha_myisam.h:
        table/index_flags revamped
      sql/ha_myisammrg.h:
        table/index_flags revamped
      sql/handler.cc:
        handler interface cleanups
      sql/handler.h:
        handler interface cleanups:
          more logical table/index_flags
          return  HA_ERR_WRONG_COMMAND instead of abstract methods
          max_keys and other limits renamed to max_supported_keys/etc
          max_keys/etc are now wrappers to max_supported_keys/etc 
          ha_index_init/ha_rnd_init/ha_index_end/ha_rnd_end are now wrappers to enforce strict pairing
      sql/item_subselect.cc:
        index_init/index_end/rnd_init/rnd_end strict pairing fixed
      sql/lex.h:
        renamed to avoid conflicts
      sql/opt_range.cc:
        index_init/index_end/rnd_init/rnd_end strict pairing fixed
        table/index_flags cleanup
      sql/opt_range.h:
        index_init/index_end/rnd_init/rnd_end strict pairing fixed
      sql/opt_sum.cc:
        index_init/index_end/rnd_init/rnd_end strict pairing fixed
        table/index_flags cleanup
      sql/records.cc:
        index_init/index_end/rnd_init/rnd_end strict pairing fixed
      sql/sql_acl.cc:
        index_init/index_end/rnd_init/rnd_end strict pairing fixed
      sql/sql_cache.cc:
        cleanup
      sql/sql_delete.cc:
        index_init/index_end/rnd_init/rnd_end strict pairing fixed
      sql/sql_handler.cc:
        index_init/index_end/rnd_init/rnd_end strict pairing fixed
      sql/sql_help.cc:
        index_init/index_end/rnd_init/rnd_end strict pairing fixed
      sql/sql_insert.cc:
        table/index_flags cleanup
      sql/sql_select.cc:
        index_init/index_end/rnd_init/rnd_end strict pairing fixed
        table/index_flags cleanup
      sql/sql_table.cc:
        index_init/index_end/rnd_init/rnd_end strict pairing fixed
        table/index_flags cleanup
      sql/sql_update.cc:
        index_init/index_end/rnd_init/rnd_end strict pairing fixed
      sql/sql_yacc.yy:
        INDEX -> INDEX_SYM
      sql/table.cc:
        table/index_flags cleanup
      9a554b47
  18. 20 Jun, 2004 1 commit
    • unknown's avatar
      Robustness feature. · 3220a945
      unknown authored
      Won't be pushed as is - separate email sent for internal review.
      WL#1717 "binlog-innodb consistency".
      Now when mysqld starts, if InnoDB does a crash recovery, we use the binlog name
      and position retrieved from InnoDB (corresponding to the last transaction
      successfully committed by InnoDB) to cut any rolled back transaction from
      the binary log. This is triggered by the --innodb-safe-binlog option.
      Provided you configure mysqld to fsync() InnoDB at every commit (using
      flush_log_at_trx_commit) and to fsync() the binlog at every write
      (using --sync-binlog=1), this behaviour guarantees that a master always has
      consistency between binlog and InnoDB, whenever the crash happens.
      6 tests to verify that it works.
      
      
      client/mysqltest.c:
        New command require_os (only "unix" accepted for now).
      innobase/include/trx0sys.h:
        when InnoDB does crash recovery, we now save the binlog coords it prints, into variables for later use.
      innobase/trx/trx0sys.c:
        when InnoDB does crash recovery, we now save the binlog coords it prints, into variables for later use.
      mysql-test/mysql-test-run.sh:
        The tests which check that the binlog is cut at restart, need to not delete those binlogs, of course.
        And not delete replication info, so that we can test that the slave does not receive anything
        wrong from the cut binlog.
      sql/ha_innodb.cc:
        methods to read from InnoDB the binlog coords stored into it
      sql/ha_innodb.h:
        ethods to read from InnoDB the binlog coords stored into it
      sql/log.cc:
        Added my_sync() when we create a binlog (my_sync of the binlog and of the index file);
        this is always done, whether --sync-binlog or not (binlog creation is rare, so no speed
        problem, and I like to have the existence of the binlog always reliably recorded, even if
        later content is not).
        If --crash-binlog-innodb, crash between the binlog write and the InnoDB commit.
        New methods:
        - report_pos_in_innodb() to store the binlog name and position into InnoDB (used only when
        we create a new binlog: at startup and at FLUSH LOGS)
        - cut_spurious_tail() to possibly cut the tail of a binlog based on the info we read
        from InnoDB (does something only if InnoDB has just done a crash recovery).
      sql/mysql_priv.h:
        new option, to crash (use for testing only)
      sql/mysqld.cc:
        New option --innodb-safe-binlog and --crash-binlog-innodb (the latter is for testing, it makes mysqld crash).
        Just after opening the logs and opening the storage engines, cut any wrong statement from the binlog, based
        on info read from InnoDB.
      sql/sql_class.h:
        new methods for MYSQL_LOG.
      3220a945
  19. 10 Jun, 2004 1 commit
    • unknown's avatar
      · 378761c1
      unknown authored
      Added function 
      
      /***********************************************************************
      This function stores binlog offset and flushes logs */
      
      
      void innobase_store_binlog_offset_and_flush_log(char *binlog_name,longlong offset) 
      requested by Guilhem to ha_innodb.cc and ha_innodb.h. 
      
      Change made by Jan.Lindstrom@innodb.com
      
      
      378761c1
  20. 16 May, 2004 1 commit
    • unknown's avatar
      key_cmp -> key_cmp_if_same · 70f79563
      unknown authored
      New records_in_range() interface (similar to read_range())
      Macros for faster bitmap handling
      Simplify read_range() code (#WL1786)
      New general key_cmp() function to compare keys
      
      
      
      
      heap/hp_hash.c:
        New records_in_range() interface
      include/heap.h:
        New records_in_range() interface
      include/my_base.h:
        Moved 'key_range' here so that all table handlers can use it
      include/my_bitmap.h:
        Make some bitmap functions inline for faster usage in one thread
      include/myisam.h:
        New records_in_range() interface
      include/myisammrg.h:
        New records_in_range() interface
      myisam/mi_range.c:
        New records_in_range() interface
      myisam/mi_test2.c:
        New records_in_range() interface
      myisam/rt_test.c:
        New records_in_range() interface
        Indentation fixes
      myisam/sp_test.c:
        New records_in_range() interface
        Indentation fixes
      myisammrg/myrg_range.c:
        New records_in_range() interface
      mysys/my_bitmap.c:
        Make some bitmap functions inline for faster usage in one thread
      sql/examples/ha_example.cc:
        New records_in_range() interface
      sql/field.cc:
        Fixed indentation
      sql/ha_berkeley.cc:
        New records_in_range() interface
      sql/ha_berkeley.h:
        New records_in_range() interface
      sql/ha_heap.cc:
        New records_in_range() interface
      sql/ha_heap.h:
        New records_in_range() interface
      sql/ha_innodb.cc:
        New records_in_range() interface
      sql/ha_innodb.h:
        New records_in_range() interface
      sql/ha_isam.cc:
        New records_in_range() interface
      sql/ha_isam.h:
        New records_in_range() interface
      sql/ha_myisam.cc:
        New records_in_range() interface
      sql/ha_myisam.h:
        New records_in_range() interface
      sql/ha_myisammrg.cc:
        New records_in_range() interface
      sql/ha_myisammrg.h:
        New records_in_range() interface
      sql/ha_ndbcluster.cc:
        New records_in_range() interface
      sql/ha_ndbcluster.h:
        New records_in_range() interface
      sql/handler.cc:
        Simplify read_range() interface:
        - Add 'eq_range' to read_range_first
        - Remove 'eq_range' parameer from read_range_next()
        - Trust values from index_next_same()
        - Simplfy compare_key() by moving key_comparision to key.cc (as this code can be reused from other places)
      sql/handler.h:
        Move key_range to my_base.h to be used by external table handlers
        Simplify read_range() interface
        New records_in_range() interface
      sql/key.cc:
        Rename key_cmp() to key_cmp_if_same() to make it more descriptive
        Add new key_cmp() function usable from range and handler code.
      sql/mysql_priv.h:
        Prototypes for new functions
      sql/opt_range.cc:
        New records_in_range() interface
        Simplify cmp_prev()
        (We can in 5.0 simplify cmp_next() the same way)
      sql/opt_range.h:
        Added key_part_info to QUICK_SELECT to be able to use key_cmp() in get_next()
      sql/opt_sum.cc:
        key_cmp -> key_cmp_if_same
      sql/sql_acl.cc:
        key_cmp -> key_cmp_if_same
      sql/sql_select.cc:
        key_cmp -> key_cmp_if_same
      70f79563
  21. 24 Apr, 2004 1 commit
    • unknown's avatar
      ha_innodb.h: · 39ef383c
      unknown authored
        Allow a key path length in InnoDB to be up to 3500 bytes; this is needed so that one can create an index on a column with 255 UTF-8 characters
      
      
      sql/ha_innodb.h:
        Allow a key path length in InnoDB to be up to 3500 bytes; this is needed so that one can create an index on a column with 255 UTF-8 characters
      39ef383c
  22. 06 Apr, 2004 1 commit
    • unknown's avatar
      ::reset(), HA_FAST_KEY_READ, disable_indexes(), enable_indexes(),... · c6270543
      unknown authored
      ::reset(), HA_FAST_KEY_READ, disable_indexes(), enable_indexes(), start_bulk_insert(), end_bulk_insert()
      Field::val_str simplification, comment
      
      
      include/my_base.h:
        typos fixed
      mysql-test/r/myisam.result:
        alter table enable/disable keys
      mysql-test/t/help.test:
        cleanup
      mysql-test/t/myisam.test:
        alter table enable/disable keys
      sql/field.cc:
        Field::val_str() simplification
      sql/field.h:
        Field::val_str() simplification and comment
      sql/field_conv.cc:
        Field::val_str() simplification
      sql/ha_berkeley.cc:
        ::reset(), HA_FAST_KEY_READ
      sql/ha_berkeley.h:
        ::reset(), HA_FAST_KEY_READ
      sql/ha_heap.cc:
        ::reset(), HA_FAST_KEY_READ
      sql/ha_heap.h:
        ::reset(), HA_FAST_KEY_READ
      sql/ha_innodb.cc:
        ::reset(), HA_FAST_KEY_READ
      sql/ha_innodb.h:
        ::reset(), HA_FAST_KEY_READ
      sql/ha_isam.cc:
        ::reset(), HA_FAST_KEY_READ
      sql/ha_isam.h:
        ::reset(), HA_FAST_KEY_READ
      sql/ha_isammrg.cc:
        ::reset(), HA_FAST_KEY_READ
      sql/ha_isammrg.h:
        ::reset(), HA_FAST_KEY_READ
      sql/ha_myisam.cc:
        ::reset(), HA_FAST_KEY_READ, disable_indexes(), enable_indexes(), start_bulk_insert(), end_bulk_insert()
      sql/ha_myisam.h:
        ::reset(), HA_FAST_KEY_READ, disable_indexes(), enable_indexes(), start_bulk_insert(), end_bulk_insert()
      sql/ha_myisammrg.cc:
        ::reset(), HA_FAST_KEY_READ
      sql/ha_myisammrg.h:
        ::reset(), HA_FAST_KEY_READ
      sql/handler.h:
        ::reset(), HA_FAST_KEY_READ, disable_indexes(), enable_indexes(), start_bulk_insert(), end_bulk_insert()
      sql/item.cc:
        Field::val_str() simplification
      sql/item_sum.cc:
        Field::val_str() simplification
      sql/key.cc:
        Field::val_str() simplification
      sql/opt_range.cc:
        Field::val_str() simplification
      sql/protocol.cc:
        Field::val_str() simplification
      sql/records.cc:
        HA_FAST_KEY_READ
      sql/sql_acl.cc:
        Field::val_str() simplification
      sql/sql_base.cc:
        ::reset
      sql/sql_insert.cc:
        ::reset(), start_bulk_insert(), end_bulk_insert()
      sql/sql_load.cc:
        start_bulk_insert(), end_bulk_insert()
      sql/sql_show.cc:
        Field::val_str() simplification
      sql/sql_table.cc:
        disable_indexes(), enable_indexes(), start_bulk_insert(), end_bulk_insert()
      sql/table.cc:
        Field::val_str() simplification
      c6270543
  23. 31 Mar, 2004 1 commit
  24. 02 Mar, 2004 1 commit
    • unknown's avatar
      Cleanup ha_checktype() and redundant variables. · 8286684e
      unknown authored
      libmysqld/lib_sql.cc:
        Removing *_skip variables
      sql/ha_berkeley.cc:
        Removing *_skip variables
      sql/ha_berkeley.h:
        Removing *_skip variables
      sql/ha_innodb.cc:
        Removing *_skip variables
      sql/ha_innodb.h:
        Removing *_skip variables
      sql/ha_isam.cc:
        Removing *_skip variables
      sql/ha_isam.h:
        Removing *_skip variables
      sql/handler.cc:
        Removing *_skip variables
        Cleanup ha_checktype()
      sql/mysqld.cc:
        Removing *_skip variables
      sql/sql_show.cc:
        Removing *_skip variables
      8286684e
  25. 09 Feb, 2004 1 commit
    • unknown's avatar
      row0mysql.c: · e2646f09
      unknown authored
        Allow always DROPping of a table which is only referenced by FOREIGN KEY constraints from the same table
      Many files:
        Do not let REPLACE to perform internally an UPDATE if the table is referenced by a FOREIGN KEY: the manual says that REPLACE must resolve a duplicate key error semantically with DELETE(s) + INSERT, and not by an UPDATE; the internal update caused foreign key checks and cascaded operations to behave in a semantically wrong way
      
      
      sql/ha_innodb.cc:
        Do not let REPLACE to perform internally an UPDATE if the table is referenced by a FOREIGN KEY: the manual says that REPLACE must resolve a duplicate key error semantically with DELETE(s) + INSERT, and not by an UPDATE; the internal update caused foreign key checks and cascaded operations to behave in a semantically wrong way
      sql/sql_insert.cc:
        Do not let REPLACE to perform internally an UPDATE if the table is referenced by a FOREIGN KEY: the manual says that REPLACE must resolve a duplicate key error semantically with DELETE(s) + INSERT, and not by an UPDATE; the internal update caused foreign key checks and cascaded operations to behave in a semantically wrong way
      sql/ha_innodb.h:
        Do not let REPLACE to perform internally an UPDATE if the table is referenced by a FOREIGN KEY: the manual says that REPLACE must resolve a duplicate key error semantically with DELETE(s) + INSERT, and not by an UPDATE; the internal update caused foreign key checks and cascaded operations to behave in a semantically wrong way
      sql/handler.h:
        Do not let REPLACE to perform internally an UPDATE if the table is referenced by a FOREIGN KEY: the manual says that REPLACE must resolve a duplicate key error semantically with DELETE(s) + INSERT, and not by an UPDATE; the internal update caused foreign key checks and cascaded operations to behave in a semantically wrong way
      innobase/dict/dict0dict.c:
        Do not let REPLACE to perform internally an UPDATE if the table is referenced by a FOREIGN KEY: the manual says that REPLACE must resolve a duplicate key error semantically with DELETE(s) + INSERT, and not by an UPDATE; the internal update caused foreign key checks and cascaded operations to behave in a semantically wrong way
      innobase/include/dict0dict.h:
        Do not let REPLACE to perform internally an UPDATE if the table is referenced by a FOREIGN KEY: the manual says that REPLACE must resolve a duplicate key error semantically with DELETE(s) + INSERT, and not by an UPDATE; the internal update caused foreign key checks and cascaded operations to behave in a semantically wrong way
      innobase/row/row0mysql.c:
        Allow always DROPping of a table which is only referenced by FOREIGN KEY constraints from the same table
      e2646f09
  26. 24 Oct, 2003 1 commit
  27. 13 Oct, 2003 1 commit
    • unknown's avatar
      Many files: · d212ba60
      unknown authored
        ALTER TABLE ... DISCARD/IMPORT TABLESPACE
        Track crash in buf_LRU_block_remove_hashed_page + 1807 reported in MySQL-3.23.5x
      
      
      sql/ha_innodb.cc:
        ALTER TABLE ... DISCARD/IMPORT TABLESPACE
      sql/sql_class.cc:
        ALTER TABLE ... DISCARD/IMPORT TABLESPACE
      sql/sql_parse.cc:
        ALTER TABLE ... DISCARD/IMPORT TABLESPACE
      sql/sql_table.cc:
        ALTER TABLE ... DISCARD/IMPORT TABLESPACE
      sql/ha_innodb.h:
        ALTER TABLE ... DISCARD/IMPORT TABLESPACE
      sql/handler.h:
        ALTER TABLE ... DISCARD/IMPORT TABLESPACE
      sql/lex.h:
        ALTER TABLE ... DISCARD/IMPORT TABLESPACE
      sql/mysql_priv.h:
        ALTER TABLE ... DISCARD/IMPORT TABLESPACE
      sql/sql_class.h:
        ALTER TABLE ... DISCARD/IMPORT TABLESPACE
      sql/sql_lex.h:
        ALTER TABLE ... DISCARD/IMPORT TABLESPACE
      sql/sql_yacc.yy:
        ALTER TABLE ... DISCARD/IMPORT TABLESPACE
      innobase/ha/ha0ha.c:
        Track crash in buf_LRU_block_remove_hashed_page + 1807 reported in MySQL-3.23.5x
      innobase/ha/hash0hash.c:
        Track crash in buf_LRU_block_remove_hashed_page + 1807 reported in MySQL-3.23.5x
      innobase/buf/buf0buf.c:
        Track crash in buf_LRU_block_remove_hashed_page + 1807 reported in MySQL-3.23.5x
      innobase/buf/buf0flu.c:
        Track crash in buf_LRU_block_remove_hashed_page + 1807 reported in MySQL-3.23.5x
      innobase/buf/buf0lru.c:
        Track crash in buf_LRU_block_remove_hashed_page + 1807 reported in MySQL-3.23.5x
      innobase/buf/buf0rea.c:
        Track crash in buf_LRU_block_remove_hashed_page + 1807 reported in MySQL-3.23.5x
      innobase/btr/btr0btr.c:
        Track crash in buf_LRU_block_remove_hashed_page + 1807 reported in MySQL-3.23.5x
      innobase/btr/btr0sea.c:
        Track crash in buf_LRU_block_remove_hashed_page + 1807 reported in MySQL-3.23.5x
      innobase/fil/fil0fil.c:
        ALTER TABLE ... DISCARD/IMPORT TABLESPACE
      innobase/include/buf0buf.h:
        ALTER TABLE ... DISCARD/IMPORT TABLESPACE
      innobase/include/ha0ha.h:
        ALTER TABLE ... DISCARD/IMPORT TABLESPACE
      innobase/include/hash0hash.h:
        ALTER TABLE ... DISCARD/IMPORT TABLESPACE
      innobase/include/row0mysql.h:
        ALTER TABLE ... DISCARD/IMPORT TABLESPACE
      innobase/include/buf0buf.ic:
        ALTER TABLE ... DISCARD/IMPORT TABLESPACE
      innobase/include/ha0ha.ic:
        ALTER TABLE ... DISCARD/IMPORT TABLESPACE
      innobase/include/ibuf0ibuf.ic:
        ALTER TABLE ... DISCARD/IMPORT TABLESPACE
      innobase/page/page0page.c:
        ALTER TABLE ... DISCARD/IMPORT TABLESPACE
      innobase/row/row0mysql.c:
        ALTER TABLE ... DISCARD/IMPORT TABLESPACE
      innobase/row/row0purge.c:
        ALTER TABLE ... DISCARD/IMPORT TABLESPACE
      innobase/row/row0uins.c:
        ALTER TABLE ... DISCARD/IMPORT TABLESPACE
      innobase/row/row0umod.c:
        ALTER TABLE ... DISCARD/IMPORT TABLESPACE
      d212ba60
  28. 11 Oct, 2003 1 commit
    • unknown's avatar
      key_map with more that 64 bits width · 2e1115ed
      unknown authored
      sql/field.cc:
        typedef Bitmap<64> key_map
        all tests pass
      sql/ha_berkeley.cc:
        typedef Bitmap<64> key_map
        all tests pass
      sql/ha_berkeley.h:
        typedef Bitmap<64> key_map
        all tests pass
      sql/item.cc:
        typedef Bitmap<64> key_map
        all tests pass
      sql/item_func.cc:
        typedef Bitmap<64> key_map
        all tests pass
      sql/opt_sum.cc:
        typedef Bitmap<64> key_map
        all tests pass
      sql/sql_delete.cc:
        typedef Bitmap<64> key_map
        all tests pass
      sql/sql_show.cc:
        typedef Bitmap<64> key_map
        all tests pass
      sql/sql_test.cc:
        typedef Bitmap<64> key_map
        all tests pass
      sql/sql_update.cc:
        typedef Bitmap<64> key_map
        all tests pass
      include/my_bitmap.h:
        more bitmap methods
      mysys/my_bitmap.c:
        more bitmap methods
      sql/field.h:
        init bitmaps
      sql/ha_innodb.h:
        optimization
      sql/ha_isam.cc:
        optimization
      sql/ha_myisam.cc:
        optimization
      sql/ha_myisammrg.cc:
        optimization
      sql/handler.h:
        optimization
      sql/mysqld.cc:
        bitmap_init() interface changed
      sql/opt_range.cc:
        optimization
      sql/opt_range.h:
        optimization
      sql/slave.cc:
        bitmap_init() interface changed
      sql/sql_base.cc:
        optimization
      sql/sql_select.cc:
        init bitmaps
        using const for bitmaps whenever possible
      sql/sql_select.h:
        cleanup
      sql/table.cc:
        always init bitmaps
      BitKeeper/etc/ignore:
        Added sql/udf_example.so to the ignore list
      sql/mysql_priv.h:
        use Bitmap over ulonglong by default
      2e1115ed
  29. 07 Oct, 2003 1 commit
    • unknown's avatar
      Many files: · d1485aad
      unknown authored
        Multiple tablespaces for InnoDB
      sql_table.cc:
        Tell explicitly that InnoDB should retrieve all columns in CHECKSUM TABLE
      sql_update.cc, sql_select.cc, my_base.h:
        More descriptive flag name HA_EXTRA_RETRIEVE_ALL_COLS
      
      
      include/my_base.h:
        More descriptive flag name HA_EXTRA_RETRIEVE_ALL_COLS
      sql/sql_select.cc:
        More descriptive flag name HA_EXTRA_RETRIEVE_ALL_COLS
      sql/sql_update.cc:
        More descriptive flag name HA_EXTRA_RETRIEVE_ALL_COLS
      sql/sql_table.cc:
        Tell explicitly that InnoDB should retrieve all columns in CHECKSUM TABLE
      sql/sql_db.cc:
        Multiple tablespaces for InnoDB
      sql/ha_innodb.cc:
        Multiple tablespaces for InnoDB
      sql/mysqld.cc:
        Multiple tablespaces for InnoDB
      sql/set_var.cc:
        Multiple tablespaces for InnoDB
      sql/sql_cache.cc:
        Multiple tablespaces for InnoDB
      sql/ha_innodb.h:
        Multiple tablespaces for InnoDB
      innobase/include/btr0btr.ic:
        Multiple tablespaces for InnoDB
      innobase/include/btr0pcur.ic:
        Multiple tablespaces for InnoDB
      innobase/include/data0type.ic:
        Multiple tablespaces for InnoDB
      innobase/include/dyn0dyn.ic:
        Multiple tablespaces for InnoDB
      innobase/include/fut0lst.ic:
        Multiple tablespaces for InnoDB
      innobase/include/log0log.ic:
        Multiple tablespaces for InnoDB
      innobase/include/mach0data.ic:
        Multiple tablespaces for InnoDB
      innobase/include/mtr0log.ic:
        Multiple tablespaces for InnoDB
      innobase/include/rem0rec.ic:
        Multiple tablespaces for InnoDB
      innobase/include/ut0byte.ic:
        Multiple tablespaces for InnoDB
      innobase/include/ut0ut.ic:
        Multiple tablespaces for InnoDB
      innobase/include/buf0buf.h:
        Multiple tablespaces for InnoDB
      innobase/include/buf0lru.h:
        Multiple tablespaces for InnoDB
      innobase/include/buf0rea.h:
        Multiple tablespaces for InnoDB
      innobase/include/data0type.h:
        Multiple tablespaces for InnoDB
      innobase/include/db0err.h:
        Multiple tablespaces for InnoDB
      innobase/include/dict0boot.h:
        Multiple tablespaces for InnoDB
      innobase/include/dict0dict.h:
        Multiple tablespaces for InnoDB
      innobase/include/dict0load.h:
        Multiple tablespaces for InnoDB
      innobase/include/dict0mem.h:
        Multiple tablespaces for InnoDB
      innobase/include/fil0fil.h:
        Multiple tablespaces for InnoDB
      innobase/include/fsp0fsp.h:
        Multiple tablespaces for InnoDB
      innobase/include/ibuf0ibuf.h:
        Multiple tablespaces for InnoDB
      innobase/include/lock0lock.h:
        Multiple tablespaces for InnoDB
      innobase/include/log0log.h:
        Multiple tablespaces for InnoDB
      innobase/include/log0recv.h:
        Multiple tablespaces for InnoDB
      innobase/include/os0file.h:
        Multiple tablespaces for InnoDB
      innobase/include/page0page.h:
        Multiple tablespaces for InnoDB
      innobase/include/que0types.h:
        Multiple tablespaces for InnoDB
      innobase/include/rem0rec.h:
        Multiple tablespaces for InnoDB
      innobase/include/srv0srv.h:
        Multiple tablespaces for InnoDB
      innobase/include/srv0start.h:
        Multiple tablespaces for InnoDB
      innobase/include/sync0sync.h:
        Multiple tablespaces for InnoDB
      innobase/include/trx0sys.h:
        Multiple tablespaces for InnoDB
      innobase/include/ut0byte.h:
        Multiple tablespaces for InnoDB
      innobase/include/univ.i:
        Multiple tablespaces for InnoDB
      innobase/btr/btr0cur.c:
        Multiple tablespaces for InnoDB
      innobase/btr/btr0sea.c:
        Multiple tablespaces for InnoDB
      innobase/buf/buf0buf.c:
        Multiple tablespaces for InnoDB
      innobase/buf/buf0flu.c:
        Multiple tablespaces for InnoDB
      innobase/buf/buf0lru.c:
        Multiple tablespaces for InnoDB
      innobase/buf/buf0rea.c:
        Multiple tablespaces for InnoDB
      innobase/data/data0type.c:
        Multiple tablespaces for InnoDB
      innobase/dict/dict0boot.c:
        Multiple tablespaces for InnoDB
      innobase/dict/dict0crea.c:
        Multiple tablespaces for InnoDB
      innobase/dict/dict0dict.c:
        Multiple tablespaces for InnoDB
      innobase/dict/dict0load.c:
        Multiple tablespaces for InnoDB
      innobase/dict/dict0mem.c:
        Multiple tablespaces for InnoDB
      innobase/fil/fil0fil.c:
        Multiple tablespaces for InnoDB
      innobase/fsp/fsp0fsp.c:
        Multiple tablespaces for InnoDB
      innobase/ha/ha0ha.c:
        Multiple tablespaces for InnoDB
      innobase/ibuf/ibuf0ibuf.c:
        Multiple tablespaces for InnoDB
      innobase/log/log0log.c:
        Multiple tablespaces for InnoDB
      innobase/log/log0recv.c:
        Multiple tablespaces for InnoDB
      innobase/mach/mach0data.c:
        Multiple tablespaces for InnoDB
      innobase/mem/mem0dbg.c:
        Multiple tablespaces for InnoDB
      innobase/mem/mem0pool.c:
        Multiple tablespaces for InnoDB
      innobase/mtr/mtr0log.c:
        Multiple tablespaces for InnoDB
      innobase/os/os0file.c:
        Multiple tablespaces for InnoDB
      innobase/os/os0proc.c:
        Multiple tablespaces for InnoDB
      innobase/page/page0cur.c:
        Multiple tablespaces for InnoDB
      innobase/que/que0que.c:
        Multiple tablespaces for InnoDB
      innobase/row/row0ins.c:
        Multiple tablespaces for InnoDB
      innobase/row/row0mysql.c:
        Multiple tablespaces for InnoDB
      innobase/row/row0sel.c:
        Multiple tablespaces for InnoDB
      innobase/row/row0upd.c:
        Multiple tablespaces for InnoDB
      innobase/srv/srv0srv.c:
        Multiple tablespaces for InnoDB
      innobase/srv/srv0start.c:
        Multiple tablespaces for InnoDB
      innobase/sync/sync0rw.c:
        Multiple tablespaces for InnoDB
      innobase/sync/sync0sync.c:
        Multiple tablespaces for InnoDB
      innobase/trx/trx0sys.c:
        Multiple tablespaces for InnoDB
      innobase/trx/trx0trx.c:
        Multiple tablespaces for InnoDB
      innobase/trx/trx0undo.c:
        Multiple tablespaces for InnoDB
      innobase/ut/ut0byte.c:
        Multiple tablespaces for InnoDB
      innobase/ut/ut0ut.c:
        Multiple tablespaces for InnoDB
      d1485aad
  30. 14 Jul, 2003 2 commits
    • unknown's avatar
      ha_innodb.h: · 66672ad1
      unknown authored
        Revert the previous patch: MySQL would not allow creation of VARCHAR columns whose total max length is > 8000 bytes, though InnoDB can easily store them as trailing spaces are removed
      
      
      sql/ha_innodb.h:
        Revert the previous patch: MySQL would not allow creation of VARCHAR columns whose total max length is > 8000 bytes, though InnoDB can easily store them as trailing spaces are removed
      66672ad1
    • unknown's avatar
      ha_innodb.h: · 666d4717
      unknown authored
        Fix wrong error message: If one tried to create table with a very big row len, MySQL claimed the max len is 64 kB for InnoDB, while it normally is 8000 bytes
      
      
      sql/ha_innodb.h:
        Fix wrong error message: If one tried to create table with a very big row len, MySQL claimed the max len is 64 kB for InnoDB, while it normally is 8000 bytes
      666d4717
  31. 23 Jun, 2003 1 commit
  32. 15 Jun, 2003 1 commit
    • unknown's avatar
      handler.h, ha_innodb.h, ha_innodb.cc: · 52506029
      unknown authored
        Cleanup; remove compiler warning on Windows
      
      
      sql/ha_innodb.cc:
        Cleanup; remove compiler warning on Windows
      sql/ha_innodb.h:
        Cleanup; remove compiler warning on Windows
      sql/handler.h:
        Cleanup; remove compiler warning on Windows
      52506029
  33. 14 Jun, 2003 1 commit
    • unknown's avatar
      Many files: · 8fe7e029
      unknown authored
        Merge InnoDB-4.0.14: SAVEPOINT now implemented; InnoDB now accepts also column prefix keys; crashing bug in ON UPDATE CASCADE fixed; page checksum formula fixed
      
      
      sql/ha_innodb.h:
        Merge InnoDB-4.0.14: SAVEPOINT now implemented; InnoDB now accepts also column prefix keys; crashing bug in ON UPDATE CASCADE fixed; page checksum formula fixed
      sql/handler.h:
        Merge InnoDB-4.0.14: SAVEPOINT now implemented; InnoDB now accepts also column prefix keys; crashing bug in ON UPDATE CASCADE fixed; page checksum formula fixed
      sql/sql_lex.h:
        Merge InnoDB-4.0.14: SAVEPOINT now implemented; InnoDB now accepts also column prefix keys; crashing bug in ON UPDATE CASCADE fixed; page checksum formula fixed
      sql/ha_innodb.cc:
        Merge InnoDB-4.0.14: SAVEPOINT now implemented; InnoDB now accepts also column prefix keys; crashing bug in ON UPDATE CASCADE fixed; page checksum formula fixed
      sql/handler.cc:
        Merge InnoDB-4.0.14: SAVEPOINT now implemented; InnoDB now accepts also column prefix keys; crashing bug in ON UPDATE CASCADE fixed; page checksum formula fixed
      sql/sql_parse.cc:
        Merge InnoDB-4.0.14: SAVEPOINT now implemented; InnoDB now accepts also column prefix keys; crashing bug in ON UPDATE CASCADE fixed; page checksum formula fixed
      sql/sql_yacc.yy:
        Merge InnoDB-4.0.14: SAVEPOINT now implemented; InnoDB now accepts also column prefix keys; crashing bug in ON UPDATE CASCADE fixed; page checksum formula fixed
      include/my_base.h:
        Merge InnoDB-4.0.14: SAVEPOINT now implemented; InnoDB now accepts also column prefix keys; crashing bug in ON UPDATE CASCADE fixed; page checksum formula fixed
      mysql-test/t/innodb.test:
        Merge InnoDB-4.0.14: SAVEPOINT now implemented; InnoDB now accepts also column prefix keys; crashing bug in ON UPDATE CASCADE fixed; page checksum formula fixed
      mysql-test/r/innodb.result:
        Merge InnoDB-4.0.14: SAVEPOINT now implemented; InnoDB now accepts also column prefix keys; crashing bug in ON UPDATE CASCADE fixed; page checksum formula fixed
      innobase/btr/btr0cur.c:
        Merge InnoDB-4.0.14: SAVEPOINT now implemented; InnoDB now accepts also column prefix keys; crashing bug in ON UPDATE CASCADE fixed; page checksum formula fixed
      innobase/btr/btr0pcur.c:
        Merge InnoDB-4.0.14: SAVEPOINT now implemented; InnoDB now accepts also column prefix keys; crashing bug in ON UPDATE CASCADE fixed; page checksum formula fixed
      innobase/buf/buf0buf.c:
        Merge InnoDB-4.0.14: SAVEPOINT now implemented; InnoDB now accepts also column prefix keys; crashing bug in ON UPDATE CASCADE fixed; page checksum formula fixed
      innobase/buf/buf0flu.c:
        Merge InnoDB-4.0.14: SAVEPOINT now implemented; InnoDB now accepts also column prefix keys; crashing bug in ON UPDATE CASCADE fixed; page checksum formula fixed
      innobase/data/data0data.c:
        Merge InnoDB-4.0.14: SAVEPOINT now implemented; InnoDB now accepts also column prefix keys; crashing bug in ON UPDATE CASCADE fixed; page checksum formula fixed
      innobase/data/data0type.c:
        Merge InnoDB-4.0.14: SAVEPOINT now implemented; InnoDB now accepts also column prefix keys; crashing bug in ON UPDATE CASCADE fixed; page checksum formula fixed
      innobase/dict/dict0boot.c:
        Merge InnoDB-4.0.14: SAVEPOINT now implemented; InnoDB now accepts also column prefix keys; crashing bug in ON UPDATE CASCADE fixed; page checksum formula fixed
      innobase/dict/dict0crea.c:
        Merge InnoDB-4.0.14: SAVEPOINT now implemented; InnoDB now accepts also column prefix keys; crashing bug in ON UPDATE CASCADE fixed; page checksum formula fixed
      innobase/dict/dict0dict.c:
        Merge InnoDB-4.0.14: SAVEPOINT now implemented; InnoDB now accepts also column prefix keys; crashing bug in ON UPDATE CASCADE fixed; page checksum formula fixed
      innobase/dict/dict0load.c:
        Merge InnoDB-4.0.14: SAVEPOINT now implemented; InnoDB now accepts also column prefix keys; crashing bug in ON UPDATE CASCADE fixed; page checksum formula fixed
      innobase/dict/dict0mem.c:
        Merge InnoDB-4.0.14: SAVEPOINT now implemented; InnoDB now accepts also column prefix keys; crashing bug in ON UPDATE CASCADE fixed; page checksum formula fixed
      innobase/fil/fil0fil.c:
        Merge InnoDB-4.0.14: SAVEPOINT now implemented; InnoDB now accepts also column prefix keys; crashing bug in ON UPDATE CASCADE fixed; page checksum formula fixed
      innobase/fsp/fsp0fsp.c:
        Merge InnoDB-4.0.14: SAVEPOINT now implemented; InnoDB now accepts also column prefix keys; crashing bug in ON UPDATE CASCADE fixed; page checksum formula fixed
      innobase/ha/ha0ha.c:
        Merge InnoDB-4.0.14: SAVEPOINT now implemented; InnoDB now accepts also column prefix keys; crashing bug in ON UPDATE CASCADE fixed; page checksum formula fixed
      innobase/ibuf/ibuf0ibuf.c:
        Merge InnoDB-4.0.14: SAVEPOINT now implemented; InnoDB now accepts also column prefix keys; crashing bug in ON UPDATE CASCADE fixed; page checksum formula fixed
      innobase/include/btr0cur.h:
        Merge InnoDB-4.0.14: SAVEPOINT now implemented; InnoDB now accepts also column prefix keys; crashing bug in ON UPDATE CASCADE fixed; page checksum formula fixed
      innobase/include/buf0buf.h:
        Merge InnoDB-4.0.14: SAVEPOINT now implemented; InnoDB now accepts also column prefix keys; crashing bug in ON UPDATE CASCADE fixed; page checksum formula fixed
      innobase/include/data0data.h:
        Merge InnoDB-4.0.14: SAVEPOINT now implemented; InnoDB now accepts also column prefix keys; crashing bug in ON UPDATE CASCADE fixed; page checksum formula fixed
      innobase/include/data0type.h:
        Merge InnoDB-4.0.14: SAVEPOINT now implemented; InnoDB now accepts also column prefix keys; crashing bug in ON UPDATE CASCADE fixed; page checksum formula fixed
      innobase/include/db0err.h:
        Merge InnoDB-4.0.14: SAVEPOINT now implemented; InnoDB now accepts also column prefix keys; crashing bug in ON UPDATE CASCADE fixed; page checksum formula fixed
      innobase/include/dict0dict.h:
        Merge InnoDB-4.0.14: SAVEPOINT now implemented; InnoDB now accepts also column prefix keys; crashing bug in ON UPDATE CASCADE fixed; page checksum formula fixed
      innobase/include/dict0mem.h:
        Merge InnoDB-4.0.14: SAVEPOINT now implemented; InnoDB now accepts also column prefix keys; crashing bug in ON UPDATE CASCADE fixed; page checksum formula fixed
      innobase/include/fil0fil.h:
        Merge InnoDB-4.0.14: SAVEPOINT now implemented; InnoDB now accepts also column prefix keys; crashing bug in ON UPDATE CASCADE fixed; page checksum formula fixed
      innobase/include/lock0lock.h:
        Merge InnoDB-4.0.14: SAVEPOINT now implemented; InnoDB now accepts also column prefix keys; crashing bug in ON UPDATE CASCADE fixed; page checksum formula fixed
      innobase/include/os0file.h:
        Merge InnoDB-4.0.14: SAVEPOINT now implemented; InnoDB now accepts also column prefix keys; crashing bug in ON UPDATE CASCADE fixed; page checksum formula fixed
      innobase/include/page0page.h:
        Merge InnoDB-4.0.14: SAVEPOINT now implemented; InnoDB now accepts also column prefix keys; crashing bug in ON UPDATE CASCADE fixed; page checksum formula fixed
      innobase/include/rem0cmp.h:
        Merge InnoDB-4.0.14: SAVEPOINT now implemented; InnoDB now accepts also column prefix keys; crashing bug in ON UPDATE CASCADE fixed; page checksum formula fixed
      innobase/include/row0row.h:
        Merge InnoDB-4.0.14: SAVEPOINT now implemented; InnoDB now accepts also column prefix keys; crashing bug in ON UPDATE CASCADE fixed; page checksum formula fixed
      innobase/include/row0sel.h:
        Merge InnoDB-4.0.14: SAVEPOINT now implemented; InnoDB now accepts also column prefix keys; crashing bug in ON UPDATE CASCADE fixed; page checksum formula fixed
      innobase/include/row0upd.h:
        Merge InnoDB-4.0.14: SAVEPOINT now implemented; InnoDB now accepts also column prefix keys; crashing bug in ON UPDATE CASCADE fixed; page checksum formula fixed
      innobase/include/srv0srv.h:
        Merge InnoDB-4.0.14: SAVEPOINT now implemented; InnoDB now accepts also column prefix keys; crashing bug in ON UPDATE CASCADE fixed; page checksum formula fixed
      innobase/include/data0type.ic:
        Merge InnoDB-4.0.14: SAVEPOINT now implemented; InnoDB now accepts also column prefix keys; crashing bug in ON UPDATE CASCADE fixed; page checksum formula fixed
      innobase/include/trx0roll.h:
        Merge InnoDB-4.0.14: SAVEPOINT now implemented; InnoDB now accepts also column prefix keys; crashing bug in ON UPDATE CASCADE fixed; page checksum formula fixed
      innobase/include/trx0trx.h:
        Merge InnoDB-4.0.14: SAVEPOINT now implemented; InnoDB now accepts also column prefix keys; crashing bug in ON UPDATE CASCADE fixed; page checksum formula fixed
      innobase/include/trx0types.h:
        Merge InnoDB-4.0.14: SAVEPOINT now implemented; InnoDB now accepts also column prefix keys; crashing bug in ON UPDATE CASCADE fixed; page checksum formula fixed
      innobase/include/ut0dbg.h:
        Merge InnoDB-4.0.14: SAVEPOINT now implemented; InnoDB now accepts also column prefix keys; crashing bug in ON UPDATE CASCADE fixed; page checksum formula fixed
      innobase/include/ut0mem.h:
        Merge InnoDB-4.0.14: SAVEPOINT now implemented; InnoDB now accepts also column prefix keys; crashing bug in ON UPDATE CASCADE fixed; page checksum formula fixed
      innobase/include/row0mysql.ic:
        Merge InnoDB-4.0.14: SAVEPOINT now implemented; InnoDB now accepts also column prefix keys; crashing bug in ON UPDATE CASCADE fixed; page checksum formula fixed
      innobase/include/trx0sys.ic:
        Merge InnoDB-4.0.14: SAVEPOINT now implemented; InnoDB now accepts also column prefix keys; crashing bug in ON UPDATE CASCADE fixed; page checksum formula fixed
      innobase/lock/lock0lock.c:
        Merge InnoDB-4.0.14: SAVEPOINT now implemented; InnoDB now accepts also column prefix keys; crashing bug in ON UPDATE CASCADE fixed; page checksum formula fixed
      innobase/log/log0log.c:
        Merge InnoDB-4.0.14: SAVEPOINT now implemented; InnoDB now accepts also column prefix keys; crashing bug in ON UPDATE CASCADE fixed; page checksum formula fixed
      innobase/log/log0recv.c:
        Merge InnoDB-4.0.14: SAVEPOINT now implemented; InnoDB now accepts also column prefix keys; crashing bug in ON UPDATE CASCADE fixed; page checksum formula fixed
      innobase/mem/mem0pool.c:
        Merge InnoDB-4.0.14: SAVEPOINT now implemented; InnoDB now accepts also column prefix keys; crashing bug in ON UPDATE CASCADE fixed; page checksum formula fixed
      innobase/os/os0file.c:
        Merge InnoDB-4.0.14: SAVEPOINT now implemented; InnoDB now accepts also column prefix keys; crashing bug in ON UPDATE CASCADE fixed; page checksum formula fixed
      innobase/os/os0thread.c:
        Merge InnoDB-4.0.14: SAVEPOINT now implemented; InnoDB now accepts also column prefix keys; crashing bug in ON UPDATE CASCADE fixed; page checksum formula fixed
      innobase/page/page0cur.c:
        Merge InnoDB-4.0.14: SAVEPOINT now implemented; InnoDB now accepts also column prefix keys; crashing bug in ON UPDATE CASCADE fixed; page checksum formula fixed
      innobase/page/page0page.c:
        Merge InnoDB-4.0.14: SAVEPOINT now implemented; InnoDB now accepts also column prefix keys; crashing bug in ON UPDATE CASCADE fixed; page checksum formula fixed
      innobase/pars/pars0opt.c:
        Merge InnoDB-4.0.14: SAVEPOINT now implemented; InnoDB now accepts also column prefix keys; crashing bug in ON UPDATE CASCADE fixed; page checksum formula fixed
      innobase/pars/pars0pars.c:
        Merge InnoDB-4.0.14: SAVEPOINT now implemented; InnoDB now accepts also column prefix keys; crashing bug in ON UPDATE CASCADE fixed; page checksum formula fixed
      innobase/rem/rem0cmp.c:
        Merge InnoDB-4.0.14: SAVEPOINT now implemented; InnoDB now accepts also column prefix keys; crashing bug in ON UPDATE CASCADE fixed; page checksum formula fixed
      innobase/row/row0ins.c:
        Merge InnoDB-4.0.14: SAVEPOINT now implemented; InnoDB now accepts also column prefix keys; crashing bug in ON UPDATE CASCADE fixed; page checksum formula fixed
      innobase/row/row0mysql.c:
        Merge InnoDB-4.0.14: SAVEPOINT now implemented; InnoDB now accepts also column prefix keys; crashing bug in ON UPDATE CASCADE fixed; page checksum formula fixed
      innobase/row/row0row.c:
        Merge InnoDB-4.0.14: SAVEPOINT now implemented; InnoDB now accepts also column prefix keys; crashing bug in ON UPDATE CASCADE fixed; page checksum formula fixed
      innobase/row/row0sel.c:
        Merge InnoDB-4.0.14: SAVEPOINT now implemented; InnoDB now accepts also column prefix keys; crashing bug in ON UPDATE CASCADE fixed; page checksum formula fixed
      innobase/row/row0umod.c:
        Merge InnoDB-4.0.14: SAVEPOINT now implemented; InnoDB now accepts also column prefix keys; crashing bug in ON UPDATE CASCADE fixed; page checksum formula fixed
      innobase/row/row0upd.c:
        Merge InnoDB-4.0.14: SAVEPOINT now implemented; InnoDB now accepts also column prefix keys; crashing bug in ON UPDATE CASCADE fixed; page checksum formula fixed
      innobase/row/row0vers.c:
        Merge InnoDB-4.0.14: SAVEPOINT now implemented; InnoDB now accepts also column prefix keys; crashing bug in ON UPDATE CASCADE fixed; page checksum formula fixed
      innobase/srv/srv0srv.c:
        Merge InnoDB-4.0.14: SAVEPOINT now implemented; InnoDB now accepts also column prefix keys; crashing bug in ON UPDATE CASCADE fixed; page checksum formula fixed
      innobase/srv/srv0start.c:
        Merge InnoDB-4.0.14: SAVEPOINT now implemented; InnoDB now accepts also column prefix keys; crashing bug in ON UPDATE CASCADE fixed; page checksum formula fixed
      innobase/trx/trx0rec.c:
        Merge InnoDB-4.0.14: SAVEPOINT now implemented; InnoDB now accepts also column prefix keys; crashing bug in ON UPDATE CASCADE fixed; page checksum formula fixed
      innobase/trx/trx0roll.c:
        Merge InnoDB-4.0.14: SAVEPOINT now implemented; InnoDB now accepts also column prefix keys; crashing bug in ON UPDATE CASCADE fixed; page checksum formula fixed
      innobase/trx/trx0sys.c:
        Merge InnoDB-4.0.14: SAVEPOINT now implemented; InnoDB now accepts also column prefix keys; crashing bug in ON UPDATE CASCADE fixed; page checksum formula fixed
      innobase/trx/trx0trx.c:
        Merge InnoDB-4.0.14: SAVEPOINT now implemented; InnoDB now accepts also column prefix keys; crashing bug in ON UPDATE CASCADE fixed; page checksum formula fixed
      innobase/ut/ut0mem.c:
        Merge InnoDB-4.0.14: SAVEPOINT now implemented; InnoDB now accepts also column prefix keys; crashing bug in ON UPDATE CASCADE fixed; page checksum formula fixed
      innobase/ut/ut0ut.c:
        Merge InnoDB-4.0.14: SAVEPOINT now implemented; InnoDB now accepts also column prefix keys; crashing bug in ON UPDATE CASCADE fixed; page checksum formula fixed
      8fe7e029
  34. 16 May, 2003 1 commit
    • unknown's avatar
      buf0lru.c, buf0flu.c, buf0buf.c, buf0lru.h: · e4a95f29
      unknown authored
        Search first only 10 % of the LRU list for a replaceable block before doing an LRU flush; enable again flushing of close pages also in a flush list (checkpointing) flush
      trx0trx.c:
        Add forgotten return value (it was not used anywhere, fortunately)
      ha_innodb.h, mysql_priv.h:
        Move declaration of srv_buf_pool_max_modified_pct to ha_innodb.h and enclose it to denote it is a C variable, not C++
      
      
      sql/mysql_priv.h:
        Move declaration of srv_buf_pool_max_modified_pct to ha_innodb.h and enclose it to denote it is a C variable, not C++
      sql/ha_innodb.h:
        Move declaration of srv_buf_pool_max_modified_pct to ha_innodb.h and enclose it to denote it is a C variable, not C++
      innobase/trx/trx0trx.c:
        Add forgotten return value (it was not used anywhere, fortunately)
      innobase/include/buf0lru.h:
        Search first only 10 % of the LRU list for a replaceable block before doing an LRU flush; enable again flushing of close pages also in a flush list (checkpointing) flush
      innobase/buf/buf0buf.c:
        Search first only 10 % of the LRU list for a replaceable block before doing an LRU flush; enable again flushing of close pages also in a flush list (checkpointing) flush
      innobase/buf/buf0flu.c:
        Search first only 10 % of the LRU list for a replaceable block before doing an LRU flush; enable again flushing of close pages also in a flush list (checkpointing) flush
      innobase/buf/buf0lru.c:
        Search first only 10 % of the LRU list for a replaceable block before doing an LRU flush; enable again flushing of close pages also in a flush list (checkpointing) flush
      e4a95f29
  35. 02 May, 2003 1 commit
    • unknown's avatar
      Many files: · 8d8f52e9
      unknown authored
        Eliminate the LOCK_log bottleneck in group commit in binlogging: flush InnoDB log files only after it has been released
      
      
      sql/log.cc:
        Eliminate the LOCK_log bottleneck in group commit in binlogging: flush InnoDB log files only after it has been released
      sql/handler.cc:
        Eliminate the LOCK_log bottleneck in group commit in binlogging: flush InnoDB log files only after it has been released
      sql/handler.h:
        Eliminate the LOCK_log bottleneck in group commit in binlogging: flush InnoDB log files only after it has been released
      sql/ha_innodb.cc:
        Eliminate the LOCK_log bottleneck in group commit in binlogging: flush InnoDB log files only after it has been released
      sql/ha_innodb.h:
        Eliminate the LOCK_log bottleneck in group commit in binlogging: flush InnoDB log files only after it has been released
      innobase/include/log0log.h:
        Eliminate the LOCK_log bottleneck in group commit in binlogging: flush InnoDB log files only after it has been released
      innobase/include/trx0trx.h:
        Eliminate the LOCK_log bottleneck in group commit in binlogging: flush InnoDB log files only after it has been released
      innobase/os/os0file.c:
        Eliminate the LOCK_log bottleneck in group commit in binlogging: flush InnoDB log files only after it has been released
      innobase/buf/buf0flu.c:
        Eliminate the LOCK_log bottleneck in group commit in binlogging: flush InnoDB log files only after it has been released
      innobase/trx/trx0trx.c:
        Eliminate the LOCK_log bottleneck in group commit in binlogging: flush InnoDB log files only after it has been released
      innobase/log/log0log.c:
        Eliminate the LOCK_log bottleneck in group commit in binlogging: flush InnoDB log files only after it has been released
      innobase/srv/srv0srv.c:
        Eliminate the LOCK_log bottleneck in group commit in binlogging: flush InnoDB log files only after it has been released
      innobase/row/row0mysql.c:
        Eliminate the LOCK_log bottleneck in group commit in binlogging: flush InnoDB log files only after it has been released
      8d8f52e9
  36. 24 Apr, 2003 1 commit
    • unknown's avatar
      ha_innodb.h, ha_innodb.cc: · 1e841480
      unknown authored
        Make ANALYZE TABLE to update index cardinality and other statistics also for an InnoDB table; note that the estimates are based on 10 random dives, not on an exhaustive read of the table
      
      
      sql/ha_innodb.cc:
        Make ANALYZE TABLE to update index cardinality and other statistics also for an InnoDB table; note that the estimates are based on 10 random dives, not on an exhaustive read of the table
      sql/ha_innodb.h:
        Make ANALYZE TABLE to update index cardinality and other statistics also for an InnoDB table; note that the estimates are based on 10 random dives, not on an exhaustive read of the table
      1e841480
  37. 23 Apr, 2003 1 commit
    • unknown's avatar
      Fixes for valgrind · 70324868
      unknown authored
      Added optimzation for clustered index
      Fixed bug in UPDATE ... ORDER BY
      Fixed handling of UPDATE ... LIMIT
      
      
      BitKeeper/deleted/.del-.cvsignore~7e29af89a3559f4c:
        Delete: Images/.cvsignore
      BitKeeper/deleted/.del-README~d5a4e7ca3a2e87a9:
        Delete: repl-tests/README
      BitKeeper/deleted/.del-run-all-tests~4deb6479a13e4568:
        Delete: repl-tests/run-all-tests
      BitKeeper/deleted/.del-run.test~3dc5b9bd1e9feea5:
        Delete: repl-tests/test-repl-alter/run.test
      BitKeeper/deleted/.del-run.test~4020771cff278f14:
        Delete: repl-tests/test-bad-query/run.test
      BitKeeper/deleted/.del-run.test~452f2b66537404a8:
        Delete: repl-tests/test-dump/run.test
      BitKeeper/deleted/.del-run.test~b1f0c1f96554df8:
        Delete: repl-tests/test-auto-inc/run.test
      BitKeeper/deleted/.del-table-dump-check.master~e13afeb8c79264b5:
        Delete: repl-tests/test-dump/table-dump-check.master
      BitKeeper/deleted/.del-table-dump-select.master~744acb955e33f3db:
        Delete: repl-tests/test-dump/table-dump-select.master
      BitKeeper/deleted/.del-x.master~29a93ed7956c8693:
        Delete: repl-tests/test-auto-inc/x.master
      BitKeeper/deleted/.del-x.master~3b248cbac9abda2b:
        Delete: repl-tests/test-bad-query/x.master
      BitKeeper/deleted/.del-foo-dump-master.master~b49ae6bec1e918ee:
        Delete: repl-tests/test-repl/foo-dump-master.master
      BitKeeper/deleted/.del-foo-dump-slave.master~f16ed20457d59be9:
        Delete: repl-tests/test-repl/foo-dump-slave.master
      BitKeeper/deleted/.del-repl-timestamp.master.reject~3492d2b74b413771:
        Delete: repl-tests/test-repl-ts/repl-timestamp.master.reject
      BitKeeper/deleted/.del-repl-timestamp.master~4b7782da5cc13161:
        Delete: repl-tests/test-repl-ts/repl-timestamp.master
      BitKeeper/deleted/.del-run.test~a1e32ea1e4253af4:
        Delete: repl-tests/test-repl/run.test
      BitKeeper/deleted/.del-run.test~ce5e626c91b760ec:
        Delete: repl-tests/test-repl-ts/run.test
      BitKeeper/deleted/.del-sum-wlen-master.master~1a5ea625c79e978:
        Delete: repl-tests/test-repl/sum-wlen-master.master
      BitKeeper/deleted/.del-sum-wlen-slave.master~f016d98833433084:
        Delete: repl-tests/test-repl/sum-wlen-slave.master
      BitKeeper/deleted/.del-test.master~5829e7b3770179db:
        Delete: repl-tests/test-repl-alter/test.master
      BitKeeper/deleted/.del-master-slave.inc~6775f6ae10137c39:
        Delete: repl-tests/include/master-slave.inc
      include/my_global.h:
        Fix for purify/valgrind
      myisam/mi_info.c:
        Updated comment
      mysql-test/r/group_by.result:
        New test results
      mysql-test/r/innodb.result:
        New test results
      mysql-test/r/join_outer.result:
        New test results
      mysql-test/r/multi_update.result:
        New test results
      mysql-test/r/null_key.result:
        New test results
      mysql-test/r/update.result:
        New test results
      mysql-test/t/group_by.test:
        Added extra explain to 'suspicious' test.
      mysql-test/t/innodb.test:
        Added test for UPDATE ... ORDER BY
      mysql-test/t/join_outer.test:
        Changed test to be repeatable
      mysql-test/t/multi_update.test:
        Slight change of test to catch more bugs
      mysql-test/t/update.test:
        Better test for UPDATE ... ORDER BY
      sql/field.cc:
        Simple optimization
      sql/ha_heap.h:
        Added optimzation for clustered index
      sql/ha_innodb.cc:
        Added optimzation for clustered index
      sql/ha_innodb.h:
        Added optimzation for clustered index
      sql/handler.h:
        Added optimzation for clustered index
      sql/item_sum.cc:
        Removed some usage of current_thd
      sql/mysqld.cc:
        Fix bug when compiling for purify/valgrind
      sql/opt_range.cc:
        Added optimzation for clustered index
      sql/records.cc:
        Fixed comment
      sql/sql_list.h:
        Fixed comment
      sql/sql_select.cc:
        Removed some usage of current_thd
      sql/sql_select.h:
        Removed some usage of current_thd
      sql/sql_union.cc:
        Removed some usage of current_thd
      sql/sql_update.cc:
        Fixed bug in UPDATE ... ORDER BY
        Fixed handling of UPDATE ... LIMIT
      support-files/my-huge.cnf.sh:
        Added default size for query cache
      support-files/my-large.cnf.sh:
        Added default size for query cache
      70324868
  38. 18 Apr, 2003 1 commit
    • unknown's avatar
      ha_innodb.h, ha_innodb.cc: · 46438203
      unknown authored
        Make InnoDB to restore old active_index value after a table scan: MySQL may assume that a scan does NOT change active_index; this partially fixes bug 241 of UPDATE ... ORDER BY ... but it still remains that MySQL actually ignores the ORDER BY for both MyISAM and InnoDB tables
      log0recv.c:
        Use fflush to make sure report of a corrupt log record is printed to .err log before mysqld crashes
      
      
      innobase/log/log0recv.c:
        Use fflush to make sure report of a corrupt log record is printed to .err log before mysqld crashes
      sql/ha_innodb.cc:
        Make InnoDB to restore old active_index value after a table scan: MySQL may assume that a scan does NOT change active_index; this partially fixes bug 241 of UPDATE ... ORDER BY ... but it still remains that MySQL actually ignores the ORDER BY for both MyISAM and InnoDB tables
      sql/ha_innodb.h:
        Make InnoDB to restore old active_index value after a table scan: MySQL may assume that a scan does NOT change active_index; this partially fixes bug 241 of UPDATE ... ORDER BY ... but it still remains that MySQL actually ignores the ORDER BY for both MyISAM and InnoDB tables
      46438203