… and your purge_thread. The history list length never exceed 20000 during any TPC-C test at the server. And purge_thread affect 3~4% improve of throughput and it seems to purge aggressively (not exceed 1000). And about 32 threads, the server has 16 cores and the each thread of the…
Post: Percona Server 5.1.57-12.8 Stable Release
June 8, 2011 By 10 Comments
… for innodb_use_purge_threads has been corrected to 32 (maximum number of parallel threads in a parallelized operation). The innodb_purge_thread patch accepted a value up to 64 for the innodb_use_purge_thread variable…
Post: How to load large files safely into InnoDB with LOAD DATA INFILE
July 3, 2008 By 29 Comments
… the load — but from other transactions’ changes too; the purge thread cannot purge them, so everything gets bloated and slow. Even simple SELECT… scan through lots of obsolete, but not-yet-purged, row versions. Later, the purge thread will have to clean these up. This is…
Post: MySQL 5.5.8 - in search of stability
January 3, 2011 By 11 Comments
…_files_in_group = 2 innodb_read_io_threads = 16 innodb_write_io_threads = 16 innodb_purge_threads=1 innodb_adaptive_flushing=1 innodb_doublewrite…_read_io_threads = 16 innodb_write_io_threads = 16 innodb_io_capacity=500 innodb_max_dirty_pages_pct = 60 innodb_purge_threads=1 innodb…
Comment: Multiple purge threads in Percona Server 5.1.56 and MySQL 5.6.2
May 3, 2011 By 13 Comments
Peter, don’t forget that “innodb_max_purge_lag” is dynamic – so if you’ve some planned night … the needed value once activity is back to the normal.. Purge has an important cost, and for the moment all proposed solution so speed-up the purge are also considerably slowing down TPS level.. – that’s why “Purge Thread + max purge lag” is looking as…
Post: MySQL 5.6: Improvements in the Nutshell
January 27, 2013 By 16 Comments
…-Recursive Deadlock Detection – Faster Locking Primitives – Improved Innodb Thread Concurrency – Multiple background Purge Threads – Improved Purge lag control (now works) – Split of “Kernel Mutex” – Data Dictionary Cache – Improved Adaptive Flushing – Page Cleaner/Separate Flush Thread…
Post: Percona Server and XtraBackup Weekly News, April 18th
April 18, 2011 By Leave a Comment
… Percona Server news items, We are fixing and backporting multiple purge thread support from 5.6 to 5.1, to replace the… bugs, but we found a bug in 5.1′s purge-thread functionality that I think is of interest to some fork…
Comment: Purge Thread Spiral of Death
February 14, 2011 By 5 Comments
When will Percona support multiple purge threads? The docs claim that more than one is experimental — http://www.percona.com/docs/wiki/percona-server:features:innodb_purge_thread
Comment: Which adaptive should we use?
September 17, 2009 By 14 Comments
Hi Dimitri, OK. I understand. 
But this topics is about the flushing. I think the purging is next problem (though both of them are done by master thread currently…). I will test it soon (also your purge_thread effect). Please wait to discuss about it. Regards, Yasufumi
Comment: Multiple purge threads in Percona Server 5.1.56 and MySQL 5.6.2
May 3, 2011 By 13 Comments
Laurynas, Is this CPU bound or IO bound purge operation ? In this case with short transactions in Sysbench, which … is able to catch up with workload even with 1 purge thread while I know from the practice there are many cases… more gains to get if you can trigger IO bound purge. I’d also use just update-key in sysbench instead…
