PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.2Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/information-schema-innodb-sys-foreign-table.html
row *************************** ID: test/fk1 FOR_NAME: test/child REF_NAME: test/parent N_COLS: 1 TYPE: 1 Notes You must have the PROCESS privilege to query this table. The INNODB_SYS_FOREIGN table provides metadata about InnoDB foreign keys, ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-innodb-sys-indexes-table.html
row *************************** INDEX_ID: 40 NAME: i1 TABLE_ID: 34 TYPE: 0 N_FIELDS: 1 PAGE_NO: 4 SPACE: 23 MERGE_THRESHOLD: 50 Notes You must have the PROCESS privilege to query this table. The INNODB_SYS_INDEXES table provides metadata about ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-innodb-sys-tables-table.html
row *************************** TABLE_ID: 214 NAME: test/t1 FLAG: 129 N_COLS: 4 SPACE: 233 FILE_FORMAT: Antelope ROW_FORMAT: Compact ZIP_PAGE_SIZE: 0 SPACE_TYPE: General Notes You must have the PROCESS privilege to query this table. The ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-innodb-sys-tablespaces-table.html
row *************************** SPACE: 26 NAME: test/t1 FLAG: 0 FILE_FORMAT: Antelope ROW_FORMAT: Compact or Redundant PAGE_SIZE: 16384 ZIP_PAGE_SIZE: 0 SPACE_TYPE: Single FS_BLOCK_SIZE: 4096 FILE_SIZE: 98304 ALLOCATED_SIZE: 65536 Notes You must ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-innodb-sys-virtual-table.html
The INNODB_SYS_VIRTUAL table provides metadata about InnoDB virtual generated columns and columns upon which virtual generated columns are based, equivalent to information in the SYS_VIRTUAL table in the InnoDB data dictionary. A row appears in the ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-innodb-temp-table-info-table.html
The INNODB_TEMP_TABLE_INFO table provides information about user-created InnoDB temporary tables that are active in an InnoDB instance. It does not provide information about internal InnoDB temporary tables used by the optimizer. The ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-innodb-trx-table.html
The INNODB_TRX table provides information about every transaction currently executing inside InnoDB, including whether the transaction is waiting for a lock, when the transaction started, and the SQL statement the transaction is executing, if any.
https://dev.mysql.com/doc/refman/5.7/en/information-schema-routines-table.html
If you do not have privileges for the routine itself, the value displayed for the ROUTINE_DEFINITION column is NULL. The ROUTINES table provides information about stored routines (stored procedures and stored functions). The ROUTINES table does not ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-triggers-table.html
To see information about a table's triggers, you must have the TRIGGER privilege for the table. The TRIGGERS table has these columns: TRIGGER_CATALOG The name of the catalog to which the trigger belongs. TRIGGER_SCHEMA The name of the schema ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-views-table.html
You must have the SHOW VIEW privilege to access this table. The VIEWS table has these columns: TABLE_CATALOG The name of the catalog to which the view belongs. TABLE_SCHEMA The name of the schema (database) to which the view belongs. VIEW_DEFINITION ...