… tuned and it is recommended to turn this off. The query used is: select c_custkey, c_name, sum(l_extendedprice * (1… Innodb_buffer_pool_read_ahead which shows that the access pattern was sequential and hence InnoDB decided to do read_ahead, while in MySQL 5.5… in MariaDB 5.5 and not in MySQL 5.6, is that because of a bug in MySQL 5.6 code? As MRR was used in both MySQL 5.6 and MariaDB 5.5…
Post: Multiple purge threads in Percona Server 5.1.56 and MySQL 5.6.2
May 3, 2011 By 13 Comments
… become obsolete. In MySQL 5.1 this is done by the master InnoDB thread. Since then, InnoDB has been moving towards the parallelized purge: in MySQL 5.5 there is an option to have a single separate dedicated purge thread and in MySQL 5… change and by no means a replacement to proper future 5.6 tuning. MySQL 5.6.2 Results With Purge Sleeps Removed I’ve…
Post: Heikki Tuuri Innodb answers - Part I
October 26, 2007 By 17 Comments
…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.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: 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 70 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 …
