MySQL 9.0 Reference Manual Including MySQL NDB Cluster 9.0
The MySQL Enterprise Data Masking and De-Identification components support the following system variables. Use these variables to configure related component operations. Variables are unavailable unless the appropriate MySQL Enterprise Data Masking and De-Identification components are installed (see Section 8.5.2.1, “MySQL Enterprise Data Masking and De-Identification Component Installation”).
component_masking.dictionaries_flush_interval_seconds
| Command-Line Format | --component-masking.dictionaries-flush-interval-seconds=# |
|---|---|
| System Variable | component_masking.dictionaries_flush_interval_seconds |
| Scope | Global |
| Dynamic | No |
SET_VAR Hint Applies |
No |
| Type | Integer |
| Default Value | 0 |
| Minimum Value | 60 |
| Maximum Value (Unix) | 18446744073709551615 |
| Maximum Value (Windows) | 4294967295 |
| Unit | seconds |
Sets the interval, in seconds, to wait before attempting to schedule another flush of the data masking dictionaries table to the memory data masking dictionaries cache following a restart or previous execution. The value is handled as listed here:
0: No flushing
1 - 59 inclusive: Round up to 60, with a warning
>= 60: Wait this many seconds to perform flush
component_masking.masking_database
| Command-Line Format | --component-masking.masking-database[=value] |
|---|---|
| System Variable | component_masking.masking_database |
| Scope | Global |
| Dynamic | No |
SET_VAR Hint Applies |
No |
| Type | String |
| Default Value | mysql |
Specifies the database to use for data masking dictionaries at server startup. This variable is read only.
Use this variable to set and persist a schema other than the
default value (mysql). For additional
information about setting up the data-masking components to
use an alternative location for the data-masking table, see
Install Using a Dedicated Schema.
For general guidelines about using the PERSIST
ONLY keyword, see Section 15.7.6.1, “SET Syntax for Variable Assignment”.