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 3467 Bob Bankay 01/24/2005 12:39PM
Re: Innodb unexplained IOs 1867 Bob Bankay 01/24/2005 12:43PM
Re: Innodb unexplained IOs 2265 Heikki Tuuri 01/24/2005 01:09PM
Re: Innodb unexplained IOs 2241 Bob Bankay 01/24/2005 05:40PM
Re: Innodb unexplained IOs 2363 James Day 01/27/2005 05:07AM
Re: Innodb unexplained IOs 2190 Bob Bankay 02/08/2005 04:31PM
Re: Innodb unexplained IOs -still need help! 2025 Bob Bankay 01/26/2005 02:37PM
Re: Innodb unexplained IOs - have finally stopped 2213 Bob Bankay 01/27/2005 06:56PM
Re: Innodb unexplained IOs 1931 Heikki Tuuri 01/31/2005 11:32AM
Re: Innodb unexplained IOs 2024 Bob Bankay 01/31/2005 04:57PM
Re: Innodb unexplained IOs 2189 Jeff Cobb 02/03/2005 06:23PM
Re: Innodb unexplained IOs 2716 James Day 02/03/2005 08:56PM
Re: Innodb unexplained IOs 2225 Jeff Cobb 02/04/2005 01:25PM
Re: Innodb unexplained IOs 2221 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.