Search Results
https://dev.mysql.com/doc/refman/9.7/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/9.7/en/partitioning-limitations-storage-engines.html
It is not possible under normal circumstances in NDB Cluster to create an NDB Cluster table using any partitioning type other than [LINEAR] KEY, and attempting to do so fails with an error. CREATE TABLE and ALTER TABLE statements that would cause a ... In MySQL 9.7, partitioning support is not actually provided by the MySQL Server, but rather by a table storage engine's own or native partitioning ...
https://dev.mysql.com/doc/refman/9.7/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/9.7/en/partitioning-range.html
A table that is partitioned by range is partitioned in such a way that each partition contains rows for which the partitioning expression value lies within a given range. Ranges should be contiguous but not overlapping, and are defined using the ...
https://dev.mysql.com/doc/refman/9.7/en/password-logging.html
An implication of password rewriting is that statements that cannot be parsed (due, for example, to syntax errors) are not written to the general query log because they cannot be known to be password free. Use cases that require logging of all ...
https://dev.mysql.com/doc/refman/9.7/en/performance-schema-clone-status-table.html
The clone_status table shows the status of the current or last executed cloning operation only. The table only ever contains one row of data, or is empty. The clone_status table has these columns: ID A unique cloning operation identifier in the ...
https://dev.mysql.com/doc/refman/9.7/en/performance-schema-connection-tables.html
When a client connects to the MySQL server, it does so under a particular user name and from a particular host. They differ in that, for grant tables, the host part of an account can be a pattern, whereas for Performance Schema tables, the host ...
https://dev.mysql.com/doc/refman/9.7/en/performance-schema-quick-start.html
Check the server error log for information about what went wrong. This section briefly introduces the Performance Schema with examples that show how to use it. For additional examples, see Section 29.19, “Using the Performance Schema to Diagnose ...
https://dev.mysql.com/doc/refman/9.7/en/performance-schema-replication-group-members-table.html
ERROR: The member has encountered an error, either during applying transactions or during the recovery phase, and is not participating in the group's transactions. This table shows network and status information for replication group members. The ...
https://dev.mysql.com/doc/refman/9.7/en/performance-schema-setup-loggers-table.html
This can be one of the following: logger/sql/error_log logger/sql/general_log The General log does not have a log level. This can be set to one of the following values: none error warn info debug DESCRIPTION: A text description of the logger. For ...