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
To empty an undo tablespace, the undo tablespace must first be marked as inactive using ALTER UNDO TABLESPACE syntax so that the tablespace is no longer used for assigning rollback segments to new transactions. ALTER UNDO TABLESPACE tablespace_name ... 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/replication-binlog-encryption-key-rotation.html
When binary log encryption is enabled, you can rotate the binary log master key at any time while the server is running by issuing ALTER INSTANCE ROTATE BINLOG MASTER KEY. The BINLOG_ENCRYPTION_ADMIN privilege is required to issue ALTER INSTANCE ...
https://dev.mysql.com/doc/refman/8.0/en/stored-programs-logging.html
To create or alter a stored function, you must have the SET_USER_ID privilege (or the deprecated SUPER privilege), in addition to the CREATE ROUTINE or ALTER ROUTINE privilege that is normally required. The server writes CREATE EVENT, CREATE ... The ...
https://dev.mysql.com/doc/refman/8.0/en/atomic-ddl.html
Supported table DDL statements include CREATE, ALTER, and DROP statements for databases, tablespaces, tables, and indexes, and the TRUNCATE TABLE statement. Supported non-table DDL statements include: CREATE and DROP statements, and, if applicable, ...An atomic DDL statement combines the data dictionary updates, storage engine operations, and binary log writes associated with a DDL operation into a single, atomic ...
https://dev.mysql.com/doc/refman/8.0/en/create-table-gipks.html
When GIPKs are enabled, a generated primary key cannot be altered other than to switch it between VISIBLE and INVISIBLE. To make the generated invisible primary key on auto_1 visible, execute this ALTER TABLE statement: mysql> ALTER TABLE auto_1 ...
https://dev.mysql.com/doc/refman/8.0/en/grant-tables.html
To assign a plugin to an account that is missing one, use the ALTER USER statement. The default password_expired value is 'N', but can be set to 'Y' with the ALTER USER statement. After an account's password has been expired, all operations ... The ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-page-compression.html
Page compression is enabled by specifying the COMPRESSION attribute with CREATE TABLE or ALTER TABLE. For example: CREATE TABLE t1 (c1 INT) COMPRESSION="zlib"; You can also enable page compression in an ALTER TABLE statement. ALTER TABLE t1 ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-tablespace-autoextend-size.html
ALTER TABLESPACE cannot be used to configure the AUTOEXTEND_SIZE of a file-per-table tablespace. By default, when a file-per-table or general tablespace requires additional space, the tablespace is extended incrementally according to the following ...
https://dev.mysql.com/doc/refman/8.0/en/log-destinations.html
CREATE TABLE, ALTER TABLE, and DROP TABLE are valid operations on a log table. For ALTER TABLE and DROP TABLE, the log table cannot be in use and must be disabled, as described later. The log tables can be altered to use the MyISAM storage engine.
https://dev.mysql.com/doc/refman/8.0/en/partitioning-limitations-storage-engines.html
CREATE TABLE and ALTER TABLE statements that would cause a user-partitioned NDB table not to meet either or both of the following two requirements are not permitted, and fail with an error: The table must have an explicit primary key. Partitioned ...