June 19, 2013

Post: Percona XtraBackup 2.0.7 for MySQL available for download

… MySQL hot backup software that performs non-blocking backups for InnoDB and XtraDB databases. This release is the current GA (Generally… pool dump files). Percona XtraBackup has implemented support for the InnoDB Buffer Pool Preloading introduced in MySQL 5.6. Starting with… can spend a lot of time opening all the tablespaces. Optimization has been implemented and XtraBackup now avoids loading non-relevant…

Post: What I'm looking forward to at Percona Live (MySQL Users Conference)

… sessions I will give an Innodb and Performance Optimization Tutorial as well as talk about Goal-Driven Performance Optimization and Choosing storage systems…

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

… pool dump files). Percona XtraBackup has implemented support for the InnoDB Buffer Pool Preloading introduced in MySQL 5.6. Starting with… can spend a lot of time opening all the tablespaces. Optimization has been implemented and XtraBackup now avoids loading non-relevant… were not printed to stderr directly. Because of that all InnoDB error or diagnostic messages are never printed by xtrabackup_56…

Comment: Is Synchronous Replication right for your app?

… with fsync is probably correct given the current design of InnoDB, but it’s not fundamental — see the 2009 paper on…-node replicated systems, but I’m fairly certain the same optimization could be applied. -Todd

Post: Keynotes, BOFs, and the Community Networking Reception at Percona Live MySQL Conference and Expo

… Engineer, Oracle Topic: “MySQL 5.6: What’s New in InnoDB” Dmitri Kravtchuk, MySQL Performance Architect, Oracle Topic: “MySQL 5.6… 10.0 & What’s New With the Project” Sergei Petrunia, Optimizer Developer, and Colin Charles, Chief Evangelist, MariaDB, for Monty Program…

Comment: Should you move from MyISAM to Innodb ?

… enough to make well informed decisions about engines and other optimizations. Getting very involved in e-commerce I’ve recently been… DBA to help me past MyISAM. Along with MySQL’s InnoDB, I also have PostgreSQL on my radar for future more…

Post: MySQL 5.6 Compatible Percona Toolkit 2.2 Released

… are configurable. Also, we removed –lock-wait-timeout which set innodb_lock_wait_timeout because that now conflicts, or is at…). This feature is still in development while we determine the optimal JSON structure. Version check is on by default In 2…

Post: InnoDB Full-text Search in MySQL 5.6 (part 1)

… global innodb_ft_aux_table=’test/dir_test_innodb‘; mysql> set global innodb_optimize_fulltext_only=1; mysql> select * from information_schema.innodb_ft_config; +—————————+——–+ | KEY | VALUE | +—————————+——–+ | optimize_checkpoint_limit…

Post: Improved InnoDB fast index creation

… supports the new option –innodb-optimize-keys which does just that, i.e. it tries to optimize dumps of InnoDB tables by first creating…): $ mysqldump -uroot test > dump_unoptimized.sql $ mysqldump -uroot test –innodb-optimize-keys > dump_optimized.sql $ time mysql -uroot test < dump_unoptimized.sql real…

Post: How to estimate time it takes Innodb to Recover ?

… better to understand how Innodb recovery works. When Innodb recovers from logs it finds the last checkpoint time. Innodb has fuzzy checkpointing and… major part of recovery time. It is worth to note Innodb optimizes log recovery by reading portions of log records and sorting… expect system to handle and crash Innodb few times to see how long it takes Innodb to recover. I’d recommend to…