MySQL Forums
Forum List  »  Performance

Re: slow queries and high % of wait I/O
Posted by: Vince Gatto
Date: January 20, 2009 12:46AM

Rick, I don't want to derail the original poster, but I was wondering if you've got a good feel for the cost of page read, in terms of time. And if you do, can you work backwards from that to figure out what 100% I/O wait should be, assuming other processes disk usage is negligible? For example, if your average seek + transfer time is 10ms and you're missing the page pool 1 out of 30 times, you would have to be running 3000 primary key lookups per second to reach 100% I/O wait.

Options: ReplyQuote


Subject
Views
Written By
Posted
2950
January 19, 2009 05:36PM
2587
January 19, 2009 11:37PM
2411
January 21, 2009 01:22AM
Re: slow queries and high % of wait I/O
2333
January 20, 2009 12:46AM
2355
January 20, 2009 01:28AM
2285
January 20, 2009 08:41PM


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.