Search Results
https://dev.mysql.com/doc/mysql-em-plugin/en/myoem-config-metric-performanceschema-category.html
Table 7.27 Performance Schema Configuration Metrics NameDescriptionAccounts Size The number of rows in the accounts table. Digests Size The maximum number of rows in the events_statements_summary_by_digest table. Events Stages History Long Size The ... Lists the Performance Schema configuration metrics and provides a brief description of ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-genai-generate-embeddings.html
You can pass the text string in the routine manually or use data from tables in your database. To embed multiple rows of text stored in a table in a single run, you can even run a batch query. Using this method, you can create vector embedding ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-overview.html
While Lakehouse provides in-memory query processing on data in Object Storage, it does not load data into a DB System table. External Tables When MySQL HeatWave loads data and creates a table from a file in Object Storage, it is an external ... The ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-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/heatwave-aws/en/heatwave-aws-bulk-ingest-limitations.html
Bulk Ingest Limitations 7.2.2.3 Bulk Ingest Limitations The following are some limitations to the Bulk Ingest Feature of MySQL HeatWave on AWS when using the LOAD DATA FROM S3 statement with ALGORITHM=BULK: The target table must be empty. The state ...If needed, set the secondary engine after running LOAD DATA FROM S3 with ...
https://dev.mysql.com/doc/refman/8.4/en/federated-description.html
When you create a table using one of the standard storage engines (such as MyISAM, CSV or InnoDB), the table consists of the table definition and the associated data. When you create a FEDERATED table, the table definition is the same, but the ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-deadlock-example.html
Client A enables innodb_print_all_deadlocks, creates two tables, 'Animals' and 'Birds', and inserts data into each. The following example illustrates how an error can occur when a lock request causes a deadlock. Thererfore, the previous read-only ...
https://dev.mysql.com/doc/refman/8.4/en/known-issues.html
Even if you use lower_case_table_names=2 (which enables MySQL to remember the case used for databases and table names), MySQL does not remember the case used for database names for the function DATABASE() or within the various logs (on ... This ...
https://dev.mysql.com/doc/refman/8.4/en/partitioning-list.html
For more detailed syntactical information, see Section 15.1.20, “CREATE TABLE Statement”. As with the other partitioning examples, we assume that the default_storage_engine is InnoDB.) Suppose that there are 20 video stores distributed among 4 ... List partitioning in MySQL is similar to range partitioning in many ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/backup-performance.html
In an emergency, the time needed to uncompress the backup data before restoring it might be unacceptable. InnoDB Configuration Options Settings As discussed later, there are a number of reasons why you might prefer to run with the setting ... This ...