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-innodb-indexes-table.html
For related usage information and examples, see Section 17.15.3, “InnoDB INFORMATION_SCHEMA Schema Object Tables”. The INNODB_INDEXES table has these columns: INDEX_ID An identifier for the index. TABLE_ID An identifier representing the table ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-innodb-virtual-table.html
The INNODB_VIRTUAL table provides metadata about InnoDB virtual generated columns and columns upon which virtual generated columns are based. A row appears in the INNODB_VIRTUAL table for each column upon which a virtual generated column is based.
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-error-summary-tables.html
The Performance Schema maintains summary tables for aggregating statistical information about server errors (and warnings). Each error summary table has three columns that identify the error: ERROR_NUMBER is the numeric error value. For example, if ...For a list of server errors, see Server Error Message ...
https://dev.mysql.com/doc/refman/8.0/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/8.0/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/8.0/en/performance-schema-setup-instruments-table.html
The setup_instruments table lists classes of instrumented objects for which events can be collected: mysql> SELECT * FROM performance_schema.setup_instruments\G *************************** 1. row *************************** NAME: ...row ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-statement-tables.html
These tables store statement events: events_statements_current: The current statement event for each thread. prepared_statements_instances: Prepared statement instances and statistics The following sections describe the statement event tables. There ...Statement events occur at a high level of the event ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-table-constraints-extensions-table.html
The TABLE_CONSTRAINTS_EXTENSIONS table (available as of MySQL 8.0.21) provides information about table constraint attributes defined for primary and secondary storage engines. The TABLE_CONSTRAINTS_EXTENSIONS table has these columns: ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-view-table-usage-table.html
The VIEW_TABLE_USAGE table (available as of MySQL 8.0.13) provides access to information about tables and views used in view definitions. You can see information only for views for which you have some privilege, and only for tables for which you ...
https://dev.mysql.com/doc/refman/8.0/en/charset-table.html
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 charset_name] [COLLATE collation_name]] ALTER TABLE tbl_name ...If ...