Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

mysqld taking alot of CPU time

Status
Not open for further replies.
nerbonne

nerbonne

Technical User
Dec 11, 2006
99
US
Hi. On my webserver which runs Apache on Fedora Core 1, I have noticed that the process mysqld is using 40-60% CPU, but sometimes as even as high as 100%. How can I find out why this is happening, and what can I do about it? Here is my process information.

0.4 00:36:26 /usr/libexec/mysqld --defaults-file=/etc/my.cnf --basedir=/usr --datadir=/var/lib/mysql --user=mysql --pid-file=/var/run/mysqld/mysqld.pid --skip-locking
0.2 00:00:39 /usr/sbin/httpd
0.2 00:01:30 /usr/sbin/httpd
0.2 00:02:01 /usr/sbin/httpd
0.1 00:00:55 /usr/sbin/httpd
0.1 00:01:39 /usr/sbin/httpd
0.1 00:00:58 /usr/sbin/httpd
0.0 00:00:00 ps -e -o pcpu,cputime,args --sort pcpu
0.0 00:00:00 tcp-env /var/qmail/bin/relaylock /var/qmail/bin/qmail-smtpd /var/qmail/bin/smtp_auth /var/qmail/bin/true /var/qmail/bin/cmd5checkpw /var/qmail/bin/true
0.0 00:00:00 [run ]
0.0 00:00:00 [tcpserver ]
0.0 00:00:00 tcp-env /var/qmail/bin/relaylock /var/qmail/bin/qmail-smtpd /var/qmail/bin/smtp_auth /var/qmail/bin/true /var/qmail/bin/cmd5checkpw /var/qmail/bin/true
0.0 00:00:00 /usr/local/psa/admin/bin/httpsd
0.0 00:00:00 /usr/local/psa/admin/bin/httpsd
0.0 00:00:00 /usr/local/psa/admin/bin/httpsd
0.0 00:00:00 /usr/local/psa/admin/bin/httpsd
0.0 00:00:00 /usr/local/psa/admin/bin/httpsd
0.0 00:00:00 qmail-remote lilachouse.com studebobvsd@lilachouse.com
0.0 00:00:00 qmail-remote abwehrspray.de forbearinghops@abwehrspray.de
0.0 00:00:00 qmail-remote crazymail.net qlomi@crazymail.net
0.0 00:00:00 qmail-remote casedunlap.com bcasedunlape@casedunlap.com
0.0 00:00:00 /usr/local/psa/admin/bin/httpsd
0.0 00:00:00 qmail-remote rediffmail.com palvert@rediffmail.com
0.0 00:00:00 bin/qmail-queue
0.0 00:00:00 /var/qmail/bin/qmail-smtpd /var/qmail/bin/smtp_auth /var/qmail/bin/true /var/qmail/bin/cmd5checkpw /var/qmail/bin/true
0.0 00:00:00 /var/qmail/bin/qmail-smtpd /var/qmail/bin/smtp_auth /var/qmail/bin/true /var/qmail/bin/cmd5checkpw /var/qmail/bin/true
0.0 00:00:11 /usr/sbin/httpd
0.0 00:00:10 /usr/sbin/httpd
0.0 00:00:23 /usr/sbin/httpd
0.0 00:00:30 /usr/sbin/httpd
0.0 00:00:00 qmail-remote spsmedical.com bspsmedicale@spsmedical.com
0.0 00:00:00 /usr/sbin/httpd
0.0 00:00:00 /usr/local/bin/multilog t /var/log/qmail
0.0 00:00:54 /usr/local/bin/multilog t /var/log/qmail/smtpd
0.0 00:00:00 /bin/sh ./run
0.0 00:00:00 supervise log
0.0 00:01:14 supervise qmail-smtpd
0.0 00:00:00 supervise log
0.0 00:00:02 supervise qmail-send
0.0 00:00:01 readproctitle service errors: ...: line 2: /var/qmail/rc: No such file or directory?./run: line 2: exec: /var/qmail/rc: cannot execute: No such file or directory?./run: line 2: /var/qmail/rc: No such file or directory?./run: line 2: exec: /var/qmail/rc: cannot execute: No such file or directory?./run: lin
0.0 00:00:00 svscan /service
0.0 00:00:00 /bin/sh /command/svscanboot
0.0 00:00:00 /sbin/mingetty tty6
0.0 00:00:00 /sbin/mingetty tty5
0.0 00:00:00 /sbin/mingetty tty4
0.0 00:00:00 /sbin/mingetty tty3
0.0 00:00:00 /sbin/mingetty tty2
0.0 00:00:00 /sbin/mingetty tty1
0.0 00:00:00 /usr/sbin/atd
0.0 00:00:00 crond
0.0 00:00:00 /usr/local/psa/admin/bin/httpsd
0.0 00:00:00 postgres: stats collector process
0.0 00:00:00 postgres: stats buffer process
0.0 00:00:00 /usr/bin/postmaster -p 5432
0.0 00:00:01 /usr/sbin/httpd
0.0 00:00:00 /usr/bin/spamd --username=popuser --daemonize --helper-home-dir=/var/qmail --max-children 20 --pidfile=/var/run/spamd_light.pid --socketpath=/tmp/spamd_light.sock --siteconfigpath=/dev/null
0.0 00:00:00 /usr/bin/spamd --username=popuser --daemonize --helper-home-dir=/var/qmail --max-children 20 --pidfile=/var/run/spamd_full.pid --socketpath=/tmp/spamd_full.sock --siteconfigpath=/dev/null
0.0 00:00:00 /usr/bin/spamd -d -c -a -m5 -H
0.0 00:00:26 qmail-clean
0.0 00:00:24 qmail-rspawn
0.0 00:00:34 qmail-lspawn ./Maildir/
0.0 00:00:56 splogger qmail
0.0 00:03:29 qmail-send
0.0 00:00:00 /usr/lib/courier-imap/sbin/courierlogger pop3d-ssl
0.0 00:00:00 /usr/lib/courier-imap/libexec/couriertcpd -address=0 -stderrlogger=/usr/lib/courier-imap/sbin/courierlogger -stderrloggername=pop3d-ssl -maxprocs=40 -maxperip=4 -pid=/var/run/pop3d-ssl.pid -nodnslookup -noidentlookup 995 /usr/lib/courier-imap/bin/couriertls -server -tcpd /usr/lib/courier-imap/sbin/pop3log
0.0 00:00:03 /usr/lib/courier-imap/sbin/courierlogger pop3d
0.0 00:00:08 /usr/lib/courier-imap/libexec/couriertcpd -address=0 -stderrlogger=/usr/lib/courier-imap/sbin/courierlogger -stderrloggername=pop3d -maxprocs=40 -maxperip=4 -pid=/var/run/pop3d.pid -nodnslookup -noidentlookup 110 /usr/lib/courier-imap/sbin/pop3login /usr/lib/courier-imap/libexec/authlib/authpsa /usr/lib/c
0.0 00:00:00 /usr/lib/courier-imap/sbin/courierlogger imapd-ssl
0.0 00:00:00 /usr/lib/courier-imap/libexec/couriertcpd -address=0 -stderrlogger=/usr/lib/courier-imap/sbin/courierlogger -stderrloggername=imapd-ssl -maxprocs=40 -maxperip=4 -pid=/var/run/imapd-ssl.pid -nodnslookup -noidentlookup 993 /usr/lib/courier-imap/bin/couriertls -server -tcpd /usr/lib/courier-imap/sbin/imaplog
0.0 00:00:00 /usr/lib/courier-imap/sbin/courierlogger imapd
0.0 00:00:00 /usr/lib/courier-imap/libexec/couriertcpd -address=0 -stderrlogger=/usr/lib/courier-imap/sbin/courierlogger -stderrloggername=imapd -maxprocs=40 -maxperip=4 -pid=/var/run/imapd.pid -nodnslookup -noidentlookup 143 /usr/lib/courier-imap/sbin/imaplogin /usr/lib/courier-imap/libexec/authlib/authpsa /usr/lib/c
0.0 00:00:00 /bin/sh /usr/bin/safe_mysqld --defaults-file=/etc/my.cnf
0.0 00:01:07 xinetd -stayalive -pidfile /var/run/xinetd.pid
0.0 00:00:01 /usr/sbin/sshd
0.0 00:01:01 /usr/sbin/named -u named -c /etc/named.conf -u named -t /var/named/run-root
0.0 00:00:00 /usr/sbin/smartd
0.0 00:00:00 /usr/sbin/apmd -p 10 -w 5 -W -P /etc/sysconfig/apm-scripts/apmscript
0.0 00:00:00 rpc.statd
0.0 00:00:00 portmap
0.0 00:00:00 klogd -x
0.0 00:02:24 syslogd -m 0
0.0 00:00:00 [kjournald]
0.0 00:05:49 [kjournald]
0.0 00:00:00 [mdrecoveryd]
0.0 00:00:00 [kupdated]
0.0 00:01:29 [kswapd]
0.0 00:00:00 [bdflush]
0.0 00:00:00 [ksoftirqd/0]
0.0 00:00:00 [kapmd]
0.0 00:00:00 [keventd]
0.0 00:00:10 init [3]
%CPU TIME COMMAND
 
Sort by date Sort by votes
What my.cnf are you using? If you are running Apache and MySQL on the same server. Use the my-medium.cnf

This should resolve the issue and speed things up.

M. Brooks
 
Upvote 0 Downvote
I don't know what you mean by my.cnf Could you explain it a bit more?
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Edwin Reyes
  • Locked
  • Question
High CPU utilization Linux Server due to mysql
Replies
1
Views
216
spamjim
spamjim
Agent0007
  • Locked
  • Question
HELP Traffic Control of IP
Replies
2
Views
166
Agent0007
Agent0007
theniteowl
  • Locked
  • Question
Parsing data out of files
Replies
0
Views
170
theniteowl
theniteowl
audiopro
  • Locked
  • Question
Gateway Timeout
Replies
0
Views
134
audiopro
audiopro
samiramiss
  • Locked
  • Question
Unfamiliar behavior of "setdscp" in IPFW
Replies
0
Views
118
samiramiss
samiramiss

Part and Inventory Search

Sponsor

Back
Top