… frequently you have purge not being the problem at all and when out of no where you can see purge thread being unable… is when problems often starts to happen. Now instead of purge thread simply operating in memory it has to perform IO which… it can be controlled), using innodb_max_purge_lag or enable separate purge thread (or threads) via innodb_use_purge_thread if you’re running Percona Server.
Post: Multiple purge threads in Percona Server 5.1.56 and MySQL 5.6.2
May 3, 2011 By 13 Comments
… 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.6.2 one can have multiple dedicated purge threads. Percona Server 5.1 supports multiple purge threads too…
Post: InnoDB, InnoDB-plugin vs XtraDB on fast storage
January 13, 2010 By 12 Comments
… doing much better here, it allows to utilize multiple IO threads, which as we saw ( http://www.mysqlperformanceblog.com/2010/01…. In additional to multiple IO threads, we have patch to decrease contention on buffer_pool mutex, plus separate purge thread. Also we use different…-plugin or XtraDB to get better results. Putting logs on separate partition may be good idea, but only if you have…
Post: Percona-XtraDB-9.1: released and new coming features
March 17, 2010 By 14 Comments
… 5.0: extended slow.log USER/TABLE/INDEX/CLIENT_STATISTICS + THREAD_STATISTICS ( coming in release-10) Extended slow.log is now… scalability Fast recovery Improved IO path Improved rollback segment scalability Separate purge thread Limited size of data dictionary in memory Increased number of…
Post: XtraDB storage engine release 1.0.6-9
January 13, 2010 By 9 Comments
… InnoDB plugin. MySQL 5.1.42 as a base release Separate purge thread and LRU dump is implemented (this feature was actually added…
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… and large range scans. We surely should benchmark this aspect separately. Improved Auto Increment handling Yet another known Innodb problem is… more things inside Innodb to unleash performance such as multiple purge threads or parallel log recovery features, which he however needs to…
Post: SHOW INNODB STATUS walk through
July 17, 2006 By 40 Comments
… section shows state of file IO helper threads – insert buffer thread, log thread, read thread and write thread. These are responsible appropriately for insert buffer… checkpoint log writes. Number of log/io operations allows to separate tablespace related IO from log related IO so you can…, state of Innodb main thread which controls scheduling of number of system operations – flushing dirty pages, checkpointing, purging, flusing logs, doing insert…
Post: My Innodb Feature wishes
May 4, 2006 By 30 Comments
… if possible as we know they are going to be purged. Long Rows. One ugly thing Innodb currently does is storing… multiple threads for some tasks would be helpful, especially for flushing dirty buffers. I would actually like to see it separated to different options – for example it does not make much sense to have more than one log flush thread. The…
