Search Results
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-processlist-table.html
For example, if a CALL statement executes a stored procedure that is executing a SELECT statement, the INFO value shows the SELECT statement. The MySQL process list indicates the operations currently being performed by the set of threads executing ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-threads-table.html
For example, if a CALL statement executes a stored procedure that is executing a SELECT statement, the PROCESSLIST_INFO value shows the SELECT statement. The threads table contains a row for each server thread. Each row contains information about a ...
https://dev.mysql.com/doc/refman/8.4/en/replication-asynchronous-connection-failover.html
The list of potential source servers is stored on the replica, and in the event of a connection failure, a new source is selected from the list based on a weighted priority that you set. InnoDB ClusterSet and InnoDB Cluster are designed to abstract ... 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 ...
https://dev.mysql.com/doc/refman/8.4/en/replication-gtids-howto.html
This is a “cold start” procedure that assumes either that you are starting the source server for the first time, or that it is possible to stop it; for information about provisioning replicas using GTIDs from a running source server, see Section ... This section describes a process for configuring and starting GTID-based replication in MySQL ...
https://dev.mysql.com/doc/refman/8.4/en/resource-groups.html
Resource group definitions are stored in the resource_groups data dictionary table so that groups persist across server restarts. MySQL supports creation and management of resource groups, and permits assigning threads running within the server to ...
https://dev.mysql.com/doc/refman/8.4/en/security.html
Access control and security within the database system itself, including the users and databases granted with access to the databases, views and stored programs in use within the database. Note Several topics in this chapter are also addressed in ...
https://dev.mysql.com/doc/refman/8.4/en/show-binary-logs.html
This statement is used as part of the procedure described in Section 15.4.1.1, “PURGE BINARY LOGS Statement”, that shows how to determine which logs can be purged. Encrypted binary log files have a 512-byte file header that stores information ...
https://dev.mysql.com/doc/refman/8.4/en/show-grants.html
SHOW GRANTS [FOR user_or_role [USING role [, role] ...]] user_or_role: { user (see Section 8.2.4, “Specifying Account Names”) | role (see Section 8.2.5, “Specifying Role Names”. } This statement displays the privileges and roles that are ...
https://dev.mysql.com/doc/refman/8.4/en/show-processlist.html
For example, if a CALL statement executes a stored procedure that is executing a SELECT statement, the Info value shows the SELECT statement. SHOW [FULL] PROCESSLIST Important The INFORMATION SCHEMA implementation of SHOW PROCESSLIST is deprecated ...
https://dev.mysql.com/doc/refman/8.4/en/start-replica.html
IO_THREAD starts the replication receiver thread, which reads events from the source server and stores them in the relay log. Remove the option or system variable setting after the procedure is complete, so that it is not forgotten in the event of ... START REPLICA [thread_types] [until_option] [connection_options] [channel_option] thread_types: [thread_type [, thread_type] ...