MySQL :: MySQL 9.7 Reference Manual

Search Results

Displaying 61 to 70 of 431 total results

19.1.6.4 Binary Logging Options and Variables

https://dev.mysql.com/doc/refman/9.7/en/replication-options-binary-log.html

binlog_expire_logs_seconds Command-Line Format --binlog-expire-logs-seconds=# System Variable binlog_expire_logs_seconds Scope Global Dynamic Yes SET_VAR Hint Applies No Type Integer Default Value 2592000 Minimum Value 0 Maximum Value 4294967295 ...

19.1.6.1 Replication and Binary Logging Option and Variable Reference

https://dev.mysql.com/doc/refman/9.7/en/replication-options-reference.html

replica_checkpoint_period: Update progress status of multithreaded replica and flush relay log info to disk after this number of milliseconds. replica_net_timeout: Number of seconds to wait for more data from source/replica connection before ... The ...

7.6.4.2 Using the Rewriter Query Rewrite Plugin

https://dev.mysql.com/doc/refman/9.7/en/rewriter-query-rewrite-plugin-usage.html

The second statement illustrates that when the Rewriter plugin rewrites a statement, it produces a warning message. The second rule works only when appdb is the default database. To enable or disable the plugin, enable or disable the ...

7.1.10 Server Status Variables

https://dev.mysql.com/doc/refman/9.7/en/server-status-variables.html

Innodb_row_lock_time The total time spent in acquiring row locks for InnoDB tables, in milliseconds. Innodb_row_lock_time_avg The average time to acquire a row lock for InnoDB tables, in milliseconds. Innodb_row_lock_time_max The maximum time to ...

15.7.7.37 SHOW REPLICA STATUS Statement

https://dev.mysql.com/doc/refman/9.7/en/show-replica-status.html

Seconds_Behind_Source This field is an indication of how “late” the replica is: When the replica is actively processing updates, this field shows the difference between the current timestamp on the replica and the original timestamp logged on ...

8.4.1.11 WebAuthn Pluggable Authentication

https://dev.mysql.com/doc/refman/9.7/en/webauthn-pluggable-authentication.html

For example, if the account is set to use WebAuthn as the second authentication factor, the user invokes mysql with the --register-factor=2 option. If the user account is configured with the authentication_webauthn plugin set as the second or third ... Note WebAuthn authentication is an extension included in MySQL Enterprise Edition, a commercial ...

8.4.7.5 Configuring Audit Logging Characteristics for Audit Log Component

https://dev.mysql.com/doc/refman/9.7/en/audit-log-component-logging-configuration.html

A flush task configured using the audit_log.flush_interval_seconds system variable has a value of zero by default, which means the task is not scheduled to run. Start the server using audit_log.flush_interval_seconds and set the value to a number ...

8.4.6.5 Configuring Audit Plugin Logging Characteristics for Audit Log Plugin (Deprecated)

https://dev.mysql.com/doc/refman/9.7/en/audit-log-logging-configuration.html

A flush task configured using the audit_log_flush_interval_seconds system variable has a value of zero by default, which means the task is not scheduled to run. Start the server using audit_log_flush_interval_seconds and set the value to a number ...

8.5.2.5 MySQL Enterprise Data Masking Component Variables

https://dev.mysql.com/doc/refman/9.7/en/data-masking-component-variables.html

The MySQL Enterprise Data Masking components support the following system variables. Variables are unavailable unless the appropriate MySQL Enterprise Data Masking components are installed (see Section 8.5.2.1, “MySQL Enterprise Data Masking ...

7.4.2.6 Rule-Based Error Log Filtering (log_filter_dragnet)

https://dev.mysql.com/doc/refman/9.7/en/error-log-rule-based-filtering.html

The window_size value is the time window in seconds; if omitted, the default window is 60 seconds. This rule throttles plugin-shutdown messages to 5 occurrences per 60 seconds: IF err_code == ER_PLUGIN_SHUTTING_DOWN_PLUGIN THEN throttle 5. The ...

Displaying 61 to 70 of 431 total results