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