Search Results
https://dev.mysql.com/doc/refman/8.4/en/invisible-indexes.html
If an index made invisible actually is needed or used by the optimizer, there are several ways to notice the effect of its absence on queries for the table: Errors occur for queries that include index hints that refer to the invisible index. MySQL ...
https://dev.mysql.com/doc/refman/8.4/en/lateral-derived-tables.html
A derived table cannot normally refer to (depend on) columns of preceding tables in the same FROM clause. A derived table may be defined as a lateral derived table to specify that such references are permitted. Nonlateral derived tables are ...
https://dev.mysql.com/doc/refman/8.4/en/log-file-maintenance.html
As described in Section 7.4, “MySQL Server Logs”, MySQL Server can create several different log files to help you see what activity is taking place. However, you must clean up these files regularly to ensure that the logs do not take up too ...
https://dev.mysql.com/doc/refman/8.4/en/time-zone-support.html
The desired result is that both queries return the same result (the input time, converted to the equivalent value in the 'US/Central' time zone). This section describes the time zone settings maintained by MySQL, how to load the system tables ...
https://dev.mysql.com/doc/refman/8.4/en/timestamp-lookups.html
In such cases, all index-using queries of the form shown match at most one index entry. It remains true that index-using queries match the converted search value to a single value in the UTC index entries, rather than matching multiple UTC values ...
https://dev.mysql.com/doc/mysql-ai/9.5/en/mys-ai-genai-generate-embeddings.html
This topic contains the following sections: Before You Begin Generating a Vector Embedding for Specified Text Running Batch Queries What's Next Before You Begin Review the GenAI requirements and privileges. For Running Batch Queries, add the text ...
https://dev.mysql.com/doc/mysql-ai/9.5/en/mys-ai-genai-vector-store-overview.html
GenAI encodes your queries using the same embedding model that is used to encode the ingested data to create the vector store. About Accelerated Processing of Queries on Vector-Based Tables GenAI lets you run queries on tables that contain vector ...
https://dev.mysql.com/doc/workbench/en/wb-performance-explain.html
MySQL Workbench provides all of the EXPLAIN formats for executed queries including the raw extended JSON, traditional format, and visual query plan. For information about how MySQL executes statements, see Optimizing Queries with EXPLAIN. Prior to ... The visual explain feature generates and displays a visual representation of the MySQL EXPLAIN statement by using extended information available in the extended JSON ...
https://dev.mysql.com/doc/connectors/en/connector-j-connp-props-performance-extensions.html
callableStmtCacheSize If 'cacheCallableStmts' is enabled, how many callable statements should be cached? Default Value 100 Since Version 3.1.2 metadataCacheSize The number of queries to cache 'ResultSetMetadata' for if 'cacheResultSetMetaData' is ...Prior to version 8.0.29, this property was named 'parseInfoCacheFactory', which remains as an ...
https://dev.mysql.com/doc/connectors/en/connector-odbc-configuration-connection-parameters.html
prefetch Prefetch from server by _ rows at a time 0 When set to a non-zero value N, causes all queries in the connection to return N rows at a time rather than the entire result set. Useful for queries against very large tables where it is not ...On ...