Search Results
https://dev.mysql.com/doc/refman/8.4/en/optimizer-hints.html
It places a limit N (a timeout value in milliseconds) on how long a statement is permitted to execute before the server terminates it: MAX_EXECUTION_TIME(N) Example with a timeout of 1 second (1000 milliseconds): SELECT /*+ MAX_EXECUTION_TIME(1000) ... One means of control over optimizer strategies is to set the optimizer_switch system variable (see Section 10.9.2, “Switchable ...
https://dev.mysql.com/doc/refman/8.4/en/sys-ps-setup-save.html
ps_setup_save() takes a timeout parameter to indicate how many seconds to wait if the lock already exists (which indicates that some other session has a saved configuration outstanding). Parameters in_timeout INT: How many seconds to wait to obtain ...This enables you to alter the configuration temporarily for debugging or other purposes, then restore it to the previous state by invoking the ps_setup_reload_saved() ...
https://dev.mysql.com/doc/refman/8.4/en/with.html
The max_execution_time system variable enforces an execution timeout for SELECT statements executed within the current session. The MAX_EXECUTION_TIME optimizer hint enforces a per-query execution timeout for the SELECT statement in which it appears. For queries that execute and thus recurse slowly or in contexts for which there is reason to set the cte_max_recursion_depth value very high, another way to guard against deep recursion is to set a per-session ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/advanced.replica-backup-restore.html
The duration mysqlbackup waits until it times out is specified by the --safe-replica-backup-timeout option. In addition, mysqlbackup also runs an initial check at the beginning of a replica backup to see if Replica_open_temp_tables becomes 0 within ... To backup a replica database, add the --replica-info option to your backup ...
https://dev.mysql.com/doc/mysql-router/9.4/en/mysql-router-rest-api-reference.html
This is the timeout in seconds (integer) before connections in the connection pool are closed. This is the maximum number (integer) of idling server connections in the connection pool. GET /connection_pool/{name}/status Shows reusedConnections as a ...For example, if the endpoint is "/metadata" then the URL is similar to ...
https://dev.mysql.com/doc/connectors/en/connector-j-reference-jdbc-url-format.html
This section explains the syntax of the URLs for connecting to MySQL. This is the generic format of the connection URL: protocol//[hosts][/database][?properties] The URL consists of the following parts: Important Any reserved characters for URLs ...
https://dev.mysql.com/doc/connector-j/en/connector-j-reference-jdbc-url-format.html
This section explains the syntax of the URLs for connecting to MySQL. This is the generic format of the connection URL: protocol//[hosts][/database][?properties] The URL consists of the following parts: Important Any reserved characters for URLs ...
https://dev.mysql.com/doc/relnotes/connector-cpp/en/news-8-0-24.html
(WL #14425) For connections made using X Plugin, if client with a connection to a server remains idle (not sending to the server) for longer than the relevant X Plugin timeout setting (read, write, or wait timeout), X Plugin closes the connection.
https://dev.mysql.com/doc/relnotes/connector-j/en/news-8-0-22.html
Deprecation and Removal Notes Functionality Added or Changed Bugs Fixed Deprecation and Removal Notes X DevAPI: The asynchronous variant of the X Protocol is no longer supported by Connector/J; the connection properties useAsyncProtocol and ...It is ...
https://dev.mysql.com/doc/relnotes/connector-j/en/news-8-0-12.html
(Bug #26089880) If wait_timeout was set on the server and the Connector/J had the connection property interactiveClient=false, or if interactive_timeout was set on the server and Connector/J had the connection property interactiveClient=true, a ...