Search Results
https://dev.mysql.com/doc/heatwave-aws/en/heatwave-aws-importing-data-bulk-ingesting.html
For example, the following query creates a new database, airportdb, and selects the database for further actions: CREATE DATABASE airportdb; USE airportdb; Use an existing empty table or create a new table. <Table-name>: Specify an already existing ... Importing Data Using the Bulk Ingest Feature 7.2.2.2 Importing Data Using the Bulk Ingest Feature Connect to a DB System and bulk ingest data from an Amazon S3 bucket to a DB System in the same ...
https://dev.mysql.com/doc/refman/8.4/en/column-indexes.html
The maximum number of indexes per table and the maximum index length is defined per storage engine. All storage engines support at least 16 indexes per table and a total index length of at least 256 bytes. For example: CREATE TABLE test (blob_col ...
https://dev.mysql.com/doc/refman/8.4/en/creating-accounts.html
Account-management statements cause the server to make appropriate modifications to the underlying grant tables, which are discussed in Section 8.2.3, “Grant Tables”. Note Direct modification of grant tables using statements such as INSERT, ...
https://dev.mysql.com/doc/refman/8.4/en/ddl-rewriter.html
MySQL 8.4 includes a ddl_rewriter plugin that modifies CREATE TABLE statements received by the server before it parses and executes them. The plugin removes ENCRYPTION, DATA DIRECTORY, and INDEX DIRECTORY clauses, which may be helpful when ...For ...
https://dev.mysql.com/doc/refman/8.4/en/drop-index.html
algorithm_option: ALGORITHM [=] {DEFAULT | INPLACE | COPY} lock_option: LOCK [=] {DEFAULT | NONE | SHARED | EXCLUSIVE} DROP INDEX drops the index named index_name from the table tbl_name. This statement is mapped to an ALTER TABLE statement to drop ...This is done automatically by the server whenever it determines that it is possible to do so; you do not have to use any special SQL syntax or server options to cause it to ...
https://dev.mysql.com/doc/refman/8.4/en/events-privileges.html
Since the user does not have the INSERT privilege for the table in question, the event has no effect. If you inspect the MySQL error log (hostname.err), you can see that the event is executing, but the action it is attempting to perform fails: ...
https://dev.mysql.com/doc/refman/8.4/en/example-auto-increment.html
To start with an AUTO_INCREMENT value other than 1, set that value with CREATE TABLE or ALTER TABLE, like this: mysql> ALTER TABLE tbl AUTO_INCREMENT = 100; InnoDB Notes For information about AUTO_INCREMENT usage specific to InnoDB, see Section ...
https://dev.mysql.com/doc/refman/8.4/en/identifier-length.html
The following table describes the maximum length for each type of identifier. For constraint definitions that include no constraint name, the server internally generates a name derived from the associated table name. For example, internally ...You ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-buffer-pool-resize.html
Before you change innodb_buffer_pool_chunk_size, calculate the effect on innodb_buffer_pool_size to ensure that the resulting buffer pool size is acceptable. Monitoring Online Buffer Pool Resizing Progress The Innodb_buffer_pool_resize_status ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-buffer-pool.html
The buffer pool is an area in main memory where InnoDB caches table and index data as it is accessed. A table scan, performed for a mysqldump operation or a SELECT statement with no WHERE clause, for example, can bring a large amount of data into ...The buffer pool permits frequently used data to be accessed directly from memory, which speeds up ...