Search Results
https://dev.mysql.com/doc/refman/8.4/en/packet-too-large.html
A communication packet is a single SQL statement sent to the MySQL server, a single row that is sent to the client, or a binary log event sent from a replication source server to a replica. The largest possible packet that can be transmitted to or ...
https://dev.mysql.com/doc/refman/8.4/en/partitioning-columns-list.html
See Section 15.1.20, “CREATE TABLE Statement”, for additional information about PARTITION BY LIST COLUMNS() syntax. This is a variant of LIST partitioning that enables the use of multiple columns as partition keys, and for columns of data types ...
https://dev.mysql.com/doc/refman/8.4/en/partitioning-limitations-functions.html
This section discusses limitations in MySQL Partitioning relating specifically to functions used in partitioning expressions. Each of these functions returns an integer only if it is passed an argument of an exact numeric type, such as one of the ...
https://dev.mysql.com/doc/refman/8.4/en/partitioning-limitations-storage-engines.html
CREATE TABLE and ALTER TABLE statements that would cause a user-partitioned NDB table not to meet either or both of the following two requirements are not permitted, and fail with an error: The table must have an explicit primary key. In MySQL 8.4, ...
https://dev.mysql.com/doc/refman/8.4/en/partitioning-linear-hash.html
MySQL also supports linear hashing, which differs from regular hashing in that linear hashing utilizes a linear powers-of-two algorithm whereas regular hashing employs the modulus of the hashing function's value. We call this value V; it can be ...
https://dev.mysql.com/doc/refman/8.4/en/partitioning-management-hash-key.html
Tables which are partitioned by hash or by key are very similar to one another with regard to making changes in a partitioning setup, and both differ in a number of ways from tables which have been partitioned by range or list. For that reason, ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-build-configuration.html
For example, to exclude stage and statement instrumentation, do this: $> cmake . \ -DDISABLE_PSI_STAGE=1 \ -DDISABLE_PSI_STATEMENT=1 For more information, see the descriptions of the DISABLE_PSI_XXX CMake options in Section 2.8.7, “MySQL ...It is ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-miscellaneous-tables.html
user_defined_functions: Loadable functions registered by a component, plugin, or CREATE FUNCTION statement. The following sections describe tables that do not fall into the table categories discussed in the preceding sections: ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-replication-applier-global-filters-table.html
CONFIGURED_BY The method used to configure the replication filter, can be one of: CHANGE_REPLICATION_FILTER configured by a global replication filter using a CHANGE REPLICATION FILTER statement. This table shows the global replication filters ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-replication-tables.html
This is similar to the information available from the SHOW REPLICA STATUS statement, but representation in table form is more accessible and has usability benefits: SHOW REPLICA STATUS output is useful for visual inspection, but not so much for ...