MySQL Forums
Forum List  »  InnoDB

Re: Innodb unexplained IOs
Posted by: Bob Bankay
Date: February 08, 2005 04:31PM

Hi James,

Thanks for this detailed response. When you first posted it we had too much angst for the moment to appreciate all of it. Since then we have been running our replacement Opteron server as slave replica (it appears to be about 20x faster than the sparc box) and as soon as we are happy about its stability it will become the master. This will resolve the problem until we start hitting its limits of memory and IO capacity in the future.

For the Opteron we are using 4GB of buffer_pool, and 1GBx4 innodb_files. I know this does not meet your 50% per file suggestion but we are concerned about recovery time from outages and so will try to live with it, at least for a while.

Options: ReplyQuote


Subject
Views
Written By
Posted
4698
January 24, 2005 12:39PM
2481
January 24, 2005 12:43PM
2862
January 24, 2005 01:09PM
2943
January 24, 2005 05:40PM
2998
January 27, 2005 05:07AM
Re: Innodb unexplained IOs
2925
February 08, 2005 04:31PM
2455
January 31, 2005 11:32AM
2753
January 31, 2005 04:57PM
2846
February 03, 2005 06:23PM
3482
February 03, 2005 08:56PM
2836
February 04, 2005 01:25PM
2793
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.