PDF (US Ltr)
- 41.8Mb
PDF (A4)
- 41.9Mb
Man Pages (TGZ)
- 272.4Kb
Man Pages (Zip)
- 378.4Kb
Info (Gzip)
- 4.2Mb
Info (Zip)
- 4.2Mb
Search Results
https://dev.mysql.com/doc/refman/9.7/en/connection-control-plugin-variables.html
Connection Control Plugin Status Variables 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 connection_control_failed_connections_threshold at runtime resets Connection_control_delay_generated to ... This section describes ...
https://dev.mysql.com/doc/refman/9.7/en/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/doc/refman/9.7/en/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/doc/refman/9.7/en/correlated-subqueries.html
A correlated subquery is a subquery that contains a reference to a table that also appears in the outer query. For example: SELECT * FROM t1 WHERE column1 = ANY (SELECT column1 FROM t2 WHERE t2.column2 = t1.column2); Notice that the subquery ...
https://dev.mysql.com/doc/refman/9.7/en/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/doc/refman/9.7/en/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, ...
https://dev.mysql.com/doc/refman/9.7/en/create-index.html
CREATE [UNIQUE | FULLTEXT | SPATIAL] INDEX index_name [index_type] ON tbl_name (key_part,...) [index_option] [algorithm_option | lock_option] ... This guideline is especially important for InnoDB tables, where the primary key determines the ...
https://dev.mysql.com/doc/refman/9.7/en/create-json-duality-view.html
If the table is projected multiple times, the set of columns projected must be consistent across all instances of the table projection. CREATE [OR REPLACE] [ALGORITHM = {UNDEFINED | MERGE}] [DEFINER = user] [SQL SECURITY {DEFINER | INVOKER}] JSON ...
https://dev.mysql.com/doc/refman/9.7/en/create-library.html
code is a string consisting of JavaScript code, or Base64 or hexadecimal encoding of the compiled WebAssembly code, which is checked for validity at creation time. CREATE LIBRARY [IF NOT EXISTS] [database.]library LANGUAGE language [COMMENT ...
https://dev.mysql.com/doc/refman/9.7/en/create-logfile-group.html
There can be only one log file group per NDB Cluster instance at any given time. CREATE LOGFILE GROUP logfile_group ADD UNDOFILE 'undo_file' [INITIAL_SIZE [=] initial_size] [UNDO_BUFFER_SIZE [=] undo_buffer_size] [REDO_BUFFER_SIZE [=] ...