Difference between revisions of "High IO usage on Database server"

From Kolmisoft Wiki
Jump to navigationJump to search
Line 5: Line 5:
  innodb_flush_method=O_DSYNC
  innodb_flush_method=O_DSYNC


to my.cnf and restart mysql service.
to my.cnf [general] section and restart mysql service.




Source:
Source:
http://dev.mysql.com/doc/refman/5.5/en/optimizing-innodb-diskio.html
http://dev.mysql.com/doc/refman/5.5/en/optimizing-innodb-diskio.html

Revision as of 09:22, 6 October 2014

If "iotop" shows that most resources are used by jbd2/md2-8 and not by mysql service,

try to add:

innodb_flush_method=O_DSYNC

to my.cnf [general] section and restart mysql service.


Source: http://dev.mysql.com/doc/refman/5.5/en/optimizing-innodb-diskio.html