7.5.8.3 Option Tracker Status Variables

The Option Tracker component supplies a number of status variables, which are described in this section.

Table 7.9 Option Tracker Status Variable Summary

Variable Name	Variable Type	Variable Scope
option_tracker.gr_complete_table_received	Integer	Global
option_tracker.gr_complete_table_sent	Integer	Global
option_tracker.gr_error_received	Integer	Global
option_tracker.gr_error_sent	Integer	Global
option_tracker.gr_reset_request_received	Integer	Global
option_tracker.gr_reset_request_sent	Integer	Global
option_tracker.gr_single_row_received	Integer	Global
option_tracker.gr_single_row_sent	Integer	Global

• option_tracker.gr_complete_table_received

  This is the number of complete tables which have been received through Group Replication.

• option_tracker.gr_complete_table_sent

  This is the number of complete tables which have been sent through Group Replication.

• option_tracker.gr_error_received

  This is the number of errors which have been received through Group Replication.

• option_tracker.gr_error_sent

  This is the number of errors which have been sent through Group Replication.

• option_tracker.gr_reset_request_received

  This is the number of reset requests which have been received through Group Replication.

• option_tracker.gr_reset_request_sent

  This is the number of reset requests which have been sent through Group Replication.

• option_tracker.gr_single_row_received

  This is the number of single rows which have been received through Group Replication.

• option_tracker.gr_single_row_sent

  This is the number of single rows which have been sent through Group Replication.

• option_tracker_usage:*

  For each feature available in the MySQL server, a status variable showing the feature's usage is exposed. The name of each variable follows the pattern option_tracker_usage:feature_name, where feature_name is the name of the feature as shown in the OPTION_NAME column of the mysql_option.option_usage table, or in the OPTION_NAME column of the Performance Schema mysql_option. You can obtain all such variables using either of the queries shown here, and their values from the latter query:

  Press CTRL+C to copy
   
  mysql> SHOW STATUS LIKE 'option_tracker_usage%';
  +------------------------------------------------+-------+
  | Variable_name                                  | Value |
  +------------------------------------------------+-------+
  | option_tracker_usage:Binary Log                | 161   |
  | option_tracker_usage:Enterprise Data Masking   | 0     |
  | option_tracker_usage:JavaScript Library        | 1     |
  | option_tracker_usage:JavaScript Stored Program | 1     |
  | option_tracker_usage:Replication Replica       | 0     |
  | option_tracker_usage:Vector                    | 0     |
  +------------------------------------------------+-------+
  6 rows in set (0.00 sec)
  
  mysql> SELECT * FROM performance_schema.global_status
       > WHERE VARIABLE_NAME LIKE 'option_tracker_usage%';
  +------------------------------------------------+----------------+
  | VARIABLE_NAME                                  | VARIABLE_VALUE |
  +------------------------------------------------+----------------+
  | option_tracker_usage:Binary Log                | 161            |
  | option_tracker_usage:Enterprise Data Masking   | 0              |
  | option_tracker_usage:JavaScript Library        | 1              |
  | option_tracker_usage:JavaScript Stored Program | 1              |
  | option_tracker_usage:Replication Replica       | 0              |
  | option_tracker_usage:Vector                    | 0              |
  +------------------------------------------------+----------------+
  6 rows in set (0.00 sec)

  The output just shown is dependent on the features enabled on the system, and thus may not match the output shown on your system precisely. The values of these status variables are updated only if the Option Tracker component, available with MySQL Enterprise Edition, is installed in the system. The status variables themselves are installed by installing the corresponding features, whether the Option Tracker is present, or not.

  These status variables were added in MySQL 9.2.1. For more information, see Section 7.5.8, “Option Tracker Component”.