Search Results
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-online-add-node-basics.html
Exception: For tables created using the MAX_ROWS option, this statement does not work; instead, use ALTER TABLE ... ALGORITHM=INPLACE, REORGANIZE PARTITION statement in the mysql client for each NDBCLUSTER table. Note This needs to be done only for ... In this section, we list the basic steps required to add new data nodes to an NDB ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-exclude-table-columns.html
To exclude a column, specify the NOT SECONDARY column attribute in an ALTER TABLE or CREATE TABLE statement, as shown below. mysql> ALTER TABLE tbl_name MODIFY column_name datatype NOT SECONDARY; mysql> CREATE TABLE tbl_name ( column_1 datatype, ...
https://dev.mysql.com/doc/refman/8.4/en/creating-tables.html
If you make a poor choice and it turns out later that you need a longer field, MySQL provides an ALTER TABLE statement. You want a table that contains a record for each of your pets. This can be called the pet table, and it should contain, as a bare ...For example, if more than one person in your family keeps pets, you might want to list each animal's ...
https://dev.mysql.com/doc/refman/8.4/en/json-search-functions.html
Queries using JSON_CONTAINS() on InnoDB tables can be optimized using multi-valued indexes; see Multi-Valued Indexes, for more information. row *************************** id: 1 select_type: SIMPLE table: jemp partitions: NULL type: range ... The ...
https://dev.mysql.com/doc/refman/8.4/en/show-index.html
row *************************** Table: city Non_unique: 1 Key_name: CountryCode Seq_in_index: 1 Column_name: CountryCode Collation: A Cardinality: 232 Sub_part: NULL Packed: NULL Null: Index_type: BTREE Comment: Index_comment: Visible: YES ... SHOW ...The WHERE clause can be given to select rows using more general conditions, as discussed in Section 28.8, “Extensions to SHOW ...
https://dev.mysql.com/doc/refman/8.4/en/audit-log-installation.html
Alternatively, you can reinstall the plugin after upgrading MySQL to load new functions. $> mysql -u root -p -D mysql < audit_log_filter_linux_install.sql Enter password: (enter root password here) It is possible to specify a custom database for ...
https://dev.mysql.com/doc/refman/8.4/en/creating-spatial-indexes.html
To drop spatial indexes, use ALTER TABLE or DROP INDEX: With ALTER TABLE: ALTER TABLE geom DROP INDEX g; With DROP INDEX: DROP INDEX g ON geom; Example: Suppose that a table geom contains more than 32,000 geometries, which are stored in the column g ... For InnoDB and MyISAM tables, MySQL can create spatial indexes using syntax similar to that for creating regular indexes, but using the SPATIAL ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-file-defragmenting.html
To speed up index scans, you can periodically perform a “null” ALTER TABLE operation, which causes MySQL to rebuild the table: ALTER TABLE tbl_name ENGINE=INNODB You can also use ALTER TABLE tbl_name FORCE to perform a “null” alter operation ...One symptom of fragmentation is that a table takes more space than it “should” ... Random ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-online-ddl.html
The online DDL feature provides support for instant and in-place table alterations and concurrent DML. You can control aspects of a DDL operation using the ALGORITHM and LOCK clauses of the ALTER TABLE statement. For example: ALTER TABLE tbl_name ...Benefits of this feature include: Improved responsiveness and availability in busy production environments, where making a table unavailable for minutes or hours is not ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-secondary-load.html
Loading Tables Statement To load a table into MySQL HeatWave, specify the SECONDARY_LOAD clause in an ALTER TABLE statement and use the following syntax. ALTER TABLE table_name SECONDARY_LOAD [PARTITION (...)] [GUIDED {ON | OFF}]; Specify the ...The ...