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 [ | to my.cnf [mysqld] 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 [mysqld] section and restart mysql service.
Source:
http://dev.mysql.com/doc/refman/5.5/en/optimizing-innodb-diskio.html
