PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 296.5Kb
Man Pages (Zip)
- 401.8Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/partitioning-handling-nulls.html
Partitioning in MySQL does nothing to disallow NULL as the value of a partitioning expression, whether it is a column value or the value of a user-supplied expression. Even though it is permitted to use NULL as the value of an expression that must ...
https://dev.mysql.com/doc/refman/8.0/en/partitioning-key.html
Partitioning by key is similar to partitioning by hash, except that where hash partitioning employs a user-defined expression, the hashing function for key partitioning is supplied by the MySQL server. NDB Cluster uses MD5() for this purpose; for ...
https://dev.mysql.com/doc/refman/8.0/en/partitioning-management.html
There are a number of ways using SQL statements to modify partitioned tables; it is possible to add, drop, redefine, merge, or split existing partitions using the partitioning extensions to the ALTER TABLE statement. There are also ways to obtain ...
https://dev.mysql.com/doc/refman/8.0/en/partitioning-overview.html
Partition selection is also supported for the data modification statements DELETE, INSERT, REPLACE, UPDATE, and LOAD DATA, LOAD XML. This section provides a conceptual overview of partitioning in MySQL 8.0. For information on partitioning ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-build-configuration.html
If you install MySQL over a previous installation that was configured without the Performance Schema (or with an older version of the Performance Schema that has missing or out-of-date tables). It is possible to exclude certain parts of the ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-error-log-table.html
The LOGGED column stores values using the TIMESTAMP data type, for which values are stored in UTC but displayed when retrieved in the current session time zone; see Section 13.2.2, “The DATE, DATETIME, and TIMESTAMP Types”. Of the logs the ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-instrumentation-checking.html
This information is always up to date for your version of MySQL, also includes instrumentation for instrumented plugins you might have installed that are not part of the core server, and can be used by automated tools. It is always possible to ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-statement-digests.html
A normalized statement does not retain information such as names, passwords, dates, and so forth. The Performance Schema updates all three columns each time it chooses a sample statement. The MySQL server is capable of maintaining statement digest ...
https://dev.mysql.com/doc/refman/8.0/en/point-in-time-recovery.html
(The full backup can be made in several ways, such as those listed in Section 9.2, “Database Backup Methods”.) Point-in-time recovery then brings the server up to date incrementally from the time of the full backup to a more recent time.
https://dev.mysql.com/doc/refman/8.0/en/problems-with-null.html
When reading data with LOAD DATA, empty or missing columns are updated with ''. Under certain conditions, if you insert NULL into a TIMESTAMP column, the current date and time is inserted; this behavior depends in part on the server SQL mode (see ...