https://dev.mysql.com/condition-pushdown-optimization.html
For example, in a my.cnf file, use these lines: [mysqld] optimizer_switch=engine_condition_pushdown=off At runtime, disable condition pushdown like this: SET optimizer_switch='engine_condition_pushdown=off';Limitations. This optimization improves ...
https://dev.mysql.com/connecting-disconnecting.html
To connect to the server, you will usually need to provide a MySQL user name when you invoke mysql and, most likely, a password. If the server runs on a machine other than the one where you log in, you will also need to specify a host name. Contact ...
https://dev.mysql.com/connecting-using-uri-or-key-value-pairs.html
connect-timeout: An integer value used to configure the number of seconds that clients, such as MySQL Shell, wait until they stop trying to connect to an unresponsive MySQL server. connection-attributes: Controls the key-value pairs that application ... This section describes use of URI-like connection strings or key-value pairs to specify how to establish connections to the MySQL server, for clients such as MySQL ...
https://dev.mysql.com/connecting.html
It is possible to specify connection parameters without entering them on the command line each time you invoke a client program: Specify the connection parameters in the [client] section of an option file. This section describes use of command-line ...
https://dev.mysql.com/connection-compression-control.html
Because enabling compression decreases performance, its benefits occur primarily when there is low network bandwidth, network transfer time dominates the cost of compression and decompression operations, and result sets are large. To configure that ... Connections to the server can use a compressed protocol that reduces the number of bytes sent over the ...
https://dev.mysql.com/connection-control-variables.html
If the CONNECTION_CONTROL plugin is installed, it exposes this status variable: Connection_control_delay_generated The number of times the server added a delay to its response to a failed connection attempt. Assigning a value to ... This section ...
https://dev.mysql.com/constant-folding-optimization.html
Comparisons between constants and column values in which the constant value is out of range or of the wrong type with respect to the column type are now handled once during query optimization rather row-by-row than during execution. The comparisons ...
https://dev.mysql.com/constraint-foreign-key.html
MATCH options do not have any other effect in MySQL, which in effect enforces MATCH SIMPLE semantics full-time. Foreign keys let you cross-reference related data across tables, and foreign key constraints help keep this spread-out data consistent.
https://dev.mysql.com/corrupted-myisam-tables.html
You are using an external program (such as myisamchk) to modify a table that is being modified by the server at the same time. Even though the MyISAM table format is very reliable (all changes to a table made by an SQL statement are written before ...
https://dev.mysql.com/crashing.html
Some external program is manipulating data files or index files at the same time as mysqld without locking the table properly. Each MySQL version is tested on many platforms before it is released. This does not mean that there are no bugs in MySQL, ...
