Percona's MySQL & InnoDB performance and scalability blog
… Extra: Using index) is a very interesting performance optimization, a full index scan (type: index) is …employees ADD INDEX idx_first (first_name),ENGINE=InnoDB; And then let’s consider this query: SELECT … based on a full index scan is basically the difference between sequential reads and random …
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…
…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…
…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…
…performance in the third installment. For now, the important number here is to note that the InnoDB…
… 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…
… the introduction of the “index merge” optimizer plan. The basic idea behind index merge is that… a significant performance win, perhaps. Sometimes it is. Other times, it is a major performance killer….status` (status), INDEX `user_type` (user_type) ) ENGINE=InnoDB; SELECT user_id FROM user WHERE user…
… have to consider on case by case basics before recommending the move. Is MyISAM used …cases this is deliberate choice with system being optimized to deal with MyISAM limits, for example … to be performed as part of the move. Performance Innodb has a lot to offer in terms of performance – Performance …
…, rows are the worst case for performance. Optimal mathematical performance requires operations on reduced sets. … can automatically partition sets into subsets using basic relational algebra substitution rules that are… performance level. Soon you will be able to set up computation over ICE, InnoDB,…
…, and then we will go to solutions. The basic problem is that, unfortunately, none of the existing … of how it works, instead of performing 1 random write, InnoDB will perform 8 random writes. I do not … will limit the rate of changes in memory. Optimize the flushing of sequential neighbor pages in a…
Copyright © Percona LLC • Contact Us • MySQL and InnoDB are trademarks of Oracle Corp.