Search Results
https://dev.mysql.com/doc/refman/8.4/en/information-schema-innodb-ft-index-cache-table.html
The INNODB_FT_INDEX_CACHE table provides token information about newly inserted rows in a FULLTEXT index. Before querying it, set the value of the innodb_ft_aux_table system variable to the name (including the database name) of the table that ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-information-schema-metrics-table.html
The INNODB_METRICS table provides information about InnoDB performance and resource-related counters. For example, to enable the log module, metadata_table_handles_opened and metadata_table_handles_closed counters, enter the following line in the ...SET GLOBAL innodb_monitor_disable = [counter-name|module_name|pattern|all]; innodb_monitor_reset: Resets counter values to ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-truncate-table-reclaim-space.html
To reclaim operating system disk space when truncating an InnoDB table, the table must be stored in its own .ibd file. For a table to be stored in its own .ibd file, innodb_file_per_table must enabled when the table is created. Additionally, there ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-system-variable-tables.html
System variable information is available in these Performance Schema tables: global_variables: Global system variables. An application that wants only global values should use this table. An application that wants all system variable values for its ... The MySQL server maintains many system variables that indicate how it is configured (see Section 7.1.8, “Server System ...
https://dev.mysql.com/doc/refman/8.4/en/table-scan-avoidance.html
The output from EXPLAIN shows ALL in the type column when MySQL uses a full table scan to resolve a query. This usually happens under the following conditions: The table is so small that it is faster to perform a table scan than to bother with a ...
https://dev.mysql.com/doc/workbench/en/wb-basic-add-table.html
The table tool is the rectangular grid in the middle of the vertical toolbar. Mousing over it shows the message, Place a New Table (T). Create a table on the canvas by clicking anywhere on the EER Diagram grid. Right-click the table and choose Edit ... The tools in the vertical toolbar on the left of the EER Diagram tab are used for designing an EER ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-exclude-table-columns.html
Before loading a table into MySQL HeatWave, exclude the columns with unsupported data types. With MySQL version 8.2.0 or higher, this step is not required as the guided load feature automatically excludes all unsupported columns when you load the ...For a list of data types that MySQL HeatWave supports, see Section 4.2.1, “Supported Data Types for MySQL ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-rpd-mirror-table.html
The rpd_mirror table keeps track of all existing tables in the DB System, whose engine is InnoDB. MYSQL_ACCESS_COUNT Number of times the table has been accessed by the DB System. HEATWAVE_ACCESS_COUNT Number of times the table has been accessed by ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-columns-table.html
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 of the catalog to which the table containing the column belongs. TABLE_SCHEMA The ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-innodb-ft-deleted-table.html
The INNODB_FT_DELETED table stores rows that are deleted from the FULLTEXT index for an InnoDB table. Before querying it, set the value of the innodb_ft_aux_table system variable to the name (including the database name) of the table that contains ...For more information about InnoDB FULLTEXT search, see Section 17.6.2.4, “InnoDB Full-Text Indexes”, and Section 14.9, “Full-Text Search ...