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/sys-schema-tables-with-full-table-scans.html
These views display which tables are being accessed with full table scans. The schema_tables_with_full_table_scans and x$schema_tables_with_full_table_scans views have these columns: object_schema The schema name. rows_full_scanned The total number ...
https://dev.mysql.com/doc/refman/8.0/en/partitioning-maintenance.html
A number of table and partition maintenance tasks can be carried out on partitioned tables using SQL statements intended for such purposes. Table maintenance of partitioned tables can be accomplished using the statements CHECK TABLE, OPTIMIZE ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-check-constraints-table.html
As of MySQL 8.0.16, CREATE TABLE permits the core features of table and column CHECK constraints, and the CHECK_CONSTRAINTS table provides information about these constraints. The CHECK_CONSTRAINTS table has these columns: CONSTRAINT_CATALOG The ...
https://dev.mysql.com/doc/refman/8.0/en/partitioning-management.html
Note All partitions of a partitioned table must have the same number of subpartitions; it is not possible to change the subpartitioning once the table has been created. To change a table's partitioning scheme, it is necessary only to use the ALTER ... There are a number of ways using SQL statements to modify partitioned tables; it is possible to add, drop, redefine, merge, or split existing partitions using the partitioning extensions to the ALTER TABLE ...
https://dev.mysql.com/doc/refman/8.0/en/full-table.html
If a table-full error occurs, it may be that the disk is full or that the table has reached its maximum size. The effective maximum table size for MySQL databases is usually determined by operating system constraints on file sizes, not by MySQL ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-keywords-table.html
The KEYWORDS table lists the words considered keywords by MySQL and, for each one, indicates whether it is reserved. This table provides applications a runtime source of MySQL keyword information. Prior to MySQL 8.0.13, selecting from the KEYWORDS ...Reserved keywords may require special treatment in some contexts, such as special quoting when used as identifiers (see Section 11.3, “Keywords and Reserved ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-schema-privileges-table.html
The SCHEMA_PRIVILEGES table has these columns: GRANTEE The name of the account to which the privilege is granted, in 'user_name'@'host_name' format. TABLE_CATALOG The name of the catalog to which the schema belongs. IS_GRANTABLE YES if the user has ...The value can be any privilege that can be granted at the schema level; see Section 15.7.1.6, “GRANT ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-schemata-extensions-table.html
The SCHEMATA_EXTENSIONS table (available as of MySQL 8.0.22) augments the SCHEMATA table with information about schema options. The SCHEMATA_EXTENSIONS table has these columns: CATALOG_NAME The name of the catalog to which the schema belongs. If ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-tablespaces-table.html
Other INFORMATION_SCHEMA tables may provide related information: For NDB, the INFORMATION_SCHEMA FILES table provides tablespace-related information. For InnoDB, the INFORMATION_SCHEMA INNODB_TABLESPACES and INNODB_DATAFILES tables provide ...It is ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-user-privileges-table.html
The USER_PRIVILEGES table has these columns: GRANTEE The name of the account to which the privilege is granted, in 'user_name'@'host_name' format. IS_GRANTABLE YES if the user has the GRANT OPTION privilege, NO otherwise. The value can be any ...