Software RAID and mysql process on server

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • steven_elvisda
    Member
    Forum Explorer
    • Mar 2021
    • 42

    #1

    Software RAID and mysql process on server

    Hello All,

    I have two questions to ask for idea from you all as below:

    1. My Dedicated server using SATA 3 two Hard Disk. we are using software RAID(mdadm) to manage its. in this week I saw it resync two time already and when it resync. do you have any idea to manage this issue?
    2. my server is alway high load every 1 hours to 2hours. when I was check htop or top. It have no problem with CPU at all. But when I check with atop I saw my Hard Disk very busy with process of mysql. due my experience to optimize mysql server is abit small range I would like to ask some idea from you. Please kindly share.

    your idea is very important to me.

    best regards,
    Steve.
  • steven_elvisda
    Member
    Forum Explorer
    • Mar 2021
    • 42

    #2
    will db_governer is able to help the second issue?

    Comment

    • john
      Junior Member
      Forum Explorer
      • Mar 2021
      • 12

      #3
      MySQL Governor will help with MySQL abuse. We use it and it stopped clients with very busy websites or buggy coding from killing MySQL.

      Comment

      Working...