what differences within mysql IO and mysql governor
Forum
  1. Forums
  2. General
  3. General Discussion
  1. lokali
  2. Sunday, 14 January 2018
  3.  Subscribe via email
i very confused about MYSQL IO on LVE manager and limit mysql governor dbctl

are they the same? please describ about them and usage
Rate this post:
  1. 15.01.2018 13:01:21
  2. # 1
Posts: 187
Joined: 31.01.2017
0
Votes
Undo
MySQL IO in Current Usage tab of LVE Manager can reveal how much IO has been consumed by users queries to MySQL server, while MySQL Governor actually lets listing/setting up users' limits for such queries.
  1. 15.01.2018 17:01:51
  2. # 2
lokali Accepted Answer
Posts: 0
Joined: 21.07.2019
0
Votes
Undo
it make me confuse because i can set mysql io on LVE manager and on dbctl i can set as well
so whats the differences? set mysql io on LVE manager and on mysql governor
  1. 15.01.2018 17:01:47
  2. # 3
Posts: 187
Joined: 31.01.2017
0
Votes
Undo
I forgot to mention that mysql limits can be adjusted from both LVE Manager UI (USERS tab) and mysql governor CLI.
Most CloudLinux OS UI settings have their CLI equivalents, so that users that do not have compatible control panel can benefit from using CloudLinux OS. So yes, these settings have the same meaning, with CLI giving more granular control than those in UI.
  1. 15.01.2018 18:01:35
  2. # 4
lokali Accepted Answer
Posts: 0
Joined: 21.07.2019
0
Votes
Undo
is that true? because i have set DEFAULT mysql IO on LVE manager to 4MB/s but on dbctl list status showing 2/1/1/1

why are they different?
  1. 16.01.2018 17:01:30
  2. # 5
lokali Accepted Answer
Posts: 0
Joined: 21.07.2019
0
Votes
Undo
anyone from cloudlinuz can answer my question?
  1. 16.01.2018 18:01:23
  2. # 6
Posts: 187
Joined: 31.01.2017
0
Votes
Undo
It shows 2/X/X/X instead of 4, because "under the hood" there are actually two different mysql governor limits: MYSQL READ IO and MYSQL WRITE IO. When MYSQL IO is set in LVE Manager UI, it is divided equally between READ IO and WRITE IO - that is why you can see the limit divided by 2.
  • Page :
  • 1


There are no replies made for this post yet.
Be one of the first to reply to this post!
Guest
Submit Your Response
Upload files or images for this discussion by clicking on the upload button below. Supports gif,jpg,png,zip,rar,pdf
• Insert • Remove Upload Files (Maximum File Size: 2 MB)
Captcha
To protect the site from bots and unauthorized scripts, we require that you enter the captcha codes below before posting your question.