PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/clone-plugin-remote.html
The donor and recipient must have the same MySQL server character set and collation. For information about MySQL server character set and collation configuration, see Section 12.15, “Character Set Configuration”. The clone plugin supports the ...
https://dev.mysql.com/doc/refman/8.0/en/column-indexes.html
Index Prefixes FULLTEXT Indexes Spatial Indexes Indexes in the MEMORY Storage Engine Index Prefixes With col_name(N) syntax in an index specification for a string column, you can create an index that uses only the first N characters of the column.
https://dev.mysql.com/doc/refman/8.0/en/comparison-operators.html
String values can be converted to a different character set using CONVERT(). By default, string comparisons are not case-sensitive and use the current character set. If any argument is a nonbinary (character) string, the arguments are compared as ...
https://dev.mysql.com/doc/refman/8.0/en/create-tablespace.html
Note When determining the path used for a data file, NDB does not expand the ~ (tilde) character. In addition to these rules, the slash character (“/”) is not permitted, nor can you use names beginning with innodb_, as this prefix is reserved ...
https://dev.mysql.com/doc/refman/8.0/en/error-log-format.html
Each error log sink (writer) component has a characteristic output format it uses to write messages to its destination, but other factors may influence the content of the messages: The information available to the log sink. If a log filter ...
https://dev.mysql.com/doc/refman/8.0/en/index-btree-hash.html
B-Tree Index Characteristics Hash Index Characteristics B-Tree Index Characteristics A B-tree index can be used for column comparisons in expressions that use the =, >, >=, <, <=, or BETWEEN operators. The index also can be used for LIKE comparisons ... Understanding the B-tree and hash data structures can help predict how different queries perform on different storage engines that use these data structures in their indexes, particularly for the MEMORY storage engine that lets you choose B-tree or hash ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-general-table-reference.html
The following table summarizes INFORMATION_SCHEMA general tables. For greater detail, see the individual table descriptions. Table 28.2 INFORMATION_SCHEMA General Tables Table Name Description Introduced Deprecated ADMINISTRABLE_ROLE_AUTHORIZATIONS ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-statistics-table.html
That is, the number of indexed characters if the column is only partly indexed, NULL if the entire column is indexed. However, prefix lengths for index specifications in CREATE TABLE, ALTER TABLE, and CREATE INDEX statements are interpreted as ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-table-reference.html
The following table summarizes all available INFORMATION_SCHEMA tables. For greater detail, see the individual table descriptions. Table 28.1 INFORMATION_SCHEMA Tables Table Name Description Introduced Deprecated ADMINISTRABLE_ROLE_AUTHORIZATIONS ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-moving-data-files-offline.html
When moving tablespace files to a different operating system, ensure that tablespace file names do not include prohibited characters or characters with a special meaning on the destination system. Quotes are used around the argument value because a ... The innodb_directories variable, which defines directories to scan at startup for tablespace files, supports moving or restoring tablespace files to a new location while the server is ...