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-general-info.html
Support for the NDB storage engine is not included in standard MySQL Server 8.0 binaries built by Oracle. NDB Cluster 8.0 users who build from source should use the sources provided for MySQL 8.0 and build with the options required to provide NDB ...
https://dev.mysql.com/doc/refman/8.0/en/replication-howto-additionalslaves.html
To do this, you can set up the new replica by copying the data directory of an existing replica, and giving the new replica a different server ID (which is user-specified) and server UUID (which is generated at startup). As an alternative to ... You ...
https://dev.mysql.com/doc/refman/8.0/en/resetting-permissions.html
If you know the root password and want to change it, see Section 15.7.1.1, “ALTER USER Statement”, and Section 15.7.1.10, “SET PASSWORD Statement”. The following sections provide instructions for Windows and Unix and Unix-like systems, as ...
https://dev.mysql.com/doc/refman/8.0/en/secure-client-programming.html
Handle External Data Properly Handle MySQL Error Messages Properly Handle External Data Properly Applications that access MySQL should not trust any data entered by users, who can try to trick your code by entering special or escaped character ...
https://dev.mysql.com/doc/refman/8.0/en/transport-protocols.html
For programs that use the MySQL client library (for example, mysql and mysqldump), MySQL supports connections to the server based on several transport protocols: TCP/IP, Unix socket file, named pipe, and shared memory. This section describes how to ...Otherwise, a connection to localhost results in a TCP/IP connection to ...
https://dev.mysql.com/doc/refman/8.0/en/char.html
The CHAR and VARCHAR types are similar, but differ in the way they are stored and retrieved. They also differ in maximum length and in whether trailing spaces are retained. The CHAR and VARCHAR types are declared with a length that indicates the ...
https://dev.mysql.com/doc/refman/8.0/en/charset-unicode-conversion.html
This section describes issues that you may face when converting character data between the utf8mb3 and utf8mb4 character sets. Note This discussion focuses primarily on converting between utf8mb3 and utf8mb4, but similar principles apply to ...One ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-compression-syntax-warnings.html
This section describes syntax warnings and errors that you may encounter when using the table compression feature with file-per-table tablespaces and general tablespaces. SQL Compression Syntax Warnings and Errors for File-Per-Table Tablespaces ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-setup-instruments-table.html
Events produced by the instrument have NULL for the TIMER_START, TIMER_END, and TIMER_WAIT timer values. This in turn causes those values to be ignored when calculating the sum, minimum, maximum, and average time values in summary tables. For ...row ... The setup_instruments table lists classes of instrumented objects for which events can be collected: mysql> SELECT * FROM performance_schema.setup_instruments\G ...
https://dev.mysql.com/doc/refman/8.0/en/data-type-defaults.html
See Section 13.2.5, “Automatic Initialization and Updating for TIMESTAMP and DATETIME”. The exception is that, for TIMESTAMP and DATETIME columns, you can specify CURRENT_TIMESTAMP as the default. See Section 13.2.5, “Automatic Initialization ...Some aspects of explicit DEFAULT clause handling are version dependent, as described ...