Search Results
https://dev.mysql.com/doc/x-devapi-userguide-shell-python/en/using-sql.html
In addition to the simplified X DevAPI syntax of the Session object, the Session object has a sql() function that takes any SQL statement as a string. The following example uses a Session to call an SQL Stored Procedure on the specific node.
https://dev.mysql.com/doc/x-devapi-userguide-shell-python/en/working-with-document-ids.html
If an _id is provided when a document is created, it is honored; if no _id is provided, one is automatically assigned to the document. This section describes what a document ID is and how to work with it. Every document has a unique identifier ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-advisor-auto-indexing-execution.html
Autopilot Indexing does evaluate past SQL statements that access a table that has been dropped and recreated. Rather than drop the suggested indexes, make them invisible first, and then drop them later after confirmation that there is no impact to ... Autopilot Indexing provides recommendations for schemas with a representative workload that has at least five queries in the SQL statement digest history in the Performance ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-advisor-auto-indexing.html
An estimate of the index creation time and the estimated performance gain of the top 5 queries of each create index recommendation. To run Autopilot Indexing for OLTP workloads, the user must have the following MySQL privileges: The PROCESS ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-analyzing-tables.html
If not, ask your admin user to grant you the required privileges. When the secondary engine creates the ACE statistics model, the ACE_MODEL column is updated in the performance schema table rpd_tables. As of MySQL 9.3.0, you can use the ANALYZE ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-excluded-columns.html
If not, ask your admin user to grant you the required privileges. mysql> SELECT COLUMN_NAME, EXTRA FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME LIKE 't1' AND EXTRA LIKE '%NOT SECONDARY%'; +-------------+---------------+ | COLUMN_NAME | EXTRA | ... In MySQL HeatWave, you can explicitly exclude certain table columns from being loaded into the MySQL HeatWave Cluster, by defining them with the NOT SECONDARY ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-varlen-encoding.html
You can define the encoding type while creating the table or later modify it using ALTER TABLE statement. Variable-length encoding is automatically applied when tables are loaded into MySQL HeatWave with the exception of string columns defined ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-automl-workflow.html
Predictions and explanations are returned to the DB System and to the user or application that issued the query. What's Next Learn more about the following: MySQL HeatWave AutoML Learning Types MySQL HeatWave AutoML Ease of Use Oracle AutoML Learn ... A typical MySQL HeatWave AutoML workflow is described below: When you run the ML_TRAIN routine, MySQL HeatWave AutoML retrieves the data to use for ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-classification-generate-prediction.html
For the option to set the user name, you can set it to NULL. The following example runs ML_PREDICT_TABLE on the testing dataset previously created. To generate predictions, use the sample data from the testing_data dataset. Even though the table has ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-classification-score.html
For the option to set the user name, you can set it to NULL. The following example runs ML_SCORE on the testing dataset previously created. After generating predictions and explanations, you can score the model to assess its reliability. For a list ...