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
4138
January 24, 2005 12:39PM
2195
January 24, 2005 12:43PM
2573
January 24, 2005 01:09PM
2623
January 24, 2005 05:40PM
2710
January 27, 2005 05:07AM
Re: Innodb unexplained IOs
2595
February 08, 2005 04:31PM
2212
January 31, 2005 11:32AM
2457
January 31, 2005 04:57PM
2573
February 03, 2005 06:23PM
3196
February 03, 2005 08:56PM
2576
February 04, 2005 01:25PM
2502
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.