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/merge-storage-engine.html
An alternative to a MERGE table is a partitioned table, which stores partitions of a single table in separate files and enables some operations to be performed more efficiently. Use ALTER TABLE tbl_name UNION=(...) to change the list of underlying ... The MERGE storage engine, also known as the MRG_MyISAM engine, is a collection of identical MyISAM tables that can be used as ...
https://dev.mysql.com/doc/refman/8.0/en/grant.html
(Alternatively, if you have the UPDATE privilege for the grant tables in the mysql system schema, you can grant any account any privilege.) When the read_only system variable is enabled, GRANT additionally requires the CONNECTION_ADMIN privilege (or ...ALTER USER may be used to change the nonprivilege characteristics of existing ...[WITH ...
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, ...In earlier MySQL versions, metadata was stored in metadata files, nontransactional tables, and storage engine-specific dictionaries, which necessitated intermediate ...An ...
https://dev.mysql.com/doc/refman/8.0/en/repair-table.html
REPAIR PARTITION to repair one or more partitions; for more information, see Section 15.1.9, “ALTER TABLE Statement”, and Section 26.3.4, “Maintenance of Partitions”. [QUICK] [EXTENDED] [USE_FRM] REPAIR TABLE repairs a possibly corrupted ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-information-schema-system-tables.html
INSTANT_COLS shows number of columns in the table prior to adding the first instant column using ALTER TABLE ... The HAS_DEFAULT and DEFAULT_VALUE columns only apply to columns added instantly using ALTER TABLE ... You can extract metadata about ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-file-per-table-tablespaces.html
A table-copying ALTER TABLE operation on a table that resides in a shared tablespace can increase the amount of disk space occupied by the tablespace. A file-per-table tablespace contains data and indexes for a single InnoDB table, and is stored on ...Changing the setting at runtime requires privileges sufficient to set global system ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-table-wait-summary-tables.html
The following sections describe the table I/O and lock wait summary tables: table_io_waits_summary_by_index_usage: Table I/O waits per index table_io_waits_summary_by_table: Table I/O waits per table table_lock_waits_summary_by_table: Table lock ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-data-encryption.html
ALTER SCHEMA and ALTER TABLESPACE operations do not apply the default_table_encryption setting. An ENCRYPTION clause must be specified explicitly to alter the encryption of an existing schema or general tablespace. When ... InnoDB supports ...InnoDB ...
https://dev.mysql.com/doc/refman/8.0/en/rename-table.html
You must have ALTER and DROP privileges for the original table, and CREATE and INSERT privileges for the new table. RENAME TABLE tbl_name TO new_tbl_name [, tbl_name2 TO new_tbl_name2] ... As of MySQL 8.0.13, you can rename tables locked with a ...
https://dev.mysql.com/doc/refman/8.0/en/server-status-variables.html
| Connections | 30023 | | Created_tmp_disk_tables | 0 | | Created_tmp_files | 3 | | Created_tmp_tables | 2 | ... For additional connection-related information, check the Connection_errors_xxx status variables and the host_cache table. The MySQL ...