content_image/848308.jpg
The number of operations by this replica based on or using primary keys. This includes operations on blob tables, implicit unlock operations, and auto-increment operations, as well as user-visible primary key operations. 

Although this variable can be read using either SHOW GLOBAL STATUS  or SHOW SESSION STATUS , it is effectively global in scope. If this MySQL server does not act as a replica, or does not use NDB tables, this value is always 0. 

For more information, see Section 23.5.13, “NDB API Statistics Counters and Variables” . 

• Ndb_api_pk_op_count 

The number of operations by this MySQL Server (SQL node) based on or using primary keys. This includes operations on blob tables, implicit unlock operations, and auto-increment operations, as well as user-visible primary key operations. 

Although this variable can be read using either SHOW GLOBAL STATUS  or SHOW SESSION STATUS , it is effectively global in scope. 

For more information, see Section 23.5.13, “NDB API Statistics Counters and Variables” . 

• Ndb_api_pruned_scan_count_session 

The number of scans in this client session that have been pruned to a single partition. 

Although this variable can be read using either SHOW GLOBAL STATUS  or SHOW SESSION STATUS , it relates to the current session only, and is not affected by any other clients of this mysqld . 

For more information, see Section 23.5.13, “NDB API Statistics Counters and Variables” . 

• Ndb_api_pruned_scan_count_replica 

The number of scans by this replica that have been pruned to a single partition. 

Although this variable can be read using either SHOW GLOBAL STATUS  or SHOW SESSION STATUS , it is effectively global in scope. If this MySQL server does not act as a replica, or does not use NDB tables, this value is always 0. 

For more information, see Section 23.5.13, “NDB API Statistics Counters and Variables” . 

• Ndb_api_pruned_scan_count_slave 

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

The number of scans by this replica that have been pruned to a single partition. 

## Note 

Deprecated in NDB 8.0.23; use Ndb_api_pruned_scan_count_replica instead. 

Although this variable can be read using either SHOW GLOBAL STATUS  or SHOW SESSION STATUS , it is effectively global in scope. If this MySQL server does not act as a replica, or does not use NDB tables, this value is always 0. 

For more information, see Section 23.5.13, “NDB API Statistics Counters and Variables” . 

