content_image/824940.jpg content_image/824941.jpg
mysql> SHOW STATUS LIKE ’%trans_commit_count%’; +------------------------------------+-------+ | Variable_name | Value | +------------------------------------+-------+ | Ndb_api_trans_commit_count_session | 1 | | Ndb_api_trans_commit_count_slave | 0 | | Ndb_api_trans_commit_count | 2 | +------------------------------------+-------+ 3 rows in set (0.00 sec) 

From this you can determine that 1 transaction has been committed in the current mysql  client session, and 2 transactions have been committed on this mysqld  since it was last restarted. 

You can see how various NDB API counters are incremented by a given SQL statement by comparing the values of the corresponding _session  status variables immediately before and after performing the statement. In this example, after getting the initial values from SHOW STATUS , we create in the test database an NDB  table, named t , that has a single column: 

<img src='content_image/824940.jpg'>

Now you can execute a new SHOW STATUS  statement and observe the changes, as shown here (with the changed rows highlighted in the output): 

<img src='content_image/824941.jpg'>

