Documentation Home
MySQL 5.7 Reference Manual
Related Documentation Download this Manual
PDF (US Ltr) - 38.0Mb
PDF (A4) - 38.0Mb
PDF (RPM) - 37.3Mb
HTML Download (TGZ) - 10.2Mb
HTML Download (Zip) - 10.2Mb
HTML Download (RPM) - 8.9Mb
Man Pages (TGZ) - 216.6Kb
Man Pages (Zip) - 329.3Kb
Info (Gzip) - 3.5Mb
Info (Zip) - 3.5Mb
Excerpts from this Manual

MySQL 5.7 Reference Manual  /  ...  /  ndb_top — View CPU usage information for NDB threads

21.4.30 ndb_top — View CPU usage information for NDB threads

ndb_top displays running information in the terminal about CPU usage by NDB threads on an NDB Cluster data node. Each thread is represented by two rows in the output, the first showing system statistics, the second showing the measured statistics for the thread.

ndb_top is available beginning with MySQL NDB Cluster 7.6.3.

Usage

ndb_top [-h hostname] [-t port] [-u user] [-p pass] [-n node_id]

ndb_top connects to a MySQL Server running as an SQL node of the cluster. By default, it attempts to connect to a mysqld running on localhost and port 3360, as the MySQL root user with no password specified. You can override the default host and port using, respectively, --host (-h) and --port (-t). To specify a MySQL user and password, use the --user (-u) and --passwd (-p) options. This user must be able to read tables in the ndbinfo database (ndb_top uses information from ndbinfo.cpustat and related tables).

For more information about MySQL user accounts and passwords, see Section 6.3, “MySQL User Account Management”, as well as Section 6.2, “The MySQL Access Privilege System”.

Output is available as plain text or an ASCII graph; you can specify this using the --text (-x) and --graph (-g) options, respectively. These two display modes provide the same information; they can be used concurrently. At least one display mode must be in use.

Color display of the graph is supported and enabled by default (--color or -c option). With color support enabled, the graph display shows OS user time in blue, OS system time in green, and idle time as blank. For measured load, blue is used for execution time, yellow for send time, red for time spent in send buffer full waits, and blank spaces for idle time. The percentage shown in the graph display is the sum of percentages for all threads which are not idle. Colors are not currently configurable; you can use grayscale instead by using --skip-color.

The sorted view (--sort, -r) is based on the maximum of the measured load and the load reported by the OS. Display of these can be enabled and disabled using the --measured-load (-m) and --os-load (-o) options. Display of at least one of these loads must be enabled.

The program tries to obtain statistics from a data node having the node ID given by the --node-id (-n) option; if unspecified, this is 1. ndb_top cannot provide information about other types of nodes.

The view adjusts itself to the height and width of the terminal window; the minimum supported width is 76 characters.

Once started, ndb_top runs continuously until forced to exit; you can quit the program using Ctrl-C. The display updates once per second; to set a different delay interval, use --sleep-time (-s).

Note

ndb_top is available on Mac OS X, Linux, and Solaris. It is not currently supported on Windows platforms.

The following table includes all options that are specific to the NDB Cluster program ndb_top. Additional descriptions follow the table.

Table 21.108 This table describes command-line options for the ndb_top program

Format Description Added or Removed

--color,

-c

Show ASCII graphs in color; use --skip-colors to disable

ADDED: NDB 7.6.3

--graph,

-g

Display data using graphs; use --skip-graphs to disable

ADDED: NDB 7.6.3

--help,

-?

Show program usage information

ADDED: NDB 7.6.3

--host[=name],

-h

Host name or IP address of MySQL Server to connect to

ADDED: NDB 7.6.3

--measured-load,

-m

Show measured load by thread

ADDED: NDB 7.6.3

