Search Results
https://dev.mysql.com/doc/refman/8.4/en/partitioning-limitations.html
Tables employing user-defined partitioning do not preserve the SQL mode in effect at the time that they were created. Therefore, a change in the SQL mode at any time after the creation of partitioned tables may lead to major changes in the behavior ...Partitioning and repartitioning operations (such as ALTER TABLE with PARTITION BY ..., REORGANIZE PARTITION, or REMOVE PARTITIONING) depend on file system operations for their ...
https://dev.mysql.com/doc/refman/8.4/en/create-tablespace.html
Considerations for InnoDB Considerations for NDB Cluster Options Notes InnoDB Examples NDB Example Considerations for InnoDB CREATE TABLESPACE syntax is used to create general tablespaces or undo tablespaces. The UNDO keyword must be specified to ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-fulltext-index.html
A full-text index is defined as part of a CREATE TABLE statement or added to an existing table using ALTER TABLE or CREATE INDEX. The inverted index is partitioned into six auxiliary index tables to support parallel index creation. Consider ...
https://dev.mysql.com/doc/refman/8.4/en/converting-tables-to-innodb.html
Note Partitioned MyISAM tables created in previous versions of MySQL are not compatible with MySQL 8.4. When you convert MyISAM tables that are large, frequently accessed, and hold vital data, investigate and consider the innodb_file_per_table and ... If you have MyISAM tables that you want to convert to InnoDB for better reliability and scalability, review the following guidelines and tips before ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-tpch-quickstart.html
This quickstart contains the following sections: tpch Requirements Generate tpch Sample Data Create the tpch Sample Database and Import Data Load tpch Data Into MySQL HeatWave Run tpch Queries Additional tpch Queries Unload tpch Tables tpch ... The ...We recommend that you always run the latest version of MySQL Shell, which is currently MySQL version ...
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/internal-temporary-tables.html
In some cases, the server creates internal temporary tables while processing statements. The server creates temporary tables under conditions such as these: Evaluation of UNION statements, with some exceptions described later. Tables created for ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-loading-data-uri.html
As of MySQL 9.3.1, and only on MySQL HeatWave on OCI, you can use uniform resource identifiers (URI) to specify files for loading data when creating external tables manually. Review the following examples for different ways to create external ...To ...This topic contains the following sections: Before You Begin Types of URIs URI Parameters OCIFS URI Examples PAR URI Examples Native URI Examples What's Next Before You Begin To use URIs, you require the same privileges to use pre-authenticated requests and resource ...
https://dev.mysql.com/doc/mysql-monitor/8.0/en/glossary.html
Includes not just SQL SELECT queries, but also DML statements such as INSERT, UPDATE, and DELETE, and DDL statements such as CREATE TABLE and TRUNCATE TABLE. Based on your organization's particular needs, you may create or adapt custom advisors.
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-online-operations.html
For ALGORITHM=COPY, the mysqld NDB Cluster handler performs the following actions: Tells the data nodes to create an empty copy of the table, and to make the required schema changes to this copy. ALGORITHM=INPLACE can be used to perform online ADD ... MySQL NDB Cluster supports online table schema changes using ALTER TABLE ...