…then performing the lookup, and then there are other possibilities like InnoDB…lookup will be performed. So key-ordered scan is basically an …optimizer_switch=’index_condition_pushdown=off’ optimizer_switch=’mrr=on’ optimizer_switch=’mrr_sort_keys=on’ optimizer_switch=’mrr_cost_based=off’ optimizer…
Post: Innodb Performance Optimization Basics
November 1, 2007 By 70 Comments
… like to hear extending it with basics of Hardware OS And 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 settings…
Comment: Innodb Performance Optimization Basics
June 13, 2009 By 70 Comments
[...] some sane InnoDB performance options per Innodb Performance Optimization Basics at the MySQL Performance [...]
Comment: Innodb Performance Optimization Basics
September 17, 2009 By 70 Comments
[...] Innodb Performance Optimization Basics | MySQL Performance Blog (tags: mysql innodb) [...]
Comment: Innodb Performance Optimization Basics
November 20, 2007 By 70 Comments
[...] InnoDB Performance Optimization Basics [...]
Page: Presentations
May 3, 2006 By
…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: SHOW INNODB STATUS walk through
July 17, 2006 By 40 Comments
… to improve MySQL Performance. To start with basics SHOW INNODB STATUS is command which prints out a lot of internal Innodb performance counters, statistics, information about transaction processing and all kinds of other things. In MySQL 5 number of Innodb performance counters… have been flushed you can check if your innodb_log_buffer_size is optimal – if you see more than 30% of log…
Post: How InnoDB handles REDO logging
February 3, 2011 By 18 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 in…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
…stage. Is it the current performance, future performance, scalability, ability to recover …Basically, anything but silence in the error log is interesting and needs to be investigated. You might find that there are InnoDB… Schema, query, and index optimization Analyzing and optimizing a server’s table…
Post: Heikki Tuuri Innodb answers - Part I
October 26, 2007 By 17 Comments
… search almost as efficient as a binary search can be performed. But InnoDB‘s adaptive hash indexes require that the prefix is… 8G write ahead log and tell innodb to do a full write of the database (basically dump memory to disk) once every… InnoDB‘s flushes smoother and increase performance substantially. I assume there is lots of room to tune the flushes, since I never optimized…
