Search Results
https://dev.mysql.com/doc/x-devapi-userguide-shell-python/en/connection-attributes-xdevapi.html
Connection attributes are key-value pairs that application programs can pass to the server during connection time to be stored in the PERFORMANCE_SCHEMA tables session_account_connect_attrs and session_connect_attrs. There are two different kinds ...The set of client-defined attributes differ from client to client—see the X DevAPI references of you client for ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-async-exec.html
The mysql_tasks.config table stores the following key values that are used to define maximum task limits: The limits.maximumPreparedStmtAsyncTasks key specifies the maximum number of SQL statements that can run concurrently within the MySQL HeatWave ... As of MySQL 9.3.1, you can run SQL statements as asynchronous tasks that run in the ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-json-functions.html
JSON_DEPTH() Maximum depth of JSON document JSON_EXTRACT() Return data from JSON document JSON_INSERT() Insert or update data into JSON document JSON_KEYS() Array of keys from JSON document. JSON_LENGTH() Number of elements in JSON document ...Table ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-rpd-columns-table.html
DATA_PLACEMENT_INDEX The data placement key index ID associated with the column. For information about data placement key index values, see Section 5.8.2, “Data Placement Keys”. NULL indicates that the column is not defined as a data placement ... The rpd_columns table provides column encoding information for columns of tables loaded in MySQL ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-train-test-split.html
Anomaly detection for log data: A split of data based on primary key values. TRAIN_TEST_SPLIT Syntax mysql> CALL sys.TRAIN_TEST_SPLIT ('table_name', 'target_column_name', [options | NULL]); options: { JSON_OBJECT("key","value"[,"key","value"] ...) ... MySQL 9.4.1 introduces the TRAIN_TEST_SPLIT routine, which automatically splits your data into training and testing ...
https://dev.mysql.com/doc/heatwave/en/mys-hwgenai-hw-chat.html
vector_store_columns: optional parameter which specifies column names for finding relevant vector and embedding tables for context retrieval as key-value pairs in JSON format. It can include the following parameters: JSON_OBJECT('segment', ... The ...
https://dev.mysql.com/doc/refman/8.4/en/alter-table-examples.html
For NDB tables, it is also possible to change the storage type used for a table or column. row *************************** Table: t1 Create Table: CREATE TABLE `t2` ( `c1` int(11) DEFAULT NULL ) /*!50100 TABLESPACE ts_1 STORAGE DISK */ ...
https://dev.mysql.com/doc/refman/8.4/en/built-in-function-reference.html
The following table lists each built-in (native) function and operator and provides a short description of each one. For a table listing functions that are loadable at runtime, see Section 14.2, “Loadable Function Reference”. ->> Return value ...
https://dev.mysql.com/doc/refman/8.4/en/derived-tables.html
For information about lateral derived tables preceded by the LATERAL keyword, see Section 15.2.15.9, “Lateral Derived Tables”. row *************************** id: 1 select_type: PRIMARY table: <derived2> partitions: NULL type: system ...A ...
https://dev.mysql.com/doc/refman/8.4/en/engine-condition-pushdown-optimization.html
row *************************** id: 1 select_type: SIMPLE table: x partitions: p0,p1 type: ALL possible_keys: NULL key: NULL key_len: NULL ref: NULL rows: 4 filtered: 100.00 Extra: NULL *************************** 2. row *************************** ... This optimization improves the efficiency of direct comparisons between a nonindexed column and a ...