Skip navigation links
8.2.3.35 DUMP 2515 »
Section Navigation      [Toggle]

8.2.3.34. DUMP 2514

Code Symbol Kernel Block(s)
2514 TcDumpApiConnectRecSummary DBTC

Description.  Provides information counts for allocated, seized, stateless, stateful, and scanning transaction objects for each API node. Available beginning with MySQL Cluster NDB 6.3.52, MySQL Cluster NDB 7.0.38, MySQL Cluster NDB 7.1.27, and MySQL Cluster NDB 7.2.13. (Bug #15878085)

Sample Output.  

Start of ApiConnectRec summary (6144 total allocated)
  Api node 10 connect records seized : 0 stateless : 0 stateful : 0 scan : 0
  Api node 11 connect records seized : 2 stateless : 0 stateful : 0 scan : 0
  Api node 12 connect records seized : 1 stateless : 0 stateful : 0 scan : 0

The total number of records allocated depends on the value of MaxNoOfConcurrentTransactions.

Additional Information.  There are two possible states for each record, listed here:

  1. Available: In the per-data node pool, not yet seized by any API node

  2. Seized: Reserved from the per-data node pool by a particular API

Seized nodes further be divided into a number of categories or sub-states, as shown in the following list:

  • Ready: (Not counted here) Seized, ready for use; can be calculated for an API as # seized - (# stateless + # stateful + # scan)

  • Stateless: Record was last used for a 'stateless' transaction, and is effectively ready

  • Stateful: Record is in use by a transaction

  • Scan: Record is in use for a scan (table or ordered index)

Copyright © 2003, 2013, Oracle and/or its affiliates. All rights reserved. Legal Notices