Search Results
https://dev.mysql.com/doc/heatwave/en/mys-hw-secondary-load-partitions.html
Loading Partitions using Secxondary _Load Clause To load partitions into MySQL HeatWave, specify the SECONDARY_LOAD clause in an ALTER TABLE statement with the PARTITION clause. As of MySQL 9.1.0, MySQL HeatWave supports partitions for DB System ...
https://dev.mysql.com/doc/connectors/en/connector-odbc-usagenotes-apptips-microsoft.html
If you want to have MEMO columns instead, change BLOB columns to TEXT with ALTER TABLE. Include a TIMESTAMP column in all tables that you want to be able to update. Include a primary key in each MySQL table you want to use with Access. If you are ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-limitations-bulk-load.html
Use ALTER TABLE to make any changes to the table after LOAD DATA with ALGORITHM=BULK. For versions earlier than MySQL 9.4.0, tables must have a primary key, and the primary key must not have a prefix index. LOAD DATA with ALGORITHM=BULK has the ...
https://dev.mysql.com/doc/refman/8.4/en/column-indexes.html
Note Prefix limits are measured in bytes, whereas the prefix length in CREATE TABLE, ALTER TABLE, and CREATE INDEX statements is interpreted as number of characters for nonbinary string types (CHAR, VARCHAR, TEXT) and number of bytes for binary ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-performance-optimizer-statistics.html
You can use the STATS_PERSISTENT, STATS_AUTO_RECALC, and STATS_SAMPLE_PAGES clauses with CREATE TABLE and ALTER TABLE statements to configure optimizer statistics for individual tables. You can manually modify the mysql.innodb_table_stats and ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-mgm-client-commands.html
Since there is currently no way using ndb_mgm or the mysql client to remove all data from a specific data node or node group, this means that the command succeeds only in the two following cases: After issuing CREATE NODEGROUP in the ndb_mgm client, ...TRUNCATE TABLE does not work for this purpose because this removes only the table data; the data nodes continue to store an NDBCLUSTER table's definition until a DROP TABLE statement is issued that causes the table metadata to be ...
MySQL 8.4 Reference Manual :: 19.2.1.3 Determination of Safe and Unsafe Statements in Binary Logging
https://dev.mysql.com/doc/refman/8.4/en/replication-rbr-safe-unsafe.html
Trigger or stored program updates a table having an AUTO_INCREMENT column. In addition, an INSERT into a table that has a composite primary key containing an AUTO_INCREMENT column that is not the first column of this composite key is unsafe. ON ...
https://dev.mysql.com/doc/refman/8.4/en/slow-query-log.html
Administrative statements include ALTER TABLE, ANALYZE TABLE, CHECK TABLE, CREATE INDEX, DROP INDEX, OPTIMIZE TABLE, and REPAIR TABLE. Note If you specify the TABLE log destination, see Log Tables and “Too many open files” Errors. (Even with ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-compression-background.html
The compressed page size is specified through the CREATE TABLE or ALTER TABLE KEY_BLOCK_SIZE parameter. Specify a value that is too small, and the CREATE TABLE or ALTER TABLE statement fails. An InnoDB table created with ROW_FORMAT=COMPRESSED can ...
https://dev.mysql.com/doc/workbench/en/wb-what-is-new-8.html
Failed login attempts and password lock time in ALTER USER statements. New and changed keywords: ARRAY FAILED_LOGIN_ATTEMPTS MASTER_COMPRESSION_ALGORITHM MASTER_TLS_CIPHERSUITES MASTER_ZSTD_COMPRESSION_LEVEL MEMBER OFF PASSWORD_LOCK_TIME ... This ...