Search Results
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 ...
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/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/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 ...