Sorry, I don't know about Solaris, but I observed that my MySQL
processes (Linux) are sometimes from 10 to 25 MB which makes me
wonder. I think that a process should reflect the result size,
for example. We have all sorts of parameters here to adjust
memory usage, and normally there are restrictions to keep
programs from running away. What happens if you get a result set
of 100 MB? Will MySQL show in top with, say 110 MB?

Sie schrieben am Mittwoch, 18. Juli 2001, 13:00:09:

> I don't know. I've got a server with Linux+Mysql and the output of top is
> different

>  PID USER     PRI  NI  SIZE  RSS SHARE STAT %CPU %MEM   TIME COMMAND
>  822 mysql      0   0  9628 7548  5296 S     0,0 11,9   0:00 mysqld
>  839 mysql      0   0  9628 7548  5296 S     0,0 11,9   0:01 mysqld
>  840 mysql      0   0  9628 7548  5296 S     0,0 11,9   0:01 mysqld

> Why in the output of Top in Solaris mysqld is 801M
> If you need an archive conf. or something to help me, say me please.



> -----Mensaje original-----
> De: Werner Stuerenburg [mailto:[EMAIL PROTECTED]]
> Enviado el: miércoles, 18 de julio de 2001 12:46
> Para: Jorge Ruiz Martinez
> CC: '[EMAIL PROTECTED]'
> Asunto: Re: SMP+mysql problem


> What I am stumbling about is this:

>>   PID USERNAME THR PRI  NICE     SIZE   RES STATE   TIME    CPU COMMAND
>>> 22889 root           30  33    0  801M   11M cpu0   23.6H 26.75% mysqld

> Is this really true: size 801 M???? How can that be????




-- 
Herzlich
Werner Stuerenburg            

_________________________________________________
ISIS Verlag, Teut 3, D-32683 Barntrup-Alverdissen
Tel 0(049) 5224-997 407 · Fax 0(049) 5224-997 409
http://pferdezeitung.de



---------------------------------------------------------------------
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

Reply via email to