Search Results
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-table-reference.html
The following table summarizes all available Performance Schema tables. For greater detail, see the individual table descriptions. Table 29.1 Performance Schema Tables Table Name Description accounts Connection statistics per client account ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-threads-table.html
If a client has auto-reconnect enabled and the session reconnects after a disconnect, the session becomes associated with a new row in the threads table that has a different PROCESSLIST_ID value. The threads table contains a row for each server ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-variables-info-table.html
PERSISTED The variable was set from a server-specific mysqld-auto.cnf option file. The variables_info table shows, for each system variable, the source from which it was most recently set, and its range of values. VARIABLE_SOURCE The source from ...
https://dev.mysql.com/doc/refman/8.4/en/plugin-loading.html
Built-in Plugins Plugins Registered in the mysql.plugin System Table Plugins Named with Command-Line Options Plugins Installed with the INSTALL PLUGIN Statement Built-in Plugins A built-in plugin is known by the server automatically. If any plugin ... Server plugins must be loaded into the server before they can be ...
https://dev.mysql.com/doc/refman/8.4/en/privileges-provided.html
Accounts created with the SYSTEM_USER privilege have the AUDIT_ABORT_EXEMPT privilege assigned automatically when they are created. The BACKUP_ADMIN privilege is automatically granted to users with the RELOAD privilege when performing an in-place ...
https://dev.mysql.com/doc/refman/8.4/en/program-options.html
For the server, one exception applies: The mysqld-auto.cnf option file in the data directory is processed last, so it takes precedence even over command-line options. There are several ways to specify options for MySQL programs: List the options on ...
https://dev.mysql.com/doc/refman/8.4/en/programs-development.html
This section describes some utilities that you may find useful when developing MySQL programs. In shell scripts, you can use the my_print_defaults program to parse option files and see what options would be used by a given program. This works well ...
https://dev.mysql.com/doc/refman/8.4/en/replica-logs-status.html
A replica server creates two replication metadata repositories, the connection metadata repository and the applier metadata repository. If binary log file position based replication is in use, when the replica restarts, it reads the two ...
https://dev.mysql.com/doc/refman/8.4/en/replication-asynchronous-connection-failover-source.html
To activate asynchronous connection failover for a replication channel set SOURCE_CONNECTION_AUTO_FAILOVER=1 in a CHANGE REPLICATION SOURCE TO statement for this channel. GTID auto-positioning must be in use for the channel (SOURCE_AUTO_POSITION = ...Important When the existing connection to a source fails, the replica first retries the same connection the number of times specified by the SOURCE_RETRY_COUNT option of the CHANGE REPLICATION SOURCE ...
https://dev.mysql.com/doc/refman/8.4/en/replication-asynchronous-connection-failover.html
You can use the asynchronous connection failover mechanism to establish an asynchronous (source-to-replica) replication connection to a new source automatically, after the existing connection from a replica to its source fails. The asynchronous ...