PDF (US Ltr)
- 40.2Mb
PDF (A4)
- 40.3Mb
Man Pages (TGZ)
- 262.0Kb
Man Pages (Zip)
- 367.6Kb
Info (Gzip)
- 4.0Mb
Info (Zip)
- 4.0Mb
Search Results
https://dev.mysql.com/doc/refman/8.4/en/start-group-replication.html
This option acts as a hint to the server, and the donor for distributed recovery overrides it if a different plugin is associated with the user account on that server. START GROUP_REPLICATION [USER='user_name'] [, PASSWORD='user_pass'] [, ...
https://dev.mysql.com/doc/refman/8.4/en/subquery-materialization.html
MySQL can also apply subquery materialization to a single-table UPDATE or DELETE statement that uses a [NOT] IN or [NOT] EXISTS subquery predicate, provided that the statement does not use ORDER BY or LIMIT, and that subquery materialization is ...
https://dev.mysql.com/doc/refman/8.4/en/ibd2sdi.html
For example: Usage: ./ibd2sdi [-v] [-c <strict-check>] [-d <dump file name>] [-n] filename1 [filenames] See http://dev.mysql.com/doc/refman/8.4/en/ibd2sdi.html for usage hints. ibd2sdi is a utility for extracting serialized dictionary information ...
https://dev.mysql.com/doc/refman/8.4/en/memory-storage-engine.html
You can also specify a MAX_ROWS table option in CREATE TABLE statements for MEMORY tables to provide a hint about the number of rows you plan to store in them. The MEMORY storage engine (formerly known as HEAP) creates special-purpose tables with ...
https://dev.mysql.com/doc/refman/8.4/en/table-scan-avoidance.html
Use FORCE INDEX for the scanned table to tell MySQL that table scans are very expensive compared to using the given index: SELECT * FROM t1, t2 FORCE INDEX (index_for_column) WHERE t1.col_name=t2.col_name; See Section 10.9.4, “Index Hints”. The ...
https://dev.mysql.com/doc/refman/8.4/en/timestamp-lookups.html
Temporal values are stored in TIMESTAMP columns as UTC values, and values inserted into and retrieved from TIMESTAMP columns are converted between the session time zone and UTC. (This is the same type of conversion performed by the CONVERT_TZ() ...
https://dev.mysql.com/doc/refman/8.4/en/generated-column-index-optimizations.html
If the optimizer picks the wrong index, an index hint can be used to disable it and force the optimizer to make a different choice. For example: CREATE TABLE t1 (f1 INT, gc INT AS (f1 + 1) STORED, INDEX (gc)); The generated column, gc, is defined as ...
https://dev.mysql.com/doc/refman/8.4/en/using-explain.html
To give a hint to the optimizer to use a join order corresponding to the order in which the tables are named in a SELECT statement, begin the statement with SELECT STRAIGHT_JOIN rather than just SELECT. The EXPLAIN statement provides information ...
https://dev.mysql.com/doc/refman/8.4/en/explain.html
To give a hint to the optimizer to use a join order corresponding to the order in which the tables are named in a SELECT statement, begin the statement with SELECT STRAIGHT_JOIN rather than just SELECT. In practice, the DESCRIBE keyword is more ...
https://dev.mysql.com/doc/refman/8.4/en/explain-output.html
The EXPLAIN statement provides information about how MySQL executes statements. EXPLAIN returns a row of information for each table used in the SELECT statement. It lists the tables in the output in the order that MySQL would read them while ...