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-metrics-table.html
The INNODB_METRICS table provides a wide variety of InnoDB performance information, complementing the specific focus areas of the Performance Schema tables for InnoDB. With simple queries, you can check the overall health of the system. With more ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-innodb-session-temp-tablespaces-table.html
The INNODB_SESSION_TEMP_TABLESPACES table provides metadata about session temporary tablespaces used for internal and user-created temporary tables. The INNODB_SESSION_TEMP_TABLESPACES table has these columns: ID The process or session ID. A range ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-innodb-tables-table.html
Example mysql> SELECT * FROM INFORMATION_SCHEMA.INNODB_TABLES WHERE TABLE_ID = 214\G *************************** 1. For related usage information and examples, see Section 17.15.3, “InnoDB INFORMATION_SCHEMA Schema Object Tables”. The ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-innodb-tablespaces-brief-table.html
Example mysql> SELECT * FROM INFORMATION_SCHEMA.INNODB_TABLESPACES_BRIEF WHERE SPACE = 7; +-------+---------+---------------+-------+------------+ | SPACE | NAME | PATH | FLAG | SPACE_TYPE | +-------+---------+---------------+-------+------------+ | ... The INNODB_TABLESPACES_BRIEF table provides space ID, name, path, flag, and space type metadata for file-per-table, general, undo, and system ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-innodb-tablestats-table.html
Example mysql> SELECT * FROM INFORMATION_SCHEMA.INNODB_TABLESTATS where TABLE_ID = 71\G *************************** 1. The INNODB_TABLESTATS table provides a view of low-level status information about InnoDB tables. This data is used by the MySQL ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-innodb-temp-table-info-table.html
Example mysql> CREATE TEMPORARY TABLE t1 (c1 INT PRIMARY KEY) ENGINE=INNODB; mysql> SELECT * FROM INFORMATION_SCHEMA.INNODB_TEMP_TABLE_INFO\G *************************** 1. The INNODB_TEMP_TABLE_INFO table provides information about user-created ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-partitions-table.html
Each row in this table corresponds to an individual partition or subpartition of a partitioned table. The PARTITIONS table has these columns: TABLE_CATALOG The name of the catalog to which the table belongs. TABLE_SCHEMA The name of the schema ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-plugins-table.html
These statements are equivalent: SELECT PLUGIN_NAME, PLUGIN_STATUS, PLUGIN_TYPE, PLUGIN_LIBRARY, PLUGIN_LICENSE FROM INFORMATION_SCHEMA.PLUGINS; SHOW PLUGINS; . The PLUGINS table has these columns: PLUGIN_NAME The name used to refer to the plugin in ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-profiling-table.html
For example, the following queries are equivalent: SHOW PROFILE FOR QUERY 2; SELECT STATE, FORMAT(DURATION, 6) AS DURATION FROM INFORMATION_SCHEMA.PROFILING WHERE QUERY_ID = 2 ORDER BY SEQ; . Its contents correspond to the information produced by ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-routines-table.html
Notes To see information about a routine, you must be the user named as the routine DEFINER, have the SHOW_ROUTINE privilege, have the SELECT privilege at the global level, or have the CREATE ROUTINE, ALTER ROUTINE, or EXECUTE privilege granted at a ... The ROUTINES table provides information about stored routines (stored procedures and stored ...