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 3804 Bob Bankay 01/24/2005 12:39PM
Re: Innodb unexplained IOs 1980 Bob Bankay 01/24/2005 12:43PM
Re: Innodb unexplained IOs 2373 Heikki Tuuri 01/24/2005 01:09PM
Re: Innodb unexplained IOs 2374 Bob Bankay 01/24/2005 05:40PM
Re: Innodb unexplained IOs 2504 James Day 01/27/2005 05:07AM
Re: Innodb unexplained IOs 2392 Bob Bankay 02/08/2005 04:31PM
Re: Innodb unexplained IOs -still need help! 2265 Bob Bankay 01/26/2005 02:37PM
Re: Innodb unexplained IOs - have finally stopped 2395 Bob Bankay 01/27/2005 06:56PM
Re: Innodb unexplained IOs 2056 Heikki Tuuri 01/31/2005 11:32AM
Re: Innodb unexplained IOs 2263 Bob Bankay 01/31/2005 04:57PM
Re: Innodb unexplained IOs 2400 Jeff Cobb 02/03/2005 06:23PM
Re: Innodb unexplained IOs 2958 James Day 02/03/2005 08:56PM
Re: Innodb unexplained IOs 2349 Jeff Cobb 02/04/2005 01:25PM
Re: Innodb unexplained IOs 2334 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.