June 19, 2013

Post: How Percona does a MySQL Performance Audit

Many people…, too. …mysql –user=mysql –pid-file=/var/run/mysqld/mysqld.pid –skip-external-locking –port=3306 –socket=/var/db/mysql/mysql… | Variable_name | Value | +———————————–+———————-+ | Aborted_clients | 205174 | | Aborted_connects | 29 | | Binlog_…

Comment: How fast is FLUSH TABLES WITH READ LOCK?

… lost. Then I received an e-mail, saying “Backup failed: MySQL has gone away” or something to that effect. Eventually I… took too long to complete, so I aborted with Ctrl-C. In fact, in that version of MySQL, this only caused the client to… manually, because the statistics-gathering query I ran was taking many hours to run. Some convoluted thing with a subquery, if…