Search Results
https://dev.mysql.com/doc/relnotes/heatwave/en/news-9-3-1.html
This enhancement also makes it easier to load the exported results into a table with a single column of JSON data type, or use the HEATWAVE_LOAD routine to load the exported results into MySQL HeatWave Cluster for further processing. (WL #16778) ...
https://dev.mysql.com/doc/heatwave-aws/en/heatwave-aws-backup-details.html
Table 18-1 Tabs on the Backup Details Page Name Description Details Backup Details. Table 18-2 Backup Details Field Description General information Name: The name of the backup. Table 18-3 Backup Event Details Field Description Type The event and ...
https://dev.mysql.com/doc/heatwave-aws/en/heatwave-aws-server-compatibility.html
The MySQL Shell compatibility option applies the specified requirements for compatibility with MySQL HeatWave on AWS for all tables in the dump output, altering the dump files as necessary. This option modifies the ENGINE= clause of CREATE TABLE ...
https://dev.mysql.com/doc/connector-j/en/connector-j-usagenotes-spring-config-transactional.html
To use transactional database access, we will need to change the storage engine of the tables in the world database. The downloaded script explicitly creates MyISAM tables, which do not support transactional semantics. ALTER TABLE City ... Spring ...
https://dev.mysql.com/doc/refman/8.4/en/blob.html
For example, if a table contains 'a', an attempt to store 'a ' causes a duplicate-key error. This is in contrast to all other data types, for which storage is allocated once per column when the table is opened. A BLOB is a binary large object that ...
https://dev.mysql.com/doc/refman/8.4/en/component-loading.html
For example: INSTALL COMPONENT 'file://component_validate_password'; UNINSTALL COMPONENT 'file://component_validate_password'; A loader service handles component loading and unloading, and also registers loaded components in the mysql.component ...
https://dev.mysql.com/doc/refman/8.4/en/controlling-optimizer.html
The server maintains histogram statistics about column values in the column_statistics data dictionary table (see Section 10.9.6, “Optimizer Statistics”). Like other data dictionary tables, this table is not directly accessible by users. MySQL ...
https://dev.mysql.com/doc/refman/8.4/en/controlling-query-plan-evaluation.html
For join queries, the number of possible plans investigated by the MySQL optimizer grows exponentially with the number of tables referenced in a query. For small numbers of tables (typically less than 7 to 10) this is not a problem. The behavior of ... The task of the query optimizer is to find an optimal plan for executing an SQL ...
https://dev.mysql.com/doc/refman/8.4/en/copying-databases.html
Check the description for the mysqldump --set-gtid-purged option to find what happens with the versions you are using, and how to change the behavior if the outcome of the default behavior is not suitable for your situation. For large tables, this ... In cases where you need to transfer databases between different architectures, you can use mysqldump to create a file containing SQL ...
https://dev.mysql.com/doc/refman/8.4/en/data-dictionary-transactional-storage.html
The data dictionary schema stores dictionary data in transactional (InnoDB) tables. Data dictionary tables are located in the mysql database together with non-data dictionary system tables. Data dictionary tables are created in a single InnoDB ...