… name is innodb-blocking-buffer-pool-restore (to be consistent with innodb-buffer-pool-restore-at-startup).” Just checked 5.5.16 on our test machine with the innodb-blocking-buffer-pool-restore directive: mysqld: 111017 10:13:12 InnoDB: Restoring buffer pool pages…
Post: Percona Server 5.5.10 (Release Candidate)
April 4, 2011 By 4 Comments
… innodb_import_table_from_xtrabackup. (Yasufumi Kinoshita) Old system variable innodb_auto_lru_dump was renamed to innodb_buffer_pool_restore_at_startup. (Yasufumi Kinoshita) Old system variable innodb_overwrite_relay_log_info was renamed to innodb_recovery…
Post: Percona Server 5.5.16-22.0
October 16, 2011 By 2 Comments
… threads to warm the server: replay statements and then rollback at commit. That makes prefetch simple but has high overhead from…. Block startup until LRU dump is loaded Added a new boolean option, –innodb-blocking-buffer-pool-restore (in 5.1 it is –innodb-blocking-lru-restore), which…
Post: MySQL Crash Recovery
July 30, 2006 By 26 Comments
… ACID even with Innodb tables, at least …server its caches (key_buffer, innodb_buffer_pool, query_cache,table…Innodb statistics – Unlike MyISAM Innodb does not store index cardinality in tables, instead it computes them on first table access after startup… – Restoring data from backup, corrupted Innodb…
Post: Percona Server 5.1.50-rel12.1
October 14, 2010 By 2 Comments
…innodb_lru_dump_restore – Implemented automatic dumping of the buffer pool at specified intervals. innodb_buffer_pool_shm – Implemented option ”innodb_buffer_pool_shm_checksum”; when enabled, shared memory buffer pool…
Comment: Returning to InnoDB scalability
August 7, 2006 By 42 Comments
…innodb_thread_concurrency=20 innodb_buffer_pool_size=3G =================================================== =================MySQL error log=================== 060804 20:56:56 InnoDB…
