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/extensions-to-ansi.html
See Section 15.1.12, “CREATE DATABASE Statement”, Section 15.1.24, “DROP DATABASE Statement”, and Section 15.1.2, “ALTER DATABASE Statement”. Use of CHANGE col_name, DROP col_name, or DROP INDEX, IGNORE or RENAME in ALTER TABLE ... MySQL ...
https://dev.mysql.com/doc/refman/8.0/en/index-page-merge-threshold.html
If the “page-full” percentage for an index page falls below the MERGE_THRESHOLD value when a row is deleted or when a row is shortened by an UPDATE operation, InnoDB attempts to merge the index page with a neighboring index page. The default ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-files-table.html
For NDB: The name of an undo log file created by CREATE LOGFILE GROUP or ALTER LOGFILE GROUP, or of a data file created by CREATE TABLESPACE or ALTER TABLESPACE. This means, for example, that the name of a data file created with ALTER TABLESPACE ts ... The FILES table provides information about the files in which MySQL tablespace data is ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-file-defragmenting.html
To speed up index scans, you can periodically perform a “null” ALTER TABLE operation, which causes MySQL to rebuild the table: ALTER TABLE tbl_name ENGINE=INNODB You can also use ALTER TABLE tbl_name FORCE to perform a “null” alter operation ... Random insertions into or deletions from a secondary index can cause the index to become ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-online-ddl-performance.html
Transactions started before or during the DDL operation can hold metadata locks on the table being altered. Session 2: mysql> ALTER TABLE t1 ADD COLUMN x INT, ALGORITHM=INPLACE, LOCK=NONE; The online DDL operation in session 2, which requires an ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-online-ddl.html
The online DDL feature provides support for instant and in-place table alterations and concurrent DML. You can control aspects of a DDL operation using the ALGORITHM and LOCK clauses of the ALTER TABLE statement. For example: ALTER TABLE tbl_name ...Benefits of this feature include: Improved responsiveness and availability in busy production environments, where making a table unavailable for minutes or hours is not ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-redo-log.html
Disabling Redo Logging As of MySQL 8.0.21, you can disable redo logging using the ALTER INSTANCE DISABLE INNODB REDO_LOG statement. An ALTER INSTANCE [ENABLE|DISABLE] INNODB REDO_LOG operation requires an exclusive backup metadata lock, which ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-row-format.html
To store DYNAMIC tables in the system tablespace, either disable innodb_file_per_table and use a regular CREATE TABLE or ALTER TABLE statement, or use the TABLESPACE [=] innodb_system table option with CREATE TABLE or ALTER TABLE. The row format of ... The row format of a table determines how its rows are physically stored, which in turn can affect the performance of queries and DML ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-install-example-data.html
To specify this, use the ENGINE=NDBCLUSTER or ENGINE=NDB option when creating the table: CREATE TABLE tbl_name (col_name column_definitions) ENGINE=NDBCLUSTER; Alternatively, for an existing table that uses a different storage engine, use ALTER ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-online-add-node-remarks.html
The ability to add new nodes online includes a means to reorganize NDBCLUSTER table data and indexes so that they are distributed across all data nodes, including the new ones, by means of the ALTER TABLE ... However, it is not possible to perform ... This section provides general information about the behavior of and current limitations in adding NDB Cluster nodes ...