Search Results
https://dev.mysql.com/doc/connector-python/en/connector-python-example-ddl.html
In a MySQL server, tables are very long-lived objects, and are often accessed by multiple applications written in different languages. cnx = mysql.connector.connect(user='scott') cursor = cnx.cursor() A single MySQL server can manage multiple ...
https://dev.mysql.com/doc/mysql-installer/en/server-type-network.html
Server Configuration Type Choose the MySQL server configuration type that describes your setup. This setting defines the amount of system resources (memory) to assign to your MySQL server instance. This setting configures MySQL to use the least ...
https://dev.mysql.com/doc/ndbapi/en/ndb-examples-secondary-indexes-ndbrecord.html
This program illustrates how to use secondary indexes in the NDB API with the aid of the NdbRecord interface. The source code for this example may be found in the NDB Cluster source trees, in the file ...
https://dev.mysql.com/doc/mysql-monitor/8.0/en/mem-unattended-execution.html
The basic process for performing an unattended installation is the same for both MySQL Enterprise Monitor Agent and MySQL Enterprise Service Manager installers, with the only difference being the options supported by each installer. For information ...There are two methods for installation: either specify the option on the command line, or use an options file containing the relevant options and their ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-change-propagation.html
After tables are loaded into MySQL HeatWave, data changes are automatically propagated from DB System tables to their counterpart tables in the MySQL HeatWave Cluster. DML operations, INSERT, UPDATE, and DELETE, on the DB System do not wait for ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-json-functions.html
What's Next Learn how to perform the following tasks: Run queries Modify tables Retrieve MySQL HeatWave Metadata Optimize workloads for OLAP and OLTP Monitor MySQL HeatWave processes . Table 5.7 JSON Functions Name Description -> Return value from ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-auto-loading-data-rp.html
As of MySQL 9.2.1, if the region is not specified, the instance's associated region is used as the default region. MySQL HeatWave automatically creates the database if it does not exist. MySQL HeatWave automatically creates the table if it does not ... Review the following examples to see the different ways to use resource principals and Auto Parallel Load to specify files when creating external ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-rpd-nodes-table.html
The rpd_nodes read-only table provides information about MySQL HeatWave nodes. The rpd_nodes table has the following columns: ID A unique identifier for the MySQL HeatWave node. CORES The number of cores used by the MySQL HeatWave node. The table ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-rpd-query-stats-table.html
The rpd_query_stats table stores query compilation and execution statistics produced by the MySQL HeatWave plugin in JSON format. For MySQL HeatWave AutoML routines that include multiple sub-queries, such as ML_TRAIN, a new record is used for each ...The rpd_query_stats table has these columns: CONNECTION_ID The ID of the ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-model-handles.html
mysql> SET @variable = (SELECT model_handle FROM ML_SCHEMA_user1.MODEL_CATALOG ORDER BY build_timestamp DESC LIMIT 1); The following example sets the latest_model variable. mysql> SET @latest_model = (SELECT model_handle FROM ...You must use model ... When ML_TRAIN trains a model, you have the option to specify a name for the model, which is the model ...