MySQL govenor is beta?
Forum
  1. Forums
  2. CloudLinux and Control Panels
  3. CloudLinux and cPanel
  1. kernow
  2. Monday, 03 March 2014
  3.  Subscribe via email
Hi,
Thinking about installing MySQL govenor, is this  still in beta stage? and would it replace our  current MySQL version ( 5.6 ) ?
Rate this post:
  1. 22.03.2014 12:03:16
  2. # 1
Hostking Accepted Answer
Posts: 38
Joined: 07.11.2012
0
Votes
Undo
I don\'t think it\'s in beta anymore. But stand to be corrected. Nevertheless I think it works just fine.
  1. 22.03.2014 12:03:22
  2. # 2
kernow Accepted Answer
Posts: 72
Joined: 06.08.2010
0
Votes
Undo
Thanks for replying. We have been trying it out for the last couple of weeks. It seems to work fine stopping surges or sudden spikes. But if you get a persistant  user heavily abusing MySQL then it can cause issues. We found that when the heavy abuser gets restricted the MySQL process list built up to the max allowed, the account starts using more and more memory which in turns slows the clients site down until it eventually stops loading at all. But like I said, for sudded short spikes it does its job OK.
  1. 22.03.2014 20:03:25
  2. # 3
Igor Seletskiy Accepted Answer
Posts: 1195
Joined: 09.02.2010
0
Votes
Undo
Is that cPanel server? Are you using \"all\" mode? In that mode, site\'s PHP would get throttled as well, causing less requests, and preventing that issues
  1. 23.03.2014 03:03:44
  2. # 4
kernow Accepted Answer
Posts: 72
Joined: 06.08.2010
0
Votes
Undo
Hi,
Yes cpanel server. It was in \"abusers\" mode though one of your staff changed it to \"single\" mode. \"abusers\" mode made no difference though. See ticket #LOK-461-55959
  1. 23.03.2014 06:03:20
  2. # 5
Igor Seletskiy Accepted Answer
Posts: 1195
Joined: 09.02.2010
0
Votes
Undo
Try switching to \'all\' mode -- that is the best mode to run with MySQL.
  1. 23.03.2014 08:03:15
  2. # 6
kernow Accepted Answer
Posts: 72
Joined: 06.08.2010
0
Votes
Undo
Will try that out, thanks.
So in \"all\" mode do the limits set in mysql-governor.xml need to be removed or are they just ignored in \"all\" mode?
  1. 24.03.2014 05:03:36
  2. # 7
Alexey Berezhok Accepted Answer
Posts: 35
Joined: 20.04.2010
0
Votes
Undo
Hello,

limits in mysql-governor.xml will be ignored in \"all\" mode. And try to switch on killing long queries in mysql-governor.xml.
  1. 24.03.2014 05:03:39
  2. # 8
kernow Accepted Answer
Posts: 72
Joined: 06.08.2010
0
Votes
Undo
Thanks, will give it try.
  • 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.