Shulou(Shulou.com)05/31 Report--

This article will explain in detail what the new configuration parameters of MySQL are, which the editor thinks is very practical, so I share it with you for reference. I hope you can get something after reading this article.

Activate_all_roles_on_login

This parameter was introduced in version 8.0.2 and is a dynamically adjustable global-level parameter with a default value of OFF. This parameter is used to control whether granted roles are activated when the account logs in, if ON, the granted roles are activated, and when set to OFF, user roles can only be explicitly activated through SET DEFAULT ROLE. The activate_all_roles_on_login setting takes effect only when the account logs in or starts executing the stored procedure. If you want to change the role of session, you need to execute the SET ROLE statement.

Binlog_expire_logs_seconds

The parameter, introduced in version 8.0.1, is a global-level parameter that can be adjusted dynamically. The default value before 8.0.4 is 2592000 after 8.0.11, that is, 30 days. In previous versions of binlog, the automatic cleanup time is measured in parameters expire_logs_days, that is, days. If the current two parameters coexist and there is a non-0 parameter, the binlog automatic cleanup time is taken as the non-0 parameter. If both are non-0 values, the expire_logs_days parameter setting is ignored with binlog_expire_logs_seconds as the binlog cleanup time.

Binlog_row_metadata

This parameter was introduced in version 8.0.1 and is a global-level parameter that can be adjusted dynamically. The default value is MINIMAL and can be set to FULL. This parameter is used to control the amount of metadata in the table in binlog in row format, record symbol marks, column character sets and space types when set to MINMAL, and record all metadata of the table, such as column names, enumerations or collections, primary key information, etc., when set to FULL.

Binlog_row_value_options

This parameter was introduced in version 8.0.3 and can be adjusted dynamically at the global level. The default value is''and can be set to PARTIAL_JSON.

When set to PARTIAL_JSON and the binlog format is in ROW or MIXED mode, when using JSON_SET (), JSON_REPLACE (), and JSON_REMOVE () to operate on the columns of JSON, binlog records only the updated portion, rather than the changes to the entire JSON, thereby reducing the binlog size. However, when changes to the JSON document require more space than the current document, or when the SERVER cannot be partially updated, binlog still records the entire JSON document.

This is the end of this article on "what are the new configuration parameters for MySQL?". I hope the above content can be of some help to you, so that you can learn more knowledge. if you think the article is good, please share it for more people to see.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.