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.
Subject
Views
Written By
Posted
4606
January 24, 2005 12:39PM
2435
January 24, 2005 12:43PM
2822
January 24, 2005 01:09PM
2908
January 24, 2005 05:40PM
2960
January 27, 2005 05:07AM
Re: Innodb unexplained IOs
2897
February 08, 2005 04:31PM
2713
January 26, 2005 02:37PM
2824
January 27, 2005 06:56PM
2422
January 31, 2005 11:32AM
2718
January 31, 2005 04:57PM
2802
February 03, 2005 06:23PM
3437
February 03, 2005 08:56PM
2808
February 04, 2005 01:25PM
2753
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.