Massive SQL Activity in top from single web user - How to determine the problem?

Discussion in 'Server Operation' started by rwheindl, Nov 20, 2017.

  1. rwheindl

    rwheindl New Member

    I got a complaint that my website was erroring with too many mysql connections. I ssh'd into the server and found another website was killing mysql with a ton of connections. For now I've changed max_connections=500 and max_user_connections=20, but the problem from this other site continues. How do I inspect what's causing this activity in top? I'm attaching a screenshot.

    I've checked the maillog, no activity, so the site doesn't seem to be hacked and sending spam.

    I've added the following to Sites > site.com > Options in ISPConfig:
    disable_functions = exec, passthru, shell_exec, system, proc_open, popen, curl_exec, curl_multi_exec, parse_ini_file, show_source, mail, eval

    No effect. How else can I determine the problem?
     

    Attached Files:

    Last edited: Nov 20, 2017
  2. florian030

    florian030 ISPConfig Developer ISPConfig Developer

    scan the site for malware and/or use mytop to see the sql-queries.
     

Share This Page