MySQL :: MySQL 9.7 Reference Manual

Search Results

Displaying 41 to 45 of 45 total results

« Previous
1
2
3
4
5
Next »

https://dev.mysql.com/doc/refman/9.7/en/group-replication-frequently-asked-questions.html

The member makes the specified number of auto-rejoin attempts five minutes apart. What is the maximum number of MySQL servers in a group? A group can consist of maximum 9 servers. Attempting to add another server to a group with 9 members causes the ...

20.5.1.1 Changing the Primary

https://dev.mysql.com/doc/refman/9.7/en/group-replication-change-primary.html

You can specify a timeout from 1 to 3600 seconds (60 minutes) for transactions that are running when you use the function. This section explains how to change which member of a single-primary group is the primary, using the ...

27.5.6 The Event Scheduler and MySQL Privileges

https://dev.mysql.com/doc/refman/9.7/en/events-privileges.html

To enable or disable the execution of scheduled events, it is necessary to set the value of the global event_scheduler system variable. The EVENT privilege governs the creation, modification, and deletion of events. For example, suppose that ...

10.9.1 Controlling Query Plan Evaluation

https://dev.mysql.com/doc/refman/9.7/en/controlling-query-plan-evaluation.html

At the same time, if compiled with optimizer_search_depth equal to 3 or 4, the optimizer may compile in less than a minute for the same query. The task of the query optimizer is to find an optimal plan for executing an SQL query. Because the ...

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

For example, to configure the flush task to recur every two minutes: $> mysqld --audit_log_flush_interval_seconds=120 For more information, see the audit_log_flush_interval_seconds system variable. Important The audit_log plugin is deprecated, and ...