… indexes were temporarily dropped and then recreated using fast index creation; dumps produced by mysqldump first create tables with all secondary indexes… indexes will obviously take longer. Another important thing that is worth mentioning is fragmentation. Fast index creation results in much less fragmented…_options: Comment: 1 row in set (0.01 sec) mysqldump Quoting the fast index creation chapter in the MySQL manual: “… you can…
Post: Interested to learn about New Innodb Plugin Performance ?
April 15, 2008 By 2 Comments
… 24 hours) as well as performance improvements to compression and fast index build functionality. As it is now publicly released we… data load tools (mysqldump import, using LOAD DATA INFILE or ALTER TABLE from other storage engine) would use Fast Innodb Index creation. Keep…
Post: MySQL Backup tools used by Percona Remote DBA for MySQL
March 13, 2013 By 8 Comments
…. Mydumper for logical backups Strong Points: Very fast for logical backups – compared to mysqldump Consistent backups between myisam and innodb tables. Global… is not encrypted before transfer Monitoring Monitoring is the most important piece to tie all of these process together. We employ…
Post: Predicting how long data load would take
May 24, 2007 By 14 Comments
… is very fast and Innodb can use insert buffer for them. Data Insert Order It is well known it is important to… quick do it on decent hardware. Especially memory size is important. If you need database on some small box it may… because of easier parsing. Mysqldump however takes care of special options to make multi value inserts as fast as possible as well…
Post: How to create/restore a slave using GTID replication in MySQL 5.6
February 8, 2013 By 7 Comments
…+—————+——————————————+ Now we take a backup with mysqldump from the master: # mysqldump –all-databases –single-transaction –… First we have the bad and fast way, that is, point to …EXECUTED is empty. [...] Wop! It is important to mention that these kind …
Post: Impossible - possible, moving InnoDB tables between servers
June 8, 2009 By 9 Comments
…one server to another and answer “use mysqldump” is quite disappointed. Jokes aside, I …import tablespace; 7) enjoy progress in error.log like: InnoDB: import: extended import of test/img_out59 InnoDB: import… just need to shutdown instance with innodb_fast_shutdown=1 (done in xtrabackup –prepare –…
Post: How would you compress your MySQL Backup
June 5, 2008 By 29 Comments
…this point for databases of decent size. Two important compression questions you need to decide for … but it looks like LZO uses relatively fast compression by default already. With real server …server for backups. I should also note for mysqldump backup typically tools with better and slower …
Post: Percona Server 5.1.56-12.7
April 18, 2011 By Leave a Comment
….1 series. New Features Expanded the applicability of InnoDB fast index creation to mysqldump, ALTER TABLE and, OPTIMIZE TABLE. (Alexey Kopytov) Variables…. (Yasufumi Kinoshita) Bug #727704 – When using the Expand Table Import feature, importing .ibd files created on MySQL 5.0 or Percona Server…
Post: Living with backups
November 6, 2008 By 28 Comments
… by my last sentence, but it is not important right now. Either way the data is out … queries against each table in the database when mysqldump is used or reading a lot of data … conflict between the regular database activities, which need fast response times, and doing backups which would gladly …
Post: Percona Server and XtraBackup weekly news, April 4th
April 4, 2011 By 1 Comment
… baseline for Percona Server, we think that it is extremely important to continue developing Percona Server, we don’t see the… a Release Candidate. (Full details). Alexey made Percona Server use “fast index creation” for ALTER TABLE and OPTIMIZE TABLE, which can… result in less fragmented indexes. He also improved mysqldump so indexes are created with “fast index creation” when restoring a dump, which…
