… MySQL manual, especially the option …Com_resignalblogpercona.commanual Com_restore_tableblogpercona.commanual Com_revokeblogpercona…commanual flush_timeblogpercona.commanual foreign_key_checksblogpercona.commanual ft_boolean…scanblogpercona.commanual sporadic_binlog_dump_failblogpercona.commanual sql_…
Post: Percona Server 5.5.16-22.0
October 16, 2011 By 2 Comments
… Repositories). Based on MySQL 5.5.16, …restore (in 5.1 it is –innodb-blocking-lru-restore), which is OFF by default. When set to ON, restoring from the LRU dump…foreign key changes. This unnecessarily delays their creation in a mysqldump output, so –innodb-optimize-keys should ignore foreign key…
Post: Percona Server 5.1.59-13.0
October 16, 2011 By Leave a Comment
…lru-restore, which is OFF by default. When set to ON, restoring from the LRU dump …foreign key changes. This unnecessarily delays their creation in a mysqldump output, so –innodb-optimize-keys should ignore foreign key…of a PRIMARY KEY. #851674 (Alexey Kopytov). Backported fix for MySQL bug #53761 (…
Post: Improved InnoDB fast index creation
November 6, 2011 By 4 Comments
…-optimize-keys > dump_optimized.sql $ time mysql -uroot test < dump_unoptimized.sql real 2m52.785s user 0m3.179s sys 0m0.069s $ time mysql -uroot test < dump… on foreign key changes. So adding them back with a separate ALTER TABLE after restoring the data from a dump would actually make the restore…
