June 19, 2013

Post: Percona XtraBackup 2.1.0 for MySQL beta now available

… announce the release of Percona XtraBackup 2.1.0 for MySQL beta on April 22, 2013. Downloads are available from our… XtraBackup for MySQL 2.0.6, plus the following: New Features: Percona XtraBackup has implemented basic support for MySQL 5.6, Percona Server 5.6 and MariaDB…. Release notes with all the bugfixes for Percona XtraBackup for MySQL 2.1.0-beta1 are available in our online documentation…

Post: Percona Server 5.5.30-30.2 rerelease fixes non-restart issue

… for bug #1070856 introduced a regression in Percona Server for MySQL 5.5.28-29.3 which could cause a server to hang…. Bug fixed #1163439 (Alexey Kopytov). Ported back from the upstream MySQL 5.6 the fix for unnecessary log_flush_order_mutex acquisition. Bug… fixed #1154954 (Hrvoje Matijakovic). Release notes for Percona Server for MySQL 5.5.30-30.2 are available in our online documentation. Bugs…

Post: Percona Live MySQL Conference 2013 wrap-up

… Zaitsev from Percona and the keynote panel on MySQL 5.6 and the future of MySQL in the cloud with all of these speakers… Oracle development discipline MySQL 5.0 and 5.1 were rushed and not properly tested but 5.5 and 5.6 were significantly improved and 5.7 promises to be more of the same The future for the MySQL community…

Post: Disconnecting a replication slave is easier with MySQL 5.5+ (RESET SLAVE vs. RESET SLAVE ALL)

… short For MySQL 5.0 and 5.1, run STOP SLAVE, CHANGE MASTER TO MASTER_HOST=” and then RESET SLAVE. For MySQL 5.5 and 5.6, run… from MySQL 5.5). If you want to know more details, please read on! MySQL 5.0/5.1 First let’s consider MySQL 5.0 and 5.1… never set master-xxx variables in my.cnf! From MySQL 5.5 Starting with MySQL 5.5, the situation has slightly changed. First the master-xxx…

Post: Percona XtraBackup 2.0.7 for MySQL available for download

…, 5.6-style buffer pool dump files). Percona XtraBackup has implemented support for the InnoDB Buffer Pool Preloading introduced in MySQL 5.6. Starting with MySQL 5.6MySQL 5.6. This option can be used to produce 5.6-style metadata files, that can be imported by ALTER TABLE IMPORT TABLESPACE on MySQL

Post: trx descriptors: MySQL performance improvements in Percona Server 5.5.30-30.2

… the perfect case for read-only optimization in MySQL 5.6 and as you can see MySQL 5.6 shines in this benchmark. This is also… scan in MySQL 5.5 basically kills throughput on high concurrency. The picture changes dramatically when the read-only optimization in MySQL 5.6 does not… read-only) transactions. In this case MySQL 5.6 scalability goes back to the good old MySQL 5.5 times and we see identical results with…

Post: MySQL and Percona Server in LinkBench benchmark

… the IO-bound scenario. Percona Server 5.5 outperforms MySQL in about 2x times. Both MySQL 5.5.30 and MySQL 5.6.11 demonstrate notable drops in performance… second for MySQL 5.6.11. Conclusion: In CPU-bounds case MySQL performs quite well, though we can see small performance drop in MySQL 5.6. In…

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

…, 5.6-style buffer pool dump files). Percona XtraBackup has implemented support for the InnoDB Buffer Pool Preloading introduced in MySQL 5.6. Starting with MySQL 5.6MySQL 5.6. This option can be used to produce 5.6-style metadata files, that can be imported by ALTER TABLE IMPORT TABLESPACE on MySQL

Post: MySQL alternative Percona Server 5.1.68 -14.6 now available

… for MySQL version 5.1.68-14.6[/caption] Percona is glad to announce the release of Percona Server  5.1.68 -14.6 on April 19, 2013 (downloads are available here and from the Percona Software Repositories). Based on MySQL 5.1.68, including all the bug fixes in it, Percona Server 5.1.68-14.6, a MySQL alternative, is…

Post: More on MySQL transaction descriptors optimization

…’s tests Percona Server scalability is somewhere in between of MySQL 5.5 and MySQL 5.6. In order to understand more about differences between results… much confusion. Even though the read-only transactions optimization in MySQL 5.6 virtually eliminates contention on the mutex protecting the list of…