Hi,
I have been searching for some answeres to my problem for around 2 months
now....
I am a longtime user of MySQL but by no means am I very proficient at it. I
have had no problems up to this point with it, so Ive not really needed to
do much with it....
My webiste is PHP-Nuke 5 based. If your not familiar with PHPNuke it is a
PHP based content manager. Anyhow, certain things on my system slow it to a
crawl.... for example, the forums. When you browse the forums, or post, or
reply, etc.. the system crawls...
My site runs great for some aspects, but for others it boggs tremedously.
during these bogged times, mySQL is showing in 'top' as taking anywhere from
40% to 90% CPU usage, and the system lags beyond belief.
Now this problem has NOT always been happening. It started about 3 months
ago, and I have changed nothing I can think of that would have affected
it....
Anyways, to the point.... I have done the checks on the tables and they say
that they are fine.
Im wondering what would be the best way to track down my problem. What
troubleshooting from the MySQL end could be done to pinpoint whats going on?
Here is some copys of 'top' during these times - though they probably server
as nothing more than spam to you at this point:
PID USER PRI NI SIZE RSS SHARE STAT LIB %CPU %MEM TIME COMMAND
15091 mysql 14 0 16332 6352 1668 R 0 90.7 1.6 0:18 mysqld
15076 root 5 0 1052 1052 824 R 0 2.3 0.2 0:01 top
13422 nobody 0 0 63528 60M 5740 S 0 1.7 15.9 107:13 httpd
1594 nobody 0 0 5184 4252 1600 R 0 0.7 1.0 1:13 httpd
15114 nobody 0 0 2608 2156 1628 S 0 0.5 0.5 0:00 httpd
14858 nobody 0 0 4124 3740 1732 S 0 0.3 0.9 0:01 httpd
30852 nobody 0 0 4360 3416 1272 S 0 0.1 0.8 1:33 httpd
150
Mem: 387504K av, 384188K used, 3316K free, 69512K shrd, 7860K buff
Swap: 208804K av, 64652K used, 144152K free 57008K cached
PID USER PRI NI SIZE RSS SHARE STAT LIB %CPU %MEM TIME COMMAND
15134 mysql 12 0 16320 6340 1668 R 0 43.2 1.6 0:02 mysqld
15136 mysql 12 0 16320 6340 1668 R 0 11.4 1.6 0:00 mysqld
13950 nobody 2 0 4308 3880 1408 S 0 4.6 1.0 0:05 httpd
13422 nobody 2 0 63528 60M 5732 S 0 3.3 15.9 107:13 httpd
26094 nobody 0 0 31232 29M 1884 S 0 3.1 7.7 45:47 httpd
15076 root 5 0 1052 1052 824 R 0 2.5 0.2 0:02 top
13433 nobody 0 0 60568 56M 12816 S 0 0.3 14.9 104:03 httpd
5 root 0 0 0 0 0 SW 0 0.1 0.0 8:33 kswapd
13436 root 0 0 1664 880 448 S 0 0.1 0.2 9:40 named
30852 nobody 0
PID USER PRI NI SIZE RSS SHARE STAT LIB %CPU %MEM TIME COMMAND
15134 mysql 12 0 16772 6792 1704 R 0 40.4 1.7 0:04 mysqld
15136 mysql 12 0 16772 6792 1704 R 0 40.4 1.7 0:02 mysqld
14626 nobody 0 0 3124 2744 1476 S 0 2.9 0.7 0:03 httpd
15076 root 5 0 1052 1052 824 R 0 2.3 0.2 0:02 top
15140 mysql 2 0 16772 6792 1704 R 0 1.7 1.7 0:00 mysqld
14858 nobody 0 0 3724 3540 1956 S 0 0.9 0.9 0:01 httpd
30852 nobody 0 0 4360 3416 1272 S 0 0.5 0.8 1:33 httpd
PID USER PRI NI SIZE RSS SHARE STAT LIB %CPU %MEM TIME COMMAND
15091 mysql 15 0 16312 6048 1400 R 0 86.3 1.5 0:08 mysqld
13433 nobody 1 0 60568 56M 12816 S 0 4.0 14.9 104:03 httpd
14528 nobody 0 0 3100 2652 1364 S 0 2.3 0.6 0:01 httpd
15076 root 5 0 1052 1052 824 R 0 2.1 0.2 0:01 top
31732 nobody 0 0 4356 3760 1572 S 0 1.7 0.9 1:25 httpd
15024 root 0 0 876 876 684 R 0 0.3 0.2 0:00
in.telnetd
I run a PII300 with 384MB RAM. It gets worse when more people are on
obviously. My site gets about 5000 hits a day, but even at offpeak times,
certain things take way longer to process than others.
You can visit at www.worldwidepunks.com and browse around to see what I
mean. For example, the forums ALWAYS give me a problem..........
Any info you need, let me know. I will provide it ASAP.
Thanks in advance!
CJ
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
