cannot find mysql performance info at Linux "top" command

[boonkit]

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]

bo*****@gmail.com wrote:

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.

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