Announcement Module
No announcement yet.

MySQL MyISAM Tuning Specific

Page Title Module
Move Remove Collapse
Conversation Detail Module
  • Filter
  • Time
  • Show
Clear All
new posts

  • MySQL MyISAM Tuning Specific


    I am using purely MYISAM and database size is couple of hundreds gigabyte. I read about write back cache and nobarrier option. And as per suggetions both need to be disabled. is that correct for MyISAM tables ?
    Also what is the link between write back cache and nobarrier. one can be disabled on both need to be disabled.

    I am using hardware RAID 10 with battery backed cache. Please suggest. and disk scheduler is default NOOP on CentOS 6.

  • #2

    As write back cache and nobarrier option are independent to storage engine, they need for MyISAM too. Any one must be enable for the file system integrity but not both. In case of both enabled, it can degrade performance and both disabled, increase the risk of data corruption during power loss. so I think, If you are using RAID 10 with battery backed cache then you can safely disable write barriers with (-o nobarrier) option.