Search Results
https://dev.mysql.com/doc/refman/8.4/en/partitioning-hash.html
Partitioning by HASH is used primarily to ensure an even distribution of data among a predetermined number of partitions. To partition a table using HASH partitioning, it is necessary to append to the CREATE TABLE statement a PARTITION BY HASH ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-events-waits-current-table.html
END_EVENT_ID This column is set to NULL when the event starts and updated to the thread current event number when the event ends. If an event is produced from an instrument that has TIMED = NO, timing information is not collected, and TIMER_START, ...The table stores one row per thread showing the current status of the thread's most recent monitored wait event, so there is no system variable for configuring the table ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-statement-summary-tables.html
If no row has the statement digest value for the statement that just completed, and the table is full, the statistics for the statement that just completed are added to a special “catch-all” row with DIGEST = NULL, which is created if necessary.
https://dev.mysql.com/doc/refman/8.4/en/replace.html
REPLACE [LOW_PRIORITY | DELAYED] [INTO] tbl_name [PARTITION (partition_name [, partition_name] ...)] [(col_name [, col_name] ...)] { {VALUES | VALUE} (value_list) [, (value_list)] ... | VALUES row_constructor_list } REPLACE [LOW_PRIORITY | DELAYED] ...
https://dev.mysql.com/doc/refman/8.4/en/replication-threads-monitor-main.html
row *************************** Id: 2 User: root Host: localhost:32931 db: NULL Command: Binlog Dump Time: 94 State: Has sent all binlog to slave; waiting for binlog to be updated Info: NULL Here, thread 2 is a Binlog Dump thread that services a ...
https://dev.mysql.com/doc/refman/8.4/en/sys-sys-get-config.html
Given a configuration option name, returns the option value from the sys_config table, or the provided default value (which may be NULL) if the option does not exist in the table. If sys_get_config() returns the default value and that value is ...
https://dev.mysql.com/doc/mysql-shell/9.4/en/upgrade-mysql-replicaset-from-8027to8028.html
To upgrade the instances in an InnoDB ReplicaSet, complete the following steps: Upgrade MySQL Router. Check the versions of the installed binaries: mysqlrouter --version: Checks the version of MySQL Router installed. To upgrade MySQL Router, ...
https://dev.mysql.com/doc/mysql-ai/9.4/en/mys-ai-aml-predictions-ml-predict-row.html
mysql> CALL sys.ML_MODEL_LOAD(@census_model, NULL); For more information about training and loading models, see Train a Model and Load a Model. mysql> SELECT sys.ML_PREDICT_ROW(JSON_OBJECT( "age", census_train.`age`, "workclass", ... ML_PREDICT_ROW ...
https://dev.mysql.com/doc/mysql-ai/9.4/en/mys-ai-aml-scoring-a-forecasting-model.html
The ML_SCORE routine does not require a target_column_name for forecasting, so you can set it to NULL. For the option to set the user name, you can set it to NULL. mysql> CALL sys.ML_MODEL_LOAD(@model, NULL); The following example uses the model ...
https://dev.mysql.com/doc/mysql-ai/9.4/en/mys-mysqlai-ml-explain.html
ML_EXPLAIN Syntax mysql> CALL sys.ML_EXPLAIN ('table_name', 'target_column_name', model_handle, [options]); options: { JSON_OBJECT("key","value"[,"key","value"] ...) "key","value": { ['model_explainer', ... Running the ML_EXPLAIN routine on a model ...