… the world’s only open-source, free MySQL hot backup software that performs non-blocking backups for InnoDB and XtraDB databases. This… Preloading introduced in MySQL 5.6. Starting with MySQL 5.6 buffer pool dumps can be produced and loaded for faster server warmup after… feature is similar to the Dump/Restore of the Buffer Pool in Percona Server. MySQL 5.6 buffer pool dump is copied into backup…
Post: Announcing Percona Server 5.1.65-14.0
September 4, 2012 By Leave a Comment
… temporary indexes resulting in an unbootable server. Bug fixed #999147 (Laurynas Biveinis). Fixed the upstream MySQL bug #66301. Concurrent INSERT … ON DUPLICATE…_mutex during the entire dump process. Now the mutex is periodically released in order not to block server while the dump is in progress…
Post: Announcing Percona Server 5.5.27-29.0
October 11, 2012 By Leave a Comment
… Software Repositories). Based on MySQL 5.5.27, including all the bug fixes in it, Percona Server 5.5.27-29.0… LRU dump would hold LRU_list_mutex during the entire dump process. Now the mutex is periodically released in order not to block server while the dump is in progress…
Post: Percona Server 5.5.16-22.0
October 16, 2011 By 2 Comments
… Software Repositories). Based on MySQL 5.5.16, including all the bug fixes in it, Percona Server 5.5.16-22.0… prevents users from blocking purge by mistake. Block startup until LRU dump is loaded Added a new boolean option, –innodb-blocking-buffer-pool-restore… the LRU dump file is synchronous, i.e. InnoDB waits until it is complete before reporting successful startup to the server. #785489…
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
… MySQL manual, especially the option …Key_blocks_not_flushedblogpercona.commanual Key_blocks_unusedblogpercona.commanual Key_blocks…scanblogpercona.commanual sporadic_binlog_dump_failblogpercona.commanual sql_…modeblogpercona.commanual ssl_verify_server_certblogpercona.commanual Ssl_versionblogpercona…
Post: Percona Server 5.1.59-13.0
October 16, 2011 By Leave a Comment
… Software Repositories). Based on MySQL 5.1.59, including all the bug fixes in it, Percona Server 5.1.59-13.0… prevents users from blocking purge by mistake. Block startup until LRU dump is loaded Added a new boolean option, –innodb-blocking-lru-restore, which… the LRU dump file is synchronous, i.e. InnoDB waits until it is complete before reporting successful startup to the server. #785489…
Post: Percona Server and XtraBackup weekly news, April 4th
April 4, 2011 By 1 Comment
…MySQL releases as a baseline for Percona Server, we think that it is extremely important to continue developing Percona Server…Server use “fast index creation” for ALTER TABLE and OPTIMIZE TABLE, which can make these blocking…
Post: MySQL Backup tools used by Percona Remote DBA for MySQL
March 13, 2013 By 8 Comments
… and mysql shuts down Your server or RAID controller crashes and all data is lost on that server A… read lock only held until myisam tables are dumped. We are researching into how we could further… WITH READ LOCK”. Namely when a select is blocking the flush from completing and queuing all requests…
Post: Quickly finding unused indexes (and estimating their size)
December 5, 2012 By 2 Comments
…break replication!). mysql> create schema index_analysis; If our index_statistics are collecting on the same server, … stats come from some other server, then you may need to dump and load a copy of …table by simply doing: mysql> alter table mytable ENGINE=Innodb; However, this blocks and on a large …
Post: Percona Server 5.1.54-12.5
January 11, 2011 By 9 Comments
Percona Server version 5.1.54-12.5 is now available for … is based on MySQL 5.1.54. New Features Added: None Other Changes: Added system variable innodb_log_block_size and new… #692211 – Starting the server with a non-zero innodb_auto_lru_dump value could crash the server if the dump file did not exist…
