cannot find mysql performance info at Linux "top" command

Collapse
This topic is closed.
X
X
 
  • Time
  • Show
Clear All
new posts
  • boonkit@gmail.com

    cannot find mysql performance info at Linux "top" command

    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

    #2
    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

    Comment

    Working...