[EMAIL PROTECTED] wrote:
> Question,
>
> Could some one tell me why our mysqld daemon appears to be incrementing on time.
> For instance I get the following output when I use ps -elf. the 470 you see below
>was 460
> 30 secs ago. Is there a memory leak or ? we are using MySql 3.23.30
>
> What can I do to resolve this??? besides restart mysqld
>
> Thanks, Joe Balderrama
>
> F S UID PID PPID C PRI NI ADDR SZ WCHAN STIME TTY TIME
>CMD
> 19 T root 0 0 0 0 SY 10414c50 0 Aug 16 ? 0:00
>sched
> 8 S root 1 0 0 41 20 70111848 94 70111a70 Aug 16 ? 0:14
>/etc/init -
> 8 S root 287 1 0 84 20 70a3a728 373 7019e83a Aug 16 ? 0:00
>/usr/lib/dmi/dmispd
> 8 O mysql 22907 22897 1 81 20 70892e20 3190 Aug 26 ? 470:02
>/usr/local/mysql/bin/mysqld --basedir=/usr/local/mysql --datadir=/local_home/my
> 8 S http 23257 305 0 41 20 7160e798 1168 706ae3ac Aug 26 ? 15:38
>/local_home/apache/v1.3.20/bin/http
> 8 S root 28988 1408 0 41 20 70c20a58 178 70d5baa6 Aug 28 pts/1 0:00
>/bin/csh
> 8 O root 3058 2673 0 51 20 7160eea0 119 14:18:37 pts/7 0:00
>ps -elf
> 8 S http 24038 305 1 81 20 716103b8 1161 70d5bbae Aug 27 ? 15:26
>/local_home/apache/v1.3.20/bin/http
> 8 S http 23925 305 0 41 20 70c21160 1170 7055662c Aug 27 ? 15:11
>/local_home/apache/v1.3.20/bin/http
>
> ---------------------------------------------------------------------
> 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
It looks like a Solaris (or others SysV unix?) ps print and the time column shows
the total (user+system) cpu time used by the process.
In case of mysqld it will mostly be query processing.
---------------------------------------------------------------------
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
