Search Results
https://dev.mysql.com/doc/refman/8.4/en/identifier-case-sensitivity.html
The following statement would not work because it refers to a table both as my_table and as MY_TABLE: mysql> SELECT * FROM my_table WHERE MY_TABLE.col=1; Partition, subpartition, column, index, stored routine, event, and resource group names are not ... In MySQL, databases correspond to directories within the data ...
https://dev.mysql.com/doc/refman/8.4/en/index-merge-optimization.html
In EXPLAIN output, the Index Merge method appears as index_merge in the type column. In this case, the key column contains a list of indexes used, and key_len contains a list of the longest key parts for those indexes. If all columns used in the ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-innodb-buffer-pool-stats-table.html
The INNODB_BUFFER_POOL_STATS table has these columns: POOL_ID The buffer pool ID. Use the INFORMATION_SCHEMA COLUMNS table or the SHOW COLUMNS statement to view additional information about the columns of this table, including data types and default ... The INNODB_BUFFER_POOL_STATS table provides much of the same buffer pool information provided in SHOW ENGINE INNODB STATUS ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-innodb-cached-indexes-table.html
Use the INFORMATION_SCHEMA COLUMNS table or the SHOW COLUMNS statement to view additional information about the columns of this table, including data types and default values. The INNODB_CACHED_INDEXES table reports the number of index pages cached ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-innodb-cmp-table.html
The INNODB_CMP and INNODB_CMP_RESET tables have these columns: PAGE_SIZE The compressed page size in bytes. Use the INFORMATION_SCHEMA COLUMNS table or the SHOW COLUMNS statement to view additional information about the columns of this table, ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-innodb-datafiles-table.html
Use the INFORMATION_SCHEMA COLUMNS table or the SHOW COLUMNS statement to view additional information about the columns of this table, including data types and default values. The INNODB_DATAFILES table provides data file path information for ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-innodb-ft-default-stopword-table.html
The INNODB_FT_DEFAULT_STOPWORD table has these columns: value A word that is used by default as a stopword for FULLTEXT indexes on InnoDB tables. Use the INFORMATION_SCHEMA COLUMNS table or the SHOW COLUMNS statement to view additional information ... The INNODB_FT_DEFAULT_STOPWORD table holds a list of stopwords that are used by default when creating a FULLTEXT index on InnoDB ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-innodb-session-temp-tablespaces-table.html
The INNODB_SESSION_TEMP_TABLESPACES table has these columns: ID The process or session ID. Use the INFORMATION_SCHEMA COLUMNS table or the SHOW COLUMNS statement to view additional information about the columns of this table, including data types ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-innodb-tablespaces-brief-table.html
Use the INFORMATION_SCHEMA COLUMNS table or the SHOW COLUMNS statement to view additional information about the columns of this table, including data types and default values. The INNODB_TABLESPACES_BRIEF table provides space ID, name, path, flag, ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-table-constraints-table.html
The TABLE_CONSTRAINTS table has these columns: CONSTRAINT_CATALOG The name of the catalog to which the constraint belongs. The UNIQUE and PRIMARY KEY information is about the same as what you get from the Key_name column in the output from SHOW ...