enterprise-support team mailing list archive

[Daniel Black <1292279@xxxxxxxxxxxxxxxxxx>]

Public bug reported:

Thanks so much for the less-locking option in mydumper-0.6.

I'm wondering if in this less-locking mode (or generally) if the FLUSH
TABLES WITH READ LOCK, can be replaced by FLUSH TABLES {iterative list
of non-Innodb tables} WITH READ LOCK? This may require something
specific for the binlog handling for innodb tables.

The FLUSH TABLES for EXPORT ( https://mariadb.com/kb/en/flush-tables-
for-export/ ) in mariadb-10.x looks promising too though I can't quite
tell what the remaining global read/write access is left on these
tables.

** Affects: mydumper
     Importance: Undecided
         Status: New

-- 
You received this bug notification because you are a member of Ubuntu
Server/Client Support Team, which is subscribed to MySQL.
Matching subscriptions: Ubuntu Server/Client Support Team
https://bugs.launchpad.net/bugs/1292279

Title:
  flush tables db.tb1, db.tbl2 with read lock

To manage notifications about this bug go to:
https://bugs.launchpad.net/mydumper/+bug/1292279/+subscriptions