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 2935 Bob Bankay 01/24/2005 12:39PM
Re: Innodb unexplained IOs 1625 Bob Bankay 01/24/2005 12:43PM
Re: Innodb unexplained IOs 1989 Heikki Tuuri 01/24/2005 01:09PM
Re: Innodb unexplained IOs 1951 Bob Bankay 01/24/2005 05:40PM
Re: Innodb unexplained IOs 2050 James Day 01/27/2005 05:07AM
Re: Innodb unexplained IOs 1955 Bob Bankay 02/08/2005 04:31PM
Re: Innodb unexplained IOs -still need help! 1729 Bob Bankay 01/26/2005 02:37PM
Re: Innodb unexplained IOs - have finally stopped 1916 Bob Bankay 01/27/2005 06:56PM
Re: Innodb unexplained IOs 1669 Heikki Tuuri 01/31/2005 11:32AM
Re: Innodb unexplained IOs 1793 Bob Bankay 01/31/2005 04:57PM
Re: Innodb unexplained IOs 1934 Jeff Cobb 02/03/2005 06:23PM
Re: Innodb unexplained IOs 2412 James Day 02/03/2005 08:56PM
Re: Innodb unexplained IOs 1941 Jeff Cobb 02/04/2005 01:25PM
Re: Innodb unexplained IOs 1939 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.