Hello,

When I start mysql, the processlist shows 10 processes:

Ps aux | grep mysql | wc -l
10

But 'mytop' (handy command line utility to see processes) shows only the
number of threads I'm using.

Anyone know why its using 10 processes if it only has 1 thread?  I'm not
familiar with how 'ps' tries to report on threads (since mysql
technically supposedly has only 1 process).  Is it doing something
wrong?

My main concern is for the reported memory usage.  If ps is right, and
it IS using that memory, what is it doing?

 1 31454 mysql    23M  2.1M  108M   23M 34819  S   mysqld     
 2 31456 mysql    23M  2.1M  108M   23M 34819  S   mysqld     
.. continue until ..
29 31639 mysql    23M  2.1M  108M   23M 34819  S   mysqld     
30 31709 mysql    23M  2.1M  108M   23M 34819  S   mysqld    

Thanks,
Kevin Watt
Community Manager, Allpoetry.com
What happened to the cow who went for a drive?   He got a Moo_ving
violation
What do you call someone who is crazy about hot chocolate?   A cocoa nut
What do bees use to cut wood?   Buzz saws
Who eats at underwater resturants ?   Suba diners
How do really small people call each other ?   On Microphones
How do you fix a broken chimp?   With a monkey wrench

> -----Original Message-----
> From: Charlie Brewer [mailto:[EMAIL PROTECTED]
> Sent: Thursday, September 25, 2003 12:13 PM
> To: [EMAIL PROTECTED]
> Subject: Noob Question: Error 1046
> 
> Evenin',
> 
> Sorry to send noob questions, I know how annoying they can be, but we
need
> help too ;)  Anyways, Im using a self teach book to teach myself PHP,
> MySQL and Apache.  The book is getting into MySQL and basic commands.
> Anyways, they gave an example, and I typed it in as shown in the book,
but
> I get an error.  I took a screenshot (I thought that would be easier)
and
> posted it here:
> 
> http://hostultra.org/brewer/mysql.jpg
> 
> Any help would be very much so appreciated, thanks.


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to