1. 27 Oct, 2004 2 commits
    • unknown's avatar
      Change 'Build-tools/mysql-copyright' to ensure the receiving machines will build · d4342115
      unknown authored
      without trying to re-run autotools.
      (Backport from 4.1.7 for 4.0.22)
      
      
      Build-tools/mysql-copyright:
        The top level Makefile will try to re-run the autotools unless the timestamps of the
        relevant files are in truly ascending order. Ensure this order!
        (Backport from 4.1.7 for 4.0.22)
      d4342115
    • 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
  2. 24 Oct, 2004 1 commit
  3. 22 Oct, 2004 5 commits
    • unknown's avatar
      postreview fixes · 5ab6c5e5
      unknown authored
      
      sql/mysql_priv.h:
        constant definition
      sql/sql_base.cc:
        difine used instead of constant
      sql/sql_cache.cc:
        difine used instead of constant
        typo fixed
      5ab6c5e5
    • unknown's avatar
      Merge sanja.is.com.ua:/home/bell/mysql/bk/mysql-4.0 · a6efe82f
      unknown authored
      into sanja.is.com.ua:/home/bell/mysql/bk/work-qc-4.0
      
      
      a6efe82f
    • unknown's avatar
      Merge sanja.is.com.ua:/home/bell/mysql/bk/mysql-4.0 · b8847967
      unknown authored
      into sanja.is.com.ua:/home/bell/mysql/bk/work-4.0
      
      
      b8847967
    • unknown's avatar
      Part of fix for bug #6081 "Call to deprecated mysql_create_db() function · dd126ba1
      unknown authored
      crashes server"
      
      (in 4.0 we fix only connection stalling in case of error, crash itself is
      fixed in 4.1, the test case for this code is also there).
      
      
      sql/sql_parse.cc:
        Handling of COM_CREATE_DB, COM_DROP_DB:
        We should call send_error() if mysql_create_db or mysql_drop_db
        return error (like we do it for SQL versions of these commands).
      dd126ba1
    • unknown's avatar
      os0file.c: · f18efec5
      unknown authored
        Add typecast from ulint to ssize_t in pread and pwrite, so that the type is according to the Linux man page; this will probably not help to fix the HP-UX 32-bit pwrite failure, since the compiler should do the appropriate typecasts anyway
      
      
      innobase/os/os0file.c:
        Add typecast from ulint to ssize_t in pread and pwrite, so that the type is according to the Linux man page; this will probably not help to fix the HP-UX 32-bit pwrite failure, since the compiler should do the appropriate typecasts anyway
      f18efec5
  4. 21 Oct, 2004 2 commits
    • unknown's avatar
      row0mysql.c, row0ins.c: · 4f84f90f
      unknown authored
        Fix bug #5961: release the dictionary latch during a long cascaded FOREIGN KEY operation, so that we do not starve other users
      
      
      innobase/row/row0ins.c:
        Fix bug #5961: release the dictionary latch during a long cascaded FOREIGN KEY operation, so that we do not starve other users
      innobase/row/row0mysql.c:
        Fix bug #5961: release the dictionary latch during a long cascaded FOREIGN KEY operation, so that we do not starve other users
      4f84f90f
    • unknown's avatar
      Check of temporary tables hiding for query fetched from QC (BUG#6084) · e6e1600e
      unknown authored
      
      mysql-test/r/query_cache.result:
        hiding real table stored in query cache by temporary table
      mysql-test/t/query_cache.test:
        hiding real table stored in query cache by temporary table
      sql/sql_cache.cc:
        Check of temporary tables hiding for query fetched from QC
      sql/sql_cache.h:
        Key length now stored in table record of query cache
      e6e1600e
  5. 20 Oct, 2004 3 commits
    • unknown's avatar
      Fix test case for innodb-lock · ec8779e9
      unknown authored
      
      mysql-test/r/innodb-lock.result:
        Fix test case (old one didn't test things correctly)
      mysql-test/t/innodb-lock.test:
        Fix test case (old one didn't test things correctly)
      mysys/thr_lock.c:
        More debugging information
      sql/mysqld.cc:
        Enable innodb_table_locks as default, as otherwise there is a possibility for deadlocks
      sql/sql_base.cc:
        More debug information
      ec8779e9
    • unknown's avatar
      Merge bk-internal.mysql.com:/home/bk/mysql-4.0 · 95f0e39a
      unknown authored
      into mysql.com:/home/my/mysql-4.0
      
      
      libmysql/libmysql.c:
        Auto merged
      95f0e39a
    • unknown's avatar
      Code cleanups (done during review of new code) · ed8ec2cf
      unknown authored
      Rename innodb_table_locks_old_behavior -> innodb_table_locks
      Set innodb_table_locks to off by default to get same behaviour as in MySQL 4.0.20
      (This means that Innodb ignore table locks by default, which makes it easier to combine MyISAM and InnoDB to simulate a transaction)
      
      
      libmysql/libmysql.c:
        Use ulong instead of unsigned long
        Reuse _dig_vec()
      myisam/myisampack.c:
        Simplify code
      mysql-test/r/innodb-lock.result:
        new test case
      mysql-test/t/innodb-lock.test:
        new test case
      sql/ha_innodb.cc:
        Rename innodb_table_locks_old_behavior -> innodb_table_locks
      sql/mysqld.cc:
        Rename innodb_table_locks_old_behavior -> innodb_table_locks
        Set this off by default to get same behaviour as in MySQL 4.0.20
      sql/set_var.cc:
        Rename innodb_table_locks_old_behavior -> innodb_table_locks
      sql/sql_class.h:
        Rename innodb_table_locks_old_behavior -> innodb_table_locks
      ed8ec2cf
  6. 19 Oct, 2004 4 commits
    • unknown's avatar
      trx0rec.c: · 0e0c9af5
      unknown authored
        test
      
      
      innobase/trx/trx0rec.c:
        test
      0e0c9af5
    • unknown's avatar
      libmysql.c: · 30d33c71
      unknown authored
        Add note to mysql_hex_string() comment.
      
      
      libmysql/libmysql.c:
        Add note to mysql_hex_string() comment.
      30d33c71
    • unknown's avatar
      fixed retsult code · 43245198
      unknown authored
      43245198
    • unknown's avatar
      libmysql.c: · 2428fb5c
      unknown authored
        New function mysql_hex_string()
      
      
      libmysql/libmysql.c:
        New function mysql_hex_string()
      2428fb5c
  7. 17 Oct, 2004 2 commits
    • unknown's avatar
      Merge dellis@bk-internal.mysql.com:/home/bk/mysql-4.0 · 38e717ea
      unknown authored
      into goetia.(none):/home/dellis/mysqlab/bk/mysql-4.0
      
      
      BitKeeper/etc/logging_ok:
        auto-union
      sql/mysqld.cc:
        Auto merged
      38e717ea
    • unknown's avatar
      mysqld.cc: · 5dfa8d85
      unknown authored
        BUG #5731 key_buffer_size not properly restricted to 4GB; use UINT_MAX32 for clarity.
      
      
      sql/mysqld.cc:
        BUG #5731 key_buffer_size not properly restricted to 4GB; use UINT_MAX32 for clarity.
      5dfa8d85
  8. 16 Oct, 2004 2 commits
  9. 15 Oct, 2004 2 commits
  10. 14 Oct, 2004 2 commits
    • unknown's avatar
      Merge mysql.com:/home/mydev/mysql-4.0 · c461eb86
      unknown authored
      into mysql.com:/home/mydev/mysql-4.0-bug5625
      
      
      sql/ha_myisam.cc:
        Auto merged
      sql/sql_table.cc:
        Auto merged
      c461eb86
    • unknown's avatar
      BUG#5625 - MyISAM Index corruption on ALTER TABLE x ENABLE KEYS due to full tmpdir. · fc27da08
      unknown authored
      Added a try to a normal repair() if repair_by_sort() failed.
      This was not done with ENABLE KEYS and OPTIMIZE TABLE.
      Fixed error code handling in mysql_alter_table().
      
      
      sql/ha_myisam.cc:
        BUG#5625 - MyISAM Index corruption on ALTER TABLE x ENABLE KEYS due to full tmpdir.
        Added a try to a normal repair() if repair_by_sort() failed.
        This was not done with ENABLE KEYS and OPTIMIZE TABLE.
      sql/sql_table.cc:
        BUG#5625 - MyISAM Index corruption on ALTER TABLE x ENABLE KEYS due to full tmpdir.
        Added a translation from 'bool' return value to '< 0' error indication,
        which is used within mysql_execute_command() and must as such be
        handed over by mysql_alter_table(). A returncode >= 0 is interpreted
        as 'I have already called send_ok()'.
      fc27da08
  11. 13 Oct, 2004 1 commit
    • unknown's avatar
      Added startup option and settable session variable · f0ed73d8
      unknown authored
      innodb_table_locks_old_behavior: do not acquire an
      InnoDB table lock for LOCK TABLES, as in mysql-4.0.18
      and earlier.
      
      
      sql/ha_innodb.cc:
        Do not acquire an InnoDB table lock for LOCK TABLES if
        innodb_table_locks_old_behavior is enabled.
      sql/mysqld.cc:
        Added innodb_table_locks_old_behavior
      sql/set_var.cc:
        Added innodb_table_locks_old_behavior
      sql/sql_class.h:
        Added innodb_table_locks_old_behavior
      f0ed73d8
  12. 12 Oct, 2004 2 commits
    • unknown's avatar
      ha_innodb.cc: · eb3b0480
      unknown authored
        Change error code to HA_ERR_ROW_IS_REFERENCED if we cannot DROP a parent table referenced by a FOREIGN KEY constraint; this error number is less misleading than the previous value HA_ERR_CANNOT_ADD_FOREIGN, but misleading still; we should introduce to 5.0 a proper MySQL error code
      
      
      sql/ha_innodb.cc:
        Change error code to HA_ERR_ROW_IS_REFERENCED if we cannot DROP a parent table referenced by a FOREIGN KEY constraint; this error number is less misleading than the previous value HA_ERR_CANNOT_ADD_FOREIGN, but misleading still; we should introduce to 5.0 a proper MySQL error code
      eb3b0480
    • unknown's avatar
      Merge heikki@build.mysql.com:/home/bk/mysql-4.0 · c061a812
      unknown authored
      into hundin.mysql.fi:/home/heikki/mysql-4.0
      
      
      c061a812
  13. 11 Oct, 2004 3 commits
    • unknown's avatar
      Merge spetrunia@bk-internal.mysql.com:/home/bk/mysql-4.0 · eb107ffe
      unknown authored
      into mysql.com:/mnt/tmp/mysql-4.0-bug-myisampack
      
      
      eb107ffe
    • unknown's avatar
      Merge gbichot@bk-internal.mysql.com:/home/bk/mysql-4.0 · a66a4dfb
      unknown authored
      into mysql.com:/home/mysql_src/mysql-4.0
      
      
      a66a4dfb
    • unknown's avatar
      Fix for BUG#5949 "error code 1223 in binlog when using innobackup": · c5f9a412
      unknown authored
      when one connection had done FLUSH TABLES WITH READ LOCK, some updates, and then COMMIT,
      it was accepted but my_error() was called and so, while client got no error, error was logged in binlog.
      We now don't call my_error() in this case; we assume the connection know what it does.
      This problem was specific to 4.0.21. The change is needed to make replication work with existing versions of innobackup.
      
      
      sql/lock.cc:
        If a connection has done FLUSH TABLES WITH READ LOCK and now is doing COMMIT, don't give error
        (applies only if it's the same connection; others' COMMITs are still blocked).
      c5f9a412
  14. 09 Oct, 2004 1 commit
    • unknown's avatar
      trx0rec.c: · 2763d893
      unknown authored
        Fix bug #5960: if one updated a column so that its size changed, or updated it to an externally stored (TEXT or BLOB) value, then ANOTHER externally stored column would show up as 512 bytes of good data + 20 bytes of garbage in a consistent read that fetched the old version of the row
      
      
      innobase/trx/trx0rec.c:
        Fix bug #5960: if one updated a column so that its size changed, or updated it to an externally stored (TEXT or BLOB) value, then ANOTHER externally stored column would show up as 512 bytes of good data + 20 bytes of garbage in a consistent read that fetched the old version of the row
      2763d893
  15. 08 Oct, 2004 1 commit
  16. 07 Oct, 2004 2 commits
    • unknown's avatar
      Fixed Bug#5575, mysqlhotcopy is broken when using --noindices · 66bdcf84
      unknown authored
      
      BitKeeper/etc/logging_ok:
        Logging to logging@openlogging.org accepted
      66bdcf84
    • unknown's avatar
      InnoDB: tolerate system clock glitches a little better · 7949ffc8
      unknown authored
      in the error monitor thread.  (Bug #5898)
      
      
      innobase/include/sync0arr.h:
        sync_array_print_long_waits(): return error status
      innobase/srv/srv0srv.c:
        srv_error_monitor_thread(): Keep track on successive fatal timeouts,
        and crash the server only if the timeouts have been exceeded for
        several times in succession.
      innobase/sync/sync0arr.c:
        sync_array_print_long_waits(): return error status
      7949ffc8
  17. 06 Oct, 2004 3 commits
  18. 05 Oct, 2004 2 commits
    • unknown's avatar
      Merge bk-internal.mysql.com:/home/bk/mysql-4.0 · 4d93bb95
      unknown authored
      into mysql.com:/home/my/mysql-4.0
      
      
      sql/sql_table.cc:
        Auto merged
      4d93bb95
    • unknown's avatar
      Reverted patch for new usage of open_count as it caused more problems than it solved · 0d76cb7e
      unknown authored
      Cleaned up patch for checking locks for multi-table updates
      
      
      myisam/mi_close.c:
        Reverted patch for new usage of open_counts
      myisam/mi_locking.c:
        Reverted patch for new usage of open_counts
      sql/ha_myisam.cc:
        Reverted patch for new usage of open_counts
      sql/handler.cc:
        Removed compiler warning
      sql/sql_acl.cc:
        Removed compiler warning
      sql/sql_table.cc:
        No need to unlock after failed call to external_lock()
      sql/sql_update.cc:
        Cleaned up (and made it more secure) patch for checking locks for multi-table updates
      0d76cb7e