Documentation Home
MySQL 9.2 Reference Manual
Related Documentation Download this Manual
PDF (US Ltr) - 40.8Mb
PDF (A4) - 40.9Mb
Man Pages (TGZ) - 259.7Kb
Man Pages (Zip) - 366.9Kb
Info (Gzip) - 4.1Mb
Info (Zip) - 4.1Mb


8.5.2.5 MySQL Enterprise Data Masking Component Variables

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 (seeSection 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 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”.