The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

MySQL governor

Discussion in 'CloudLinux' started by 10101, Jun 6, 2012.

  1. 10101

    10101 Well-Known Member

    Joined:
    Sep 4, 2003
    Messages:
    151
    Likes Received:
    0
    Trophy Points:
    16
    Hi,

    Is anyone here using the MySQL governor, if so can you please give your feedback on the addon? It looks like just what we need but would like some feedback from users as it says it's still beta.
     
  2. Prateek

    Prateek Member

    Joined:
    Aug 9, 2011
    Messages:
    7
    Likes Received:
    0
    Trophy Points:
    1
    i am using trial version of cloudlinux

    with governer install

    i didn't find it as useful as lve or cagefx

    i try to run a sql command between inter users and turn out to be useless
     
  3. NixTree

    NixTree Well-Known Member

    Joined:
    Aug 19, 2010
    Messages:
    386
    Likes Received:
    1
    Trophy Points:
    18
    Location:
    Gods Own Country
    cPanel Access Level:
    Root Administrator
    Hello,

    We also had dropped it after testing for a while as we could see it's creating more issues. Also that package is still in beta stage I guess ( even after ~2 years of its first release ). So I am afraid how much the developers are interested to maintain it!

    Thank you.
     
  4. cPanelTristan

    cPanelTristan Quality Assurance Analyst
    Staff Member

    Joined:
    Oct 2, 2010
    Messages:
    7,623
    Likes Received:
    21
    Trophy Points:
    38
    Location:
    somewhere over the rainbow
    cPanel Access Level:
    Root Administrator
    Of note, you can still use under CloudLinux and cPanel the userstats option in MySQL, since it loads the Google MySQL tools with it. Without MySQL Governor, it isn't going to limit anything, but it provides far more details for individual usage than regular MySQL reports would.

    Warning: Please note that MySQL 5.1 on some systems will have an issue enabling the option listed below. Please use at your discretion. If you really wish to use this option and have a system with MySQL 5.1, you might consider upgrading to MySQL 5.5 instead first and then enable it.

    In /etc/my.cnf file, you can place the following:

    Code:
    userstat=1
    At that point, restart MySQL:

    Code:
    /etc/init.d/mysql restart
    You can then run this in command line to see an example of stats:

    Code:
    mysql -e 'SELECT USER,CPU_TIME FROM information_schema.user_statistics ORDER BY CPU_TIME;'
    Thanks!
     
  5. NixTree

    NixTree Well-Known Member

    Joined:
    Aug 19, 2010
    Messages:
    386
    Likes Received:
    1
    Trophy Points:
    18
    Location:
    Gods Own Country
    cPanel Access Level:
    Root Administrator
    Hello Tristan,

    Thanks for your additional note :)

    One doubt raised here is, I have heard from Igor that they made "userstat=1" as default option for their MySQL builds when we reported one bug! And I believe cPanel uses the packages from CL repo to build MySQL? So you mean that option is explicit now and userstat isn't enabled by default?

    Thank you.
     
  6. cPanelTristan

    cPanelTristan Quality Assurance Analyst
    Staff Member

    Joined:
    Oct 2, 2010
    Messages:
    7,623
    Likes Received:
    21
    Trophy Points:
    38
    Location:
    somewhere over the rainbow
    cPanel Access Level:
    Root Administrator
    It isn't enabled by default on MySQL 5.1 machines due to the fact userstats can cause segfaults on some systems, but you can enable it in /etc/my.cnf file on cPanel machines. The only time it becomes enabled is when someone installs mysql_governor plugin for CloudLinux, since it requires userstats to be explicitly working. On any other system, CloudLinux or cPanel, you can enable it in /etc/my.cnf file.

    Most people don't realize this is even available actually.
     
Loading...

Share This Page