MySQL 9.3 Reference Manual Including MySQL NDB Cluster 9.3
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.
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.
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:
,
where feature_name
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:
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.
Each feature obtains the initial value of the status variable at initialization time from the Option Tracker component (if installed) and stores it in the status variable. The Option Tracker persists all such status variables once per hour.
If the Option Tracker component is loaded after the component or plugin implementing the feature, any existing value for the status variable is reset with the persistent value provided by the Option Tracker, with any increments to it before that time being lost.
These status variables were added in MySQL 9.2.1. For more information, see Section 7.5.8.2, “Option Tracker Supported Components”.