5 ms·
Is the FB branch version of mysqldump still single threaded? How do you cope with that? I currently "fake it", using "START TRANSACTION WITH CONSISTENT SNAPSHO
by mathnode 10y ago
Is the FB branch version of mysqldump still single threaded? How do you cope with that?
I currently "fake it", using "START TRANSACTION WITH CONSISTENT SNAPSHOT", with multiple mysqldump processes running, where I can't get mydumper deployed.
- jivid 10y agoWe run a single mysqldump with --single-transaction for each database on the server, nothing special.
- mathnode 10y agoThanks, how big is a single instance? All out to a single file?
- jivid 10y agoInstance size varies a lot because we've got a lot of different MySQL workloads, some with very different configurations. Remember we're backing up each database separately though, not the entire MySQL instance at once. Each database's backup is in a separate file.
- mathnode 10y agoThanks