Search Results
https://dev.mysql.com/doc/mysql-ai/9.4/en/mys-ai-aml-using-a-recommendation-model-ratings-rankings.html
mysql> CALL sys.ML_MODEL_LOAD('recommendation_use_case', NULL); Make predictions for the test dataset by using the ML_PREDICT_TABLE routine. mysql> CALL sys.ML_PREDICT_TABLE(table_name, model_handle, output_table_name), [options]); Replace ... This ...
https://dev.mysql.com/doc/heatwave-aws/en/heatwave-aws-user-configurable-system-variables.html
Note:Click on the name of a system varuable in Table 19-7 to see its description in the MySQL Reference Manual. skip_name_resolve OFF sort_buffer_size 262144 sql_mode ERROR_FOR_DIVISION_BY_ZERO, NO_ENGINE_SUBSTITUTION, NO_ZERO_DATE, NO_ZERO_IN_DATE, ... User-Configurable System Variables 19.5 User-Configurable System Variables Configure the following global system variables with the MySQL HeatWave ...
https://dev.mysql.com/doc/refman/8.4/en/alter-event.html
This example changes the SQL statement executed by myevent to one that deletes all records from mytable; it also changes the schedule for the event such that it executes once, one day after this ALTER EVENT statement is run. ALTER EVENT myevent ON ...The syntax for each of the DEFINER, ON SCHEDULE, ON COMPLETION, COMMENT, ENABLE / DISABLE, and DO clauses is exactly the same as when used with CREATE ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-redo-log.html
During normal operations, the redo log encodes requests to change table data that result from SQL statements or low-level API calls. If the redo log files occupy less space than the specified value, dirty pages are flushed from the buffer pool to ...
https://dev.mysql.com/doc/refman/8.4/en/locking-service.html
Locking Service Monitoring The locking service is implemented using the MySQL Server metadata locks framework, so you monitor locking service locks acquired or waited for by examining the Performance Schema metadata_locks table. MySQL distributions ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-overview.html
When data is stored by the NDB storage engine, the tables (and table data) are stored in the data nodes. Such tables are directly accessible from all other MySQL servers (SQL nodes) in the cluster. NDB Cluster is a technology that enables ...
https://dev.mysql.com/doc/refman/8.4/en/sha256-pluggable-authentication.html
The following table shows the plugin names on the server and client sides. MySQL provides two authentication plugins that implement SHA-256 hashing for user account passwords: caching_sha2_password: Implements SHA-256 authentication (like ...
https://dev.mysql.com/doc/refman/8.4/en/show-plugins.html
For plugins installed with INSTALL PLUGIN, the Name and Library values are also registered in the mysql.plugin system table. row *************************** Name: binlog Status: ACTIVE Type: STORAGE ENGINE Library: NULL License: GPL ...
https://dev.mysql.com/doc/refman/8.4/en/sorted-index-builds.html
Sorted Index Builds and Compressed Tables For compressed tables, the previous index creation method appended entries to both compressed and uncompressed pages. For more information about compression of B-Tree pages, see Section 17.9.1.5, “How ...
https://dev.mysql.com/doc/relnotes/mysql-cluster/8.4/en/news-8-4-6.html
(Bug #37909595) CREATE TABLESPACE, when the specified logfile group did not exist, was rejected with error 723 No such table existed, which did not correctly identify the source of the problem with the SQL statement. already exists showed the table ... MySQL NDB Cluster 8.4.6 is a new LTS release of NDB 8.4, based on MySQL Server 8.4 and including features in version 8.4 of the NDB storage engine, as well as fixing recently discovered bugs in previous NDB Cluster ...