One of the very frequent cases with performance problems with MySQL is what they happen every so often or certain times. … need to know it is not MySQL problem, might be even not problem with your MySQL configuration, queries and hardware, even though fixing these does help in many cases. Whatever powerful and well tuned system…
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… were captured when performing the benchmark on IO bound workload, mentioned above. Counter Name MySQL 5.5 MySQL 5.6 MySQL 5.6 w… MRR are performing badly. The interesting thing is that though both MariaDB and MySQL 5.6 are reporting high numbers for Innodb_rows…
Comment: Should you move from MyISAM to Innodb ?
March 10, 2012 By 53 Comments
… MySQL community are snobbish about using MyISAM (not using it that is) and that if not using InnoDB…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: Side load may massively impact your MySQL Performance
November 13, 2011 By 7 Comments
… MySQL interactive performance…mysql –mysql-host=localhost –mysql-table-engine=innodb –mysql-db=test –oltp-table-name=md_cache_test_small –oltp-table-size=1100000 –mysql-user=msandbox –mysql…tuning you might also look into changing how buffer pool is split into young and old sublists via innodb…
Post: Read Buffers, mmap, malloc and MySQL Performance
September 12, 2007 By 8 Comments
… together with strace) are great tools for MySQL Performance analyses. Too many people end tuning on plans and indexes while there well could… to use large pages. These already can be used for Innodb Buffer Pool and Key Buffer but could be used for… you could just grab one having allocation very quick. Also MySQL should get smarter in terms of which buffer size should…
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: Why you should ignore MySQL's key cache hit ratio
February 28, 2010 By 27 Comments
… good instrumentation in MySQL to guide your decisions. It is also not the be-all and end-all of MySQL performance, and people… it? What about InnoDB tuning? You might be wondering, what about InnoDB tuning? What is the best way to choose an innodb_buffer_pool_size…-based and counter-based tuning techniques. Summary Major points in this article: Counter ratios are meaningless as a performance analysis metric because…
Post: Innodb Performance Optimization Basics
November 1, 2007 By 70 Comments
… only on Innodb ones today. You can check about tuning other options here or read one of our MySQL Presentations. Application tuning for Innodb Especially… indexes). With these basic innodb performance tunings you will be better of when majority of Innodb users which take MySQL with defaults run it on…
Post: Different flavors of InnoDB flushing
January 13, 2011 By 9 Comments
…, http://dimitrik.free.fr/blog/archives/2010/12/mysql-performance-analyzing-perconas-tpcclike-workload-on-mysql-55.html). But you can’t really… MySQL 5.5 the setting of innodb_adaptive_flushing, innodb_max_dirty_pages_pct, innodb_io_capacity, and innodb_log_file_size are important for tuning…
Post: What to tune in MySQL Server after installation
September 29, 2006 By 116 Comments
… work as MySQL DBAs or be involved with MySQL Performance in some way is to ask them what should be tuned in MySQL Server straight… created on disk. innodb_buffer_pool_size This is very important variable to tune if you’re using Innodb tables. Innodb tables are much… may decrease performance. I normally leave per session variable tuning to second step after I can analyze workload. P.S Note MySQL distribution…
