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]