… MISLEADING. So we see that InnoDB performance steadily declines from 24000 tps to 18000 tps, but InnoDB can’t make 5h run. After… datadir=/mnt/data/mysql #for SSD innodb_flush_neighbor_pages = none innodb_adaptive_flushing_method = keep_average innodb_file_per_table = true innodb_data_file…
Post: Is Synchronous Replication right for your app?
May 14, 2013 By 18 Comments
… does NOT set an lower bound on performance, only a upper bound. The best performance you can expect is modifying a given… update much faster. I see this tuning very frequently for “performance” reasons when data durability isn’t as crucial. This is… to the tradeoffs we take when deploying conventional stand-alone MySQL Innodb with asynchronous slaves. We may not think about the tradeoffs…
Post: Percona Server for MySQL 5.5.30-30.2 now available
April 10, 2013 By 10 Comments
… on MySQL performance can be found in this blogpost. (Ignacio Nin) This release of Percona Server for MySQL has fixed a number of performance bugs. (Alexey Kopytov) Drop table performance feature has been removed and its controlling variable innodb_lazy…
Post: 10 years of MySQL User Conferences
April 11, 2013 By 6 Comments
…. MySQL Cluster and MySQL Press were announced during this event; “High Performance MySQL” 1st edition written by Jeremy and Derek was also available. MySQL 4… Performance Conference as a free event going concurrently with the conference and announced Percona XtraDB as improved and extended Innodb Plugin version, MySQL…
Post: Webinar: MySQL 5.6 Performance Schema
May 13, 2013 By 5 Comments
…, “Using MySQL 5.6 Performance Schema to Troubleshoot Typical Workload Bottlenecks.” In this Webinar I will offer an overview of Performance Schema, focusing… Excessive internal mutex contention Slow queries due to waits on InnoDB locks and Meta Data locks Interested ? Sign up today!
Post: Learn About MySQL 5.6 at the Percona Live MySQL Conference
April 3, 2013 By Leave a Comment
… Live MySQL Conference: “MySQL 5.6: Performance Benchmarks, Tuning, and ‘Best’ Practices” by Dmitri Kravtchuk, MySQL Performance Architect “MySQL 5.6: What’s New in InnoDB” by Sunny Bains, Senior Principal Software Engineer “MySQL 5.6: Redefining…
Post: Percona XtraDB Cluster 5.5.30-23.7.4 for MySQL now available
April 17, 2013 By 2 Comments
… our repositories. Benchmark showing the impact of memory allocators on MySQL performance can be found in this blogpost. This release of Percona… fixed #1154095 (Alex Yurchenko). If variable innodb_thread_concurrency has been defined to throttle InnoDB access, and work load contained DDL statements…
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…
Post: What I'm looking forward to at Percona Live (MySQL Users Conference)
April 4, 2013 By 1 Comment
… 10th year attending and speaking at the MySQL Users Conference (as the Percona Live MySQL Conference and Expo was originally called back… give an Innodb and Performance Optimization Tutorial as well as talk about Goal-Driven Performance Optimization and Choosing storage systems for MySQL Do Business…
Post: Follow these basics when migrating to Percona XtraDB Cluster for MySQL
May 1, 2013 By 10 Comments
…XtraDB Cluster (PXC) for MySQL is a hot thing right now and some users…However, if you can, you should consider moving to InnoDB altogether. There are very few reasons to stay … without PK imposes an additional overhead, and because cluster performance is somewhat dependent on the slowest node – this …
