DB Governor not working?

[sahostking]

Our load at random times goes up to 250.

The load usually is 0.78 Average. So something is going on.

I checked the dbgovernor_error.log file and found this:

[Sat Sep 27 22:08:54 2014] Cant execute sql request. ENABLE_GOVERNOR
[Sat Sep 27 22:09:54 2014] Cant execute sql request. ENABLE_GOVERNOR
[Sat Sep 27 22:10:54 2014] Cant execute sql request. ENABLE_GOVERNOR
[Wed Oct 1 14:41:47 2014] MySQL server has gone away
[Wed Oct 1 14:41:52 2014] Cant execute sql request. ENABLE_GOVERNOR
[Wed Oct 1 14:42:52 2014] Cant execute sql request. ENABLE_GOVERNOR
[Wed Oct 1 14:43:52 2014] Cant execute sql request. ENABLE_GOVERNOR
[Wed Oct 1 14:44:52 2014] Cant execute sql request. ENABLE_GOVERNOR
[Wed Oct 1 14:45:52 2014] Cant execute sql request. ENABLE_GOVERNOR
[Wed Oct 1 14:46:52 2014] Cant execute sql request. ENABLE_GOVERNOR

Does this mean its not working?

[alexey.com.s]

Hello,

which version of governor installed? Can you show me output of commands:
1) rpm -qa | grep governor -i
2) rpm -qa | grep cl-mysql -i
3) mysql

[sahostking]

governor-mysql-1.0-68.el6.cloudlinux.x86_64

cl-MySQL-meta-devel-5.6.19-9.el6.5.cloudlinux.x86_64
cl-MySQL56-shared-5.6.16-7.el6.5.cloudlinux.x86_64
cl-MySQL-meta-5.6.19-9.el6.5.cloudlinux.x86_64
cl-MySQL56-client-5.6.16-7.el6.5.cloudlinux.x86_64
cl-MySQL-meta-client-5.6.19-9.el6.5.cloudlinux.x86_64
cl-MySQL56-server-5.6.16-7.el6.5.cloudlinux.x86_64
cl-MySQL56-devel-5.6.16-7.el6.5.cloudlinux.x86_64

Welcome to the MySQL monitor. Commands end with ; or g.
Your MySQL connection id is 70659
Server version: 5.6.16-cll-lve MySQL Community Server (GPL)

Copyright (c) 2000, 2014, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type help; or h for help. Type c to clear the current input statement.

[alexey.com.s]

Hello,

as I see MySQL works. If run command:
service db_governor restart
will this message continue appear in log?

[sahostking]

Doesn seem to appear anymore. I think I found the cause. When MySQL is slow it occurs due to the server load being extremely high.

I found and option in cpanel that checks permissions in mySQL. I turned that off as it seems to occur once a day at 9am..

Will check if it occurs again and hopefully it is resolved.