June 18, 2013

Post: Percona XtraBackup 2.0.7 for MySQL available for download

… world’s only open-source, free MySQL hot backup software that performs non-blocking backups for InnoDB and XtraDB databases. This release… XtraBackup has implemented support for the InnoDB Buffer Pool Preloading introduced in MySQL 5.6. Starting with MySQL 5.6 buffer pool dumps… fixed #1164979. Due to different implementation in MySQL 5.6 error messages were not printed to stderr directly. Because of that all InnoDB

Post: Percona XtraBackup 2.1.0 'release candidate' for MySQL available for download

… XtraBackup has implemented support for the InnoDB Buffer Pool Preloading introduced in MySQL 5.6. Starting with MySQL 5.6 buffer pool dumps… fixed #1130145. Due to different implementation in MySQL 5.6 error messages were not printed to stderr directly. Because of that all InnoDB… typo. Bug fixed #1172016. innobackupex wasn’t handling the innodb_data_file_path option which could cause backup to fail. Bug fixed #1169726…

Post: Announcing Percona XtraBackup 2.1.1 GA

…DBD::MySQL package for server communication instead of spawning the MySQL command line client. Support for InnoDB 5.0 and InnoDB 5…directory. Bug fixed #1174314. Other bugs fixed: bug fixed #1166713, bug fixed #1175581, bug fixed #1175318, bug fixed #1175309, bug fixed #1176198, bug fixed #1175566. …

Post: Virident vCache vs. FlashCache: Part 2

… ­­\ –mysql­-user=root –mysql­-socket=/tmp/mysql.sock ­­–mysql­-table­-engine=innodb ­­\ –oltp­-read­-only=off run The base MySQL configuration (configuration A) appears below: #####fixed innodb options innodb_file_format = barracuda innodb

Post: Percona XtraBackup 2.1.0 for MySQL alpha now available

…’s DBD::MySQL package for server communication instead of spawning the MySQL command line client. Support for InnoDB 5.0 and InnoDB 5.1-builtin has been removed from Percona XtraBackup for MySQL. After… in Percona XtraBackup for MySQL 2.1. Bugs Fixed: innobackupex now supports empty arguments in the –password option. Bug fixed #1032667 (Andrew Gaul…

Post: Benchmarking Percona Server TokuDB vs InnoDB

…=/mnt/data/mysql #for SSD innodb_flush_neighbor_pages = none innodb_adaptive_flushing_method = keep_average innodb_file_per_table = true innodb_data_…plugin options innodb_read_io_threads = 16 innodb_write_io_threads = 4 innodb_io_capacity = 4000 innodb_use_native_aio=0 #not innodb options (fixed) …

Post: Memory allocators: MySQL performance improvements in Percona Server 5.5.30-30.2

…, there is another issue in InnoDB transaction processing that notably affects MySQL performance – for every transaction InnoDB creates a read view and allocates… helps MySQL 5.5.30 to fix issues with malloc scalability but still scanning of the transaction list causes performance drop = MySQL 5…

Post: MySQL 5.6 Compatible Percona Toolkit 2.2 Released

… set innodb_lock_wait_timeout because that now conflicts, or is at least confused with, lock_wait_timeout (introduced in MySQL 5… a standard (http) connection. pt-stalk and pt-mysql-summary have built-in MySQL options No more “pt-stalk — -h db1 -u… example, three tools were removed, and there were several bug fixes. See https://launchpad.net/percona-toolkit/+milestone/2.2.1…

Comment: MySQL and Percona Server in LinkBench benchmark

….mysql.com really aren’t spam. For 5.6 you need to set innodb_lru_scan_depth to a value similar to innodb… did a lot of work for the innodb_fast_free_list option to fix the stalls and that change makes 5.1… sure this one will be fixed. Too bad, as Percona has a fix for it – http://bugs.mysql.com/bug.php?id=45892

Comment: MySQL and Percona Server in LinkBench benchmark

… did a lot of work for the innodb_fast_free_list option to fix the stalls and that change makes 5.1….mysql.com/bug.php?id=68555 http://bugs.mysql.com/bug.php?id=68481 I am not sure this one will be fixed. Too bad, as Percona has a fix for it – http://bugs.mysql.com/bug.php?id=45892