Search Results
https://dev.mysql.com/doc/heatwave/en/mys-hw-genai-rag.html
The examples in this topic use the vector store table demo_embeddings created in the section Ingesting Files Using the URI with Asynchronous Load. In versions older than MySQL 9.2.1, to alter an existing table or create a new table, MySQL requires ...As of MySQL 9.2.1, for context retrieval, the ML_RAG routine uses the name of the embedding model used to embed the input query to find relevant vector store tables that contain vector embeddings from the same embedding ...
https://dev.mysql.com/doc/mysql-monitor/8.0/en/mem-qanal-config-ui.html
Temporary Tables Temporary Tables Average: the average number of internal temporary tables created per occurrence of the statement. Temporary Tables Disk: the total number of internal, on-disk temporary tables created by occurrences of the statement. Temporary Tables Total: the total number of internal in-memory temporary tables created by occurrences of the statement Time: the time at which the statements were ...Notices: Filters ...
https://dev.mysql.com/doc/refman/8.4/en/federated-usagenotes.html
It is possible for one FEDERATED table to point to another, but you must be careful not to create a loop. Care should be taken when creating a FEDERATED table since the index definition from an equivalent MyISAM or other table may not be supported.
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-limitations-transactions.html
When a user-created NDB table is accessed using a unique index, the hidden index table is first read to find the primary key that is then used to read the user-created table. When a row referenced by a unique index in the user-created NDB table is ...NDBCLUSTER stores only part of a column value that uses any of MySQL's BLOB or TEXT data types in the table visible to MySQL; the remainder of the BLOB or TEXT is stored in a separate internal table that is not accessible to ...
https://dev.mysql.com/doc/refman/8.4/en/upgrading-what-is-upgraded.html
If the actual data dictionary version is lower than the current expected version, the server creates data dictionary tables with updated definitions, copies persisted metadata to the new tables, atomically replaces the old tables with the new ones, ... Installing a new version of MySQL may require upgrading these parts of the existing installation: The mysql system schema, which contains tables that store information required by the MySQL server as it runs (see Section 7.3, “The mysql System ...
https://dev.mysql.com/doc/refman/8.4/en/myisam-storage-engine.html
To specify explicitly that you want a MyISAM table, indicate that with an ENGINE table option: CREATE TABLE t (i INT) ENGINE = MYISAM; In MySQL 8.4, it is normally necessary to use ENGINE to specify the MyISAM storage engine because InnoDB is the ...
https://dev.mysql.com/doc/refman/8.4/en/tracing-example.html
Next, for every table in the query, we estimate the cost of, and number of records returned by, a table scan or a range access. "resulting_clause_is_simple": true, "resulting_clause": "`test`.`alias1`.`col_int_key`" } /* clause_processing */ }, The ...Now we can examine the trace, whose first column (QUERY), containing the original statement to be traced, is shown here: SELECT * FROM INFORMATION_SCHEMA.OPTIMIZER_TRACE\G *************************** ...
https://dev.mysql.com/doc/refman/8.4/en/dynamic-format.html
Dynamic storage format is used if a MyISAM table contains any variable-length columns (VARCHAR, VARBINARY, BLOB, or TEXT), or if the table was created with the ROW_FORMAT=DYNAMIC table option. You can use OPTIMIZE TABLE or myisamchk -r to ...
https://dev.mysql.com/doc/refman/8.4/en/replication-gtids-concepts.html
A global transaction identifier (GTID) is a unique identifier created and associated with each transaction committed on the server of origin (the source). The mysql.gtid_executed system table is used to preserve the assigned GTIDs of all the ...
https://dev.mysql.com/doc/connectors/en/connector-python-asyncio.html
Reference: [as_completed]: https://docs.python.org/3/library/asyncio-task.html#asyncio.as_completed """ exec_seq = [] database_name = "TABLE_CREATOR" # Create/Setup database # --------------------- # No asynchronous execution is done here. async ...