MySQL Forums
Forum List  »  InnoDB

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
4722
January 24, 2005 12:39PM
2492
January 24, 2005 12:43PM
2868
January 24, 2005 01:09PM
2948
January 24, 2005 05:40PM
3001
January 27, 2005 05:07AM
2927
February 08, 2005 04:31PM
2459
January 31, 2005 11:32AM
2758
January 31, 2005 04:57PM
2854
February 03, 2005 06:23PM
Re: Innodb unexplained IOs
3487
February 03, 2005 08:56PM
2840
February 04, 2005 01:25PM
2800
February 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.