Search Results
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-tp-thread-group-stats-table.html
The tp_thread_group_stats table has these columns: TP_GROUP_ID The thread group ID. This number is incremented when a statement starts executing, not when it finishes. QUERIES_QUEUED The number of statements received that were queued for execution.
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-variables-info-table.html
If a client connects as user17 from host host34.example.com using the account 'user17'@'%.example.com, SET_USER and SET_HOST are user17 and host34.example.com, respectively. For proxy user connections, these values correspond to the external (proxy) ... The variables_info table shows, for each system variable, the source from which it was most recently set, and its range of ...
https://dev.mysql.com/doc/refman/8.4/en/perl-installation.html
These tests attempt to connect to the local MySQL server using the default user name and password. The default password is “no password.”) If you cannot connect to the server with those values (for example, if your account has a password), the ... MySQL Perl support requires that you have installed MySQL client programming support (libraries and header ...
https://dev.mysql.com/doc/refman/8.4/en/point-in-time-recovery-binlog.html
After editing the file, apply the contents as follows: $> mysql -u root -p < tmpfile If you have more than one binary log to apply on the MySQL server, use a single connection to apply the contents of all binary log files that you want to process.
https://dev.mysql.com/doc/refman/8.4/en/range-optimization.html
For EXPLAIN FOR CONNECTION, the output changes as follows if index dives are skipped: For traditional output, the rows and filtered values are NULL. Without FOR CONNECTION, EXPLAIN output does not change when index dives are skipped. The range ...
https://dev.mysql.com/doc/refman/8.4/en/replication-delayed.html
replication_connection_status: current status of the connection to the source, provides information on the last and current transaction the connection thread queued into the relay log. MySQL supports delayed replication such that a replica server ...
https://dev.mysql.com/doc/refman/8.4/en/replication-features-shutdowns.html
When a replica loses its connection to the source, the replica tries to reconnect immediately and retries periodically if that fails. A replica also is able to deal with network connectivity outages. However, the replica notices the network outage ... It is safe to shut down a replication source server and restart it ...
https://dev.mysql.com/doc/refman/8.4/en/replication-gtids-auto-positioning.html
When a replica has GTIDs enabled (GTID_MODE=ON, ON_PERMISSIVE, or OFF_PERMISSIVE ) and the SOURCE_AUTO_POSITION option enabled, auto-positioning is activated for connection to the source. The source must have GTID_MODE=ON set in order for the ...
https://dev.mysql.com/doc/refman/8.4/en/replication-gtids-howto.html
If you are starting with new servers, see Section 19.1.2.3, “Creating a User for Replication” for information about adding a specific user for replication connections and Section 19.1.2.1, “Setting the Replication Source Configuration” for ... This section describes a process for configuring and starting GTID-based replication in MySQL ...
https://dev.mysql.com/doc/refman/8.4/en/replication-implementation.html
Each replica that connects to the source requests a copy of the binary log. Because each replica is independent, the replaying of the changes from the source's binary log occurs independently on each replica that is connected to the source.