Search Results
https://dev.mysql.com/doc/refman/8.4/en/partitioning-key.html
Important For a key-partitioned table, you cannot execute an ALTER TABLE DROP PRIMARY KEY, as doing so generates the error ERROR 1466 (HY000): Field in list of fields for partition function not found in table. Partitioning by key is similar to ...
https://dev.mysql.com/doc/refman/8.4/en/partitioning-list.html
You can cause this type of error to be ignored by using the IGNORE keyword, although a warning is issued for each row containing unmatched partitioning column values, as shown here. List partitioning in MySQL is similar to range partitioning in ...
https://dev.mysql.com/doc/refman/8.4/en/partitioning-maintenance.html
Example: ALTER TABLE t1 REPAIR PARTITION p0,p1; Normally, REPAIR PARTITION fails when the partition contains duplicate key errors. You can check partitions for errors in much the same way that you can use CHECK TABLE with nonpartitioned tables. A ...
https://dev.mysql.com/doc/refman/8.4/en/partitioning-management-exchange.html
Table nt contains no foreign key references, and no other table has any foreign keys that refer to nt. There are no rows in nt that lie outside the boundaries of the partition definition for p. For InnoDB tables, both tables must use the same row ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-build-configuration.html
One indication of this issue is the presence of messages such as the following in the error log: [ERROR] Native table 'performance_schema'.'events_waits_history' has the wrong structure [ERROR] Native table ...It is possible to exclude certain parts ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-connection-attribute-tables.html
For connections initiated using the C API, the libmysqlclient library imposes a limit of 64KB on the aggregate size of connection attribute data on the client side: Calls to mysql_options() that cause this limit to be exceeded produce a ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-ndb-cluster-tables.html
If synchronization of the object fails due to a temporary error, it is picked up and added back to the queue (and to this table) the next time NDB performs mismatch detection; if the attempts fails due a permanent error, the object is added to the ... The following table shows all Performance Schema tables relating to the NDBCLUSTER storage ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-replication-group-member-actions-table.html
ERROR_HANDLING The action that Group Replication takes if an error occurs when the member action is being carried out. IGNORE means that an error message is logged to say that the member action failed, but no further action is taken. CRITICAL means ... This table lists the member actions that are included in the member actions configuration for replication group ...
https://dev.mysql.com/doc/refman/8.4/en/rename-table.html
If any errors occur during a RENAME TABLE, the statement fails and no changes are made. If a table has triggers, attempts to rename the table into a different database fail with a Trigger in wrong schema (ER_TRG_IN_WRONG_SCHEMA) error. Foreign key ... RENAME TABLE tbl_name TO new_tbl_name [, tbl_name2 TO new_tbl_name2] ...
https://dev.mysql.com/doc/refman/8.4/en/replication-administration-status.html
The most common task when managing a replication process is to ensure that replication is taking place and that there have been no errors between the replica and the source. Last_IO_Error, Last_SQL_Error: The last errors registered by the I/O ...