Here at the MySQL Performance Blog, we’ve been discussing the several new features that MySQL 5.6 brought: GTID-based replication, InnoDB Fulltext, Memcached integration, a more complete performance schema, online DDL…, and it has the exact column definition in the same order. In other words, it checks for duplicate keys, but not…
Post: MySQL Query Patterns, Optimized - Webinar questions followup
June 3, 2013 By 2 Comments
On Friday I gave a presentation on “MySQL Query Patterns, Optimized” for Percona MySQL Webinars. If you missed it, you can still… compromise, either of performance, or of accuracy of randomness. The ORDER BY RAND() solution is known to have poor performance, but it returns… this case to force MySQL to scan the `title` table first, grouping by kind_id in index order. This made the first…
Post: How to fix your PRM cluster when upgrading to RHEL/CentOS 6.4
May 29, 2013 By 2 Comments
… active cluster nodes in order to deliver membership and …, see bellow how to perform this action [root@percona1 percona]# …MySQL [p_mysql] (unmanaged) p_mysql:0 (ocf::percona:mysql): Master percona1 (unmanaged) p_mysql:1 (ocf::percona:mysql): Slave percona2 (unmanaged) p_mysql:2 (ocf::percona:mysql…
Post: trx descriptors: MySQL performance improvements in Percona Server 5.5.30-30.2
April 12, 2013 By 3 Comments
One major problem in terms of MySQL performance that still stands in the way of InnoDB scalability is … from few times to orders of magnitudes faster than a list scan. You may be curious if MySQL 5.6 brings any… the alpha stage. We are going to blog about other MySQL performance improvements introduced in our latest Percona Server release, stay tuned…
Post: Percona Server for MySQL 5.5.30-30.2 now available
April 10, 2013 By 10 Comments
… Server for MySQL will now be shipped with the libjemalloc library. Benchmark showing the impact of memory allocators on MySQL performance can be found in this blogpost. (Ignacio Nin) This release of Percona Server for MySQL has fixed a number of performance… Kopytov). Ported back from the upstream MySQL 5.6 the fix for unnecessary log_flush_order_mutex acquisition. Bug fixed #1163262 (Alexey…
Post: Keynotes, BOFs, and the Community Networking Reception at Percona Live MySQL Conference and Expo
April 15, 2013 By 1 Comment
… Engineer, Oracle Topic: “MySQL 5.6: What’s New in InnoDB” Dmitri Kravtchuk, MySQL Performance Architect, Oracle Topic: “MySQL 5.6: Performance Benchmarks, Tuning, and ‘Best’ Practices” Luís Soares, Senior Software Engineer, Oracle Topic: “MySQL 5.6… focus on MySQL 5.6 and how MySQL must evolve if it is to remain competitive in the new world order of the…
Post: Percona Server 5.5.30-30.2 rerelease fixes non-restart issue
April 24, 2013 By Leave a Comment
… Server for MySQL will now be shipped with the libjemalloc library. Benchmark showing the impact of memory allocators on MySQL performance can be found in this blogpost. (Ignacio Nin) This release of Percona Server for MySQL has fixed a number of performance… Kopytov). Ported back from the upstream MySQL 5.6 the fix for unnecessary log_flush_order_mutex acquisition. Bug fixed #1163262 (Alexey…
Post: Is Synchronous Replication right for your app?
May 14, 2013 By 18 Comments
… MySQL replication from this instance, since MySQL replication is asynchronous. What about semi-sync MySQL replication… nodes, we can (simultaneously) establish global ordering for the transaction, so by the …an lower bound on performance, only a upper bound. The best performance you can expect …
Post: More on MySQL transaction descriptors optimization
April 26, 2013 By Leave a Comment
… Server scalability is somewhere in between of MySQL 5.5 and MySQL 5.6. In order to understand more about differences between results….g. in the first two cases Percona Server performance is even slightly ahead of MySQL 5.6.10, but nothing unexpected. So… –mysql-table-engine=INNODB –mysql-socket=/tmp/mysql.sock –oltp-point-selects=1 –oltp-simple-ranges=0 –oltp-sum-ranges=0 –oltp-order-ranges…
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… streamed backups in order to add another layer of protection to the backups. innobackupex now uses Perl’s DBD::MySQL package for…. Percona XtraBackup can use XtraDB changed page tracking feature to perform the Incremental Backups now. Bugs Fixed: innobackupex is using SHOW…
