Re: Hard Disk activity spike caused by mySQL
Posted by:
Rick James
Date: March 07, 2009 04:24PM
Lots of things factor into this question. First to discover the cause, then to formulate the cure.
* Using MyISAM or InnoDB? (They use disk quite differently.)
* SHOW VARIABLES; (Lots of things _could_ be involved.)
* What Operating System? What settings do you have there? (Eg, Linux elevator strategy)
* How much RAM? (Perhaps you have the caches set too high, and you are seeing paging.)
Subject
Written By
Posted
Re: Hard Disk activity spike caused by mySQL
March 07, 2009 04:24PM
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.