increasing server load because mysqld using high CPU and Memory resources

markhard

Well-Known Member
Apr 22, 2004
252
0
166
lately My server load went high around 5 - 15 constantly. when i type top command i see mysqld using high CPU and memory load. from 'ps aux' command I only see 1 mysql server is running while before cpanel upgrade i see 5 mysqld is running. does this happen on your servers too?



i see on /tmp there is alot of temporary file like:

#sql_1142_11.MYD
#sql_1142_11.MYI
#sql_1142_12.MYD
#sql_1142_12.MYI

what is it?

I also see alot of user name like a, b, c, d, ... while that username actually doesn't exist is this normal? as i already see it when i received the server from dedicated server provider



on "Show Current Running Processes" page i see alot of PID that doesn't have any explanation, it's just white blanks.



CPanel version:
WHM 10.8.0 cPanel 10.8.2-C467
CentOS 4.3 i686 - WHM X v3.1.0

MySQL version:
mysql (4.1.21-standard)

i already run chkrootkit on my server and once there is a sniffer log file but i already delete it and chkrootkit doesn't report any sniffer anymore.
 

websupport

Well-Known Member
Jun 24, 2006
92
0
156
Mysql Load

Hi

Following command will show how many current open connections there are to mysql
mysqladmin processlist |wc -l

Following command will display IP address and number of connections from that IP:
netstat -plan|grep :<mysqlport>|awk {'print $5'}|cut -d: -f 1|sort|uniq -c|sort -n

If you are getting lots of connections from specific IP then temporary block that IP address from iptables/apf.
 

AndyReed

Well-Known Member
PartnerNOC
May 29, 2004
2,221
4
193
Minneapolis, MN
markhard said:
lately My server load went high around 5 - 15 constantly. when i type top command i see mysqld using high CPU and memory load. from 'ps aux' command I only see 1 mysql server is running while before cpanel upgrade i see 5 mysqld is running. does this happen on your servers too?
Check this out: http://forums.cpanel.net/showthread.php?t=56614
 

markhard

Well-Known Member
Apr 22, 2004
252
0
166
thanks for your replies :)

any comment for the strange user names and blank processes?