MySQL / db_governor / abuse question
Forum
  1. Forums
  2. CloudLinux and Control Panels
  3. CloudLinux and cPanel
  1. Christos Panagiotakis
  2. Saturday, 09 November 2013
  3.  Subscribe via email
Normally a few servers are running like this:

[--] Up for: 2d 7h 51m 39s (16M q [82.992 qps], 1M conn, TX: 5025B, RX: 4B)
[--] Up for: 24d 23h 26m 58s (121M q [56.310 qps], 2M conn, TX: 1004B, RX: 30B)

but I got a few ones like this:

[--] Up for: 44d 6h 19m 55s (1B q [401.366 qps], 9M conn, TX: 2415B, RX: 169B)

and even worse

[--] Up for: 2d 4h 26m 24s (165M q [879.055 qps], 820K conn, TX: 155B, RX: 19B)


Is there a way to check queries per second per user so I could possibly sort them out and find which ones are hammering / raping the system ?
Rate this post:
  1. 11.11.2013 04:11:25
  2. # 1
Alexey Berezhok Accepted Answer
Posts: 35
Joined: 20.04.2010
0
Votes
Undo
Hello,

governor hasn\'t now ability to check queries per second per user. But if you use governor with cPanel you can activate experimantal mode \"Always run queries inside user\'s LVE\" this can slow abusers queries.

http://docs.cloudlinux.com/index.html?modes_of_opeartion.html

This mode available only for cPanel now.
  • 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.