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-column-privileges-table.html
In the output from SHOW FULL COLUMNS, the privileges are all in one column and in lowercase, for example, select,insert,update,references. The COLUMN_PRIVILEGES table has these columns: GRANTEE The name of the account to which the privilege is ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-columns-table.html
Unlike SHOW COLUMNS, SELECT from the COLUMNS table does not have automatic ordering. The related ST_GEOMETRY_COLUMNS table provides information about table columns that store spatial data. The COLUMNS table has these columns: TABLE_CATALOG The name ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-innodb-cached-indexes-table.html
Examples This query returns the number of index pages cached in the InnoDB buffer pool for a specific index: mysql> SELECT * FROM INFORMATION_SCHEMA.INNODB_CACHED_INDEXES WHERE INDEX_ID=65\G *************************** 1. SELECT tables.NAME AS ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-innodb-tablespaces-table.html
The undo tablespace was either selected by the purge thread implicitly or was made inactive by an ALTER UNDO TABLESPACE ... Example mysql> SELECT * FROM INFORMATION_SCHEMA.INNODB_TABLESPACES WHERE SPACE = 26\G *************************** 1. The ...
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/information-schema-schemata-extensions-table.html
The SCHEMATA_EXTENSIONS table (available as of MySQL 8.0.22) augments the SCHEMATA table with information about schema options. The SCHEMATA_EXTENSIONS table has these columns: CATALOG_NAME The name of the catalog to which the schema belongs. If ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-st-spatial-reference-systems-table.html
Example mysql> SELECT * FROM ST_SPATIAL_REFERENCE_SYSTEMS WHERE SRS_ID = 4326\G *************************** 1. The ST_SPATIAL_REFERENCE_SYSTEMS table provides information about available spatial reference systems (SRSs) for spatial data. Entries in ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-tp-thread-group-state-table.html
For example, if an application uses this query: SELECT * FROM INFORMATION_SCHEMA.TP_THREAD_GROUP_STATE; The application should use this query instead: SELECT * FROM performance_schema.tp_thread_group_state; The TP_THREAD_GROUP_STATE table has one ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-tp-thread-group-stats-table.html
For example, if an application uses this query: SELECT * FROM INFORMATION_SCHEMA.TP_THREAD_GROUP_STATS; The application should use this query instead: SELECT * FROM performance_schema.tp_thread_group_stats; The TP_THREAD_GROUP_STATS table reports ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-tp-thread-state-table.html
For example, if an application uses this query: SELECT * FROM INFORMATION_SCHEMA.TP_THREAD_STATE; The application should use this query instead: SELECT * FROM performance_schema.tp_thread_state; The TP_THREAD_STATE table has one row per thread ...