cannot find mysql performance info at Linux "top" command

[boonkit@gmail.com]

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.

Thanks.

[vineyard_saker@yahoo.com]

Re: cannot find mysql performance info at Linux "top&qu ot; command

boonkit@gmail.c om wrote:[color=blue]
> Hi all,
>
> I cannot find MySQl performance info at linux "top" command. I[/color]
already[color=blue]
> 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.
>
> Thanks.[/color]

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.

HTH