Search Results
https://dev.mysql.com/doc/mysql-ai/9.5/en/mys-ai-aml-predictions-ml-predict-row.html
The column names must match the feature column names in the training dataset. The following example trains a dataset with the classification machine learning task. mysql> CALL sys.ML_TRAIN('census_data.census_train', 'revenue', JSON_OBJECT('task', ... ML_PREDICT_ROW generates predictions for one or more rows of data specified in JSON ...mysql> CALL sys.ML_MODEL_LOAD(@census_model, NULL); ...
https://dev.mysql.com/doc/internals/en/guided-tour-skeleton.html
"Prepare: Parse the query Allocate a new statement, keep it in 'thd->prepared statements' pool Return to client the total number of parameters and result-set metadata information (if any)" The prepare is the step that must happen before execute ...
https://dev.mysql.com/doc/refman/8.4/en/replication-solutions-backups-rawdata.html
If the MySQL server is still running, background tasks may still be updating the database files, particularly those involving storage engines with background processes such as InnoDB. The relay log files must be backed up separately if they have ...
https://dev.mysql.com/doc/heatwave-aws/en/heatwave-aws-loading-unloading-heatwave.html
The time required to load data from the DB System into the MySQL HeatWave Cluster depends on the data size. Note: MySQL HeatWave Cluster data can also be managed using SQL or the Auto Parallel Load interface from a MySQL client. To load data, do the ... Loading or Unloading Data into MySQL HeatWave Cluster 9.1 Loading or Unloading Data into MySQL HeatWave Cluster Use MySQL HeatWave Console to load data into or unload data from a MySQL HeatWave ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-load-event-based.html
Once an event for an external file location is emitted due to a change to an object, Lakehouse automatically refreshes the data into the external table. For the initial load, you must specify at least one external file location with the file or ...
https://dev.mysql.com/doc/refman/8.4/en/mysqldump-delimited-text.html
INTO OUTFILE to write the files, so you must have the FILE privilege to perform this operation, and an error occurs if a given .txt file already exists. The .txt file contains the table data, one line per table row. The following command dumps the ...If you invoke mysqldump with the --tab=dir_name option, it uses dir_name as the output directory and dumps tables individually in that directory using two files for each ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-loading-data-resource-principal.html
mysql> CREATE EXTERNAL TABLE table_1(col_1 int, col_2 int, col_3 int) ENGINE_ATTRIBUTE='{"dialect": {"format": "csv"}, "file": [{"region": "regionName", "namespace": "tenant_1", "bucket": "bucket_1", "prefix": "data_files/"}]}'; The following ...To ...
https://dev.mysql.com/doc/connectors/en/connector-net-ref-mysqlclient.html
Classes Class Description AuthenticationPluginConfigurationElement Retrieves the authentication plugin configuration from the configuration file. InterceptorConfigurationElement Class used in the configuration file to get configuration details for ...BaseCommandInterceptor Provides a means of enhancing or replacing SQL commands through the connection string rather than ...
https://dev.mysql.com/doc/connector-net/en/connector-net-ref-mysqlclient.html
Classes Class Description AuthenticationPluginConfigurationElement Retrieves the authentication plugin configuration from the configuration file. InterceptorConfigurationElement Class used in the configuration file to get configuration details for ...BaseCommandInterceptor Provides a means of enhancing or replacing SQL commands through the connection string rather than ...
https://dev.mysql.com/doc/mysql-em-plugin/en/myoem-config-metric-innodbconfiguration-category.html
Checksums Enabled Whether InnoDB uses checksum validation on all pages read from the disk to ensure extra fault tolerance against broken hardware or data files. Data File Path The paths to individual InnoDB data files and their sizes. Data Home Dir ...Additional Mem Pool Size The size in bytes of a memory pool InnoDB uses to store data dictionary information and other internal data ...