Documentation Home
MySQL 8.4 Reference Manual
Related Documentation Download this Manual
PDF (US Ltr) - 40.2Mb
PDF (A4) - 40.3Mb
Man Pages (TGZ) - 262.0Kb
Man Pages (Zip) - 367.6Kb
Info (Gzip) - 4.0Mb
Info (Zip) - 4.0Mb


MySQL 8.4 Reference Manual  / ...  / Security  / MySQL Enterprise Data Masking and De-Identification  / MySQL Enterprise Data Masking and De-Identification Components  /  MySQL Enterprise Data Masking and De-Identification Component Variables

8.5.2.5 MySQL Enterprise Data Masking and De-Identification Component Variables

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 (seeSection 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 Variablecomponent_masking.dictionaries_flush_interval_seconds
    ScopeGlobal
    DynamicNo
    SET_VAR Hint AppliesNo
    TypeInteger
    Default Value0
    Minimum Value60
    Maximum Value (Unix)18446744073709551615
    Maximum Value (Windows)4294967295
    Unitseconds

    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 Variablecomponent_masking.masking_database
    ScopeGlobal
    DynamicNo
    SET_VAR Hint AppliesNo
    TypeString
    Default Valuemysql

    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, seeInstall Using a Dedicated Schema. For general guidelines about using thePERSIST ONLY keyword, seeSection 15.7.6.1, “SET Syntax for Variable Assignment”.