… cases. Whatever powerful and well tuned system you have if you put too heavy of concurrent load on it the response times… to use. Do push concurrency too high Many developers will test script with multiple level of concurrency and find out doing work… to serve other users too you typically need to reduce concurrency to where it does not overload the system. Unless it…
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 …use MyISAM. If you have a huge number of concurrent writes and selects and query performance must be …speeds, tables which are easily maintained, is more easily tuned and a system that will run even when …
Post: Tuning InnoDB Concurrency Tickets
May 24, 2010 By 4 Comments
… innodb_concurrency_tickets that seems widely misunderstood. From the docs: “The number of threads that can enter InnoDB concurrently is determined by the innodb_thread_concurrency… you’re optimizing for throughput in this scenario, you will tune innodb_concurrency_tickets to the 99th percentile of small PK lookups. If…
Post: Innodb Performance Optimization Basics
November 1, 2007 By 70 Comments
… looking for more details, check out detailed guide on tuning innodb buffer pool innodb_log_file_size – This depends on your recovery speed…a lot of short write transactions. innodb_thread_concurrency=8 Even with current Innodb Scalability Fixes having limited concurrency helps. The actual number may…
Post: Should you move from MyISAM to Innodb ?
January 12, 2009 By 53 Comments
… to memory size), generally slower writes, slower blob handling, concurrency issues, problems dealing with very large number of tables, …) for logging. Innodb Needs Tuning As a final note about MyISAM to Innodb migration I should mention about Innodb tuning. Innodb needs tuning. Really. MyISAM …
Post: How Innodb Contention may manifest itself
July 28, 2011 By 1 Comment
… to note fine tuning Innodb Contention with number of spin locks loops is something i would consider last resort tuning, the performance improvements… number of Apache Children) as well as adjusting innodb_thread_concurrency and doing other server tuning should be first on your list. I…
Post: Heikki Tuuri Innodb answers - Part I
October 26, 2007 By 17 Comments
…_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…
Comment: When is it a time to upgrade memory ?
December 9, 2009 By 11 Comments
… default-storage-engine=InnoDB bulk_insert_buffer_size=8M # Innobd Tuning #innodb_force_recovery=2 innodb_thread_concurrency=2 innodb_file_per_table=1 innodb_doublewrite=0 # Set buffer pool size to 50-80% of your computer’s memory innodb…
Post: Moving from MyISAM to Innodb or XtraDB. Basics
November 22, 2010 By 2 Comments
… is very much workload dependent, and again concurrent tests should be important here. Innodb also may result in different plans for some… 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: What to tune in MySQL Server after installation
September 29, 2006 By 116 Comments
… created on disk. innodb_buffer_pool_size This is very important variable to tune if you’re using Innodb tables. Innodb tables are much… larger) so you can see how much memory Innodb allocates for misc needs. innodb_log_file_size Very important for write intensive… least 16. If application has large jumps in amount of concurrent connections and I see fast growth of Threads_Created variable…
