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.') |
|||
| Line 6: | Line 6: | ||
to my.cnf and restart mysql service. | to my.cnf and restart mysql service. | ||
Source: | |||
http://dev.mysql.com/doc/refman/5.5/en/optimizing-innodb-diskio.html | |||
Revision as of 22:08, 22 August 2014
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.
Source:
http://dev.mysql.com/doc/refman/5.5/en/optimizing-innodb-diskio.html
