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/copying-databases.html
In cases where you need to transfer databases between different architectures, you can use mysqldump to create a file containing SQL statements. You can then transfer the file to the other machine and feed it as input to the mysql client. Note If ...
https://dev.mysql.com/doc/refman/8.0/en/create-table-ndb-comment-options.html
It does not indicate the number of characters, which varies according to the character set and collation used by the column. NDB_COLUMN Options NDB_TABLE Options It is possible to set a number of options specific to NDB Cluster in the table comment ...
https://dev.mysql.com/doc/refman/8.0/en/dynamic-system-variables.html
Many server system variables are dynamic and can be set at runtime. For a description of the privilege requirements for setting system variables, see Section 7.1.9.1, “System Variable Privileges” The following table lists all dynamic system ...
https://dev.mysql.com/doc/refman/8.0/en/error-interfaces.html
Error messages can originate on the server side or the client side, and each error message includes an error code, SQLSTATE value, and message string, as described in Section B.1, “Error Message Sources and Elements”. For lists of server-side, ...
https://dev.mysql.com/doc/refman/8.0/en/error-message-elements.html
These elements have the following characteristics: Error code: This value is numeric. SQLSTATE value: This value is a five-character string (for example, '42S02'). The first two characters of an SQLSTATE value indicate the error class: Class = '00' ... This section discusses how error messages originate within MySQL and the elements they ...
https://dev.mysql.com/doc/refman/8.0/en/function-resolution.html
MySQL supports built-in (native) functions, loadable functions, and stored functions. This section describes how the server recognizes whether the name of a built-in function is used as a function call or as an identifier, and how the server ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-view-changes.html
When Group Replication's distributed recovery process is carrying out state transfer from the binary log, to synchronize the joining member with the donor up to a specific point in time, the joining member and donor make use of GTIDs (see Section ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-tables-table.html
The output does not explicitly list the table default character set, but the collation name begins with the character set name. The information_schema_stats_expiry system variable defines the period of time before cached table statistics expire. If ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-compression-internals.html
The compression of B-tree nodes (of both clustered and secondary indexes) is handled differently from compression of overflow pages used to store long VARCHAR, BLOB, or TEXT columns, as explained in the following sections. Compressing BLOB, VARCHAR, ... This section describes some internal implementation details about compression for InnoDB ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-consistent-read.html
A consistent read means that InnoDB uses multi-versioning to present to a query a snapshot of the database at a point in time. The query sees the changes made by transactions that committed before that point in time, and no changes made by later or ...