Search Results
https://dev.mysql.com/doc/refman/8.4/en/alter-table-examples.html
row *************************** Table: t1 Create Table: CREATE TABLE `t2` ( `c1` int(11) DEFAULT NULL ) /*!50100 TABLESPACE ts_1 STORAGE DISK */ ENGINE=ndbcluster DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 1 row in set (0.01 sec) To change ...For NDB tables, it is also possible to change the storage type used for a table or ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-and-mysql-replication.html
This is true whether you are using statement-based or row-based replication. It is possible to use replication in a way where the storage engine on the replica is not the same as the storage engine on the source. For example, you can replicate ...
https://dev.mysql.com/doc/refman/8.4/en/partitioning-info.html
When insertions, deletions, or updates are made to partitioned tables, the binary log records information about the partition and (if any) the subpartition in which the row event took place. A new row event is created for a modification that takes ... This section discusses obtaining information about existing partitions, which can be done in a number of ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-classification-generate-explanation.html
row *************************** Notes: Debt (18000.0) had the largest impact towards predicting Approved ml_results: {"attributions": {"Debt": 0.87, "Liabilities": -0.0, "ClientAge": 0.0, "LoanAmount": 0.0}, "predictions": {"Approved": "Approved"}, ...mysql> CALL sys.ML_EXPLAIN_TABLE('classification_data.Loan_Testing', @model, 'classification_data.Loan_Testing_explanations', JSON_OBJECT('prediction_explainer', 'permutation_importance')); Query OK, 0 rows affected (12.2957 sec) Where: classification_data.Loan_Testing is the fully qualified name of the test ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-regression-explanations.html
mysql> SELECT JSON_PRETTY(model_explanation) FROM ML_SCHEMA_user1.MODEL_CATALOG WHERE model_handle='regression_use_case'; +------------------------------------------------------------------------------------------------------------------------+ | ...
https://dev.mysql.com/doc/refman/8.4/en/engine-condition-pushdown-optimization.html
This reduces the number of rows which must be handled by the SQL node during join processing. In this case, each row retrieved from the scan-filtered table is matched against every row in the buffer. This means that there is no single specific row ... This optimization improves the efficiency of direct comparisons between a nonindexed column and a ...
https://dev.mysql.com/doc/refman/8.4/en/faqs-triggers.html
Does MySQL have statement-level or row-level triggers? All triggers are FOR EACH ROW; that is, the trigger is activated for each row that is inserted, updated, or deleted. To affect trigger order, specify a clause after FOR EACH ROW that indicates ...Where can I find the documentation for MySQL 8.4 triggers? ...
https://dev.mysql.com/doc/refman/8.4/en/function-optimization.html
If a function is tagged nondeterministic, a reference to it in a WHERE clause is evaluated for every row (when selecting from one table) or combination of rows (when selecting from a multiple-table join). The second query contains an expression that ...A function is nondeterministic if, given fixed values for its arguments, it can return different results for different ...
https://dev.mysql.com/doc/refman/8.4/en/insert-select.html
| TABLE table_name | VALUES row_constructor_list } [ON DUPLICATE KEY UPDATE assignment_list] value: {expr | DEFAULT} value_list: value [, value] ... row_constructor_list: ROW(value_list)[, ROW(value_list)][, ...] assignment: col_name = value | ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-error-summary-tables.html
row *************************** ERROR_NUMBER: 1064 ERROR_NAME: ER_PARSE_ERROR SQL_STATE: 42000 SUM_ERROR_RAISED: 1 SUM_ERROR_HANDLED: 0 FIRST_SEEN: 2016-06-28 07:34:02 LAST_SEEN: 2016-06-28 07:34:02 *************************** 2. row ... The ...