Optimize Server Hard Disk for Performance to MySQL but not safe

sudo tune2fs -o journal_data_writeback /dev/sda1 (use the right partition)

vim /etc/fstab

ext4 errors=remount-ro,noatime,nodiratime,data=writeback,barrier=0,nobh,commit=100,nouser_xattr 0 1

vim /etc/my.cnf

innodb_flush_log_at_trx_commit = 2

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.