…mysql> select * from innodb_rseg; +———+———-+———-+———+————+———–+ | rseg_id | space_id | zip_size | page_no | max…innodb_max_purge_lag to make a threads doing modifications slow down if purge…
Post: SHOW INNODB STATUS walk through
July 17, 2006 By 40 Comments
…of internal Innodb performance counters, statistics, information about transaction processing and all kinds of other things. In MySQL 5 number of Innodb performance …also grow and innodb_max_purge_lag will become your friend. “undo n:o” will show the undo log record number which purge is currently…
Post: Percona Server 5.1.49-rel12.0
September 15, 2010 By 6 Comments
…MySQL 5.5. (Oleg Tsarev) query_cache_totally_disable – Allows the user to disable use of the query cache. (Oleg Tsarev, backport from MySQL 5.5…#592007 – More strictly enforces the maximum purge delay defined by innodb_max_purge_lag by removing the requirement that purge operations be delayed if an …
Post: Percona Server 5.1.49-rel11.3
September 10, 2010 By 1 Comment
… features Percona Server 5.1.49-rel11.3 is based on MySQL 5.1.49. A new variable was introduced: innodb_use_sys_stats… innodb_buffer_pool_pages_index table on systems with a large number of tables Bug #592007 – More strictly enforces the maximum purge delay defined by innodb_max_purge_lag by removing the requirement that purge operations be delayed if an old…
Comment: MySQL on Amazon RDS part 2: Determining Peak Throughput
March 28, 2011 By 4 Comments
Peter, it’s 5.1.50, to match the client’s version of MySQL; they are very careful about upgrades. The RDS… innodb_log_file_size 134217728 innodb_log_files_in_group 2 innodb_log_group_home_dir /rdsdbdata/log/innodb innodb_max_dirty_pages_pct 75 innodb_max_purge_lag 0 innodb_mirrored_log_groups 1 innodb_old_blocks_pct 37 innodb_old_blocks_time 0 innodb_open_files 300 innodb…
Comment: Disaster: MySQL 5.5 Flushing
September 19, 2011 By 27 Comments
… as we eventually do now if innodb_max_purge_lag is set. The page cleaner thread and tweaks in 5.6, as well as the…, though we made it perhaps thirty times as fast in 5.1 plugin and later without parallel recovery, so there’s… sustainable also needs to be a polite one. James Day, MySQL Senior Principal Support Engineer, Oracle UK
Comment: Multiple purge threads in Percona Server 5.1.56 and MySQL 5.6.2
May 3, 2011 By 13 Comments
….free.fr/blog/archives/2010/04/mysql-performance-why-purge-thread-in-innodb.html) and very hope since MySQL 5.6 there will be no… performance I’m still preferring a combination of “Purge Thread + max purge lag setting” rather several Purge Threads as it gave me better performance results…
