… single separate dedicated purge thread and in MySQL 5.6.2 one can have multiple dedicated purge threads. Percona Server 5.1 supports multiple purge threads too, although… setting–multiple purge thread implementation at the moment seems to be the one in Percona Server 5.1. MySQL 5.6.2 multiple purge threads have…
Post: MySQL Users Conference - Innodb
May 9, 2007 By 6 Comments
… to build indexes in parallel by running sorts in different threads – using multiple cores becomes increasingly important as their number per CPU… are more things inside Innodb to unleash performance such as multiple purge threads or parallel log recovery features, which he however needs to…
Post: Percona Server and XtraBackup Weekly News, April 18th
April 18, 2011 By Leave a Comment
… specific 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 2 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: Multiple purge threads in Percona Server 5.1.56 and MySQL 5.6.2
May 3, 2011 By 13 Comments
Dimitri, innodb_max_purge_lag can indeed be good for uniform workloads this is … like history size to be cleaned up eventually, which requires multiple purge threads for IO bound processing.
Comment: MySQL 5.5.8 and Percona Server: being adaptive
December 20, 2010 By 25 Comments
… can do multiple batches in one second. In 5.5 we tidied it up a little and forced master thread to sleep… don’t think purge should be a concern. But to keep master thread free of getting stuck in purge maybe it is a good idea to use innodb_purge_threads = 1.
Post: InnoDB, InnoDB-plugin vs XtraDB on fast storage
January 13, 2010 By 12 Comments
…-plugin is doing much better here, it allows to utilize multiple IO threads, which as we saw ( http://www.mysqlperformanceblog.com/2010… XtraDB. In additional to multiple IO threads, we have patch to decrease contention on buffer_pool mutex, plus separate purge thread. Also we use…
Comment: MySQL Replication vs DRBD Battles
May 1, 2008 By 12 Comments
… buffer cache + pending IO from insert buffer + pending IO for purge thread). When the max is exceeded the server can favor background… IO in a server. Is there any parallelism or concurrency (multiple threads or multiple IOs pending) in InnoDB crash recovery code? The Google…). This was done using the same replication protocol — the IO thread would copy events into the relay log and the mirrored…
Post: Shard-Query EC2 images available
May 11, 2011 By 2 Comments
…. It is possible to distribute splitting and/or loading among multiple nodes as well. Note that in the demonstration each node… innodb_fast_checksum innodb-purge-threads=1 innodb-read-ahead=linear innodb-read-ahead-threshold=8 innodb-read-io-threads=16 innodb-recovery… innodb-thread-concurrency=0 innodb-thread-concurrency-timer-based innodb-thread-sleep-delay=0 innodb-use-sys-stats-table innodb-write-io-threads=4…
Post: SHOW INNODB STATUS walk through
July 17, 2006 By 40 Comments
… n:o is number of transaction to which purge is done. Innodb can only purge old versions if they there are no… in “Sleep” stage – if it is multiple statement transaction. Innodb also will print OS thread_id and process id which may be…, state of Innodb main thread which controls scheduling of number of system operations – flushing dirty pages, checkpointing, purging, flusing logs, doing insert…
