Documentation Home
MySQL 5.7 Reference Manual
Related Documentation Download this Manual
PDF (US Ltr) - 35.1Mb
PDF (A4) - 35.2Mb
Man Pages (TGZ) - 256.4Kb
Man Pages (Zip) - 361.2Kb
Info (Gzip) - 3.4Mb
Info (Zip) - 3.4Mb
Excerpts from this Manual

21.6.15.34 The ndbinfo server_operations Table

Theserver_operations table contains entries for all ongoingNDB operations that the current SQL node (MySQL Server) is currently involved in. It effectively is a subset of thecluster_operations table, in which operations for other SQL and API nodes are not shown.

Theserver_operations table contains the following columns:

  • mysql_connection_id

    MySQL Server connection ID

  • node_id

    Node ID

  • block_instance

    Block instance

  • transid

    Transaction ID

  • operation_type

    Operation type (see text for possible values)

  • state

    Operation state (see text for possible values)

  • tableid

    Table ID

  • fragmentid

    Fragment ID

  • client_node_id

    Client node ID

  • client_block_ref

    Client block reference

  • tc_node_id

    Transaction coordinator node ID

  • tc_block_no

    Transaction coordinator block number

  • tc_block_instance

    Transaction coordinator block instance

Notes

Themysql_connection_id is the same as the connection or session ID shown in the output ofSHOW PROCESSLIST. It is obtained from theINFORMATION_SCHEMA tableNDB_TRANSID_MYSQL_CONNECTION_MAP.

block_instance refers to an instance of a kernel block. Together with the block name, this number can be used to look up a given instance in thethreadblocks table.

The transaction ID (transid) is a unique 64-bit number which can be obtained using the NDB API'sgetTransactionId() method. (Currently, the MySQL Server does not expose the NDB API transaction ID of an ongoing transaction.)

Theoperation_type column can take any one of the valuesREAD,READ-SH,READ-EX,INSERT,UPDATE,DELETE,WRITE,UNLOCK,REFRESH,SCAN,SCAN-SH,SCAN-EX, or<unknown>.

Thestate column can have any one of the valuesABORT_QUEUED,ABORT_STOPPED,COMMITTED,COMMIT_QUEUED,COMMIT_STOPPED,COPY_CLOSE_STOPPED,COPY_FIRST_STOPPED,COPY_STOPPED,COPY_TUPKEY,IDLE,LOG_ABORT_QUEUED,LOG_COMMIT_QUEUED,LOG_COMMIT_QUEUED_WAIT_SIGNAL,LOG_COMMIT_WRITTEN,LOG_COMMIT_WRITTEN_WAIT_SIGNAL,LOG_QUEUED,PREPARED,PREPARED_RECEIVED_COMMIT,SCAN_CHECK_STOPPED,SCAN_CLOSE_STOPPED,SCAN_FIRST_STOPPED,SCAN_RELEASE_STOPPED,SCAN_STATE_USED,SCAN_STOPPED,SCAN_TUPKEY,STOPPED,TC_NOT_CONNECTED,WAIT_ACC,WAIT_ACC_ABORT,WAIT_AI_AFTER_ABORT,WAIT_ATTR,WAIT_SCAN_AI,WAIT_TUP,WAIT_TUPKEYINFO,WAIT_TUP_COMMIT, orWAIT_TUP_TO_ABORT. (If the MySQL Server is running withndbinfo_show_hidden enabled, you can view this list of states by selecting from thendb$dblqh_tcconnect_state table, which is normally hidden.)

You can obtain the name of anNDB table from its table ID by checking the output ofndb_show_tables.

Thefragid is the same as the partition number seen in the output ofndb_desc--extra-partition-info (short form-p).

Inclient_node_id andclient_block_ref,client refers to an NDB Cluster API or SQL node (that is, an NDB API client or a MySQL Server attached to the cluster).

Theblock_instance andtc_block_instance column provide NDB kernel block instance numbers. You can use these to obtain information about specific threads from thethreadblocks table.