… from the .ibd files… InnoDB: Restoring possible half-written data pages from the doublewrite InnoDB: buffer… 120502 11:51:16 InnoDB: Started… | grep log_file # Set .._log_file_size to 25 % of buffer pool size innodb_log_file_size = 64M [root@tstlx1 mysql]#
Post: Announcing Percona XtraBackup 1.9.1
February 27, 2012 By 9 Comments
… features include: Backup and restore of LRU dump. For servers that support dump and restore of the XtraDB buffer pool (LRU), namely Percona Server, this will enable a server restored from backup to give…
Post: XtraDB feature: save / restore buffer pool
January 20, 2010 By 19 Comments
…_restore (Yasufumi names it LRU dump/restore, because he thinks about buffer pool as about LRU list, which how it is internally). To save buffer pool….6 I made small tpcc benchmark to show effect with restored buffer_pool (the condition of benchmarks are the same as in my… and ran it for 1h. After that I saved buffer_pool, restarted mysqld, restored buffer_pool ( it took about 4 min to load 26GB worth…
Comment: Percona Server 5.5.16-22.0
October 17, 2011 By 2 Comments
…-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 from ib_lru_dump So…
Post: Improved InnoDB fast index creation
November 6, 2011 By 4 Comments
… to the buffer pool. A benchmark is worth a thousand words, so let’s repeat the last test with innodb_buffer_pool_sizeset to… | 19.805849 | | restoring secondary keys | 53.885502 | . . . +——————————+———–+ 19 rows in set (0.00 sec) So, as expected, a small buffer pool had a…
Post: Percona Server 5.5.13-20.4 Stable Release
July 1, 2011 By 3 Comments
….4 milestone at Launchpad. Improvements SHM Buffer Pool has been replaced with LRU Dump/Restore The ”SHM” buffer pool patch, which provided the ability to use a shared memory segment for the buffer pool to enable…
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
… Com_restore_tableblogpercona….buffer_pool_instancesblogpercona.commanual Innodb_buffer_pool_pages_datablogpercona.commanual Innodb_buffer_pool_pages_dirtyblogpercona.commanual Innodb_buffer_pool_pages_flushedblogpercona.commanual Innodb_buffer_pool_pages_freeblogpercona.commanual Innodb_buffer_pool…
Post: Percona Server 5.1.58-12.9
August 17, 2011 By 2 Comments
… deprecated options (innodb_buffer_pool_shm_key and innodb_buffer_pool_shm_checksum) if used. Instructions for disabling the SHM buffer pool can be found here and for setting up LRU dump/restore…
Post: Percona Server 5.1.50-rel12.1
October 14, 2010 By 2 Comments
…_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… shutdown when using shared memory buffer pool. (Yasufumi Kinoshita) Bug #643724 – Fixed an InnoDB crash when shared memory buffer pool was enabled. (Yasufumi Kinoshita…
Comment: MySQL Server Memory Usage
September 1, 2006 By 18 Comments
…_replace’, ’20801587′ ‘Com_replace_select’, ’0′ ‘Com_reset’, ’0′ ‘Com_restore_table’, ’0′ ‘Com_revoke’, ’0′ ‘Com_revoke_all’, ’0′ ‘Com… innodb_buffer_pool_size=1800M # USE ALL MEMORY AVAILABLE #innodb_log_buffer_size=8M # Lowered from 32M according to MySQL innodb_additional_mem_pool…_commit=0 #innodb_log_file_size=400M # Approx 20% of buffer pool innodb_thread_concurrency=64 # Default is 8 wich is a…
