Search Results
https://dev.mysql.com/doc/heatwave/en/mys-hwgenai-ml-generate-table.html
The ML_GENERATE_TABLE routine runs multiple text generation or summarization queries in a batch, in parallel. context_column: specifies the table column that contains the context to be used for augmenting the queries and guiding the text generation ...The output generated for every input query is the same as the output generated by the ML_GENERATE ...
https://dev.mysql.com/doc/heatwave-aws/en/running-autopilot-index-advisor-using-heatwave-console.html
WARNING:If you drop any indexes that were used in the index hints FORCE INDEX, USE INDEX, or IGNORE INDEX for some queries, those queries will fail to execute. Once the recommendations are applied, queries will start taking advantage of the changes ... Running Autopilot Index Advisor 11.1 Running Autopilot Index Advisor To run Autopilot Index Advisor, the user must connect to the DB system and have the following MySQL privileges: The EXECUTE privilege on the sys ...
https://dev.mysql.com/doc/connector-j/en/connector-j-connp-props-performance-extensions.html
callableStmtCacheSize If 'cacheCallableStmts' is enabled, how many callable statements should be cached? Default Value 100 Since Version 3.1.2 metadataCacheSize The number of queries to cache 'ResultSetMetadata' for if 'cacheResultSetMetaData' is ...Prior to version 8.0.29, this property was named 'parseInfoCacheFactory', which remains as an ...
https://dev.mysql.com/doc/refman/8.4/en/data-dictionary-information-schema.html
When the underlying data dictionary tables store values previously obtained by directory scans (for example, to enumerate database names or table names within databases) or file-opening operations (for example, to read information from .frm files), ...In particular, for each INFORMATION_SCHEMA table that is a view on data dictionary tables: The server no longer must create a temporary table for each query of the INFORMATION_SCHEMA ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-autocommit-commit-rollback.html
If autocommit mode is enabled, each SQL statement forms a single transaction on its own. By default, MySQL starts the session for each new connection with autocommit enabled, so MySQL does a commit after each SQL statement if that statement did not ...
https://dev.mysql.com/doc/refman/8.4/en/insert-on-duplicate.html
SELECT statements, these rules apply regarding acceptable forms of SELECT query expressions that you can refer to in an ON DUPLICATE KEY UPDATE clause: References to columns from queries on a single table, which may be a derived table. References to ... If you specify an ON DUPLICATE KEY UPDATE clause and a row to be inserted would cause a duplicate value in a UNIQUE index or PRIMARY KEY, an UPDATE of the old row ...
https://dev.mysql.com/doc/refman/8.4/en/known-issues.html
With statement-based binary logging, the source server writes the executed queries to the binary log. If and only if the preceding queries have no ORDER BY clause guaranteeing a deterministic order. The easiest way to avoid this problem is to add an ... This section lists known issues in recent versions of ...
https://dev.mysql.com/doc/refman/8.4/en/monitor-innodb-mutex-waits-performance-schema.html
$> ./mysqlslap --auto-generate-sql --concurrency=100 --iterations=10 --number-of-queries=1000 --number-char-cols=6 --number-int-cols=6; Query the wait event data. In this example, wait event data is queried from the ... A mutex is a synchronization ...
https://dev.mysql.com/doc/refman/8.4/en/multiple-column-indexes.html
MySQL can use multiple-column indexes for queries that test all the columns in the index, or queries that test just the first column, the first two columns, the first three columns, and so on. If you specify the columns in the right order in the ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-online-operations.html
MySQL NDB Cluster supports online table schema changes using ALTER TABLE ... NDB Cluster handles COPY and INPLACE as described in the next few paragraphs. For ALGORITHM=COPY, the mysqld NDB Cluster handler performs the following actions: Tells the ...