PDF (US Ltr)
- 43.2Mb
PDF (A4)
- 43.3Mb
Man Pages (TGZ)
- 295.2Kb
Man Pages (Zip)
- 400.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/innodb-undo-tablespaces.html
Default undo tablespaces are created at initialization time to provide a location for rollback segments that must exist before SQL statements can be accepted. Default undo tablespaces are created in the location defined by the innodb_undo_directory ... Undo tablespaces contain undo logs, which are collections of records containing information about how to undo the latest change by a transaction to a clustered index ...
https://dev.mysql.com/doc/refman/8.0/en/partitioning-columns-range.html
However, the order of the column names in the partitioning column list and the value lists does not have to be the same as the order of the table column definitions in the main part of the CREATE TABLE statement. In addition, changing the character ... Range columns partitioning is similar to range partitioning, but enables you to define partitions using ranges based on multiple column ...
https://dev.mysql.com/doc/refman/8.0/en/ansi-diff-comments.html
MySQL Server supports a variant of the -- comment style; the -- start-comment sequence is accepted as such, but must be followed by a whitespace character such as a space or newline. To keep this from happening, MySQL requires a whitespace character ... Standard SQL uses the C syntax /* this is a comment */ for comments, and MySQL Server supports this syntax as ...
https://dev.mysql.com/doc/refman/8.0/en/charset-gb18030.html
If an incoming sequence is illegal, an error or warning is returned. If an illegal sequence is used in CONVERT(), an error is returned. The character set determines the length of a sequence using the first 1 or 2 bytes. In MySQL, the gb18030 ...
https://dev.mysql.com/doc/refman/8.0/en/error-log-rule-based-filtering.html
The log_filter_dragnet log filter component enables log filtering based on user-defined rules. To enable the log_filter_dragnet filter, first load the filter component, then modify the log_error_services value. The following example enables ...
https://dev.mysql.com/doc/refman/8.0/en/numeric-type-attributes.html
When you insert a value of NULL into an indexed AUTO_INCREMENT column, the column is set to the next sequence value. (AUTO_INCREMENT sequences begin with 1.) Storing 0 into an AUTO_INCREMENT column has the same effect as storing NULL, unless the ...
https://dev.mysql.com/doc/refman/8.0/en/password-management.html
To establish policy for individual accounts, use the PASSWORD EXPIRE option of the CREATE USER and ALTER USER statements. See Section 15.7.1.3, “CREATE USER Statement”, and Section 15.7.1.1, “ALTER USER Statement”. Example account-specific ... MySQL supports these password-management capabilities: Password expiration, to require passwords to be changed ...
https://dev.mysql.com/doc/refman/8.0/en/enterprise-encryption-installation.html
In releases before MySQL 8.0.30, the functions provided by MySQL Enterprise Encryption are installed by creating them individually, based on the openssl_udf shared library. If you are upgrading to MySQL 8.0.30 from an earlier release where you used ...From MySQL 8.0.30, the functions are provided by a MySQL component component_enterprise_encryption, and installing the component installs all of the ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-table-import.html
Otherwise, the table must be created on the same MySQL server instance into which it is being imported. If the table was created in an external directory by specifying the DATA DIRECTORY clause in the CREATE TABLE statement, the table that you ...
https://dev.mysql.com/doc/refman/8.0/en/keyring-aws-plugin.html
To configure keyring_aws, you must obtain a secret access key that provides credentials for communicating with AWS KMS and write it to a configuration file: Create an AWS KMS account. Use AWS KMS to create a secret access key ID and secret access ...