PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/mysql-server.html
To run the server as some specific user, add an appropriate user option to the [mysqld] group of the global /etc/my.cnf option file, as shown later in this section. The PID file value passed to mysqld_safe overrides any value specified in the ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-replication-asynchronous-connection-failover-table.html
When asynchronous connection failover is enabled for a group of replicas managed by Group Replication, the source lists are broadcast to all group members when they join, and also when the lists change. To add and remove managed groups of servers, ... This table holds the replica's source lists for each replication channel for the asynchronous connection failover ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-thread-pool-tables.html
They provide information about thread pool operation: tp_thread_group_state: Information about thread pool thread group states. In the case of tp_thread_state, all rows for a thread group comprise a snapshot in time. Thus, the MySQL server holds the ... Note The Performance Schema tables described here are available as of MySQL ...
https://dev.mysql.com/doc/refman/8.0/en/replication-rules-channel-based-filters.html
Important On a MySQL server instance that is configured for Group Replication, channel specific replication filters can be used on replication channels that are not directly involved with Group Replication, such as where a group member also acts as ... This section explains how to work with replication filters when multiple replication channels exist, for example in a multi-source replication ...
https://dev.mysql.com/doc/refman/8.0/en/reset-replica.html
To use RESET REPLICA on a Group Replication group member, the member status must be OFFLINE, meaning that the plugin is loaded but the member does not currently belong to any group. A group member can be taken offline by using a STOP GROUP ... RESET ...
https://dev.mysql.com/doc/refman/8.0/en/selinux-context-mysql-feature-ports.html
setsebool -P mysql_connect_any=ON Setting the TCP Port Context for Group Replication If SELinux is enabled, you must set the port context for the Group Replication communication port, which is defined by the group_replication_local_address variable.
https://dev.mysql.com/doc/refman/8.0/en/switchable-optimizations.html
The following list describes the permissible opt_name flag names, grouped by optimization strategy: Batched Key Access Flags batched_key_access (default off) Controls use of BKA join algorithm. Limit Optimization Flags prefer_ordering_index (default ...Its value is a set of flags, each of which has a value of on or off to indicate whether the corresponding optimizer behavior is enabled or ...
https://dev.mysql.com/doc/refman/8.0/en/thread-pool-information-schema-tables.html
They provide information about thread pool operation: TP_THREAD_GROUP_STATE: Information about thread pool thread group states TP_THREAD_GROUP_STATS: Thread group statistics TP_THREAD_STATE: Information about thread pool thread states Rows in these ... Note As of MySQL 8.0.14, the INFORMATION_SCHEMA thread pool tables are also available as Performance Schema ...
https://dev.mysql.com/doc/refman/8.0/en/version-tokens-usage.html
An administrative or management application that communicates with the servers and organizes them into high-availability groups. Groups serve different purposes, and servers within each group may have different assignments. Assignment of a server ...
https://dev.mysql.com/doc/refman/8.0/en/where-optimization.html
HAVING is merged with WHERE if you do not use GROUP BY or aggregate functions (COUNT(), MIN(), and so on). If all columns in ORDER BY and GROUP BY clauses come from the same table, that table is preferred first when joining. If there is an ORDER BY ... This section discusses optimizations that can be made for processing WHERE ...