… very heavy queries against each table in the database when mysqldump is used or reading a lot of data when copying… be done about it? Nothing really when you are using mysqldump. You can play some tricks, but it’s mostly beyond… is also a utility called ionice. It allows to affect how I/O scheduler will be dealing with I/O request…
Post: MySQL Workshops: Chicago & London this April
March 15, 2013 By Leave a Comment
…InnoDB data, and describe the advantages of common backup methods (mysqldump, file system snapshot, InnoDB hot backup). Setup and administer MySQL…from InnoDB and make informed decisions while changing configuration. Discover how Percona Server with XtraDB can provide better diagnostics and …
Post: 10 things you need to know about backup solutions for MySQL
March 3, 2009 By 23 Comments
…, etc? What technique is used for the backup? Is it mysqldump or a custom product that does something similar? Is it… system guarantee that you can perform point-in-time recovery? How does the system guarantee consistency with the binary log, InnoDB… very application-dependent and technology-dependent. Unless I know exactly how it works, I cannot tell the client whether it’ll…
Post: MySQL Upgrade Webinar Questions Followup
June 28, 2012 By 7 Comments
… is exactly how it is done in many cases. There is really no gain in dumping table via mysqldump and loading it… replication mode if you have something substantial to gain. Q: How would Upgrade work if Old Server has Antelope format and… in the environment which is maximally close to production. Q: How safe is it to upgrade from MySQL 5.5 to…
Comment: How to lag a slave behind to avoid a disaster
September 11, 2012 By 5 Comments
Sadly, you have to know how long you want a delay for. An hour? 4 days? … was, due to backups. I always make logical (export with mysqldump) backups and physical backups, so that if I just need… a difficult problem to solve. What if replication breaks entirely? how are you monitoring that?
Post: Recovery after DROP & CREATE
August 22, 2012 By 1 Comment
… one is created with the same name. This is because mysqldump in many cases generates the “DROP TABLE” instruction before the…” actor 200 “THORA” “TEMPLE” “2006-02-15 04:34:33″ How does the following “CREATE TABLE” make the recovery any harder…_INDEX/0-18/9733-00009792.page matches Earlier Aurimas explained how to deal with tables with binary only values This method…
Post: Shard-Query turbo charges Infobright community edition (ICE)
May 6, 2011 By 23 Comments
… with all MySQL storage engines. This set of benchmarks evaluates how well Infobright community edition (ICE) performs in combination with Shard… I dumped the data to tab delimited flat files using mysqldump. I started by loading the raw data from the BTS… 1 ORDER BY c LIMIT 10; The next queries show how performance is improved when Shard-Query adds parallelism when “subqueries…
Post: Baron Schwartz interviewed on WebPulp.tv
November 1, 2010 By 2 Comments
… to do it, how to think logically about performance optimization, what ugly surprises happen when you set up mysqldump backups and forget… show. He’s a web engineer himself, and he knows how to ask probing questions that bring out a lot of…
Post: Detailed review of Tokutek storage engine
April 28, 2009 By 21 Comments
… Stony Brook, Rutgers, and MIT). I can’t say exactly how it is improved, because the engine itself is closed source… a release soon. – The ways to do a backup is mysqldump/mysqlhotcopy. It is not fully transparent backup, as it applied… in MySQL 6.0, but I can’t yet say how it will work with mix of storage engines. – The Tokutek…
Post: Recovering Innodb table Corruption
July 4, 2008 By 22 Comments
… it more later. Another alternative is to dump table with MySQLDump and load it back. It is all pretty much the… was OK. Again using binary search you can find out how many rows do you need to skip exactly to recover… make sure indexes are not corrupted. So we looked at how to get your data back from simple Innodb Table Corruption…
