Search Results
https://dev.mysql.com/doc/refman/8.4/en/option-modifiers.html
If applied to a system variable that has only a global value, an error occurs. For example, with --maximum-back_log=200, the server produces this error: Maximum value of 'back_log' cannot be set . Some options are “boolean” and control behavior ...
https://dev.mysql.com/doc/refman/8.4/en/partitioning-columns-range.html
Range columns partitioning is similar to range partitioning, but enables you to define partitions using ranges based on multiple column values. In addition, you can define the ranges using columns of types other than integer types. RANGE COLUMNS ...
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 ...