… benchmarks on both systems. The benchmark tool used was sysbench 0.5 and the version of MySQL used was Percona Server… \ –forced-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 or… –export option runs a recovery process on the backup with innodb_fast_shutdown=0 and therefore merging all the insert buffers. # innobackupex –defaults-file…
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… Bug #358194: 2nd-phase is very slow Bug #358266: xtrabackup-0.5 dies with SEGV on bad command line arguments Bug…
Comment: How to recover a single InnoDB table from a Full Backup
February 4, 2013 By 10 Comments
… up the database as specified with –export option with the “innodb_import_table_from_xtrabackup=1″ turned ON. 2) Then deleted… tried mysql restart by deleting the ib_logfiles and letting innodb create new ones, and the missing data was back, without… some role in this case. Next I set the option innodb_fast_shutdown=0, and restarted mysql, without any discard and import I got…
Comment: How to change innodb_log_file_size safely
March 18, 2013 By 17 Comments
…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 = … InnoDB: buffer… 130319 0:10:26 InnoDB: Started; log sequence number 0 65548 130319 0:10:27 [Note] Event Scheduler: Loaded 0 events 130319 0:…
Comment: How to change innodb_log_file_size safely
August 8, 2011 By 17 Comments
….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: Percona Server 5.1.49-rel12.0
September 15, 2010 By 6 Comments
…features Percona Server 5.1.49-rel12.0 is based on MySQL 5.1.49…innodb_flush_log_at_trx_commit. (Yasufumi Kinoshita) innodb_fast_index_creation – Allows disabling of fast index creation. (Yasufumi Kinoshita) innodb…. Bug #607449 – Fixes a crash during shutdown when userstat_running=1. Bug #612954 – …
Comment: MySQL on Amazon RDS part 2: Determining Peak Throughput
March 28, 2011 By 4 Comments
… innodb_checksums ON 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…
Comment: How to change innodb_log_file_size safely
November 8, 2011 By 17 Comments
… number 0 3522050451 Nov 8 19:19:58 mysqld: InnoDB: is in the future! Current system log sequence number 0 3177053196. Parameter ‘innodb_fast_shutdown‘ has NOT been set to 2, so the default was 1 (0 neither set). Even…
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… error “innodb_extra_undoslots option is disabled but it was enabled before” was sometimes reported after upgrading from MySQL 5.0. (Yasufumi…
