Difference between revisions of "High IO usage on Database server"
From Kolmisoft Wiki
Jump to navigationJump to search
| (2 intermediate revisions by one other user not shown) | |||
| Line 5: | Line 5: | ||
innodb_flush_method=O_DSYNC | innodb_flush_method=O_DSYNC | ||
to my.cnf and restart mysql service. | to my.cnf [mysqld] section and restart mysql service. | ||
NOTE: already in the default installation on new servers. | |||
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 | ||
Latest revision as of 16:56, 14 July 2020
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.
NOTE: already in the default installation on new servers.
Source: http://dev.mysql.com/doc/refman/5.5/en/optimizing-innodb-diskio.html
