High IO usage on Database server

From Kolmisoft Wiki
Jump to navigationJump to search

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