… XtraDB Cluster We started beta support for MySQL 5.6 in 2.1.8 when 5.6 was still beta. Now that MySQL 5.6 is GA, so is our support for it…. Now that we have four base versions of MySQL (5.0, 5.1, 5.5, and 5.6), plus at least four major forks (Percona Server, MariaDB…
Post: More on MySQL transaction descriptors optimization
April 26, 2013 By Leave a Comment
… focused only on case #1. Which is the perfect case for read-only transaction optimization in MySQL 5.6, because all SELECT… Percona Server scalability is somewhere in between of MySQL 5.5 and MySQL 5.6. In order to understand more about differences between…(*) from sbtest$i WHERE k like ‘%0%’ SysBench-0.5/lua: POINT_SELECT QPS test sysbench –num-threads=<1..1024> –test=oltp.lua –oltp…
Post: MySQL 5.6 - InnoDB Memcached Plugin as a caching layer
March 29, 2013 By 10 Comments
… both a standard memcached instance and a minimally tuned MySQL 5.6 instance running the memcached plugin. Here are some details… 2.33863 ms per/cmd 1.449 ms min per/cmd 7.324 ms max per/cmd 5.875 ms range per/cmd Fetching [1,000,000] items: 347181 ms total 0.347181 ms per/cmd 0.3208 ms…
Post: MySQL and Percona Server in LinkBench benchmark
May 8, 2013 By 18 Comments
…=0 performance_schema=0 #56only loose-innodb_flush_neighbors=0 loose-metadata_locks_hash_instances=256 innodb_buffer_pool_instances=16 # MySQL 5.5 and 5.6 loose-innodb_io_capacity_max = 15000 #Percona only innodb_adaptive_hash_index_partitions=8 innodb_buffer_pool_instances=1… 10x dataset: ./bin/linkbench -D dbid=linkdb -D host=127.0.0.1 -D user=root -D port=3306 -D password= -D maxid1…
Post: The write cache: Swap insanity tome III
April 19, 2013 By 5 Comments
… 0 0 148504 476 24190 24233 8 6 81 5 0 Fri Mar 22 10:03:24 UTC 2013 2 1 291992 222228 138848 7258064 0 0… 5 0 Fri Mar 22 10:03:26 UTC 2013 3 1 291992 224088 138852 7260196 0 0 172386 156 27143 27637 8 7 80 5 0 Fri Mar 22 10:03:28 UTC 2013 1 4 291992 219104 138832 7262820 0 0…
Post: Percona XtraBackup 2.1.0 for MySQL alpha now available
April 2, 2013 By Leave a Comment
… is glad to announce the release of Percona XtraBackup 2.1.0 for MySQL alpha on April 2, 2013. Downloads are available… spawning the MySQL command line client. Support for InnoDB 5.0 and InnoDB 5.1-builtin has been removed from Percona XtraBackup for MySQL… with all the bugfixes for Percona XtraBackup for MySQL 2.1.0-alpha1are available in our online documentation. Bugs can be reported…
Post: Announcing Percona XtraBackup 2.1.1 GA
May 15, 2013 By Leave a Comment
… while providing unique features for MySQL backup. The new 2.1.1 GA version offers improved performance, enterprise-grade security, and lower… spawning the MySQL command line client. Support for InnoDB 5.0 and InnoDB 5.1 builtin has been removed from Percona XtraBackup. After being…. Release notes with all the bugfixes for Percona XtraBackup 2.1.1 are available in our online documentation. Bugs can be reported…
Post: Percona Monitoring Plugins 1.0.3 for MySQL now available
April 23, 2013 By 4 Comments
… is glad to announce the release of Percona Monitoring Plugins 1.0.3 for MySQL — high-quality components to add enterprise-grade… in the form of templates, plugins, and scripts. Changelog: * MySQL 5.6 compatibility for InnoDB graphs (bug 1124292) * Added performance data…-delay to be compatible with pt-hearbeat 2.1.8+ (bug 1103364) * Added 1-second granularity to pmp-check-mysql-deadlocks (bug…
Post: 10 years of MySQL User Conferences
April 11, 2013 By 6 Comments
… “MySQL Enterprise,” and MySQL 5.0 is finally available as GA with version 5.0.20a… MySQL 5.1 is in development (5.1.9) 2007 is the… released with different versions on different schedules. MySQL 5.0.37 GA and 5.1.17 nonGA were the latest version at the conference… improved and extended Innodb Plugin version, MySQL 5.1 is FA with 5.1.34 and MySQL 5.4.0 is in a nonGA version. The…
Comment: MySQL 5.6 Compatible Percona XtraBackup 2.0.6 Released
April 11, 2013 By 2 Comments
… 5.0.* – xtrabackup_51 # MySQL 5.1.* – xtrabackup_51 # MySQL 5.1.* with InnoDB plugin – xtrabackup # MariaDB 5.1.* – xtrabackup # MariaDB 5.2.* – xtrabackup # MariaDB 5.3.* – xtrabackup # Percona Server 5.0 – xtrabackup_51 # Percona Server 5.1 – xtrabackup # Percona Server 5.5 – xtrabackup_55 # Percona Server 5…
