OVH Community, your new community space.

Cargas de CPU muy altas.


activa
07/12/2008, 22:42
en los logs , hay un usage de Mysql muy extraña !!! pero el cargo del servidor es normal

load average: 0,86, 0,83, 0,76
tienes algun script que usa el mysql ?

BoRoU
03/12/2008, 17:50
Nadie tiene vbulletin instalado en su servidor y tiene cargas altas de cpu?

BoRoU
01/12/2008, 08:13
mysql 27863 0.0 8.5 363028 264832 ? S Nov26 1:41 /usr/sbin/mysql
mysql 27870 0.0 8.5 363028 264832 ? S Nov26 1:43 /usr/sbin/mysql
mysql 27872 0.0 8.5 363028 264832 ? S Nov26 1:42 /usr/sbin/mysql
mysql 28046 0.0 8.5 363028 264832 ? S Nov26 1:44 /usr/sbin/mysql
mysql 28047 0.0 8.5 363028 264832 ? S Nov26 1:39 /usr/sbin/mysql
mysql 28084 0.0 8.5 363028 264832 ? S Nov26 1:46 /usr/sbin/mysql
mysql 28476 0.0 8.5 363028 264832 ? S Nov26 1:54 /usr/sbin/mysql
mysql 28479 0.0 8.5 363028 264832 ? S Nov26 1:52 /usr/sbin/mysql
mysql 28480 0.0 8.5 363028 264832 ? S Nov26 1:51 /usr/sbin/mysql
mysql 28559 0.0 8.5 363028 264832 ? S Nov26 1:45 /usr/sbin/mysql
mysql 28560 0.0 8.5 363028 264832 ? S Nov26 1:53 /usr/sbin/mysql
mysql 30312 0.0 8.5 363028 264832 ? S Nov26 1:35 /usr/sbin/mysql
mysql 30316 0.0 8.5 363028 264832 ? S Nov26 1:45 /usr/sbin/mysql
mysql 30317 0.0 8.5 363028 264832 ? S Nov26 1:36 /usr/sbin/mysql
Eso con esta carga...
11:52:16 up 2 days, 18:24, 1 user, load average: 0,86, 0,83, 0,76
Lo que comentas de iotop y mytop no se como usarlo, ya que no me reconoce esos comandos...:confused:

GRACIAS.

