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/information-schema-table-constraints-table.html
The TABLE_CONSTRAINTS table has these columns: CONSTRAINT_CATALOG The name of the catalog to which the constraint belongs. TABLE_SCHEMA The name of the schema (database) to which the table belongs. CONSTRAINT_SCHEMA The name of the schema (database) ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-innodb-ft-config-table.html
use_stopword: Indicates whether a stopword table is used, which is defined when the FULLTEXT index is created. The INNODB_FT_CONFIG table provides metadata about the FULLTEXT index and associated processing for an InnoDB table. Before querying it, ...The values for this column might change, depending on the needs for performance tuning and debugging for InnoDB full-text ...
https://dev.mysql.com/doc/refman/8.0/en/alter-database.html
Encryption Option The ENCRYPTION option, introduced in MySQL 8.0.16, defines the default database encryption, which is inherited by tables created in the database. It is not possible to create any other tables in it. TEMPORARY tables; it is possible ...A stored routine that uses the database defaults when the routine is created includes those defaults as part of its ...alter_option: { [DEFAULT] CHARACTER SET [=] charset_name | [DEFAULT] COLLATE [=] collation_name | [DEFAULT] ENCRYPTION [=] {'Y' ...
https://dev.mysql.com/doc/refman/8.0/en/upgrade-prerequisites.html
Triggers must not have a missing or empty definer or an invalid creation context (indicated by the character_set_client, collation_connection, Database Collation attributes displayed by SHOW TRIGGERS or the INFORMATION_SCHEMA TRIGGERS table). To ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-information-schema-metrics-table.html
Create a simple InnoDB table: mysql> USE test; Database changed mysql> CREATE TABLE t1 (c1 INT) ENGINE=INNODB; Query OK, 0 rows affected (0.02 sec) Enable the dml_inserts counter. The INNODB_METRICS table provides information about InnoDB ...SET ...
https://dev.mysql.com/doc/refman/8.0/en/cost-model.html
The primary key for the server_cost table is the cost_name column, so it is not possible to create multiple entries for any cost estimate. The server recognizes these cost_name values for the server_cost table: disk_temptable_create_cost, ...These ... To generate execution plans, the optimizer uses a cost model that is based on estimates of the cost of various operations that occur during query ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-events-transactions-current-table.html
The table stores one row per thread showing the current status of the thread's most recent monitored transaction event, so there is no system variable for configuring the table size. Other tables that contain transaction event rows are logically ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-processlist-table.html
For a comparison of this table with other sources, see Sources of Process Information. Note If the performance_schema_show_processlist system variable is enabled, the processlist table also serves as the basis for an alternative implementation ...
https://dev.mysql.com/doc/refman/8.0/en/data-size.html
Row Format InnoDB tables are created using the DYNAMIC row format by default. To use a row format other than DYNAMIC, configure innodb_default_row_format, or specify the ROW_FORMAT option explicitly in a CREATE TABLE or ALTER TABLE statement. To ...
https://dev.mysql.com/doc/refman/8.0/en/json-table-functions.html
This is equivalent to specifying a column as AUTO_INCREMENT in a CREATE TABLE statement, and can be used to distinguish parent rows with the same value for multiple rows generated by a NESTED [PATH] clause. JSON_TABLE(expr, path COLUMNS ... This ...