[Date Prev][Date Next] [Thread Prev][Thread Next] [Date Index] [Thread Index]

Re: Consumo de recursos extraño



-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Adrián Chapela wrote:
> 
> ----- Original Message ----- From: "Ricardo Frydman"
> <ricardo@sinectis.com.ar>
> To: "Adrián Chapela" <achapela1@wanadoo.es>
> Cc: "Lista Debian" <debian-user-spanish@lists.debian.org>
> Sent: Wednesday, June 29, 2005 7:22 PM
> Subject: Re: Consumo de recursos extraño
> 
> 
> Adrián Chapela wrote:
> 
>>> Muy Importante --> Al hacer un ps no sale al momento, van saliendo los
>>> procesos poco a poco.
> 
> 
> Que no salen de golpe, van saliendo  primero sale un nombre de proceso y
> después otro, vamos como cuando te conectas a un servidor desde una
> conexión con mucho uso... no se si me explico...
> 
>>> No entiendo que quieres decir con esto...
>>> olvide pedirte uptime
> 
> 
> UPTIME 2 días.
> 
La salida del comando uptime con los recursos en uso incluidos....

>>> Se nota al acceder al servidor por SSH muchísimo y
>>> no está trabajando en el Oracle lo suficiente.
>>> Me traduces al español?
> 
> 
> Lo que quiero decir que el Oracle no está teniendo muchas consultas, ni
> se está haciendo un backup ni nada, simplemente hai tres clientes
> accediendo a la base de datos que no está continuamente consultando ni
> gravando datos y el otro acceso a la base de datos es una WEB que
> tampoco tiene muchas consultas.
> 
>>> 40 % o 50 % de procesador, de recursos del sistema
> 
> procesador es una cosa, recursos del sistema otra, que kernel usas?
> 
>>> Salida de ps -aux:
>>>
>>> USER       PID %CPU %MEM   VSZ  RSS TTY      STAT START   TIME COMMAND
>>> root         1  0.0  0.0  1416  512 ?        S    Jun25   0:04 init
>>> root         2  0.0  0.0     0    0 ?        SW   Jun25   0:00 [keventd]
>>> root         3  0.0  0.0     0    0 ?        SW   Jun25   0:00 [keventd]
>>> root         4  0.0  0.0     0    0 ?        SW   Jun25   0:00 [keventd]
>>> root         5  0.0  0.0     0    0 ?        SW   Jun25   0:00 [keventd]
>>> root         6  0.0  0.0     0    0 ?        SW   Jun25   0:00 [keventd]
>>> root         7  0.0  0.0     0    0 ?        SW   Jun25   0:00 [keventd]
>>> root         8  0.0  0.0     0    0 ?        SW   Jun25   0:00 [keventd]
>>> root         9  0.0  0.0     0    0 ?        SW   Jun25   0:00 [keventd]
>>> root        10  0.0  0.0     0    0 ?        SWN  Jun25   0:00
>>> [ksoftirqd_CPU0]
>>> root        11  0.0  0.0     0    0 ?        SWN  Jun25   0:00
>>> [ksoftirqd_CPU1]
>>> root        12  0.0  0.0     0    0 ?        SWN  Jun25   0:00
>>> [ksoftirqd_CPU2]
>>> root        13  0.0  0.0     0    0 ?        SWN  Jun25   0:00
>>> [ksoftirqd_CPU3]
>>> root        14  0.0  0.0     0    0 ?        SWN  Jun25   0:00
>>> [ksoftirqd_CPU4]
>>> root        15  0.0  0.0     0    0 ?        SWN  Jun25   0:00
>>> [ksoftirqd_CPU5]
>>> root        16  0.0  0.0     0    0 ?        SWN  Jun25   0:00
>>> [ksoftirqd_CPU6]
>>> root        17  0.0  0.0     0    0 ?        SWN  Jun25   0:00
>>> [ksoftirqd_CPU7]
>>> root        18  2.7  0.0     0    0 ?        SW   Jun25 160:10 [kswapd]
> 
> ^^^^^^ esto significa 2.7% de CPU porque dices 50%?
> 
> 
>>> root        19  0.0  0.0     0    0 ?        SW   Jun25   0:00
>>> [kreclaimd]
>>> root        20  0.0  0.0     0    0 ?        SW   Jun25   0:03 [bdflush]
>>> root        21  0.0  0.0     0    0 ?        SW   Jun25   0:50 [kupdated]
>>> root        22  0.0  0.0     0    0 ?        SW   Jun25   0:00
>>> [mdrecoveryd]
>>> root       107  0.0  0.0     0    0 ?        SW   Jun25   0:00 [khubd]
>>> root       688  0.0  0.0  1480  616 ?        S    Jun25   0:22 syslogd
>>> -m 0
>>> root       693  0.0  0.0  2020 1136 ?        S    Jun25   0:00 klogd -2
>>> root       875  0.0  0.0 14736 2832 ?        S    Jun25   0:00
>>> /usr/sbin/snmpd -
>>> root       876  0.0  0.0 14736 2832 ?        S    Jun25   0:00
>>> /usr/sbin/snmpd -
>>> root       877  0.0  0.0 14736 2832 ?        S    Jun25   0:00
>>> /usr/sbin/snmpd -
>>> root       895  0.0  0.0  2596 1092 ?        S    Jun25   0:13
>>> /usr/local/sbin/s
>>> oracle     954  0.0  0.2 316968 8792 ?       S    Jun25   3:19
>>> ora_pmon_uac
>>> oracle     956  0.0  1.1 319248 43272 ?      S    Jun25   0:55
>>> ora_dbw0_uac
>>> oracle     958  0.0  0.2 322208 9340 ?       S    Jun25   3:37
>>> ora_lgwr_uac
>>> oracle     960  0.0  0.3 318148 11700 ?      S    Jun25   5:10
>>> ora_ckpt_uac
>>> oracle     962  0.0  2.7 316360 107488 ?     S    Jun25   0:10
>>> ora_smon_uac
>>> oracle     964  0.0  1.1 316320 44092 ?      S    Jun25   0:00
>>> ora_reco_uac
>>> oracle     966  0.0  0.5 316320 20884 ?      S    Jun25   0:00
>>> ora_cjq0_uac
>>> oracle     968  0.0  3.4 316956 134044 ?     S    Jun25   1:13
>>> ora_qmn0_uac
>>> oracle     970  0.0  0.1 316892 6820 ?       S    Jun25   0:00
>>> ora_s000_uac
>>> oracle     972  0.0  0.1 316764 7080 ?       S    Jun25   0:00
>>> ora_d000_uac
>>> oracle     974  0.0  0.2 320456 11400 ?      S    Jun25   0:03
>>> ora_arc0_uac
>>> oracle     976  0.0  0.2 320456 11388 ?      S    Jun25   0:02
>>> ora_arc1_uac
>>> oracle    1013  0.0  0.1 14348 4180 ?        S    Jun25   0:18
>>> /opt/oracle/produ
>>> root      1030  0.0  0.0  1444  500 ?        S    Jun25   0:00 gpm -t
>>> ps/2 -m /d
>>> root      1048  0.0  0.0  1604  660 ?        S    Jun25   0:02 crond
>>> root      1183  0.0  0.0  1456  492 ?        S<   Jun25   0:00
>>> /opt/compaq/cpqhe
>>> root      1188  0.1  0.0  1408  492 ?        S<   Jun25   6:03
>>> /opt/compaq/cpqhe
>>> root      1288  0.0  0.0  2004 1024 ?        S    Jun25   0:04
>>> cmathreshd -p 5 -
>>> root      1304  0.0  0.0 10320 1196 ?        S    Jun25   0:00 cmapeerd
>>> root      1324  0.3  0.0  2024  940 ?        S    Jun25  19:31 cmahostd
>>> -p 15 -s
>>> root      1338  0.0  0.0  5288 3188 ?        S    Jun25   0:00 cmawebd
>>> root      1339  0.0  0.0  5288 3188 ?        S    Jun25   0:00 cmawebd
>>> root      1340  0.0  0.0  5288 3188 ?        S    Jun25   0:00 cmawebd
>>> root      1361  0.0  0.0 10320 1196 ?        S    Jun25   0:00 cmapeerd
>>> root      1363  0.0  0.0 10320 1196 ?        S    Jun25   0:00 cmapeerd
>>> root      1373  0.1  0.0  1920  984 ?        S    Jun25   6:38
>>> cmahealthd -p 30
>>> root      1383  0.0  0.0  2212  880 ?        S    Jun25   0:05 cmastdeqd
>>> -p 30
>>> root      1393  0.2  0.0  1780  856 ?        S    Jun25  11:53 cmaperfd
>>> -p 30 -s
>>> root      1489  0.0  0.0 10076  816 ?        S    Jun25   0:00
>>> /sbin/cpqriisd -F
>>> root      1492  0.0  0.0 10076  816 ?        S    Jun25   0:00
>>> /sbin/cpqriisd -F
>>> root      1493  0.5  0.0 10076  816 ?        S    Jun25  30:23
>>> /sbin/cpqriisd -F
>>> root      1494  0.0  0.0 10076  816 ?        S    Jun25   5:31
>>> /sbin/cpqriisd -F
>>> root      1495  0.0  0.0  1404  492 ?        S<   Jun25   0:00
>>> /opt/compaq/cpqhe
>>> root      1496  0.0  0.0 10076  816 ?        S    Jun25   0:00
>>> /sbin/cpqriisd -F
>>> root      1497  0.0  0.0 10076  816 ?        S    Jun25   0:00
>>> /sbin/cpqriisd -F
>>> root      1504  0.0  0.0  5288 3188 ?        S    Jun25   0:00 cmawebd
>>> root      1505  0.0  0.0  5288 3188 ?        S    Jun25   0:00 cmawebd
>>> root      1506  0.0  0.0  5288 3188 ?        S    Jun25   0:00 cmawebd
>>> root      1528  0.0  0.0  2112 1024 ?        S    Jun25   0:35 cmasm2d
>>> -p 30
>>> root      1556  0.0  0.0 14512  872 ?        S    Jun25   4:07 cmarackd
>>> -p 120
>>> root      1558  0.0  0.0 14512  872 ?        S    Jun25   0:00 cmarackd
>>> -p 120
>>> root      1560  0.0  0.0 14512  872 ?        S    Jun25   0:00 cmarackd
>>> -p 120
>>> root      1561  0.0  0.0 14512  872 ?        S    Jun25   0:00 cmarackd
>>> -p 120
>>> root      1595  0.0  0.0  2212 1032 ?        S    Jun25   0:15 cmasm2d
>>> -p 30
>>> root      1609  0.0  0.0 10228  888 ?        S<   Jun25   0:00
>>> cmastorpeerd
>>> root      1637  0.2  0.0  2568 1320 ?        S    Jun25  14:29 cmaeventd
>>> root      1640  0.0  0.0 10228  888 ?        S<   Jun25   0:00
>>> cmastorpeerd
>>> root      1641  0.0  0.0 10228  888 ?        S<   Jun25   0:00
>>> cmastorpeerd
>>> root      1642  0.0  0.0 10228  888 ?        S<   Jun25   0:00
>>> cmastorpeerd
>>> root      1657  5.1  0.0  3008 1680 ?        S    Jun25 300:44 cmaidad
>>> -p 15 -s
>>> root      1708  0.0  0.0  2716 1416 ?        S    Jun25   0:00 cmafcad
>>> -p 15 -s
>>> root      1730  0.0  0.0   408  232 ?        S    Jun25   0:00 cmaided
>>> -p 15 -s
>>> root      1749  0.0  0.0  7308 1140 ?        S    Jun25   0:00 cmanicd
>>> root      1775  0.0  0.0  7308 1140 ?        S    Jun25   0:00 cmanicd
>>> root      1777  0.0  0.0  7308 1140 ?        S    Jun25   0:00 cmanicd
>>> xfs       1901  0.0  0.0  4216 2892 ?        S    Jun25   0:00 xfs
>>> -droppriv -da
>>> daemon    2024  0.0  0.0  1452  560 ?        S    Jun25   0:00
>>> /usr/sbin/atd
>>> bb        2130  0.0  0.0  2320 1096 ?        S    Jun25   0:00 /bin/sh
>>> /home/new
>>> bb        2131  0.0  0.0  1412  464 ?        SN   Jun25   0:00
>>> /home/newbb/bbc1.
>>> root      2352  0.0  0.0  1392  440 tty1     S    Jun25   0:00
>>> /sbin/mingetty tt
>>> root      2353  0.0  0.0  1392  440 tty2     S    Jun25   0:00
>>> /sbin/mingetty tt
>>> root      2354  0.0  0.0  1392  440 tty3     S    Jun25   0:00
>>> /sbin/mingetty tt
>>> root      2355  0.0  0.0  1392  440 tty4     S    Jun25   0:00
>>> /sbin/mingetty tt
>>> root      2356  0.0  0.0  1392  440 tty5     S    Jun25   0:00
>>> /sbin/mingetty tt
>>> root      2357  0.0  0.0  1392  440 tty6     S    Jun25   0:00
>>> /sbin/mingetty tt
>>> oracle    2463  0.0  0.4 316484 15748 ?      S    Jun25   0:00 oracleuac
>>> (LOCAL=
>>> oracle    2467  0.0  0.3 316448 11692 ?      S    Jun25   0:00 oracleuac
>>> (LOCAL=
>>> oracle    2469  0.0  1.3 316484 51604 ?      S    Jun25   0:00 oracleuac
>>> (LOCAL=
>>> oracle    2517  0.0  0.3 316448 11680 ?      S    Jun25   0:00 oracleuac
>>> (LOCAL=
>>> oracle    2531  0.0  0.3 316448 14332 ?      S    Jun25   0:00 oracleuac
>>> (LOCAL=
>>> oracle    2557  0.0  0.3 316452 11960 ?      S    Jun25   0:00 oracleuac
>>> (LOCAL=
>>> oracle    2566  0.0  0.3 316444 11704 ?      S    Jun25   0:00 oracleuac
>>> (LOCAL=
>>> oracle    2568  0.0  0.3 316444 13688 ?      S    Jun25   0:00 oracleuac
>>> (LOCAL=
>>> oracle    2583  0.0  0.3 316448 11708 ?      S    Jun25   0:00 oracleuac
>>> (LOCAL=
>>> oracle   24112  0.0  2.1 316488 82444 ?      S    Jun25   0:02 oracleuac
>>> (LOCAL=
>>> oracle    1481  0.0  0.6 316444 26432 ?      S    Jun27   0:00 oracleuac
>>> (LOCAL=
>>> oracle    6222  0.0  3.4 322248 133892 ?     S    Jun27   0:41 oracleuac
>>> (LOCAL=
>>> oracle   32240  0.0  2.2 321168 87336 ?      S    Jun28   0:04 oracleuac
>>> (LOCAL=
>>> oracle   30675  0.0  3.3 322228 130672 ?     S    Jun28   0:25 oracleuac
>>> (LOCAL=
>>> oracle    2965  0.0  3.3 317044 130256 ?     S    04:02   0:07 oracleuac
>>> (LOCAL=
>>> oracle    3170  0.0  3.5 316588 136232 ?     S    04:02   0:23 oracleuac
>>> (LOCAL=
>>> oracle    3172  0.0  3.5 317256 137452 ?     S    04:02   0:27 oracleuac
>>> (LOCAL=
>>> oracle    3174  0.0  3.5 317160 137256 ?     S    04:02   0:28 oracleuac
>>> (LOCAL=
>>> oracle    3176  0.0  3.5 317128 137500 ?     S    04:02   0:28 oracleuac
>>> (LOCAL=
>>> oracle    3178  0.0  3.5 317140 137056 ?     S    04:02   0:26 oracleuac
>>> (LOCAL=
>>> oracle    3181  0.2  3.5 316980 135936 ?     S    04:02   2:34 oracleuac
>>> (LOCAL=
>>> oracle    3187  0.2  3.5 317000 135732 ?     S    04:02   2:37 oracleuac
>>> (LOCAL=
>>> oracle    3189  0.3  3.5 316980 135548 ?     S    04:02   2:49 oracleuac
>>> (LOCAL=
>>> oracle    3191  0.3  3.5 318024 135864 ?     S    04:02   2:57 oracleuac
>>> (LOCAL=
>>> oracle    3193  0.3  3.5 317524 136128 ?     S    04:02   2:58 oracleuac
>>> (LOCAL=
>>> oracle    3195  0.0  0.2 316452 11328 ?      S    04:02   0:00 oracleuac
>>> (LOCAL=
>>> oracle    3197  0.0  1.8 316464 71420 ?      S    04:02   0:00 oracleuac
>>> (LOCAL=
>>> oracle   28991  0.0  0.7 317000 28240 ?      S    09:39   0:00 oracleuac
>>> (LOCAL=
>>> oracle    6786  0.0  0.3 316444 14288 ?      S    10:37   0:00 oracleuac
>>> (LOCAL=
>>> oracle    6789  0.0  0.3 316468 14140 ?      S    10:37   0:00 oracleuac
>>> (LOCAL=
>>> oracle   18010  0.0  2.3 316448 90640 ?      S    15:06   0:05 oracleuac
>>> (LOCAL=
>>> root     23598  0.8  0.0  5216 1292 ?        R    19:04   0:00 sshd:
>>> root@pts/0
>>> root     23614  0.8  0.0  2516 1328 pts/0    S    19:05   0:00 -bash
>>> root     23737  0.0  0.0  2864  884 pts/0    R    19:05   0:01 ps -aux
>>>
>>>
>>> El proceso cmanicd a veces también ocupa mucho procesador.
> 
> 
> Que es?
> 
> En serio debes pensar en volar oracle!
> 
>>>
>>> Un saludo.
>>>
>>> ----- Original Message ----- From: "Ricardo Frydman"
>>> <ricardo@sinectis.com.ar>
>>> To: "Adrián Chapela" <achapela1@wanadoo.es>
>>> Cc: "Lista Debian" <debian-user-spanish@lists.debian.org>
>>> Sent: Wednesday, June 29, 2005 6:39 PM
>>> Subject: Re: Consumo de recursos extraño
>>>
>>>
>>> Adrián Chapela wrote:
>>>
>>>>> Hola,
>>>>>
>>>>> tengo un servidor de base de datos Oracle con 4 procesadores y 4 GB. La
>>>>> duda que tengo es como con este maquinón y sirviendo para dos
>>>>> aplicaciones (principalmente), una página web y 3 clientes, en
>>>>> determinados momentos la carga del sistema es muy importante.
>>>
>>>
>>>
>>> Define "muy importante".
>>>
>>>>> Al hacer un top me indica que el proceso "kswapd" , el de gestión del
>>>>> swap ocupa un 40 % ó 50 %.
>>>
>>>
>>> 40 o 50% de que?
>>> Mira aqui:
>>> http://mail.linux.org.mx/pipermail/ayuda/2003-June/007606.html
>>>
>>> Eso es un poco raro, teniendo una memoria de
>>>
>>>>> 4 Gb no ??
>>>
>>>
>>> La verdad que si
>>>
>>>>> A alguien se le ocurre que puede estar pasando.
>>>
>>>
>>> No, pero....
>>> * manda la salida de ps aux
>>> * los logs
>>> * free -m -t
>>> y, por supuesto, evalúa migrar a postgreSQL!
>>>
>>>
>>>
>>> -- 
>>> Ricardo A.Frydman
>>> Consultor en Tecnología Open Source - Administrador de Sistemas
>>> jabber: eureka@jabber.sk - http://www.eureka-linux.com.ar
>>> SIP # 1-747-667-9534
> 
> 
> --
> Ricardo A.Frydman
> Consultor en Tecnología Open Source - Administrador de Sistemas
> jabber: eureka@jabber.sk - http://www.eureka-linux.com.ar
> SIP # 1-747-667-9534

- --
Ricardo A.Frydman
Consultor en Tecnología Open Source - Administrador de Sistemas
jabber: eureka@jabber.sk - http://www.eureka-linux.com.ar
SIP # 1-747-667-9534
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.1 (GNU/Linux)

iD8DBQFCwt1mkw12RhFuGy4RAhY9AJ9UaBOMSqt3MDG9BXe2Nyyqrcm7xACcDyqZ
TfTeZ3SK0Wg603BoxBCF0Fo=
=9+lb
-----END PGP SIGNATURE-----



Reply to: