MySQL Forums :: InnoDB :: Innodb unexplained IOs

Advanced Search

Re: Innodb unexplained IOs
Posted by: James Day ()
Date: January 27, 2005 05:07AM

From the look of that you have 16070 / 72768 = 22% dirty pages. Main thread seems to be in state: purging. Try SET GLOBAL innodb_max_dirty_pages_pct=1; (do it in steps of a few percent at a time from 22 to 1 if this is a production server under load because it'll prompt a surge in disk activity). Wait for SHOW INNODB STATUS to show the writes/s level falling from the surge value back to a low level. Then use SET GLOBAL innodb_max_dirty_pages_pct=90; to return to the default value, or return to whatever value you normally use. You've just forced a near-complete purge of dirty (changed) InnoDB pages. How is the disk I/O now you've done that purge?

You might consider increasing the value of innodb_log_file_size if it's not already at about half of the innodb_buffer_pool_size value. InnoDB has to purge dirty pages once the log is filled so you can get a higher dirty page percentage with a larger log file size. That in turn can reduce the number of disk writes you need to do if you're repeatedly writing to the same pages. There's a catch: it also increases the time taken to return to full service after a fault (power failure or whatever) and restart because the log entries must be applied and you've increased the number to apply.

Options: ReplyQuote

Subject Views Written By Posted
Innodb unexplained IOs 3624 Bob Bankay 01/24/2005 12:39PM
Re: Innodb unexplained IOs 1932 Bob Bankay 01/24/2005 12:43PM
Re: Innodb unexplained IOs 2332 Heikki Tuuri 01/24/2005 01:09PM
Re: Innodb unexplained IOs 2321 Bob Bankay 01/24/2005 05:40PM
Re: Innodb unexplained IOs 2448 James Day 01/27/2005 05:07AM
Re: Innodb unexplained IOs 2253 Bob Bankay 02/08/2005 04:31PM
Re: Innodb unexplained IOs -still need help! 2119 Bob Bankay 01/26/2005 02:37PM
Re: Innodb unexplained IOs - have finally stopped 2280 Bob Bankay 01/27/2005 06:56PM
Re: Innodb unexplained IOs 2001 Heikki Tuuri 01/31/2005 11:32AM
Re: Innodb unexplained IOs 2107 Bob Bankay 01/31/2005 04:57PM
Re: Innodb unexplained IOs 2268 Jeff Cobb 02/03/2005 06:23PM
Re: Innodb unexplained IOs 2792 James Day 02/03/2005 08:56PM
Re: Innodb unexplained IOs 2309 Jeff Cobb 02/04/2005 01:25PM
Re: Innodb unexplained IOs 2288 James Day 02/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.