Search Results
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-quick-start.html
To see the structure of individual tables, use SHOW CREATE TABLE: mysql> SHOW CREATE TABLE performance_schema.setup_consumers\G *************************** 1. row *************************** Table: setup_consumers Create Table: CREATE TABLE ...The ... This section briefly introduces the Performance Schema with examples that show how to use ...
https://dev.mysql.com/doc/mysql-ai/9.5/en/mys-ai-genai-rag.html
The examples in this topic use the vector store table demo_embeddings created in the section Ingesting Files into a Vector Store. OutputTableName: the name of the table where you want to create a new column to store the generated outputs. If the ...
https://dev.mysql.com/doc/refman/8.4/en/memory-use.html
For MEMORY tables explicitly created with CREATE TABLE, only the max_heap_table_size system variable determines how large a table can grow, and there is no conversion to on-disk format. If you use a large number of tables, you can create a large ...
https://dev.mysql.com/doc/refman/8.4/en/implicit-commit.html
CREATE TABLE and DROP TABLE statements do not commit a transaction if the TEMPORARY keyword is used. (This does not apply to other operations on temporary tables such as ALTER TABLE and CREATE INDEX, which do cause a commit.) However, although no ...
https://dev.mysql.com/doc/ndbapi/en/mccj-clusterj-session.html
Table 4.47 createQuery(QueryDefinition<T>) Parameter Description qd the query definition return the query instance 4.3.1.22.5 currentTransaction() public abstract Transaction currentTransaction(); Get the current com.mysql.clusterj.Transaction. This ...Session extends AutoCloseable so it can be used in the try-with-resources ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-genai-run-chat.html
In this topic, the HEATWAVE_CHAT routine uses the vector store table demo_embeddings created in the section Ingesting Files Using the URI with Asynchronous Load for context retrieval. To use your own embedding table for context retrieval, create a ...As of MySQL 9.2.1, MySQL HeatWave Chat lets you use your own embedding tables for context ...
https://dev.mysql.com/doc/refman/8.4/en/switchable-optimizations.html
For more information, see Section 10.2.2.5, “Derived Condition Pushdown Optimization” Derived Table Merging Flags derived_merge (default on) Controls merging of derived tables and views into outer query block. The derived_merge flag controls ...
https://dev.mysql.com/doc/refman/8.4/en/view-updatability.html
For information about generated columns, see Section 15.1.20.8, “CREATE TABLE and Generated Columns”. Consider this view: CREATE VIEW v AS SELECT col1, 1 AS col2 FROM t; This view is not insertable because col2 is an expression. Some views are ...For dependent subqueries in the select list, no data change statements are ...
https://dev.mysql.com/doc/refman/8.4/en/index-page-merge-threshold.html
Setting MERGE_THRESHOLD for a Table You can set the MERGE_THRESHOLD value for a table using the table_option COMMENT clause of the CREATE TABLE statement. row *************************** INDEX_ID: 91 NAME: id_index TABLE_ID: 68 TYPE: 0 N_FIELDS: 1 ...The MERGE_THRESHOLD for index pages can be defined for a table or for individual ...If the “page-full” percentage for an index page falls below the MERGE_THRESHOLD value when a row is deleted or when a row is shortened by an ...
https://dev.mysql.com/doc/refman/8.4/en/table-size-limit.html
If you need a MyISAM table that is larger than the default limit and your operating system supports large files, the CREATE TABLE statement supports AVG_ROW_LENGTH and MAX_ROWS options. The effective maximum table size for MySQL databases is ...For ...