June 20, 2013

Post: How Percona does a MySQL Performance Audit

… 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…