Search Results
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-consumer-configurations.html
The consumer settings in the setup_consumers table form a hierarchy from higher levels to lower. The setup_consumers table contains the following hierarchy of values: global_instrumentation thread_instrumentation events_waits_current ...The ...
https://dev.mysql.com/doc/mysql-ai/9.5/en/mys-ai-aml-model-sharing.html
ML_MODEL_EXPORT exports the model to share to a user-defined table that both users need the required privileges to access. Export the Model to Share The admin user needs to export the model to share to a user-defined table that both users can access. mysql> CALL sys.ML_MODEL_EXPORT (model_handle, output_table_name); Replace model_handle and output_table_name with your own ...
https://dev.mysql.com/doc/ndbapi/en/overview-operations.html
Unique key accesses are similar to primary key accesses, except that a unique key access is executed as a read on an index table followed by a primary key access on the table. However, only one request is sent from the MySQL Server, and the read of ... An NdbTransaction consists of a list of operations, each of which is represented by an instance of NdbOperation, NdbScanOperation, NdbIndexOperation, or NdbIndexScanOperation (that is, of NdbOperation or one of its child ...
https://dev.mysql.com/doc/refman/8.4/en/index-hints.html
They also work with multi-table DELETE statements, but not with single-table DELETE, as shown later in this section. (For the general syntax for specifying tables in a SELECT statement, see Section 15.2.13.2, “JOIN Clause”.) The syntax for ...
https://dev.mysql.com/doc/heatwave/en/mys-hwgenai-vector-store-load.html
The VECTOR_STORE_LOAD routine generates vector embedding for the specified files or folders that are stored in the bucket, and loads the embeddings into a new vector store table. This routine creates an asynchronous task which loads vector store ...
https://dev.mysql.com/doc/refman/8.4/en/replication-options-gtids.html
Only statements that can be logged using GTID safe statements can be logged when enforce_gtid_consistency is set to ON, so the operations listed here cannot be used with this option: CREATE TEMPORARY TABLE or DROP TEMPORARY TABLE statements inside ... The MySQL Server system variables described in this section are used to monitor and control Global Transaction Identifiers ...
https://dev.mysql.com/doc/workbench/en/wb-performance-reports.html
Using Temp Tables – Lists all statements that use temporary tables (access the highest percentage of disk temporary tables, then memory temporary tables). Full Table Scans – Lists statements that have performed a full table scan. If no index is ... Performance schema based reports provide insight into the MySQL server operations through helpful high-level ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-genai-summarize-docs.html
You need to first ingest these documents into vector store tables using Auto Parallel Load. The generated table contains text segments that are used as input text for the ML_GENERATE and ML_GENERATE_TABLE routines to generate summaries of the ... As ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-training-a-recommendation-model.html
To enable faster predictions, the model generates tables with embeddings for users and items. The tables are used as a representation for each user and item. The model also generates a table of interactions that stores each interaction between a ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-using-an-anomaly-detection-model.html
To detect anomalies in row data, you can run the ML_PREDICT_ROW or ML_PREDICT_TABLE routines. To detect anomalies in log data (MySQL 9.2.2 and later), you can only run the ML_PREDICT_TABLE routine. Requirements for Generating Predictions As of MySQL ...To generate predictions, use the sample data from the two anomaly detection datasets: credit_card_train and ...