…-shutdown=1 –max-time=7200 –max-requests=0 –percentile=95 \ –mysql-user=root –mysql-socket=/tmp/mysql.sock –mysql-table-engine=innodb… innodb_flush_log_at_trx_commit = 1 innodb_log_file_size = 1G innodb_log_files_in_group = 2 innodb_purge_threads = 1 innodb_fast_shutdown = 1 #not innodb…
Post: How to recover a single InnoDB table from a Full Backup
January 25, 2012 By 10 Comments
… ibdata. That is, shutting down with innodb_fast_shutdown=0. We’ll use XtraBackup to avoid the server shutdown. You must not drop, truncate… –export option runs a recovery process on the backup with innodb_fast_shutdown=0 and therefore merging all the insert buffers. # innobackupex –defaults…
Post: How long Innodb Shutdown may take
September 2, 2010 By 9 Comments
… MySQL with Innodb tables to shut down ? It can be quite a while. In default configuration innodb_fast_shutdown=ON the main job Innodb has to do to complete shutdown is flushing dirty buffers. The…
Post: Impossible - possible, moving InnoDB tables between servers
June 8, 2009 By 9 Comments
… here – just can copy InnoDB tables in fully non-blocking mode, you do not need to shutdown neither source nor destination server… just need to shutdown instance with innodb_fast_shutdown=1 (done in xtrabackup –prepare –export call). The more complex problem was that InnoDB stores pointers…
Comment: How to change innodb_log_file_size safely
August 8, 2011 By 17 Comments
…/refman/5.5/en/innodb-data-log-reconfiguration.html says innodb_fast_shutdown should be set to 1. Shouldn’t the innodb_fast_shutdown value set to 0 be the one that’s advised before changing innodb…
Post: xtrabackup-0.6
April 29, 2009 By 6 Comments
… tool. Changelist includes: – set innodb_fast_shutdown=1 on xtrabackup shutdown – set innodb_write_io_threads=10 by default for fast buffer_pool flushing during recovery…
Comment: How to change innodb_log_file_size safely
March 18, 2013 By 17 Comments
…. 1) shutdown mysql 2) change the following parameters in my.ini innodb_buffer_pool_size = 256M innodb_additional_mem_pool_size = 8M innodb_log_file_size = 64M innodb_log_buffer_size = 8M innodb_fast_shutdown = 1…
Post: Percona Server 5.1.52-12.3
December 13, 2010 By 2 Comments
… operating. (Oleg Tsarev) Â innodb_fast_shutdown – Sleeping threads could cause a delay of up to 10 seconds during InnoDB shutdown. The sleeping state of…) Other Changes: None Bugs Fixed Bug #640576 – The false error “innodb_extra_undoslots option is disabled but it was enabled before…
Comment: MySQL on Amazon RDS part 2: Determining Peak Throughput
March 28, 2011 By 4 Comments
… innodb_commit_concurrency 0 innodb_concurrency_tickets 500 innodb_data_file_path ibdata1:10M:autoextend innodb_data_home_dir /rdsdbdata/db/innodb innodb_doublewrite ON innodb_fast_shutdown 1 innodb_file_format Antelope innodb…
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
… Innodb_data_writesblogpercona.commanual Innodb_data_writtenblogpercona.commanual Innodb_dblwr_pages_writtenblogpercona.commanual Innodb_dblwr_writesblogpercona.commanual innodb_doublewriteblogpercona.commanual innodb_fast_shutdownblogpercona.commanual innodb_file_formatblogpercona.commanual innodb…
