If you’re just running innodb, you can run mysqldump with the –singletransaction flag which will get you a consistent … flush tables with read lock, but to do this right you have to hold the lock until your dump completes. A read lock is…” via this method. You’re locked up for flush time + snap time. If you’re pure innodb, I generally trust its recovery…
Comment: Best kept MySQLDump Secret
March 29, 2012 By 13 Comments
…while mysqldump is going , alter table was BLOCKED! Eventually mysqldump got the old table definition and old data in it. DROP TABLE IF…InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; — – Dumping data for table `z` — LOCK TABLES `z` WRITE; /*!40000 ALTER TABLE…
Comment: Faster MySQL failover with SELECT mirroring
February 1, 2009 By 9 Comments
…) use mysqldump with the lock all tables option (this is an outage) 3) if you’re using LVM, FLUSH TABLES WITH READLOCK … snap … RELEASE LOCK (this is a very brief outage) If you’re using innodb, you can just… site with a large number of myisam tables that we’re seriously considering moving to innodb; myisam has a lot of issues…
Comment: MySQL Server Memory Usage
May 17, 2006 By 21 Comments
… = /var/lib/mysql tmpdir = /tmp skip-locking key_buffer = 384M max_allowed_packet = 1M table_cache = 512 sort_buffer_size = 2M read… = 11468M #innodb_log_file_size = 2867M #innodb_log_buffer_size = 8M #innodb_flush_log_at_trx_commit = 1 #innodb_thread_concurrency = 8 [mysqldump] quick max…
Comment: How fast is FLUSH TABLES WITH READ LOCK?
April 24, 2010 By 30 Comments
… be worthwhile to note that even for InnoDB-only systems, using FLUSH TABLES WITH READ LOCK may be a requirement: in the case…’e doing “mysqldump –single-transaction –master-data” – you’re good. But a mylvmbackup would have to use the FLUSH TABLES… in order…
