June 18, 2013

Post: xtrabackup-0.3, binaries and stream backup

… version of xtrabackup – online backup solution for MySQL 5.0 / 5.1 and InnoDB standard version, plugin modification and XtraDB. We still consider it as… to work with standard version of InnoDB in MySQL 5.0. MySQL 5.1 + standard InnoDB / InnoDB-plugin also are supported. It can fully work as…

Post: Top 5 Wishes for MySQL

… we could write these as plugins instead of patches. 2. Be Scalable I’d like to see MySQL Scaling to large amount… Queries on MySQL because subqueries optimizer weakness. I’m saying about XA which were released in MySQL 5.0 without consistent work with MySQL close Partner – Innobase to ensure Group Commit still works in 5.0 and so we…

Post: MySQL 5.5.8 and Percona Server: being adaptive

…, in percona-patches builds for 5.0), we added adaptive checkpoint algorithms, and later the InnoDB-plugin included an implementation of  ”adaptive… that MySQL 5.5.8 has periodic drops here, too. The margin between Percona Server and MySQL is about 2500-2800 NOTPM (~15% difference). MySQL 5.5

Post: Performance improvements in Percona 5.0.83 and XtraDB

… trying to align XtraDB performance with MySQL 5.4 ® and also port all performance fixes to 5.0 tree. So basically we made: new… final result: As you see XtraDB, 5.0.83-percona and MySQL 5.4 are almost equal, leaving 5.0.83-standard far behind. If you… choose XtraDB if 5.4 has the same performance, let me refresh: – XtraDB is based on InnoDB plugin 1.0.3, with all…

Post: Announcing Percona Server 5.5.24-26.0

… Server 5.5.24-26.0 on June 1st, 2012 (Downloads are available here and from the Percona Software Repositories). Based on MySQL 5.5.24, including all the bug fixes in it, Percona Server 5.5.24-26.0 is now the current stable release in the 5.5… can be found in the 5.5.24-26.0 milestone at Launchpad. New Features: Percona PAM authentication plugin has now been integrated into…

Post: MySQL 5.6.7-RC in tpcc-mysql benchmark

… into two bugs: MySQL 5.6.7 locks itself on CREATE INDEX MySQL 5.6.7-rc crashed under tpcc-mysql workload But at the… how MySQL 5.6.7 performs Hardware specification Server: Dell PowerEdge R710 CPU: 2x Intel(R) Xeon(R) CPU E5-2660 0 @ 2…_log_file_size = 4G innodb_log_files_in_group = 2 #####plugin options innodb_read_io_threads = 16 innodb_write_io_threads…

Post: Adaptive flushing in MySQL 5.6

… for MySQL 5.5, and 2x4GB, 2x8GB for MySQL 5.6. For an initial experiment, let’s see what the result we are getting in MySQL 5.5 ( MySQL 5.5.27): As you can see there is prolonged periods of time (up to few minutes) when throughput drops to 0…_log_file_size = 4G innodb_log_files_in_group = 2 #####plugin options innodb_read_io_threads = 16 innodb_write_io_threads…

Post: Percona Server 5.1.52-12.3

MySQL 5.1. The release also includes the HandlerSocket plugin, which provides NoSQL features in Percona Server. Functionality Added or Changed Percona Server 5.1.52-12.3 is now based on MySQL 5.1.52. New Features Added: HandlerSocket plugin support has been… it was enabled before” was sometimes reported after upgrading from MySQL 5.0. (Yasufumi Kinoyasu) Bug #643463 – Shutting down XtraDB could take up…

Post: XtraDB storage engine release 1.0.4-8

….0.4 version of InnoDB plugin. We thank Schooner Information Technology for sponsoring and testing the port of XtraDB to 1.0.4 MySQL 5… Number of mysql-tests are fixed The builds for RedHat4,5 and Debian are located on http://www.percona.com/mysql/xtradb/5.1… main Then run # apt-get update # apt-get install mysql-server-5.1 Please report any bugs found on Bugs in Percona…

Post: Speaking on San Francisco Meetup 14-Dec : What's new in XtraDB/InnoDB-plugin 5.1+

… in MySQL 5.1 and 5.5 and, what is pay attention to, when you upgrade from MySQL 5.0. Although I personally mostly in 5.1->5.5 upgrade area, Erin insured me that upgrade from MySQL 5.0 is still actually…