MySQL 9.4 Reference Manual Including MySQL NDB Cluster 9.4

1.5 Server and Status Variables and Options Added, Deprecated, or Removed in MySQL 9.4

This section lists server variables, status variables, and options that were added for the first time, have been deprecated, or have been removed in MySQL 9.4.

Options and Variables Introduced in MySQL 9.4

The following system variables, status variables, and server options have been added in MySQL 9.4.

  • component_firewall.database: Database where profiles are stored by MySQL Enterprise Firewall component. Added in MySQL 9.4.0.

  • component_firewall.enabled: Whether MySQL Enterprise Firewall component is enabled. Added in MySQL 9.4.0.

  • component_firewall.reload_interval_seconds: Interval in seconds between reloads of internal cache from MySQL Enterprise Firewall component tables. Added in MySQL 9.4.0.

  • component_firewall.trace: Whether MySQL Enterprise Firewall trace is enabled. Added in MySQL 9.4.0.

  • firewall_access_denied: Number of statements rejected by MySQL Enterprise Firewall component. Added in MySQL 9.4.0.

  • firewall_access_granted: Number of statements accepted by MySQL Enterprise Firewall component. Added in MySQL 9.4.0.

  • firewall_cached_entries: Number of statements recorded by MySQL Enterprise Firewall component. Added in MySQL 9.4.0.

  • server_memory: Memory (in bytes) used by the MySQL Server when auto-tuning the default values of the configuration parameters which depend on memory. Added in MySQL 9.4.0.

Options and Variables Deprecated in MySQL 9.4

The following system variables, status variables, and options have been deprecated in MySQL 9.4.

  • Firewall_access_denied: Number of statements rejected by MySQL Enterprise Firewall plugin. Deprecated in MySQL 9.4.0.

  • Firewall_access_granted: Number of statements accepted by MySQL Enterprise Firewall plugin. Deprecated in MySQL 9.4.0.

  • Firewall_cached_entries: Number of statements recorded by MySQL Enterprise Firewall plugin. Deprecated in MySQL 9.4.0.

  • early-plugin-load: Specify plugins to load before loading mandatory built-in plugins and before storage engine initialization. Deprecated in MySQL 9.4.0.

  • mysql_firewall_database: Database from which MySQL Enterprise Firewall plugin sources its tables and stored procedures. Deprecated in MySQL 9.4.0.

  • mysql_firewall_mode: Whether MySQL Enterprise Firewall plugin is operational. Deprecated in MySQL 9.4.0.

  • mysql_firewall_reload_interval_seconds: Reload MySQL Enterprise Firewall plugin data at specified intervals. Deprecated in MySQL 9.4.0.

  • mysql_firewall_trace: Whether to enable MySQL Enterprise Firewall plugin trace. Deprecated in MySQL 9.4.0.

Options and Variables Removed in MySQL 9.4

The following system variables, status variables, and options have been removed in MySQL 9.4.

  • temptable_use_mmap: Defines whether TempTable storage engine allocates memory-mapped files when the temptable_max_ram threshold is reached. Removed in MySQL 9.4.0.