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
4788
January 24, 2005 12:39PM
2580
January 24, 2005 12:43PM
2902
January 24, 2005 01:09PM
2978
January 24, 2005 05:40PM
3026
January 27, 2005 05:07AM
Re: Innodb unexplained IOs
2954
February 08, 2005 04:31PM
2801
January 26, 2005 02:37PM
2905
January 27, 2005 06:56PM
2485
January 31, 2005 11:32AM
2795
January 31, 2005 04:57PM
2889
February 03, 2005 06:23PM
3520
February 03, 2005 08:56PM
2898
February 04, 2005 01:25PM
2832
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.