Search Results
https://dev.mysql.com/doc/refman/8.4/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.4/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.4. For information on partitioning ...
https://dev.mysql.com/doc/refman/8.4/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.4/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.4/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.4/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.4/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.4/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 ...
https://dev.mysql.com/doc/refman/8.4/en/replication-options-source.html
An unexpected exit of the source server and failover to the replica is lossless because the replica is up to date. This section describes the server options and system variables that you can use on replication source servers. You can specify the ...
https://dev.mysql.com/doc/refman/8.4/en/replication-semisync-interface.html
An unexpected exit of the source and failover to the replica is lossless because the replica is up to date. When you install the source and replica plugins for semisynchronous replication (see Section 19.4.10.1, “Installing Semisynchronous ...