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/mysql-cluster-online-operations.html
For more information, see Section 25.6.7, “Adding NDB Cluster Data Nodes Online”. Columns to be added online cannot use the BLOB or TEXT type, and must meet the following criteria: The columns must be dynamic; that is, it must be possible to ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-upgrade-downgrade.html
Versions Supported for Upgrade to NDB 8.0 Reverting an NDB Cluster 8.0 Upgrade Known Issues When Upgrading or Downgrading NDB Cluster This section provides information about NDB Cluster software and compatibility between different NDB Cluster 8.0 ...You should already be familiar with installing and configuring NDB Cluster prior to attempting an upgrade or ...
https://dev.mysql.com/doc/refman/8.0/en/optimizing-queries-myisam.html
The table uses dynamic row format if it includes even a single variable-length column. The only cases where splitting up a table makes an appreciable difference is if it is a MyISAM table using dynamic row format that you can change to a fixed row ... Some general tips for speeding up queries on MyISAM tables: To help MySQL better optimize queries, use ANALYZE TABLE or run myisamchk --analyze on a table after it has been loaded with ...
https://dev.mysql.com/doc/refman/8.0/en/pam-pluggable-authentication.html
For information about the mysql_clear_password plugin, see Section 8.4.1.4, “Client-Side Cleartext Pluggable Authentication”. The PAM plugin uses the information passed to it by MySQL Server (such as user name, host name, password, and ... Note ...
https://dev.mysql.com/doc/refman/8.0/en/populating-spatial-columns.html
Values should be stored in internal geometry format, but you can convert them to that format from either Well-Known Text (WKT) or Well-Known Binary (WKB) format. After you have created spatial columns, you can populate them with spatial data. For ...
https://dev.mysql.com/doc/refman/8.0/en/precision-math-decimal-characteristics.html
This section discusses the characteristics of the DECIMAL data type (and its synonyms), with particular regard to the following topics: Maximum number of digits Storage format Storage requirements The nonstandard MySQL extension to the upper range ...The ranges of values for the arguments are as follows: M is the maximum number of digits (the ...
https://dev.mysql.com/doc/refman/8.0/en/replication-features-transactions.html
Note A mixed statement is unrelated to mixed binary logging format. The binlog_format and binlog_checksum system variables are read-only as long as a transaction is in progress. In general, you should avoid transactions that update both ...
https://dev.mysql.com/doc/refman/8.0/en/replication-features-variables.html
sql_mode is also replicated except for the NO_DIR_IN_CREATE mode; the replica always preserves its own value for NO_DIR_IN_CREATE, regardless of changes to it on the source. However, when mysqlbinlog parses a SET @@sql_mode = mode statement, the ...
https://dev.mysql.com/doc/refman/8.0/en/select-into.html
Column and line terminators can be specified to produce a specific output format. INTO DUMPFILE writes a single row to a file without any formatting. For more detailed information about the FIELDS and LINES clauses, including their default values ...
https://dev.mysql.com/doc/refman/8.0/en/show-create-table.html
For example, when changing the storage engine from InnoDB to MyISAM, options specific to InnoDB, such as ROW_FORMAT=COMPACT, are retained, as shown here: mysql> CREATE TABLE t1 (c1 INT PRIMARY KEY) ROW_FORMAT=COMPACT ENGINE=InnoDB; mysql> ALTER ...