One of the very frequent cases with performance problems with MySQL is what they happen every so often … these does help in many cases. Whatever powerful and well tuned system you have if you put too heavy of concurrent…
Post: Multi Range Read (MRR) in MySQL 5.6 and MariaDB 5.5
March 21, 2012 By 10 Comments
… optimizer is choosing the query execution plan, is not sufficiently tuned and it is recommended to turn this off. The query… these lookups are performed in a single call to the storage engine and the counters Handler_read_key and Innodb_rows_read… and then to perform the MRR range scan on the PK. This causes the counters Handler_read_key and Innodb_rows_read…
Comment: Should you move from MyISAM to Innodb ?
March 10, 2012 By 53 Comments
…is) and that if not using InnoDB you aren’t too smart. However, InnoDB brings a lot of cons …huge number of concurrent writes and selects and query performance must be consistently fast in this use case – …, tables which are easily maintained, is more easily tuned and a system that will run even when …
Post: Innodb Performance Optimization Basics
November 1, 2007 By 70 Comments
… basics of Hardware OS And Application optimization. I call this Innodb Performance Optimization Basics so these are general guidelines which work well… easy on indexes). With these basic innodb performance tunings you will be better of when majority of Innodb users which take MySQL with defaults…
Post: Heikki Tuuri Innodb answers - Part I
October 26, 2007 By 17 Comments
…: ha_innodb.cc in 5.1: static MYSQL_SYSVAR_ULONG(thread_concurrency, srv_thread_concurrency, PLUGIN_VAR_RQCMDARG, “Helps in performance tuning in heavily concurrent environments. Sets the max\ imum number of threads allowed inside InnoDB. Value 0 will disable…
Post: Should you move from MyISAM to Innodb ?
January 12, 2009 By 53 Comments
…. QA has to be performed as part of the move. Performance Innodb has a lot to offer in terms of performance – Performance benefits and drawbacks…% performance improvement but I can perfectly use MyISAM (or Archive) for logging. Innodb Needs Tuning As a final note about MyISAM to Innodb migration…
Post: Choosing innodb_buffer_pool_size
November 3, 2007 By 38 Comments
My last post about Innodb Performance Optimization got a lot of comments choosing proper innodb_buffer_pool_size and indeed I oversimplified things… write a bit better description. Innodb Buffer Pool is by far the most important option for Innodb Performance and it must be set… Large Pages for allocating Innodb Buffer Pool and few other buffers, which may have other performance benefits as well. Tuning your VM to…
Post: Moving from MyISAM to Innodb or XtraDB. Basics
November 22, 2010 By 2 Comments
… guaranty you will never run into them. Performance Benchmarks – Innodb and MyISAM have different performance properties and you can’t really say one… do not want to try to run Innodb or XtraDB with them. Second Innodb is tuned to be ACID by default – if you… innodb_flush_log_at_trx_commit, innodb_buffer_pool_size and innodb_log_file_size. There are a lot more options for fine tuning…
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… is smaller than allocated buffer pool size so you can tune it down. Even if free pages is zero as in…
Post: MySQL Users Conference - Innodb
May 9, 2007 By 6 Comments
….0+ Heikki also mentioned there are more things inside Innodb to unleash performance such as multiple purge threads or parallel log recovery… properly before really enabling it. Innodb IO Tuning I should also mention Paul Tuckfield Keynote about Scaling Innodb at YouTube. There were many…
