cannot find mysql performance info at Linux "top" command

Do you have a question? Post it now! No Registration Necessary.  Now with pictures!

Threaded View

Hi all,

I cannot find MySQl performance info at linux "top" command. I already
tested on slow MySQL query that took more than 5 minutes (create
fulltext index), but during the 5 minutes, i cannot find any mysql
process at top command. Below is the system information:

Linux version: 2.6.9-1.667smp (Red Hat 3.4.2-6.fc3)
MySQL version: 4.1.11 (source installation)

Please help me on this.


Re: cannot find mysql performance info at Linux "top" command wrote:
Quoted text here. Click to load it

that's because your "top" only shows the processes which use most
ressources.  try "ps -A" which will give you a full list of processes.
you should see mysqld in that list.

you did mean "mysqld" (with a *d* at the end) right?  Once you start a
query the client (mysqld) does nothing but waiting.  Its the
server/daemon which does all the work.


Site Timeline