… few slave instances each of production database servers and will perform the backups. The write load is not excessive so a…’ll many scripts ready for the task. Snapshots work best with InnoDB, with MyISAM you’ll have to start the snapshot while… is a very interesting solution for MySQL backup servers. All backup solutions have an impact on performance with ZFS the impact is…
Post: What I'm looking forward to at Percona Live (MySQL Users Conference)
April 4, 2013 By 1 Comment
… other developments in the MySQL ecosystem – both to drive Percona’s direction as well as to give the best possible advice to… many shows and this is one of the best for me to present MySQL talks – I typically find the audience very engaged… 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: Learn About MySQL 5.6 at the Percona Live MySQL Conference
April 3, 2013 By Leave a Comment
… Percona 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…
Post: Keynotes, BOFs, and the Community Networking Reception at Percona Live MySQL Conference and Expo
April 15, 2013 By 1 Comment
…, 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…
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 row… 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: MySQL and Percona Server in LinkBench benchmark
May 8, 2013 By 18 Comments
… the best possible combination I got ~15k operations per second for MySQL 5.6.11. Conclusion: In CPU-bounds case MySQL performs quite well…_type=0 performance_schema=0 #56only loose-innodb_flush_neighbors=0 loose-metadata_locks_hash_instances=256 innodb_buffer_pool_instances=16 # MySQL 5…
Post: Percona XtraDB Cluster 5.5.30-23.7.4 for MySQL now available
April 17, 2013 By 2 Comments
… showing the impact of memory allocators on MySQL performance can be found in this blogpost. This…Alex Yurchenko). If variable innodb_thread_concurrency has been defined to throttle InnoDB access, and work load…in our online documentation. We did our best to eliminate bugs and problems, but this…
Post: Virident vCache vs. FlashCache: Part 2
May 17, 2013 By 3 Comments
…best vCache performance results were obtained with the default vCache configuration, I think vCache can be declared the clear winner. Base MySQL…
Post: MySQL Indexing Best Practices: Webinar Questions Followup
August 16, 2012 By 4 Comments
… of questions on my MySQL Indexing: Best Practices Webinar (both recording and slides are available… 5″ and “`id` IN (5)” regarding indexes and performance? A: Recent MySQL versions are smart enough to convert … by desc” indicates a double linked list. Innodb has double linked list – each leaf page…
Post: Troubleshooting MySQL Upgrade Performance Regressions
February 15, 2012 By Leave a Comment
…instead of expected performance improvement you see your performance being worse. What should you do ? First if you followed MySQL upgrade best practices such… innodb_stats_on_metadata and increasing innodb-stats-sample-pages to get more accurate results. In recent Percona Server versions and MySQL…
