Search Results
https://dev.mysql.com/doc/relnotes/heatwave/en/news-9-0-0.html
(WL #15931) MySQL HeatWave Autopilot MySQL HeatWave Autopilot includes improvements to cardinality estimation for queries that run in MySQL HeatWave and MySQL HeatWave Lakehouse. (WL #15817) MySQL HeatWave MySQL HeatWave includes improvements to ...
https://dev.mysql.com/doc/relnotes/heatwave/en/news-9-4-1.html
(WL #16905) MySQL HeatWave AutoML and MySQL HeatWave GenAI now support enhanced concurrency, enabling the processing of multiple queries simultaneously across different sessions, which significantly improves overall performance and efficiency. (WL ... These release notes were created with the assistance of MySQL HeatWave ...
https://dev.mysql.com/doc/heatwave-aws/en/heatwave-aws-hw-workload-perf-data.html
Recent Queries Displays recently executed queries with the Query Text, the query Start Time, and the Duration (ms) of the query. You are provided with options to Search by Query Text for specific queries and to Aggregate Executions to view ... MySQL ...
https://dev.mysql.com/doc/refman/8.4/en/column-indexes.html
Optimizations are applied to certain kinds of FULLTEXT queries against single InnoDB tables. Queries with these characteristics are particularly efficient: FULLTEXT queries that only return the document ID, or the document ID and the search rank.
https://dev.mysql.com/doc/refman/8.4/en/fulltext-boolean.html
InnoDB tables require a FULLTEXT index on all columns of the MATCH() expression to perform boolean queries. Boolean queries against a MyISAM search index can work even without a FULLTEXT index, although a search executed in this fashion would be ...
https://dev.mysql.com/doc/refman/8.4/en/fulltext-stopwords.html
The stopword list is loaded and searched for full-text queries using the server character set and collation (the values of the character_set_server and collation_server system variables). False hits or misses might occur for stopword lookups if the ...
https://dev.mysql.com/doc/refman/8.4/en/general-thread-states.html
The following list describes thread State values that are associated with general query processing and not more specialized activities such as replication. Many of these are useful only for finding bugs in the server. After create This occurs when ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-introduction.html
If you wish to make such information hidden from queries that select from these tables, you can do so by setting the value of the show_gipk_in_create_table_and_information_schema server system variable to OFF. You can filter, sort, concatenate, and ... INFORMATION_SCHEMA provides access to database metadata, information about the MySQL server such as the name of a database or table, the data type of a column, or access ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-fulltext-index.html
Full-text indexes are created on text-based columns (CHAR, VARCHAR, or TEXT columns) to speed up queries and DML operations on data contained within those columns. The data that is already flushed to disk (to the auxiliary index tables) is not ...A ...
https://dev.mysql.com/doc/refman/8.4/en/internal-temporary-tables.html
Tables created for subquery or semijoin materialization (see Section 10.2.2, “Optimizing Subqueries, Derived Tables, View References, and Common Table Expressions”). For queries that use the SQL_SMALL_RESULT modifier, MySQL uses an in-memory ...