BoRoU
01/12/2008, 08:13
mysql 4190 0.0 8.5 363028 264832 ? S Nov26 1:38 /usr/sbin/mysql
mysql 4191 0.0 8.5 363028 264832 ? S Nov26 1:41 /usr/sbin/mysql
mysql 4192 0.0 8.5 363028 264832 ? S Nov26 1:39 /usr/sbin/mysql
mysql 4195 0.0 8.5 363028 264832 ? S Nov26 1:33 /usr/sbin/mysql
mysql 4198 0.0 8.5 363028 264832 ? S Nov26 1:46 /usr/sbin/mysql
mysql 4199 0.0 8.5 363028 264832 ? S Nov26 1:27 /usr/sbin/mysql
mysql 4200 0.0 8.5 363028 264832 ? S Nov26 1:36 /usr/sbin/mysql
root 6231 0.0 0.0 6896 3048 ? Ss Nov26 0:19 /usr/local/apac
mysql 6469 0.0 8.5 363028 264832 ? Ss Nov26 0:53 /usr/sbin/mysql
mysql 6472 0.0 8.5 363028 264832 ? S Nov26 0:15 /usr/sbin/mysql
mysql 6473 0.0 8.5 363028 264832 ? S Nov26 1:03 /usr/sbin/mysql
mysql 6474 0.0 8.5 363028 264832 ? S Nov26 0:00 /usr/sbin/mysql
mysql 9209 0.0 8.5 363028 264832 ? S Nov26 1:27 /usr/sbin/mysql
mysql 9210 0.0 8.5 363028 264832 ? S Nov26 1:40 /usr/sbin/mysql
mysql 9217 0.0 8.5 363028 264832 ? S Nov26 1:37 /usr/sbin/mysql
mysql 9218 0.0 8.5 363028 264832 ? S Nov26 1:58 /usr/sbin/mysql
mysql 9226 0.0 8.5 363028 264832 ? S Nov26 1:47 /usr/sbin/mysql
mysql 9227 0.0 8.5 363028 264832 ? S Nov26 1:34 /usr/sbin/mysql
mysql 9299 0.0 8.5 363028 264832 ? S Nov26 1:35 /usr/sbin/mysql
mysql 9301 0.0 8.5 363028 264832 ? S Nov26 1:51 /usr/sbin/mysql
mysql 9302 0.0 8.5 363028 264832 ? S Nov26 1:29 /usr/sbin/mysql
mysql 9411 0.0 8.5 363028 264832 ? S Nov26 1:38 /usr/sbin/mysql
mysql 9415 0.0 8.5 363028 264832 ? S Nov26 1:27 /usr/sbin/mysql
mysql 9416 0.0 8.5 363028 264832 ? S Nov26 1:33 /usr/sbin/mysql
mysql 9417 0.0 8.5 363028 264832 ? S Nov26 1:32 /usr/sbin/mysql
qscand 12822 0.0 1.8 59320 56940 ? SNs Nov27 0:00 /usr/sbin/clamd
clamav 12825 0.0 0.0 3028 1164 ? SNs Nov27 0:00 /usr/bin/freshc
root 13117 0.0 0.1 9800 5576 ? Ss Nov27 0:01 /usr/bin/perl /
nobody 14603 0.0 0.1 7584 3156 ? S 11:41 0:00 /usr/local/apac
nobody 14648 0.0 0.1 9376 4952 ? S 11:41 0:00 /usr/local/apac
nobody 15094 0.0 0.0 7144 2732 ? S 11:42 0:00 /usr/local/apac
nobody 15134 0.0 0.0 7288 2868 ? S 11:42 0:00 /usr/local/apac
nobody 15873 0.0 0.0 7384 2960 ? S 11:43 0:00 /usr/local/apac
nobody 15895 0.0 0.0 7280 2856 ? S 11:43 0:00 /usr/local/apac
nobody 15905 0.0 0.0 7260 2840 ? S 11:43 0:00 /usr/local/apac
nobody 15912 0.0 0.0 7256 2844 ? S 11:43 0:00 /usr/local/apac
nobody 16027 0.0 0.0 7216 2796 ? S 11:44 0:00 /usr/local/apac
nobody 16031 0.0 0.0 7376 2956 ? S 11:44 0:00 /usr/local/apac
nobody 16674 0.0 0.0 7264 2844 ? S 11:45 0:00 /usr/local/apac
nobody 16682 0.0 0.0 7152 2708 ? S 11:45 0:00 /usr/local/apac
nobody 16750 0.0 0.0 7316 2892 ? S 11:45 0:00 /usr/local/apac
nobody 16759 0.0 0.0 7376 2952 ? S 11:45 0:00 /usr/local/apac
nobody 16777 0.0 0.0 7184 2760 ? S 11:46 0:00 /usr/local/apac
nobody 16998 0.0 0.0 7260 2812 ? S 11:46 0:00 /usr/local/apac
nobody 17010 0.0 0.0 7136 2716 ? S 11:46 0:00 /usr/local/apac
nobody 17016 0.0 0.0 7236 2816 ? S 11:46 0:00 /usr/local/apac
nobody 17023 0.0 0.0 7356 2936 ? S 11:46 0:00 /usr/local/apac
nobody 17033 0.0 0.0 7356 2932 ? S 11:46 0:00 /usr/local/apac
nobody 17036 0.0 0.0 7264 2844 ? S 11:46 0:00 /usr/local/apac
nobody 17041 0.0 0.0 7292 2828 ? S 11:46 0:00 /usr/local/apac
nobody 17042 0.0 0.0 7508 3040 ? S 11:46 0:00 /usr/local/apac
nobody 17044 0.0 0.0 7268 2780 ? S 11:46 0:00 /usr/local/apac
nobody 17047 0.0 0.0 7332 2844 ? S 11:46 0:00 /usr/local/apac
nobody 17054 0.0 0.0 7252 2768 ? S 11:46 0:00 /usr/local/apac
nobody 17061 0.0 0.0 7388 2964 ? S 11:46 0:00 /usr/local/apac
nobody 17065 0.0 0.0 7212 2752 ? S 11:46 0:00 /usr/local/apac
nobody 17067 0.0 0.0 7340 2912 ? S 11:46 0:00 /usr/local/apac
nobody 17068 0.0 0.0 7356 2936 ? S 11:46 0:00 /usr/local/apac
nobody 17071 0.0 0.0 7356 2936 ? S 11:46 0:00 /usr/local/apac
nobody 17502 0.0 0.0 7264 2776 ? S 11:48 0:00 /usr/local/apac
root 17747 0.0 0.0 7996 2480 ? Ss 11:48 0:00 sshd: root@pts/
root 17770 0.0 0.0 0 0 ? Z 11:48 0:00 [wat]
root 17786 0.0 0.0 2880 1664 pts/0 Ss 11:48 0:00 -bash
root 17817 0.0 0.0 2280 872 pts/0 R+ 11:49 0:00 ps aux
mysql 18496 0.0 8.5 363028 264832 ? S Nov26 1:25 /usr/sbin/mysql
mysql 18499 0.0 8.5 363028 264832 ? S Nov26 1:25 /usr/sbin/mysql
mysql 18501 0.0 8.5 363028 264832 ? S Nov26 1:19 /usr/sbin/mysql
mysql 18503 0.0 8.5 363028 264832 ? S Nov26 1:21 /usr/sbin/mysql
mysql 18504 0.0 8.5 363028 264832 ? S Nov26 1:55 /usr/sbin/mysql
mysql 18505 0.0 8.5 363028 264832 ? S Nov26 1:26 /usr/sbin/mysql
mysql 18509 0.0 8.5 363028 264832 ? S Nov26 1:28 /usr/sbin/mysql
mysql 18510 0.0 8.5 363028 264832 ? S Nov26 1:26 /usr/sbin/mysql
mysql 18512 0.0 8.5 363028 264832 ? S Nov26 1:21 /usr/sbin/mysql
mysql 18528 0.0 8.5 363028 264832 ? S Nov26 1:23 /usr/sbin/mysql
mysql 18532 0.0 8.5 363028 264832 ? S Nov26 1:16 /usr/sbin/mysql
mysql 18535 0.0 8.5 363028 264832 ? S Nov26 1:25 /usr/sbin/mysql
mysql 18536 0.0 8.5 363028 264832 ? S Nov26 1:25 /usr/sbin/mysql
mysql 18538 0.0 8.5 363028 264832 ? S Nov26 1:32 /usr/sbin/mysql
mysql 18540 0.0 8.5 363028 264832 ? S Nov26 1:16 /usr/sbin/mysql
mysql 18541 0.0 8.5 363028 264832 ? S Nov26 1:24 /usr/sbin/mysql
mysql 18542 0.0 8.5 363028 264832 ? S Nov26 1:24 /usr/sbin/mysql
mysql 18544 0.0 8.5 363028 264832 ? S Nov26 1:21 /usr/sbin/mysql
mysql 18545 0.0 8.5 363028 264832 ? S Nov26 1:19 /usr/sbin/mysql
mysql 18550 0.0 8.5 363028 264832 ? S Nov26 1:23 /usr/sbin/mysql
mysql 18554 0.0 8.5 363028 264832 ? S Nov26 1:37 /usr/sbin/mysql
mysql 18557 0.0 8.5 363028 264832 ? S Nov26 1:21 /usr/sbin/mysql
mysql 18558 0.0 8.5 363028 264832 ? S Nov26 1:18 /usr/sbin/mysql
mysql 18562 0.0 8.5 363028 264832 ? S Nov26 1:18 /usr/sbin/mysql
mysql 18563 0.0 8.5 363028 264832 ? S Nov26 1:20 /usr/sbin/mysql
mysql 18580 0.0 8.5 363028 264832 ? S Nov26 1:33 /usr/sbin/mysql
mysql 18581 0.0 8.5 363028 264832 ? S Nov26 1:28 /usr/sbin/mysql
mysql 18582 0.0 8.5 363028 264832 ? S Nov26 1:51 /usr/sbin/mysql
mysql 18587 0.0 8.5 363028 264832 ? S Nov26 1:19 /usr/sbin/mysql
mysql 18589 0.0 8.5 363028 264832 ? S Nov26 1:17 /usr/sbin/mysql
mysql 18595 0.0 8.5 363028 264832 ? S Nov26 1:19 /usr/sbin/mysql
mysql 18597 0.0 8.5 363028 264832 ? S Nov26 1:26 /usr/sbin/mysql
mysql 18599 0.0 8.5 363028 264832 ? S Nov26 1:17 /usr/sbin/mysql
mysql 18601 0.0 8.5 363028 264832 ? S Nov26 1:28 /usr/sbin/mysql
mysql 18602 0.0 8.5 363028 264832 ? S Nov26 1:24 /usr/sbin/mysql
mysql 18606 0.0 8.5 363028 264832 ? S Nov26 1:39 /usr/sbin/mysql
mysql 18610 0.0 8.5 363028 264832 ? S Nov26 1:13 /usr/sbin/mysql
mysql 18726 0.0 8.5 363028 264832 ? S Nov26 1:19 /usr/sbin/mysql
mysql 18728 0.0 8.5 363028 264832 ? S Nov26 1:42 /usr/sbin/mysql
mysql 19869 0.0 8.5 363028 264832 ? S Nov26 1:34 /usr/sbin/mysql
mysql 19870 0.0 8.5 363028 264832 ? S Nov26 1:39 /usr/sbin/mysql
mysql 19873 0.0 8.5 363028 264832 ? S Nov26 1:34 /usr/sbin/mysql
named 22344 0.0 0.4 16776 13964 ? Ss Nov26 0:02 /usr/sbin/named
mysql 27321 0.0 8.5 363028 264832 ? S Nov26 1:34 /usr/sbin/mysql
mysql 27772 0.0 8.5 363028 264832 ? S Nov26 1:49 /usr/sbin/mysql
mysql 27829 0.0 8.5 363028 264832 ? S Nov26 1:40 /usr/sbin/mysql
mysql 27831 0.0 8.5 363028 264832 ? S Nov26 1:41 /usr/sbin/mysql
mysql 27832 0.0 8.5 363028 264832 ? S Nov26 1:46 /usr/sbin/mysql
mysql 27834 0.0 8.5 363028 264832 ? S Nov26 1:37 /usr/sbin/mysql
mysql 27836 0.0 8.5 363028 264832 ? S Nov26 1:54 /usr/sbin/mysql
mysql 27837 0.0 8.5 363028 264832 ? S Nov26 1:38 /usr/sbin/mysql
mysql 27857 0.0 8.5 363028 264832 ? S Nov26 1:39 /usr/sbin/mysql
mysql 27862 0.0 8.5 363028 264832 ? S Nov26 1:42 /usr/sbin/mysql
Sigue.............

