Skip navigation links

MySQL Forums :: InnoDB :: Innodb unexplained IOs


Advanced Search

Re: Innodb unexplained IOs
Posted by: James Day ()
Date: February 03, 2005 08:56PM

This might be a factor: 197333 inserts, 167667 merged recs, 17805 merges. One of the user comments in the manual suggests that the activity will continue with merging the inserts until the number of merged records equals the number of inserts, as the records in the insert buffer are merged into the clustered index nodes. You can read more about the insert buffer at http://dev.mysql.com/doc/mysql/en/innodb-insert-buffering.html .

In addition, there's the "Main thread id 8, state: purging " portion, indicating the presence of deleted record purging activity.

Those suggest that the server had more insert and deletion activity that it could sustain and is still in the process of catching up, saved from being overwhelmed by the insert buffer and delayed delete purging.

If able you might try keeping laod from it and/or allocating more InnoDB cache RAM than usual to help to reduce the disk load as far as practical while this work continues.

Options: ReplyQuote


Subject Views Written By Posted
Innodb unexplained IOs 2925 Bob Bankay 01/24/2005 12:39PM
Re: Innodb unexplained IOs 1622 Bob Bankay 01/24/2005 12:43PM
Re: Innodb unexplained IOs 1987 Heikki Tuuri 01/24/2005 01:09PM
Re: Innodb unexplained IOs 1946 Bob Bankay 01/24/2005 05:40PM
Re: Innodb unexplained IOs 2045 James Day 01/27/2005 05:07AM
Re: Innodb unexplained IOs 1944 Bob Bankay 02/08/2005 04:31PM
Re: Innodb unexplained IOs -still need help! 1724 Bob Bankay 01/26/2005 02:37PM
Re: Innodb unexplained IOs - have finally stopped 1911 Bob Bankay 01/27/2005 06:56PM
Re: Innodb unexplained IOs 1664 Heikki Tuuri 01/31/2005 11:32AM
Re: Innodb unexplained IOs 1790 Bob Bankay 01/31/2005 04:57PM
Re: Innodb unexplained IOs 1920 Jeff Cobb 02/03/2005 06:23PM
Re: Innodb unexplained IOs 2405 James Day 02/03/2005 08:56PM
Re: Innodb unexplained IOs 1927 Jeff Cobb 02/04/2005 01:25PM
Re: Innodb unexplained IOs 1934 James Day 02/04/2005 01:44PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.