Search Results
https://dev.mysql.com/doc/ndbapi/en/ndb-start-mysql-data-types.html
You can do this by executing a copying ALTER TABLE operation on any table that uses the old temporals, or by backing up and restoring any such tables. This section provides information about the way in which MySQL data types are represented in ...
https://dev.mysql.com/doc/refman/8.4/en/replication-features-auto-increment.html
Adding an AUTO_INCREMENT column to a table with ALTER TABLE might not produce the same ordering of the rows on the replica and the source. Regardless of the method used to create and populate the copy having the AUTO_INCREMENT column, the final step ...(Bug #45677) An INSERT into a table that has a composite primary key that includes an AUTO_INCREMENT column that is not the first column of this composite key is not safe for statement-based logging or ... Statement-based replication of AUTO_INCREMENT, LAST_INSERT_ID(), and TIMESTAMP ...
https://dev.mysql.com/doc/relnotes/mysql/8.4/en/news-8-4-1.html
(Bug #113500, Bug #36137217) Bugs Fixed InnoDB: MySQL unexpectedly halted on an UPDATE after an ALTER TABLE operation. It was removed due to a critical issue that could stop the server from restarting following the creation of a very large number of ...Now pruning continues in such cases, but with a warning printed in the error log stating that it was not possible to delete the missing audit log ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-limitations-limits.html
Note Bulk loading, TRUNCATE TABLE, and ALTER TABLE are handled as special cases by running multiple transactions, and so are not subject to this limitation. Memory consumed when data is inserted into an NDB table is not automatically recovered when ... In this section, we list limits found in NDB Cluster that either differ from limits found in, or that are not found in, standard ...
https://dev.mysql.com/doc/refman/8.4/en/show-tables.html
The optional EXTENDED modifier causes SHOW TABLES to list hidden tables created by failed ALTER TABLE statements. SHOW [EXTENDED] [FULL] TABLES [{FROM | IN} db_name] [LIKE 'pattern' | WHERE expr] SHOW TABLES lists the non-TEMPORARY tables in a ...
https://dev.mysql.com/doc/refman/8.4/en/view-restrictions.html
(This is another reason you might wish to force MySQL to use the temptable algorithm by specifying ALGORITHM = TEMPTABLE in the view definition.) You can use DROP TABLE or ALTER TABLE to drop or alter a table that is used in a view definition. CHECK ... The maximum number of tables that can be referenced in the definition of a view is ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-limitations-all.html
Running ALTER TABLE statements that construct indexes, ADD or DROP columns, or add enforced check constraints. Running CREATE TABLE or ALTER TABLE statement containing a STORAGE clause in the column attributes of a Lakehouse table. Enable ... MySQL ...
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 ...
https://dev.mysql.com/doc/refman/8.4/en/change-replication-source-to.html
REQUIRE_TABLE_PRIMARY_KEY_CHECK = {STREAM | ON | OFF | GENERATE} This option lets a replica set its own policy for primary key checks, as follows: ON: The replica sets sql_require_primary_key = ON; any replicated CREATE TABLE or ALTER TABLE ...If ...
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 ...