June 19, 2013

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

… directly. Because of that all InnoDB error or diagnostic messages are never printed by xtrabackup_56. Bug fixed #1169971. innobackupex would still… fixed #1170806. Percona XtraBackup would leave xbtemp temp files behind due to a typo. Bug fixed #1172016. innobackupex wasn’t handling the innodb_data_file_path option which could cause backup to fail. Bug fixed #1169726…

Post: MySQL alternative Percona Server 5.1.68 -14.6 now available

… CentOS 6.3 during installation. Bugs fixed #1031427 and #1051874. When mysqldump was used with –innodb-optimize-keys option it produced invalid… fixed #1081016. When mysqldump was used with –innodb-optimize-keys and –no-data options, all secondary key definitions would be lost. Bug fixed… were missing. Bug fixed #1041981. Other bugs fixes: bug fixed #1154962, bug fixed #1154959, bug fixed #1154957, bug fixed #1154954, bug fixed #1144059, bug fixed #1050536. Bugs can…

Post: Announcing Percona XtraBackup 2.1.1 GA

…spawning the MySQL command line client. Support for InnoDB 5.0 and InnoDB 5.1 builtin has been removed from Percona … 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. Release …

Comment: MySQL and Percona Server in LinkBench benchmark

innodb_lru_scan_depth to a value similar to innodb_io_capacity. They should have made LRU page flushing a function of innodb… did a lot of work for the innodb_fast_free_list option to fix the stalls and that change makes 5.1… am not sure this one will be fixed. Too bad, as Percona has a fix for it – http://bugs.mysql.com/bug…

Comment: MySQL and Percona Server in LinkBench benchmark

innodb_lru_scan_depth to a value similar to innodb_io_capacity. They should have made LRU page flushing a function of innodb… did a lot of work for the innodb_fast_free_list option to fix the stalls and that change makes 5.1… am not sure this one will be fixed. Too bad, as Percona has a fix for it – http://bugs.mysql.com/bug…

Post: Percona XtraBackup 2.1.0 for MySQL alpha now available

… writing). This release contains all of the features and bug fixes in Percona XtraBackup for MySQL 2.0.6, plus the… spawning the MySQL command line client. Support for InnoDB 5.0 and InnoDB 5.1-builtin has been removed from Percona XtraBackup… completely removed in Percona XtraBackup for MySQL 2.1. Bugs Fixed: innobackupex now supports empty arguments in the –password option. Bug…

Comment: MySQL and Percona Server in LinkBench benchmark

… bug# yet, the problem you mentioned seems to be already fixed at current revision. Please looking forward to the next (or… workload-hardware innodb_io_capacity = 20000 innodb_io_capacity_max = 100000 innodb_read_ahead_threshold = 0 innodb_change_buffer_max_size = 1 innodb_lru_scan…

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… direct malloc() call, but rather goes through the InnoDB heap layer – so InnoDB allocates heap area and then creates requested block(s… glibc malloc itself – jemalloc helps MySQL 5.5.30 to fix issues with malloc scalability but still scanning of the transaction…

Comment: Solving INFORMATION_SCHEMA slowness

… many performance complaints about I_S, besides the overhead of InnoDB statistics refresh. You may get some insight by reading the… logs: http://bugs.mysql.com/bug.php?id=19588 – reported fixed in MySQL 5.1.21 but many people reported I… slow. http://bugs.mysql.com/bug.php?id=56178 – reported fixed in MySQL 5.5.16, 5.6.3. What version…

Post: Follow these basics when migrating to Percona XtraDB Cluster for MySQL

… can leave them behind. Lastly, once that bug above is fixed, and you still have MyISAM tables you wish to keep… so. However, if you can, you should consider moving to InnoDB altogether. There are very few reasons to stay with MyISAM… certification becomes non-deterministic. Although the previous bug has been fixed on latest release (5.5.30-23.7.4), table…