Hi there,
I am having serious problems with a mysql 4.0.18 production server.
Mysql takes away sometimes almost 100% of the cpu. The system works fine for days, but then suddenly load average climbes up and up and up till about 17.
This is wat top says:
top - 12:06:47 up 9:50, 2 users, load average: 16.47, 8.13, 3.38 Tasks: 123 total, 26 running, 97 sleeping, 0 stopped, 0 zombie Cpu(s): 46.3% user, 53.7% system, 0.0% nice, 0.0% idle Mem: 1025160k total, 999616k used, 25544k free, 14736k buffers Swap: 2048276k total, 5440k used, 2042836k free, 679028k cached
PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND 9157 mysqladm 20 0 55204 53m 2400 R 5.1 5.4 0:01.34 mysqld 9155 mysqladm 19 0 55204 53m 2400 R 4.8 5.4 0:01.35 mysqld 9184 mysqladm 20 0 55204 53m 2400 R 4.8 5.4 0:00.18 mysqld 9171 mysqladm 13 0 55204 53m 2400 R 4.3 5.4 0:00.78 mysqld 9178 mysqladm 12 0 55204 53m 2400 R 4.0 5.4 0:00.57 mysqld 9179 mysqladm 12 0 55204 53m 2400 R 4.0 5.4 0:00.59 mysqld 9177 mysqladm 12 0 55204 53m 2400 R 3.8 5.4 0:00.62 mysqld 9154 mysqladm 14 0 55204 53m 2400 R 3.5 5.4 0:01.11 mysqld 9182 mysqladm 12 0 55204 53m 2400 R 3.2 5.4 0:00.15 mysqld 9172 mysqladm 11 0 55204 53m 2400 R 3.0 5.4 0:00.82 mysqld 9176 mysqladm 15 0 55204 53m 2400 R 3.0 5.4 0:00.63 mysqld 9180 mysqladm 14 0 55204 53m 2400 R 3.0 5.4 0:00.43 mysqld 9151 mysqladm 10 0 55204 53m 2400 S 2.7 5.4 0:01.22 mysqld 9153 mysqladm 13 0 55204 53m 2400 R 2.7 5.4 0:01.17 mysqld 9173 mysqladm 12 0 55204 53m 2400 R 2.7 5.4 0:00.80 mysqld 9174 mysqladm 11 0 55204 53m 2400 R 2.7 5.4 0:00.76 mysqld 9181 mysqladm 14 0 55204 53m 2400 R 2.7 5.4 0:00.35 mysqld 9065 root 13 0 1112 1112 852 R 2.4 0.1 0:03.48 top 9156 mysqladm 11 0 55204 53m 2400 R 2.4 5.4 0:01.27 mysqld 9162 mysqladm 12 0 55204 53m 2400 R 2.4 5.4 0:00.87 mysqld 9165 mysqladm 10 0 55204 53m 2400 S 2.4 5.4 0:00.87 mysqld 9152 mysqladm 12 0 55204 53m 2400 R 1.9 5.4 0:01.20 mysqld 9160 mysqladm 12 0 55204 53m 2400 R 1.9 5.4 0:01.14 mysqld 2682 www 10 0 16184 15m 12m S 1.6 1.6 0:59.01 httpd 9149 mysqladm 12 0 55204 53m 2400 R 1.1 5.4 0:01.56 mysqld 9166 mysqladm 12 0 55204 53m 2400 R 1.1 5.4 0:01.05 mysqld 9167 www 9 0 7564 7560 4524 S 1.1 0.7 0:00.12 httpd 2664 www 9 0 16080 15m 12m S 0.8 1.6 1:06.70 httpd 2673 www 9 0 15632 15m 11m S 0.8 1.5 1:03.46 httpd 8766 www 9 0 8452 8448 5044 S 0.8 0.8 0:05.55 httpd 9121 www 9 0 7952 7952 4536 S 0.8 0.8 0:00.38 httpd 9183 www 9 0 7224 7224 4360 S 0.8 0.7 0:00.04 httpd 2663 www 9 0 15784 15m 12m S 0.5 1.5 1:07.80 httpd 2669 www 9 0 19228 18m 12m S 0.5 1.9 1:10.13 httpd 2670 www 9 0 15508 15m 12m S 0.5 1.5 1:05.34 httpd 2677 www 9 0 15596 15m 12m S 0.5 1.5 1:06.77 httpd 2678 www 10 0 15464 15m 12m S 0.5 1.5 1:06.44 httpd 2679 www 9 0 15500 15m 12m S 0.5 1.5 1:07.30 httpd 7094 www 9 0 8692 8688 5136 S 0.5 0.8 0:25.88 httpd 8768 www 9 0 8588 8584 5072 S 0.5 0.8 0:07.55 httpd 8988 www 9 0 7780 7776 4732 S 0.5 0.8 0:01.89 httpd 8989 www 9 0 8388 8384 4940 S 0.5 0.8 0:01.80 httpd 9025 www 9 0 8164 8160 4680 S 0.5 0.8 0:01.03 httpd 9028 www 9 0 7636 7632 4636 S 0.5 0.7 0:00.92 httpd 9030 www 10 0 7540 7536 4640 S 0.5 0.7 0:01.12 httpd
Funny enough the logfile of apache shows that there have been not a lot requests made. After a few minutes everything was back to normal.
Once every few months the system starts to swap and troutles down, so I have reboot and then again everything is fine for weeks.
Does anybody have an idea how to fix that, I am completly lost here :-(
Merlin
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]