MySQL 9.3 Reference Manual Including MySQL NDB Cluster 9.3
The MySQL Enterprise Data Masking components support the following system variables. Use these variables to configure related component operations. Variables are unavailable unless the appropriate MySQL Enterprise Data Masking components are installed (see Section 8.5.2.1, “MySQL Enterprise Data Masking 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”.