Re: Innodb unexplained IOs
Posted by:
Bob Bankay
Date: January 31, 2005 04:57PM
Heikki,
Thanks for the information. We guessed that it was doing garbage collection of some kind, perhaps redoing indices. Anyway our large table is volatile with lots of updates . inserts amd deletes. We also have long running queries. In general would reducing the duration of our queries in turn reduce the need for row versions and reduce the duration of these garbage collections?
Is there variable or option to control how or when innodb will initiate garbage collection? We would like to be able to control when and to what degree garbage collection is carried out.
Would this be a new feature? If so how do I request it?
Bob
Subject
Views
Written By
Posted
4993
January 24, 2005 12:39PM
2673
January 24, 2005 12:43PM
2973
January 24, 2005 01:09PM
3045
January 24, 2005 05:40PM
3096
January 27, 2005 05:07AM
3024
February 08, 2005 04:31PM
2887
January 26, 2005 02:37PM
2956
January 27, 2005 06:56PM
2542
January 31, 2005 11:32AM
Re: Innodb unexplained IOs
2871
January 31, 2005 04:57PM
2950
February 03, 2005 06:23PM
3587
February 03, 2005 08:56PM
2966
February 04, 2005 01:25PM
2899
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.