BoRoU
01/12/2008, 08:09
Bueno retomando un tema que estabamos "boicoteando" abro este nuevo tema haber si doy con la respuesta a mi dilema...
Cita Publicado inicialmente por josu
Cuando haces un "ps aux"

Código:
root     29688  0.0  0.1   3720  1028 pts/0    R+   10:36   0:00 ps aux
josu     13152  0.0  0.4   6256  3528 pts/3    Ss   10:02   0:00 /bin/bash
Las octava columna representa el estado del proceso. Fíjate los que están intentando ejecutarse, esos son los que te suben el "load average".

Código:
PROCESS STATE CODES
       D uninterruptible sleep (usually IO)
       R runnable (on run queue)
       S sleeping
       T traced or stopped
       W paging (2.4 kernels and older only)
       X dead
       Z a defunct ("zombie") process

       For BSD formats and when the "stat" keyword is used, additional characters may be
       displayed:

       <      high-priority task

       N      low-priority task

       L      has pages locked into memory (for real-time and custom IO)

       s      is a session leader

       +      is in the foreground process group
Te pasa una copia del ps aux
Esto es el resultado del ps aux....
USER PID %CPU %MEM VSZ RSS TTY STAT START TIME COMMAND
root 1 0.0 0.0 1480 500 ? Ss Nov25 0:01 init [3]
root 2 0.0 0.0 0 0 ? S< Nov25 0:00 [kthreadd]
root 3 0.0 0.0 0 0 ? S< Nov25 0:01 [migration/0]
root 4 0.0 0.0 0 0 ? S< Nov25 0:00 [ksoftirqd/0]
root 5 0.0 0.0 0 0 ? S< Nov25 0:01 [migration/1]
root 6 0.0 0.0 0 0 ? S< Nov25 0:00 [ksoftirqd/1]
root 7 0.0 0.0 0 0 ? S< Nov25 0:07 [events/0]
root 8 0.0 0.0 0 0 ? S< Nov25 0:07 [events/1]
root 9 0.0 0.0 0 0 ? S< Nov25 0:00 [khelper]
root 89 0.0 0.0 0 0 ? S< Nov25 0:00 [kblockd/0]
root 90 0.0 0.0 0 0 ? S< Nov25 0:01 [kblockd/1]
root 92 0.0 0.0 0 0 ? S< Nov25 0:00 [kacpid]
root 93 0.0 0.0 0 0 ? S< Nov25 0:00 [kacpi_notify]
root 174 0.0 0.0 0 0 ? S< Nov25 0:00 [ata/0]
root 175 0.0 0.0 0 0 ? S< Nov25 0:00 [ata/1]
root 176 0.0 0.0 0 0 ? S< Nov25 0:00 [ata_aux]
root 177 0.0 0.0 0 0 ? S< Nov25 0:00 [ksuspend_usbd]
root 182 0.0 0.0 0 0 ? S< Nov25 0:00 [khubd]
root 185 0.0 0.0 0 0 ? S< Nov25 0:00 [kseriod]
root 225 0.0 0.0 0 0 ? S Nov25 0:12 [pdflush]
root 226 0.0 0.0 0 0 ? S Nov25 0:04 [pdflush]
root 227 0.0 0.0 0 0 ? S< Nov25 0:01 [kswapd0]
root 228 0.0 0.0 0 0 ? S< Nov25 0:00 [aio/0]
root 229 0.0 0.0 0 0 ? S< Nov25 0:00 [aio/1]
root 234 0.0 0.0 0 0 ? S< Nov25 0:00 [xfslogd/0]
root 235 0.0 0.0 0 0 ? S< Nov25 0:00 [xfslogd/1]
root 236 0.0 0.0 0 0 ? S< Nov25 0:00 [xfsdatad/0]
root 237 0.0 0.0 0 0 ? S< Nov25 0:00 [xfsdatad/1]
root 238 0.0 0.0 0 0 ? S< Nov25 0:00 [xfs_mru_cache]
root 919 0.0 0.0 0 0 ? S< Nov25 0:00 [scsi_eh_0]
root 921 0.0 0.0 0 0 ? S< Nov25 0:00 [scsi_eh_1]
root 941 0.0 0.0 0 0 ? S< Nov25 0:00 [mtdblockd]
root 983 0.0 0.0 0 0 ? S< Nov25 0:00 [kpsmoused]
root 993 0.0 0.0 0 0 ? S< Nov25 0:00 [rpciod/0]
root 994 0.0 0.0 0 0 ? S< Nov25 0:00 [rpciod/1]
root 995 0.0 0.0 0 0 ? S< Nov25 0:02 [kirqd]
root 997 0.0 0.0 0 0 ? S< Nov25 0:19 [kjournald]
root 1113 0.0 0.0 0 0 ? S< Nov25 0:25 [kjournald]
root 1709 0.0 0.0 2984 988 ? Ss Nov25 0:01 /usr/sbin/syslo
qmails 2505 0.0 0.0 1504 384 ? S Nov25 0:00 qmail-send
root 2506 0.0 0.0 1324 248 ? S Nov25 0:00 /usr/local/bin/
qmaill 2507 0.0 0.0 1472 336 ? S Nov25 0:00 /usr/local/bin/
root 2508 0.0 0.0 1536 468 ? S Nov25 0:00 tcpserver -H -R
root 2509 0.0 0.0 1324 244 ? S Nov25 0:00 /usr/local/bin/
qmaill 2510 0.0 0.0 1344 280 ? S Nov25 0:00 /usr/local/bin/
vpopmail 2511 0.0 0.0 1536 476 ? S Nov25 0:00 tcpserver -H -R
root 2512 0.0 0.0 1324 248 ? S Nov25 0:00 /usr/local/bin/
qmaill 2513 0.0 0.0 1344 280 ? S Nov25 0:00 /usr/local/bin/
root 2535 0.0 0.0 1472 320 ? S Nov25 0:00 qmail-lspawn ./
qmailr 2536 0.0 0.0 1864 852 ? S Nov25 0:00 qmail-rspawn
qmailq 2538 0.0 0.0 1460 316 ? S Nov25 0:00 qmail-clean
root 2553 0.0 0.0 5160 1200 ? Ss Nov25 0:00 /usr/sbin/sshd
root 2891 0.0 0.0 2892 836 ? Ss Nov25 2:45 /usr/sbin/colle
root 2945 0.0 0.0 1464 376 ? S Nov25 0:00 /usr/sbin/couri
root 2946 0.0 0.0 1976 640 ? S Nov25 0:00 /usr/lib/courie
root 2959 0.0 0.0 1976 248 ? S Nov25 0:00 /usr/lib/courie
root 2960 0.0 0.0 1976 248 ? S Nov25 0:00 /usr/lib/courie
root 2961 0.0 0.0 1976 248 ? S Nov25 0:00 /usr/lib/courie
root 2962 0.0 0.0 1976 248 ? S Nov25 0:00 /usr/lib/courie
root 2963 0.0 0.0 1976 248 ? S Nov25 0:00 /usr/lib/courie
root 2970 0.0 0.0 1568 480 ? S Nov25 0:00 /usr/lib/courie
root 2972 0.0 0.0 1468 440 ? S Nov25 0:00 /usr/lib/courie
nobody 3038 0.0 0.0 5744 1436 ? Ss Nov25 0:01 proftpd: (accep
root 3119 0.0 0.7 25760 23472 ? Ss Nov25 0:22 /usr/sbin/spamd
root 3157 0.0 0.0 1464 300 ? S Nov25 0:00 /usr/sbin/couri
root 3158 0.0 0.0 3456 776 ? S Nov25 0:00 /usr/lib/sqwebm
root 3170 0.0 0.0 3456 260 ? S Nov25 0:00 /usr/lib/sqwebm
root 3172 0.0 0.0 3456 260 ? S Nov25 0:00 /usr/lib/sqwebm
root 3174 0.0 0.0 3456 260 ? S Nov25 0:00 /usr/lib/sqwebm
root 3176 0.0 0.0 3456 260 ? S Nov25 0:00 /usr/lib/sqwebm
root 3178 0.0 0.0 3456 260 ? S Nov25 0:00 /usr/lib/sqwebm
root 3195 0.0 0.0 1752 660 ? Ss Nov25 0:00 /usr/sbin/cron
root 3226 0.0 0.0 1524 1524 ? SLs Nov25 0:01 /usr/sbin/watch
qscand 3259 0.0 0.7 25760 22472 ? S Nov25 0:00 spamd child
qscand 3260 0.0 0.7 25760 22380 ? S Nov25 0:00 spamd child
root 3320 0.0 0.0 1480 460 tty1 Ss+ Nov25 0:00 /sbin/agetty 38
root 3321 0.0 0.0 1480 460 tty2 Ss+ Nov25 0:00 /sbin/agetty 38
root 3322 0.0 0.0 1480 460 tty3 Ss+ Nov25 0:00 /sbin/agetty 38
root 3323 0.0 0.0 1480 460 tty4 Ss+ Nov25 0:00 /sbin/agetty 38
root 3324 0.0 0.0 1480 460 tty5 Ss+ Nov25 0:00 /sbin/agetty 38
root 3325 0.0 0.0 1480 460 tty6 Ss+ Nov25 0:00 /sbin/agetty 38