Search Results
https://dev.mysql.com/doc/mysql-ai/9.4/en/mys-ai-aml-get-started.html
The topics in this section go through the process of training and using a machine learning model. Before going through these tasks, make sure to Review Additional AutoML Requirements. To start using AutoML with sample datasets, see Machine Learning ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-table-import.html
Otherwise, the table must be created on the same MySQL server instance into which it is being imported. If the table was created in an external directory by specifying the DATA DIRECTORY clause in the CREATE TABLE statement, the table that you ...As ...
https://dev.mysql.com/doc/refman/8.4/en/mysqldump.html
To work around this issue, use the --result-file option, which creates the output in ASCII format: mysqldump [options] --result-file=dump.sql It is not recommended to load a dump file when GTIDs are enabled on the server (gtid_mode=ON), if your dump ... The mysqldump client utility performs logical backups, producing a set of SQL statements that can be executed to reproduce the original database object definitions and table ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-programs-ndb-restore.html
Such an index is created only when necessary to apply events from the backup log to a table which has an extended primary key. This index is named NDB$RESTORE_PK_MAPPING, and is created on each table requiring it; it can be shared, if necessary, by ...This program reads the files created as a result of the backup and inserts the stored information into the ... The NDB Cluster restoration program is ...
https://dev.mysql.com/doc/refman/8.4/en/partitioning-management-exchange.html
In addition to the ALTER, INSERT, and CREATE privileges usually required for ALTER TABLE statements, you must have the DROP privilege to perform ALTER TABLE ... In addition, both tables must use the same storage engine: mysql> CREATE TABLE es3 LIKE ...Table nt contains no foreign key references, and no other table has any foreign keys that refer to ...
https://dev.mysql.com/doc/refman/8.4/en/grant-tables.html
For example, the 'root'@'localhost' account created during MySQL installation has a row in the proxies_priv table that enables granting the PROXY privilege for ''@'', that is, for all users and all hosts. The mysql system database includes several ...The server is free to ignore rows that become malformed as a result of such ...
https://dev.mysql.com/doc/mysql-shell/9.4/en/mysql-shell-utilities-dump-instance-schema.html
The dumps created by MySQL Shell's instance dump utility, schema dump utility, and table dump utility comprise DDL files specifying the schema structure, and tab-separated .tsv files containing the data. The data for the mysql.apply_status, ...The ... MySQL Shell's instance dump utility util.dumpInstance() and schema dump utility util.dumpSchemas(), support the export of all schemas or a selected schema from an on-premise MySQL instance into an Oracle Cloud Infrastructure Object Storage bucket or a set of local ...
https://dev.mysql.com/doc/refman/8.4/en/analyze-table.html
The sampling-rate value in the HISTOGRAM column of the Information Schema COLUMN_STATISTICS table can be queried to determine the fraction of data that was sampled to create the histogram. row *************************** Table: employees.employees ...ANALYZE [NO_WRITE_TO_BINLOG | LOCAL] TABLE tbl_name UPDATE HISTOGRAM ON col_name [, col_name] ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-tables-table.html
CREATE_OPTIONS shows the ENCRYPTION clause specified for tables created in file-per-table tablespaces. The encryption clause is not shown for tables created in general tablespaces. When creating a table with strict mode disabled, the storage ...The ...To always retrieve the latest statistics directly from storage engines, set information_schema_stats_expiry to ...
https://dev.mysql.com/doc/refman/8.4/en/privileges-provided.html
Renaming a table requires ALTER and DROP on the old table, CREATE, and INSERT on the new table. CREATE Enables use of statements that create new databases and tables. CREATE TABLESPACE Enables use of statements that create, alter, or drop ... The ...