* [EMAIL PROTECTED]
> On Friday, May 30, 2003, at 03:23 AM, Jon Haugsand wrote:
>
>> ps aux | grep -E 'USER|mysql'
>
> Do you mind telling me what these mean, I'd appreciate it greatly:
> I know what PID and CPU and MEM are...
>
> ps aux | grep -E 'USER|mysql'
> USER    PID %CPU %MEM      VSZ    RSS  TT  STAT STARTED      TIME
> COMMAND
> root    359   0.0  0.0     1828    580  ??  S     4:10AM   0:00.05 sh
> ./bin/mysqld_safe
> mysql   408   0.0  1.2    34936  19524  ??  S     4:10AM   0:01.53
> /Library/MySQL/libexec/mys
> ted     895   0.0  0.0     1116      4 std  R+    4:26AM   0:00.00
> grep -E USER|mysql

I'll do so, but such questions shouldn't be resolved privatly as there
may be others who need the same information.  (Share and enjoy. :-) )

Four lines, i.e. one heading and three processes.  

Headin is selfexplanatory, or look into 'man ps' if you have the
patient.  Interesting here is USER, PID and COMMAND.  USER was what we
were looking for.  COMMAND to pick out the processes.  PID if you need
to force stop the mysql server. 

First one is the program 'sh
./bin/mysqld_safe' which is run as root. I do not have this, but as I
understand it is just a bootstrap process for getting mysql to run..
Anyone must correct me if I'm wrong.  RedHat does not have this, I
guess they did something clever in order not to use system resources.

Second process should be our mysql server process.  This one is run by
mysql as it should be.

Thrird process is the process you used to get this information.  It is
run as user 'ted'.  Just forget it.

-- 
 Jon Haugsand, [EMAIL PROTECTED]
 http://www.norges-bank.no


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

Reply via email to