Search Results
https://dev.mysql.com/doc/refman/8.4/en/sys-ps-setup-disable-thread.html
Given a connection ID, disables Performance Schema instrumentation for the thread. Example Disable a specific connection by its connection ID: mysql> CALL sys.ps_setup_disable_thread(225); +-------------------+ | summary | +-------------------+ | ...This is a value of the type given in the PROCESSLIST_ID column of the Performance Schema threads table or the Id column of SHOW PROCESSLIST ...
https://dev.mysql.com/doc/refman/8.4/en/sys-ps-setup-enable-thread.html
Given a connection ID, enables Performance Schema instrumentation for the thread. Example Enable a specific connection by its connection ID: mysql> CALL sys.ps_setup_enable_thread(225); +------------------+ | summary | +------------------+ | ...
https://dev.mysql.com/doc/refman/8.4/en/sys-session-ssl-status.html
For each connection, this view displays the SSL version, cipher, and count of reused SSL sessions. The session_ssl_status view has these columns: thread_id The thread ID for the connection.
https://dev.mysql.com/doc/refman/8.4/en/thread-commands.html
Connect Used by replication receiver threads connected to the source, and by replication worker threads. Daemon This thread is internal to the server, not a thread that services a client connection. A thread can have any of the following Command ...
https://dev.mysql.com/doc/refman/8.4/en/windows-testing.html
(Be sure that an account exists that specifies an IP address or you may not be able to connect.) You can force a MySQL client to use a named-pipe connection rather than TCP/IP by specifying the --pipe or --protocol=PIPE option, or by specifying . If ...In this case, start mysqld with the skip_name_resolve system variable enabled and use only localhost and IP addresses in the Host column of the MySQL grant ...
https://dev.mysql.com/doc/refman/8.4/en/xa-states.html
Detached transactions are disconnected from the current session following execution of XA PREPARE (and can be committed or rolled back by another connection). When XA transactions are detached, a connection has no special knowledge of any XA ... An ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/mysqlbackup.backup.html
We specify some of the connection information for the database using the --user and --host options (and, with the --password option, tell mysqlbackup to prompt for a user password). The output echoes all the parameters used by the backup operation, ... In the following illustration, we back up an entire MySQL instance to a single file using the backup-to-image command, which appears at the end of the sample ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/mysqlbackup.incremental.html
The steps above assume that the connection session that initiated the DO innodb_redo_log_consumer_register(); UDF is kept open in between the base backup or the last incremental backup and the latest redo-log-only incremental backup. That setup will ...In order to that, after making first a full backup that contains all data, you can do one of the following: Performing a series of differential ...
https://dev.mysql.com/doc/mysql-cluster-manager/8.4/en/mcm-attribute-tables-api.html
AutoReconnect: Specifies whether an API node should reconnect fully when disconnected from cluster. ConnectBackoffMaxTime: Specifies longest time in milliseconds (~100ms resolution) to allow between connection attempts to any given data node by this ...ArbitrationDelay: When asked to arbitrate, arbitrator waits this many milliseconds before ...
https://dev.mysql.com/doc/mysql-cluster-manager/8.4/en/mcm-collect-logs.html
When an mcmd agent receives the collect logs command from the mcm agent it is connected with, it sets up a TCP server socket using port 0 by default, and lets the operating system assign the actual port number. All agents in the site are then ...