PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 296.6Kb
Man Pages (Zip)
- 402.0Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/charset-binary-set.html
The binary character set is the character set for binary strings, which are sequences of bytes. Comparison and sorting are based on numeric byte values, rather than on numeric character code values (which for multibyte characters differ from ...
https://dev.mysql.com/doc/refman/8.0/en/condition-filtering.html
It depends on a constant value or values from earlier tables in the join sequence. In join processing, prefix rows are those rows passed from one table in a join to the next. In general, the optimizer attempts to put tables with low prefix counts ...
https://dev.mysql.com/doc/refman/8.0/en/connecting-using-uri-or-key-value-pairs.html
The following methods are permissible: AUTO MYSQL41 SHA256_MEMORY FROM_CAPABILITIES FALLBACK PLAIN For X Protocol connections, any configured auth-method is overridden to this sequence of authentication methods: MYSQL41, SHA256_MEMORY, PLAIN. You ...
https://dev.mysql.com/doc/refman/8.0/en/gis-class-curve.html
A Curve is a one-dimensional geometry, usually represented by a sequence of points. Particular subclasses of Curve define the type of interpolation between points. A Curve is simple if it does not pass through the same point twice, with the ...
https://dev.mysql.com/doc/refman/8.0/en/index-merge-optimization.html
The Index Merge access method retrieves rows with multiple range scans and merges their results into one. This access method merges index scans from a single table only, not scans across multiple tables. The merge can produce unions, intersections, ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-innodb-fields-table.html
When a column is dropped, the remaining columns are reordered so that the sequence has no gaps. The INNODB_FIELDS table provides metadata about the key columns (fields) of InnoDB indexes. For related usage information and examples, see Section ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-innodb-ft-being-deleted-table.html
This value might reflect the value of an ID column that you defined for the underlying table, or it can be a sequence value generated by InnoDB when the table contains no suitable column. The INNODB_FT_BEING_DELETED table provides a snapshot of the ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-innodb-ft-deleted-table.html
This value might reflect the value of an ID column that you defined for the underlying table, or it can be a sequence value generated by InnoDB when the table contains no suitable column. The INNODB_FT_DELETED table stores rows that are deleted ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-profiling-table.html
SEQ A sequence number indicating the display order for rows with the same QUERY_ID value. Its contents correspond to the information produced by the SHOW PROFILE and SHOW PROFILES statements (see Section 15.7.7.30, “SHOW PROFILE Statement”). The ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-performance-ro-txn.html
InnoDB can avoid the overhead associated with setting up the transaction ID (TRX_ID field) for transactions that are known to be read-only. A transaction ID is only needed for a transaction that might perform write operations or locking reads such ...