Re: mysql mem usage

2005-05-03 Thread Chris Knipe
PID USERNAME PRI NICE SIZERES STATETIME WCPUCPU COMMAND 55651 mysql 8 12 138M 33524K nanslp 0:21 0.00% 0.00% mysqld 55649 mysql 20 14 138M 33524K pause0:21 0.00% 0.00% mysqld 55866 mysql 4 14 138M 33524K sbwait 0:12 0.00% 0.00% mysqld Ya, sin

Re: mysql mem usage

2005-05-03 Thread Dan Nelson
In the last episode (May 03), Chris Knipe said: > top... > FreeBSD 5.4-STABLE, linuxthreads > > last pid: 56803; load averages: 0.29, 0.31, 0.14 up 5+11:10:10 20:09:05 > 174 processes: 1 running, 169 sleeping, 4 zombie > CPU states: 0.0% user, 2.3% nice, 1.2% system, 0.0% interrupt, 96.5

Re: mysql mem usage

2005-05-03 Thread Chris Knipe
the whooshing sound they make as they fly by..." - Douglas Adams, 'Hitchhiker's Guide to the Galaxy' - Original Message - From: "Dan Nelson" <[EMAIL PROTECTED]> To: "Chris Knipe" <[EMAIL PROTECTED]> Cc: Sent: Tuesday, May 03, 2005 7:34 P

Re: mysql mem usage

2005-05-03 Thread Dan Nelson
In the last episode (May 03), Chris Knipe said: > I have a P4 system with 1GB Ram and 512MB Swap (a little low I know). > > I'm running a multi threaded MySQL installation on it. With a bit of > shock, I realised today that I ran completely out of swap space!!! > Each MySQL thread is consuming a