--node-id[=#],

-n

Watch node having this node ID

ADDED: NDB 7.6.3

--os-load,

-o

Show load measured by operating system

ADDED: NDB 7.6.3

--passwd[=password],

-p

Connect using this password

ADDED: NDB 7.6.3

--port[=#],

-t

Port number to use when connecting to MySQL Server

ADDED: NDB 7.6.3

--sleep-time[=seconds],

-s

Time to wait between display refreshes, in seconds

ADDED: NDB 7.6.3

--sort,

-r

Sort threads by usage; use --skip-sort to disable

ADDED: NDB 7.6.3

--text,

-x

Display data using text

ADDED: NDB 7.6.3

--user[=name],

-u

Connect as this MySQL user

ADDED: NDB 7.6.3


Additional Options

  • --color, -c

    Introduced5.7.19-ndb-7.6.3
    Command-Line Format--color
    Permitted ValuesTypeboolean
    DefaultTRUE

    Show ASCII graphs in color; use --skip-colors to disable.

  • --graph, -g

    Introduced5.7.19-ndb-7.6.3
    Command-Line Format--graph
    Permitted ValuesTypeboolean
    DefaultTRUE

    Display data using graphs; use --skip-graphs to disable. This option or --text must be true; both options may be true.

  • --help, -?

    Introduced5.7.19-ndb-7.6.3
    Command-Line Format--help
    Permitted ValuesTypeboolean
    DefaultTRUE

    Show program usage information.

  • --host[=name], -h

    Introduced5.7.19-ndb-7.6.3
    Command-Line Format--host[=name]
    Permitted ValuesTypestring
    Defaultlocalhost

    Host name or IP address of MySQL Server to connect to.

  • --measured-load, -m

    Introduced5.7.19-ndb-7.6.3
    Command-Line Format--measured-load
    Permitted ValuesTypeboolean
    DefaultFALSE

    Show measured load by thread. This option or --os-load must be true; both options may be true.

  • --node-id[=#], -n

    Introduced5.7.19-ndb-7.6.3
    Command-Line Format--node-id[=#]
    Permitted ValuesTypeinteger
    Default1

    Watch the data node having this node ID.

  • --os-load, -o

    Introduced5.7.19-ndb-7.6.3
    Command-Line Format--os-load
    Permitted ValuesTypeboolean
    DefaultTRUE

    Show load measured by operating system. This option or --measured-load must be true; both options may be true.

  • --passwd[=password], -p

    Introduced5.7.19-ndb-7.6.3
    Command-Line Format--passwd[=password]
    Permitted ValuesTypeboolean
    DefaultNULL

    Connect using this password.

  • --port[=#], -t

    Introduced5.7.19-ndb-7.6.3
    Command-Line Format--port[=#]
    Permitted ValuesTypeinteger
    Default3306

    Port number to use when connecting to MySQL Server.

  • --sleep-time[=seconds], -s

    Introduced5.7.19-ndb-7.6.3
    Command-Line Format--sleep-time[=seconds]
    Permitted ValuesTypeinteger
    Default1

    Time to wait between display refreshes, in seconds.

  • --sort, -r

    Introduced5.7.19-ndb-7.6.3
    Command-Line Format--sort
    Permitted ValuesTypeboolean
    DefaultTRUE

    Sort threads by usage; use --skip-sort to disable.

  • --text, -x

    Introduced5.7.19-ndb-7.6.3
    Command-Line Format--text
    Permitted ValuesTypeboolean
    DefaultFALSE

    Display data using text. This option or --graph must be true; both options may be true.

  • --user[=name], -u

    Introduced5.7.19-ndb-7.6.3
    Command-Line Format--user[=name]
    Permitted ValuesTypestring
    Defaultroot

    Connect as this MySQL user.

Sample Output.  The next figure shows ndb_top running in a terminal window on a Linux system with an ndbmtd data node under a moderate load. Here, the program has been invoked using ndb_top -n8 -x to provide both text and graph output:

Display from ndb_top, running in a terminal window.

User Comments
Sign Up Login You must be logged in to post a comment.