Администратор БД не работает?
Форум
  1. Forums
  2. General
  3. General Discussion
  1. Hostking
  2. Wednesday, 01 October 2014
  3.  Subscribe via email
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] Can't execute sql request. ENABLE_GOVERNOR
[Sat Sep 27 22:09:54 2014] Can't execute sql request. ENABLE_GOVERNOR
[Sat Sep 27 22:10:54 2014] Can't execute sql request. ENABLE_GOVERNOR
[Wed Oct  1 14:41:47 2014] MySQL server has gone away
[Wed Oct  1 14:41:52 2014] Can't execute sql request. ENABLE_GOVERNOR
[Wed Oct  1 14:42:52 2014] Can't execute sql request. ENABLE_GOVERNOR
[Wed Oct  1 14:43:52 2014] Can't execute sql request. ENABLE_GOVERNOR
[Wed Oct  1 14:44:52 2014] Can't execute sql request. ENABLE_GOVERNOR
[Wed Oct  1 14:45:52 2014] Can't execute sql request. ENABLE_GOVERNOR
[Wed Oct  1 14:46:52 2014] Can't execute sql request. ENABLE_GOVERNOR

Does this mean it's not working?
Rate this post:
  1. 01.10.2014 09:10:42
  2. # 1
Alexey Berezhok Accepted Answer
Posts: 35
Joined: 20.04.2010
0
Votes
Undo
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
  1. 01.10.2014 16:10:13
  2. # 2
Hostking Accepted Answer
Posts: 38
Joined: 07.11.2012
0
Votes
Undo
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.
  1. 02.10.2014 03:10:01
  2. # 3
Alexey Berezhok Accepted Answer
Posts: 35
Joined: 20.04.2010
0
Votes
Undo
Hello,

as I see MySQL works. If run command:
service db_governor restart
will this message continue appear in log?
  1. 07.10.2014 07:10:59
  2. # 4
Hostking Accepted Answer
Posts: 38
Joined: 07.11.2012
0
Votes
Undo
Doesn\'t 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 check\'s 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.
  • Page :
  • 1


There are no replies made for this post yet.
Be one of the first to reply to this post!
гость
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.