Difference between revisions of "High IO usage on Database server"
From Kolmisoft Wiki
Jump to navigationJump to search
| Line 7: | Line 7: | ||
to my.cnf [mysqld] section 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
