… | | 10290 | root | localhost | NULL | Query | 317 | Waiting for table flush | flush tables with read lock | 0 | 0 | 1 | | 10291 | root | localhost | dumptest | Query… for table flush | flush tables with read lock | 0 | 0 | 1 | | 10291 | root | localhost | dumptest | Query | 74 | Waiting for global read lock | insert into… gridlock one way or another. If you’re just using Innodb tables and you’re not actively changing users, stored procedures…

… that is derived from that. Essentially, we are using FLUSH TABLES WITH READ LOCK, and then run ‘lvcreate -s’ to create a… of the innodb in the target location fails, though, even though it has been made even under FLUSH TABLES WITH READ LOCK (I…. We are now using ‘service mysql stop’ instead of FLUSH TABLES WITH READ LOCK to get reliable snapshots from a donor box.

Davi, Yes. However for Innodb tables FLUSH TABLE is nil – so what we care about is just about Locking the table to prevent… FLUSH TABLES WITH READ LOCK suppose to flush tables not just make them read only. Most tools however do not need FLUSH PART (for Innodb tables) and might be we just need different command which locks table read only without flushing.

… us using FLUSH TABLES WITH READ LOCK. 1. copy meta data files, like frm file. 2. copy data files other than InnoDB. 3… requirements, we can do a hot backup without using FLUSH TABLES WITH READ LOCK: 1. do not do any ddl operations in… file and binlog postion information from xtrabackup_binlog_pos_innodb file since InnoDB will wirte these information in its commit log. Am…

…going down. What you might see instead is flushing tables regularly or reducing table cache … 7234 TABLE_SCHEMA: test TABLE_NAME: my ENGINE: InnoDB NAME: #sql516_1c42_2 TABLE_ROWS: …509995888 + 2623331) File system 294352 (82672 + 211680) Lock system 318875832 (318747272 + 128560) Recovery system 0 (0…

… you mean by “snapshot what is recoverable”. Even without Flush tables with read lock, LVM snapshot should be recoverable 100% of the… partition or synchronization of binary log and innodb snapshot. In certain versions FLUSH TABLES WITH READ LOCK would not block “commit” operation which…

… with FLUSH TABLES WITH READ LOCK you are getting in some cases a snapshot that is not recoverable. Apparently, FTWRL locks frontend threads, but some backend InnoDB… snapshot implemented? Is it not atomic in itself, so that InnoDB file writes can happen while the snapshot it being made…

… bug or user error. I think the innodb data from the backup where Innodb fails to recover should be passed to your support provider for investigation. It might be related to Innodb itself or how XFS plays with LVM or something. As… problems which are not handled if you have DDL however FLUSH TABLES WITH READ LOCK should prevent these.

…, where InnoDB file writes can be altogether disabled using a global variable setting? For InnoDB based databases, this allows for immediate locking of writes, safe BINLOG position snapshot, no waiting on read-queries, and no actual flushing…