Difference between revisions of "High IO usage on Database server"
From Kolmisoft Wiki
Jump to navigationJump to search
(Created page with '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 and restart mysql service.') |
|||
| (3 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: | |||
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
