… page 7. InnoDB: You may have to recover from a backup. 080703 23:46:16 InnoDB: Page dump in ascii and… the old table in case you will need to look into it more later. Another alternative is to dump table with MySQLDump and load it back. It is all pretty much the same stuff. I’m using MyISAM table for…
Post: Side load may massively impact your MySQL Performance
November 13, 2011 By 7 Comments
… when some heavy queries are ran in background or backup is done with mysqldump – a lot more than you would expect from…’re running uniform sysbench OLTP on the small table and mysqldump on the second table. First we run tests individually and when concurrently… of sysbench OLTP on small table drops more than 150 times when heavy mysqldump is running concurrently. mysqldump itself also slows down about…
Post: How to create/restore a slave using GTID replication in MySQL 5.6
February 8, 2013 By 7 Comments
…:1-2 | +—————+——————————————+ Now we take a backup with mysqldump from the master: # mysqldump –all-databases –single-transaction –triggers –routines –…table-checksum and pt-table-sync. How to restore a slave in a good and slow way The good way is mysqldump…
Post: Should you move from MyISAM to Innodb ?
January 12, 2009 By 59 Comments
… to deal with recovering tables on the crash or partially executed statements. Table locks is no more problem, hot backups are easy, though…. Backup tools like “mysqlhotcopy” does not work etc. Note Performance also affects Operations aspects a lot – for example using mysqldump as a backup…
Comment: An argument for not using mysqldump
November 8, 2010 By 26 Comments
There are two alternatives, one using mysqldump and one not. Option 1 (using mysqldump) Write a customized backup script 1) Extract the names of all databases (except mysql and information_schema) 2) FLUSH TABLES WITH…
Comment: An argument for not using mysqldump
November 8, 2010 By 26 Comments
… to make sure that you hold a lock after FLUSH TABLES WITH READ LOCK, so in command line scripting you need… this article. mysqldump needs to churn all the data through the buffer pool (something often undesired), and the backup as you described… – but this synchronizes the backup to the start of running mysqldump. Xtrabackup synchronizes with the end of the backup, which is probably the…
Comment: Using LVM for MySQL Backup and Replication Setup
August 18, 2011 By 53 Comments
…volume group they are residing in , now taking a mysqldump is a long process and can’t afford the…lvm snapshot . So i can easily lock the mysql tables and take a lvm snapshot with lvcreate in a…then becomes even more challenging to save that tar backup else where especially when you dont have space on…
Comment: Is DRBD the right choice for me?
December 12, 2012 By 18 Comments
… post but I thought I would mention that mysqldump is rarely a great backup solution beyond a couple tens of GB of…) MyISAM tables you can’t convert to InnoDB due to using FULLTEXT/RTREE index, you might use LVM snapshots rather than mysqldump –single-transaction or xtrabackup. (though xtrabackup can copy your MyISAM tables, it holds a lock while…
Comment: Should you move from MyISAM to Innodb ?
February 1, 2010 By 59 Comments
… on mysqldump and innodb file-per table. Our “Database File-Per-Table Archives” web site summarizes like this: “31 Hosts 90 Databases 2919 Tables 91 Dates 354456 Backup Files…
Post: Detailed review of Tokutek storage engine
April 28, 2009 By 21 Comments
… ways to do a backup is mysqldump/mysqlhotcopy. It is not fully transparent backup, as it applied TABLE LOCK on copying table. When recovery logs are supported, I guess it will be possible to run LVM backup. Actually I would say backup is…
