High Memory Usage, Help me please

I am still facing tons of problems, can anybody please let me know what to do I just checked one of my site there are still 999 connections, and increasing. I setup ed Ddos Deflate to kill the IP when the connection increases from 30, but still there are tons of connections. I m so much worried, can anybody please advise?

-Regards.

 

Are you using any firewall on your server? If not then try CSF and see if it helps or not.

Kailash

 

kailash

re your PM

of course I am logged in via SSH as root for the

watch -n 0.5 mysqladmin proc

command, the error always is as a.m.
and offline I have the same error if I use the same command on my laptop.

 

I am not sure but you may try the following:

watch -n 0.5 mysqladmin -uroot -pmysqlrootpassword proc

Kailash

 

that's what I figured out myself meanwhile
it's obvious because a properly configured mysql ALWAYS has a password.

here the result of my tests

The below is the correct syntax when authentication/login is required.
the first option works perfect while the second option does prompt for the password and then the system/output somehow hangs and a logout appears impossible.

watch -n 5 mysqladmin -u root -pyourpaswordhere proc
watch -n 5 mysqladmin -u root -p proc

while the 2nd line above is correct syntax - for some reason it does NOT work in this above combination. the first a.m. option however works perfectly.

I extended the time from your 0.5 seconds to 5 seconds because on an intercontinental SSH server connection the line always is too slow for a 0.5 seconds

if YOUR command works WITHOUT password - that means your server MySQL is totally open/unsecured !!

 

Come on man if you have some issue start your own thread why you are hijacking my thread

 

I am having APF and also using Ddos Deflate. Have tried csf before my vote goes to APF.