1. 10 Nov, 2004 1 commit
    • guilhem@mysql.com's avatar
      WL#1596 "make mysqldump --master-data --single-transaction able to do online... · 6cd218cc
      guilhem@mysql.com authored
      WL#1596 "make mysqldump --master-data --single-transaction able to do online dump of InnoDB AND report reliable
      binlog coordinates corresponding to the dump".
      The good news is that now mysqldump can be used to get an online backup of InnoDB *which works for
      point-in-time recovery and replication slave creation*. Formerly, mysqldump --master-data --single-transaction
      used to call in fact mysqldump --master-data, so the dump was not an online dump (took big lock all time of dump).
      The only lock which is now taken in this patch is at the beginning of the dump: mysqldump does:
      FLUSH TABLES WITH READ LOCK; START TRANSACTION WITH CONSISTENT SNAPSHOT; SHOW MASTER STATUS; UNLOCK TABLES;
      so the lock time is in fact the time FLUSH TABLES WITH READ LOCK takes to return (can be 0 or very long, if
      a table is undergoing a huge update).
      I have done some more minor changes listed in the paragraph of mysqldump.c.
      WL#2237 "WITH CONSISTENT SNAPSHOT clause for START TRANSACTION":
      it's a START TRANSACTION which additionally starts a consistent read on all
      capable storage engine (i.e. InnoDB). So, can serve as a replacement for
      BEGIN; SELECT * FROM some_innodb_table LIMIT 1; which starts a consistent read too. 
      6cd218cc
  2. 08 Nov, 2004 1 commit
    • guilhem@mysql.com's avatar
      As rollback can be 30 times slower than insert in InnoDB, and user may · 0517e7b2
      guilhem@mysql.com authored
      not know there's rollback (if it's because of a dupl row), better warn
      that it's happening. It can also be of use for a DBA killing a
      connection and wondering what this connection is still doing now. Example:
      |  5 | root | localhost | test | Killed  | 10   | Rolling back | insert into i select * from j |
      0517e7b2
  3. 03 Nov, 2004 7 commits
  4. 02 Nov, 2004 24 commits
  5. 01 Nov, 2004 7 commits