Search Results
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-model-handles.html
mysql> SET @variable = (SELECT model_handle FROM ML_SCHEMA_user1.MODEL_CATALOG ORDER BY build_timestamp DESC LIMIT 1); The following example sets the latest_model variable. mysql> SET @latest_model = (SELECT model_handle FROM ...You must use model ... When ML_TRAIN trains a model, you have the option to specify a name for the model, which is the model ...
https://dev.mysql.com/doc/heatwave-aws/en/heatwave-aws-supported-shapes.html
Supported Shapes 3.1.1 Supported Shapes MySQL HeatWave on AWS supports the following MySQL and MySQL HeatWave node shapes. The MySQL HeatWave.16GB node shape may not have enough memory for training on large data sets. Lakehouse is supported on the ...If you see error messages about this (such as ML003024), use the larger shape ...
https://dev.mysql.com/doc/refman/8.4/en/case-sensitivity.html
This example shows that VERSION() returns a string that has a case-insensitive collation, so comparisons are case-insensitive: mysql> SELECT COLLATION(VERSION()); +----------------------+ | COLLATION(VERSION()) | +----------------------+ | ... For ...
https://dev.mysql.com/doc/refman/8.4/en/general-tablespaces.html
The server keeps tablespace metadata in memory for the lifetime of a tablespace. General tablespace data files can be placed in a directory relative to or independent of the MySQL data directory, which provides you with many of the data file and ...
https://dev.mysql.com/doc/refman/8.4/en/gis-format-conversion-functions.html
MySQL supports the functions listed in this section for converting geometry values from internal geometry format to WKT or WKB format, or for swapping the order of X and Y coordinates. Functions such as ST_GeomFromText() that accept WKT geometry ...
https://dev.mysql.com/doc/refman/8.4/en/ldml-collation-example.html
To add a UCA collation for a Unicode character set without recompiling MySQL, use the following procedure. If you are unfamiliar with the LDML rules used to describe the collation's sort characteristics, see Section 12.14.4.2, “LDML Syntax ...The ...
https://dev.mysql.com/doc/refman/8.4/en/selinux-file-context.html
The MySQL Server reads from and writes to many files. The instructions that follow use the semanage binary to manage file context; on RHEL, it's part of the policycoreutils-python-utils package: yum install -y policycoreutils-python-utils After ...
https://dev.mysql.com/doc/refman/8.4/en/string-type-syntax.html
In some cases, MySQL may change a string column to a type different from that given in a CREATE TABLE or ALTER TABLE statement. For definitions of character string columns (CHAR, VARCHAR, and the TEXT types), MySQL interprets length specifications ... The string data types are CHAR, VARCHAR, BINARY, VARBINARY, BLOB, TEXT, ENUM, and ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/meb-encrypted-innodb.html
For details on how the MySQL server encrypts and decrypts InnoDB tablespaces, see InnoDB Data-at-Rest Encryption—it explains concepts like master key and tablespace keys, which are important for understanding how MySQL Enterprise Backup works with ...The encrypted undo and redo tablespaces are handled the same way as the encrypted tablespaces for InnoDB ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-threads-table.html
row *************************** THREAD_ID: 1 NAME: thread/sql/main TYPE: BACKGROUND PROCESSLIST_ID: NULL PROCESSLIST_USER: NULL PROCESSLIST_HOST: NULL PROCESSLIST_DB: mysql PROCESSLIST_COMMAND: NULL PROCESSLIST_TIME: 418094 PROCESSLIST_STATE: NULL ...Each row contains information about a thread and indicates whether monitoring and historical event logging are enabled for it: mysql> SELECT * FROM performance_schema.threads\G *************************** ...