Search Results
https://dev.mysql.com/doc/refman/8.4/en/create-index.html
This guideline is especially important for InnoDB tables, where the primary key determines the physical layout of rows in the data file. CREATE INDEX is mapped to an ALTER TABLE statement to create indexes. CREATE INDEX cannot be used to create a ...
https://dev.mysql.com/doc/refman/8.4/en/myisamchk.html
The myisamchk utility gets information about your database tables or checks, repairs, or optimizes them. myisamchk works with MyISAM tables (tables that have .MYD and .MYI files for storing data and indexes). You can also use the CHECK TABLE and ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-auto-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. Review the following examples for different ways to create external tables. These ...To learn more, see Load Structured Data Using Lakehouse Auto Parallel ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-compression-tuning.html
However, because the efficiency of compression depends on the nature of your data, you can make decisions that affect the performance of compressed tables: Which tables to compress. If the system performs DML operations on compressed tables, and the ... Most often, the internal optimizations described in InnoDB Data Storage and Compression ensure that the system runs well with compressed ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-compression-usage.html
Compressed tables can be created in file-per-table tablespaces or in general tablespaces. The system tablespace (space 0, the .ibdata files) can contain user-created tables, but it also contains internal system data, which is never compressed. You ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-ndbd-definition.html
Information about configuration parameters specific to NDB Cluster Disk Data tables can be found later in this section (see Disk Data Configuration Parameters). (NDB 8.4.0) This global parameter can be set only in the [ndbd default] section, and ...
https://dev.mysql.com/doc/refman/8.4/en/privileges-provided.html
Privileges for database objects such as tables, indexes, views, and stored routines can be granted for specific objects within a database, for all objects of a given type within a database (for example, all tables in a database), or globally for all ... The privileges granted to a MySQL account determine which operations the account can ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-selective-load.html
Available as of MySQL 9.1.2, you can update external tables using Selective Load, which lets you edit the list of files that comprise an external table without altering the directories in the Object Storage bucket. This topic contains the following ...Note the following points about the ENGINE_ATTRIBUTE option: Ensure that the ENGINE_ATTRIBUTE option specifies all the files to be ...
https://dev.mysql.com/doc/refman/8.4/en/create-table-gipks.html
MySQL 8.4 supports generated invisible primary keys for any InnoDB table that is created without an explicit primary key. When the sql_generate_invisible_primary_key server system variable is set to ON, the MySQL server automatically adds a ...By ...
https://dev.mysql.com/doc/connectors/en/connector-python-example-ddl.html
The following examples show how to create the tables of the Employee Sample Database. In a MySQL server, tables are very long-lived objects, and are often accessed by multiple applications written in different languages. You might typically work ...