Skip navigation links

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 2926 Bob Bankay 01/24/2005 12:39PM
Re: Innodb unexplained IOs 1622 Bob Bankay 01/24/2005 12:43PM
Re: Innodb unexplained IOs 1987 Heikki Tuuri 01/24/2005 01:09PM
Re: Innodb unexplained IOs 1946 Bob Bankay 01/24/2005 05:40PM
Re: Innodb unexplained IOs 2045 James Day 01/27/2005 05:07AM
Re: Innodb unexplained IOs 1945 Bob Bankay 02/08/2005 04:31PM
Re: Innodb unexplained IOs -still need help! 1726 Bob Bankay 01/26/2005 02:37PM
Re: Innodb unexplained IOs - have finally stopped 1911 Bob Bankay 01/27/2005 06:56PM
Re: Innodb unexplained IOs 1666 Heikki Tuuri 01/31/2005 11:32AM
Re: Innodb unexplained IOs 1790 Bob Bankay 01/31/2005 04:57PM
Re: Innodb unexplained IOs 1920 Jeff Cobb 02/03/2005 06:23PM
Re: Innodb unexplained IOs 2406 James Day 02/03/2005 08:56PM
Re: Innodb unexplained IOs 1928 Jeff Cobb 02/04/2005 01:25PM
Re: Innodb unexplained IOs 1934 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.