Search Results
https://dev.mysql.com/doc/refman/8.4/en/outer-join-simplification.html
Table expressions in the FROM clause of a query are simplified in many cases. When the optimizer evaluates plans for outer join operations, it takes into consideration only plans where, for each such operation, the outer tables are accessed before ...At the parser stage, queries with right outer join operations are converted to equivalent queries containing only left join ...
https://dev.mysql.com/doc/refman/8.4/en/serialized-dictionary-information.html
Other storage engines store SDI data in .sdi files that are created for a given table in the table's database directory. Serialized dictionary information (SDI) is present in all InnoDB tablespace files except for temporary tablespace and undo ...
https://dev.mysql.com/doc/refman/8.4/en/windows-restrictions.html
File system aliases When using MyISAM tables, you cannot use aliases within Windows link to the data files on another volume and then link back to the main MySQL datadir location. DATA DIRECTORY and INDEX DIRECTORY The DATA DIRECTORY clause of the ... The following restrictions apply to use of MySQL on the Windows platform: Process memory On Windows 32-bit platforms, it is not possible by default to use more than 2GB of RAM within a single process, including ...
https://dev.mysql.com/doc/mysql-ai/9.5/en/mys-mysqlai-vector-store-load.html
The VECTOR_STORE_LOAD routine generates vector embedding for the specified files or folders that are , and loads the embeddings into a new vector store table. This routine creates an asynchronous task which loads vector store tables in the ...It ...
https://dev.mysql.com/doc/refman/8.4/en/generated-column-index-optimizations.html
For example: CREATE TABLE t1 (f1 INT, gc INT AS (f1 + 1) STORED, INDEX (gc)); The generated column, gc, is defined as the expression f1 + 1. row *************************** id: 1 select_type: SIMPLE table: t1 partitions: NULL type: range ...The ...
https://dev.mysql.com/doc/refman/8.4/en/spatial-relation-functions-object-shapes.html
Unless otherwise specified, functions handle their unit argument as follows: A unit is supported if it is found in the INFORMATION_SCHEMA ST_UNITS_OF_MEASURE table. The OpenGIS specification defines the following functions to test the relationship ...
https://dev.mysql.com/doc/refman/8.4/en/upgrade-before-you-begin.html
The backup should include the mysql system database, which contains the MySQL data dictionary tables and system tables. Important Downgrade from MySQL 8.4 to MySQL 8.3, or from a MySQL 8.4 release to a previous MySQL 8.4 release, is not supported.
https://dev.mysql.com/doc/connectors/en/connector-odbc-usagenotes-functionality-catalog-schema.html
Generally, catalogs are collections of schemas, so the fully qualified name would look like catalog.schema.table.column. In ODBC both schemas and catalogs can be used when referring to database objects such as tables. As a result the client software ... Many relational databases reference CATALOG and SCHEMA in ways that do not directly correspond to what MySQL refers to as a ...
https://dev.mysql.com/doc/connector-odbc/en/connector-odbc-usagenotes-functionality-catalog-schema.html
Generally, catalogs are collections of schemas, so the fully qualified name would look like catalog.schema.table.column. In ODBC both schemas and catalogs can be used when referring to database objects such as tables. As a result the client software ... Many relational databases reference CATALOG and SCHEMA in ways that do not directly correspond to what MySQL refers to as a ...
https://dev.mysql.com/doc/heatwave-aws/en/mysql-server-default-privileges.html
Default MySQL Privileges 3.1.2.9 Default MySQL Privileges This section lists the MySQL privileges granted to the MySQL Administrator user on the DB System and those explicitly revoked on the mysql and sys schemas.