PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.3Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/information-schema-innodb-cmp-per-index-table.html
The INNODB_CMP_PER_INDEX and INNODB_CMP_PER_INDEX_RESET tables have these columns: DATABASE_NAME The schema (database) containing the applicable table. Use the INFORMATION_SCHEMA COLUMNS table or the SHOW COLUMNS statement to view additional ... The ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-introduction.html
INFORMATION_SCHEMA provides access to database metadata, information about the MySQL server such as the name of a database or table, the data type of a column, or access privileges. Although you can select INFORMATION_SCHEMA as the default database ...Other terms that are sometimes used for this information are data dictionary and system ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-profiling-table.html
Use the Performance Schema instead; see Section 25.19.1, “Query Profiling Using Performance Schema”. For example, the following queries are equivalent: SHOW PROFILE FOR QUERY 2; SELECT STATE, FORMAT(DURATION, 6) AS DURATION FROM ...Its contents ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-referential-constraints-table.html
CONSTRAINT_SCHEMA The name of the schema (database) to which the constraint belongs. UNIQUE_CONSTRAINT_SCHEMA The name of the schema (database) containing the unique constraint that the constraint references. The REFERENTIAL_CONSTRAINTS table has ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-table-constraints-table.html
CONSTRAINT_SCHEMA The name of the schema (database) to which the constraint belongs. TABLE_SCHEMA The name of the schema (database) to which the table belongs. The TABLE_CONSTRAINTS table has these columns: CONSTRAINT_CATALOG The name of the catalog ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-table-reference.html
The following table summarizes all available INFORMATION_SCHEMA tables. For greater detail, see the individual table descriptions. Table 24.1 INFORMATION_SCHEMA Tables Table Name Description Introduced Deprecated CHARACTER_SETS Available character ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-triggers-table.html
TRIGGER_SCHEMA The name of the schema (database) to which the trigger belongs. EVENT_OBJECT_CATALOG, EVENT_OBJECT_SCHEMA, and EVENT_OBJECT_TABLE As noted in Section 23.3, “Using Triggers”, every trigger is associated with exactly one table. To ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-information-schema-files-table.html
The Information Schema FILES table provides metadata about all InnoDB tablespace types including file-per-table tablespaces, general tablespaces, the system tablespace, temporary table tablespaces, and undo tablespaces (if present). This query ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-accounts-table.html
To set the table size explicitly, set the performance_schema_accounts_size system variable at server startup. For a description of how the Performance Schema maintains rows in this table, including the effect of TRUNCATE TABLE, see Section 25.12.8, ... The accounts table contains a row for each account that has connected to the MySQL ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-events-statements-history-long-table.html
To set the table size explicitly, set the performance_schema_events_statements_history_long_size system variable at server startup. For more information about the relationship between the three events_statements_xxx event tables, see Section 25.9, ... The events_statements_history_long table contains the N most recent statement events that have ended globally, across all ...