…of little known new features in MySQL 5.1 Q15: How frequently does Innodb fuzzy checkpointing is activated HT: InnoDB flushes about 128 dirty… HT: ha_innodb.cc in 5.1: static MYSQL_SYSVAR_ULONG(thread_concurrency, srv_thread_concurrency, PLUGIN_VAR_RQCMDARG, “Helps in performance tuning in heavily …
Post: MySQL 5.6 vs MySQL 5.5 and the Star Schema Benchmark
March 11, 2013 By 7 Comments
… configurations: Config 1: Default config for MySQL 5.5 and MySQL 5.6, no tuning at all Config 2: MySQL 5.6 with all default settings except innodb_old_blocks_time=0 Config 3: MySQL 5.5 and 5… is eligible to be moved to the hot portion. In MySQL 5.5 and earlier, innodb_old_blocks_time defaults to a value of 0…
Post: MySQL 5.5.8 - in search of stability
January 3, 2011 By 11 Comments
… conclusion in article [1]. My conclusion is: With doublewrite enabled, you can get a more or less stable line in MySQL 5.5.8 by tuning innodb_max_dirty_pages_pct and innodb_io_capacity; but the limiting factor is still innodb_log_file…
Post: MySQL Users Conference - Innodb
May 9, 2007 By 6 Comments
…in INSERT IGNORE and ON DUPLICATE KEY UPDATE cases. Now In MySQL 5.1…Innodb was first implemented. Many other transactional Storage Engines do not have the problems because they target at least MySQL 5.1…
Post: Percona Welcomes MySQL 5.6!
February 25, 2013 By Leave a Comment
…MySQL 5.5 was released, but MySQL 5.6 contains improvements started long before that – for example, work on the Innodb…tune your application to take advantage of MySQL 5.6′s features; create an in…
Post: Different flavors of InnoDB flushing
January 13, 2011 By 9 Comments
…, it seems MySQL 5.1 with the InnoDB-plugin, MySQL 5.5, and Percona Server show about the same performance in this case, …MySQL 5.1/InnoDB-plugin or 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: Tuning for heavy writing workloads
October 14, 2009 By 9 Comments
…=1, dbsize = 1000000, no thinktime XtraDB: (mysql-5.1.39 + XtraDB-1.0.4-current) innodb_io_capacity = 4000 innodb_support_xa = false innodb_file_per_table = true innodb… Plugin 1.0.4) In the end, the faster and more stable performance of db_STRESS benchmark is obtained by these tunings of…
Post: Innodb Performance Optimization Basics
November 1, 2007 By 75 Comments
… will not have uncontrolled innodb main tablespace growth which you can’t reclaim. This option was added in MySQL 4.1 and now stable… option has some performance benefits, especially in locking in 5.0 and even more to come with MySQL 5.1 and row level replication. There are bunch of other options you may want to tune but lets focus only on Innodb…
Post: MySQL Users Conference Presentation Proposals
October 24, 2007 By 12 Comments
…Innodb Tuning Options Innodb Storage Engine has a lot of tuning…Innodb has limited scalability with multiple CPUs and some of these were fixed in recent MySQL 5.0 versions. In…
Post: SHOW INNODB STATUS walk through
July 17, 2006 By 40 Comments
… of other things. In MySQL 5 number of Innodb performance counters were exported and now available in SHOW STATUS output… fetching rows, thread declared inside InnoDB 114 mysql tables in use 1, locked 0 MySQL thread id 8077, query … so you can tune it down. Even if free pages is zero as in this case …
