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: 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… 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…
Comment: SHOW INNODB STATUS walk through
June 15, 2009 By 40 Comments
[...] SHOW INNODB STATUS walk through | MySQL Performance Blog – June 15th ( tags: mysql innodb performance tuning database status monitoring reference ) [...]
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: Different flavors of InnoDB flushing
January 13, 2011 By 9 Comments
… for flushing, because that defines what MySQL InnoDB tuning should apply. The LRU list is used when InnoDB tries to read data from disk… your MySQL InnoDB tuning. Now I am about to make a strong statement: If your workload is LRU list bound, then InnoDB and MySQL settings…. Also, it seems MySQL 5.1 with the InnoDB-plugin, MySQL 5.5, and Percona Server show about the same performance in this case…
Post: New SpecJAppServer results at MySQL and Sun.
November 12, 2008 By Leave a Comment
… better to disable them. The MySQL Settings are probably what is the most interesting: MySQL 5.0 Tuning in /etc/my.cnf (included… bit lless of performance. innodb_thread_concurrency = 0 Good! So Innodb performed best in this workload without restricting number of threads inside Innodb Kernel. Again…
Page: Presentations
May 3, 2006 By
…MySQL Performance in DBT2 benchmark. Focuses mostly on Innodb but many findings are generally valid. Download MySQL/Innodb Performance: Server and Schema MySQL…
Post: MySQL Users Conference Presentation Proposals
October 24, 2007 By 12 Comments
… and when regressions. Practical MySQL Variables Tuning This session takes practical approach to MySQL variable tuning. Instead of giving you …. Transactional Storage Engines Performance We’re looking at performance at Open Source Transactional Storage engine MySQL – Innodb, Falcon, SolidDB, PBXT …
