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-parameters.html
innodb_background_drop_list_empty Command-Line Format --innodb-background-drop-list-empty[={OFF|ON}] System Variable innodb_background_drop_list_empty Scope Global Dynamic Yes SET_VAR Hint Applies No Type Boolean Default Value OFF Enabling the ...In ... InnoDB Startup Options InnoDB System Variables System variables that are true or false can be enabled at server startup by naming them, or disabled by using a --skip- ...
https://dev.mysql.com/doc/refman/8.0/en/create-table-check-constraints.html
Prior to MySQL 8.0.16, CREATE TABLE permits only the following limited version of table CHECK constraint syntax, which is parsed and ignored: CHECK (expr) As of MySQL 8.0.16, CREATE TABLE permits the core features of table and column CHECK ...If ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-what-is-new.html
It is also no longer possible to issue a CREATE TABLE statement that refers to a nonexistent tablespace. This means that NDB tables created in NDB Cluster 8.0 are not compatible with previous NDB Cluster releases. Tables created in previous releases ...NDB 8.0 removes the previous 63-byte limit on identifiers for databases and ... The following sections describe changes in the implementation of MySQL ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-programs-ndb-restore.html
Such an index is created only when necessary to apply events from the backup log to a table which has an extended primary key. This index is named NDB$RESTORE_PK_MAPPING, and is created on each table requiring it; it can be shared, if necessary, by ...This program reads the files created as a result of the backup and inserts the stored information into the ... The NDB Cluster restoration program is ...
https://dev.mysql.com/doc/refman/8.0/en/create-table-secondary-indexes.html
A secondary index may be created on one or more virtual columns or on a combination of virtual columns and regular columns or stored generated columns. When a secondary index is created on a virtual generated column, generated column values are ...A ...
https://dev.mysql.com/doc/refman/8.0/en/mysqldump.html
To work around this issue, use the --result-file option, which creates the output in ASCII format: mysqldump [options] --result-file=dump.sql It is not recommended to load a dump file when GTIDs are enabled on the server (gtid_mode=ON), if your dump ... The mysqldump client utility performs logical backups, producing a set of SQL statements that can be executed to reproduce the original database object definitions and table ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-tables-table.html
Prior to MySQL 8.0.16, CREATE_OPTIONS shows the ENCRYPTION clause specified for tables created in file-per-table tablespaces. The encryption clause is not shown for tables created in general tablespaces. When creating a table with strict mode ...The ...To always retrieve the latest statistics directly from storage engines, set information_schema_stats_expiry ...
https://dev.mysql.com/doc/refman/8.0/en/grant-tables.html
This change of grant table storage engine enables an accompanying change to the behavior of account-management statements such as CREATE USER or GRANT. For example, the 'root'@'localhost' account created during MySQL installation has a row in the ...
https://dev.mysql.com/doc/refman/8.0/en/partitioning-management-exchange.html
In addition to the ALTER, INSERT, and CREATE privileges usually required for ALTER TABLE statements, you must have the DROP privilege to perform ALTER TABLE ... In addition, both tables must use the same storage engine: mysql> CREATE TABLE es3 LIKE ...Table nt contains no foreign key references, and no other table has any foreign keys that refer to ...
https://dev.mysql.com/doc/refman/8.0/en/creating-accounts.html
To manage MySQL accounts, use the SQL statements intended for that purpose: CREATE USER and DROP USER create and remove accounts. Account-management statements cause the server to make appropriate modifications to the underlying grant tables, which ...GRANT and REVOKE assign privileges to and revoke privileges from ...