… open-source, free MySQL hot backup software that performs non-blocking backups for InnoDB and XtraDB databases. This release is the current… pool dump files). Percona XtraBackup has implemented support for the InnoDB Buffer Pool Preloading introduced in MySQL 5.6. Starting with… can spend a lot of time opening all the tablespaces. Optimization has been implemented and XtraBackup now avoids loading non-relevant…
Post: Keynotes, BOFs, and the Community Networking Reception at Percona Live MySQL Conference and Expo
April 15, 2013 By 1 Comment
… 5.6: What’s New in InnoDB” Dmitri Kravtchuk, MySQL Performance Architect, Oracle Topic: “MySQL 5.6: Performance Benchmarks, Tuning, and ‘Best’ Practices… 10.0 & What’s New With the Project” Sergei Petrunia, Optimizer Developer, and Colin Charles, Chief Evangelist, MariaDB, for Monty Program…
Post: Innodb Performance Optimization Basics
November 1, 2007 By 75 Comments
… Application optimization. I call this Innodb Performance Optimization Basics so these are general guidelines which work well for wide range of applications, though the optimal… on indexes). With these basic innodb performance tunings you will be better of when majority of Innodb users which take MySQL with defaults…
Post: Performance Optimization and Six Sigma
June 7, 2010 By 6 Comments
… on performance rather than performance stability even though it is the later what their users really care about. Consider Adaptive Checkpoint in Innodb for example – until it got implemented we had very poor performance stability under very large number….7%. One reason we use rather weak confidence intervals in performance optimization is we need a lot of transactions to get stable…
Post: Choosing innodb_buffer_pool_size
November 3, 2007 By 39 Comments
My last post about Innodb Performance Optimization got a lot of comments choosing proper innodb_buffer_pool_size and indeed I oversimplified things a… write a bit better description. Innodb Buffer Pool is by far the most important option for Innodb Performance and it must be set… use Large Pages for allocating Innodb Buffer Pool and few other buffers, which may have other performance benefits as well. Tuning your…
Page: Presentations
May 3, 2006 By
… as solve other performance related problems. Download Innodb Performance Optimization MySQL Users Conference 2007, Santa Clara,CA, April 2007 Presentation covering Innodb specific application design… MySQL/Innodb Performance Optimization OSCON 2004, Portland, OR Performance optimization in numbers. Presentation shows how changing various MySQL Server OS and Hardware parameters affect MySQL Performance…
Post: Tuning InnoDB Concurrency Tickets
May 24, 2010 By 5 Comments
… in the table) – 1 As with any performance optimization effort, you will want to optimize for the common case. If you have a… a significant amount of time. Setting innodb_concurrency_tickets too high can have startlingly negative performance implications. On the other hand, if…=1900M innodb_thread_concurrency=16 innodb_flush_method = O_DIRECT innodb_write_io_threads=8 innodb_read_io_threads=8 innodb_io_capacity=500 innodb_max…
Post: Guidance for MySQL Optimizer Developers
September 20, 2009 By 4 Comments
… spend large portion of my life working on MySQL Performance Optimization and so MySQL Optimizer is quite important to me. For probably last… or Innodb) others keep database on SSD which has completely different ratio between CPU and IO cost. Focus on Execution Methods Performance problems can be due to optimizer picking the wrong plan, such as doing…
Post: Full table scan vs full index scan performance
November 23, 2012 By 15 Comments
… with EXPLAIN as Extra: Using index) is a very interesting performance optimization, a full index scan (type: index) is according to the…> ALTER TABLE employees ADD INDEX idx_first (first_name),ENGINE=InnoDB; And then let’s consider this query: SELECT * FROM employees… scan and no filesort. But predicting how a query will perform by only looking at the execution plan is not enough…
Post: How InnoDB handles REDO logging
February 3, 2011 By 19 Comments
Xaprb (Baron) recently blogged about how InnoDB performs a checkpoint , I thought it might be useful to explain …, InnoDB uses Physiological logging, this basically means that it combines the two techniques to provide a logging mechanism that is both optimal… background processing of dirty pages can then apply algorithms to optimize those writes during checkpoint. What else? There is of course…
