High IO usage on Database server

From Kolmisoft Wiki
Revision as of 16:56, 14 July 2020 by Admin (talk | contribs)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
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

Retrieved from "https://wiki.kolmisoft.com/index.php?title=High_IO_usage_on_Database_server&oldid=25709"