… –session-init-query command-line option, we set the option innodb_fake_changes to prevent INSERTs, UPDATEs, and DELETEs from corrupting… server. You will need Percona Server in order to use innodb_fake_changes. Thread pool Percona Playback added a connection pool… chunk 4’s workload warmed up with chunk 3. The result is similar for every single graph, each chunk warmed up the buffer pool…
Post: My "hot" list for next InnoDB features
March 30, 2009 By 18 Comments
Many InnoDB scalability problems seem fixed in InnoDB-plugin-1.0.3 and I expect InnoDB-plugin will run fine on 16-24…. You can use custom queries by primary / secondary key to “warm up” part of table, but this solution is ugly and may… on slave which is not warmed up properly – slave may never catch up slave, but with small load warm up may take hours to complete…
Post: How well does your table fits in innodb buffer pool ?
December 9, 2010 By 12 Comments
…_id = innodb_sys_tables.id JOIN innodb_index_stats ON innodb_index_stats.table_name = innodb_sys_tables.name AND innodb_sys_indexes.name = innodb_index_stats.index_name AND innodb_index_stats.table_schema = innodb… these stats during warmup to see what is really getting warmed up first as well as how buffer pool is affected by…
Post: InnoDB vs MyISAM vs Falcon benchmarks - part 1
January 8, 2007 By 117 Comments
… was a popular myth that MyISAM is faster than InnoDB in reads, as InnoDB is transactional, supports Foreign Key and has an… MyISAM / InnoDB: libexec/mysqld –no-defaults –user=root –key-buffer-size=1500M –innodb-buffer-pool-size=1500M –innodb-log-file-size=100M –innodb-thread…, 128, 256 concurrent threads. 3. For each thread perform a warm-up run (duration 180 sec), and then run three effective runs…
Post: InnoDB compression woes
May 20, 2011 By 14 Comments
InnoDB compression is getting some traction, and I see quite contradictory … this will report us results each 10 sec. After initial warm-up the throughput for regular tables are stabilized on level 4650… 7%. Obviously we have some mutex serialization problem. Analyzing SHOW INNODB STATUS (SEMAPHORES) for workload with compression tables we can see…
Comment: How long Innodb Shutdown may take
September 3, 2010 By 9 Comments
I’m waiting for part 2 – how long InnoDB warm up might take? I have my own ideas, but I’d like to see how you would put it in words.
Post: Index Condition Pushdown in MySQL 5.6 and MariaDB 5.5 and its performance impact
March 12, 2012 By 12 Comments
I have been working with Peter in preparation for the talk comparing the optimizer enhancements in MySQL 5.6 and MariaDB 5.5. We are taking a look at and benchmarking optimizer enhancements one by one. So in the same way this blog post is aimed at a new optimizer enhancement Index Condition …
Post: Join Optimizations in MySQL 5.6 and MariaDB 5.5
April 4, 2012 By 4 Comments
… in-memory workload, the InnoDB buffer pool size is set to 6G and the buffer pool was warmed up, so that the relevant… IO bound workload, the InnoDB buffer pool size is set to 1G and the buffer pool was not warmed up, so that it does not have the relevant pages loaded up already. Now let’s take…
Post: Troubleshooting MySQL Upgrade Performance Regressions
February 15, 2012 By Leave a Comment
… fully warmed up system. Rather often people panic and what thought to be slow down with version upgrade is rather system warming up. You need to compare apples to apples such as both systems after restart or even better both systems fully warmed up… update the stats. You may consider disabling innodb_stats_on_metadata and increasing innodb-stats-sample-pages to get more accurate results…
Post: Multi Range Read (MRR) in MySQL 5.6 and MariaDB 5.5
March 21, 2012 By 10 Comments
… in-memory workload, the InnoDB buffer pool size is set to 6G and the buffer pool was warmed up, so that the relevant… IO bound workload, the InnoDB buffer pool size is set to 1G and the buffer pool was not warmed up, so that it does not have the relevant pages loaded up already: MRR does make a…
