… ext -ri10 +———————————–+———————-+ | Variable_name | Value | +———————————–+———————-+ | Aborted_clients | 205174 | | Aborted_connects | 29 | | Binlog_cache_disk_use | …tweaking one will often have effects on the others. Each …
Comment: How fast is FLUSH TABLES WITH READ LOCK?
… “Backup failed: MySQL has gone away” or something to that effect. Eventually I realized what had happened. The previous day I… complete, so I aborted with Ctrl-C. In fact, in that version of MySQL, this only caused the client to exit, and… WITH READ LOCK. It immediately acquired locks on all tables — effectively write locks, as you say — except this one log table…

