PDF (US Ltr)
- 35.0Mb
PDF (A4)
- 35.1Mb
Man Pages (TGZ)
- 255.5Kb
Man Pages (Zip)
- 360.4Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/charset-table.html
Every table has a table character set and a table collation. The CREATE TABLE and ALTER TABLE statements have optional clauses for specifying the table character set and collation: CREATE TABLE tbl_name (column_list) [[DEFAULT] CHARACTER SET ...If ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-general-table-reference.html
The following table summarizes INFORMATION_SCHEMA general tables. For greater detail, see the individual table descriptions. Table 24.2 INFORMATION_SCHEMA General Tables Table Name Description CHARACTER_SETS Available character sets ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-innodb-sys-tablespaces-table.html
The INNODB_SYS_TABLESPACES table provides metadata about InnoDB file-per-table and general tablespaces, equivalent to the information in the SYS_TABLESPACES table in the InnoDB data dictionary. For related usage information and examples, see ...For ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-key-column-usage-table.html
The KEY_COLUMN_USAGE table has these columns: CONSTRAINT_CATALOG The name of the catalog to which the constraint belongs. TABLE_CATALOG The name of the catalog to which the table belongs. TABLE_SCHEMA The name of the schema (database) to which the ...CONSTRAINT_SCHEMA The name of the schema (database) to which the constraint ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-statistics-table.html
The STATISTICS table has these columns: TABLE_CATALOG The name of the catalog to which the table containing the index belongs. TABLE_SCHEMA The name of the schema (database) to which the table containing the index belongs. To update this number, run ...NON_UNIQUE 0 if the index cannot contain duplicates, 1 if it ...
https://dev.mysql.com/doc/refman/5.7/en/nontransactional-tables.html
If you receive the following message when trying to perform a ROLLBACK, it means that one or more of the tables you used in the transaction do not support transactions: Warning: Some non-transactional changed tables couldn't be rolled back These ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-events-stages-current-table.html
The table stores one row per thread showing the current status of the thread's most recent monitored stage event, so there is no system variable for configuring the table size. Of the tables that contain stage event rows, events_stages_current is ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-setup-actors-table.html
The setup_actors table contains information that determines whether to enable monitoring and historical event logging for new foreground server threads (threads associated with client connections). This table has a maximum size of 100 rows by ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-status-variable-summary-tables.html
Note The value of the show_compatibility_56 system variable affects the information available from the tables described here. The Performance Schema makes status variable information available in the tables described in Section 25.12.14, ...For ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-wait-tables.html
These tables store wait events: events_waits_current: The current wait event for each thread. There are also summary tables that aggregate information about wait events; see Section 25.12.15.1, “Wait Event Summary Tables”. For more information ... The Performance Schema instruments waits, which are events that take ...