Search Results
https://dev.mysql.com/doc/refman/8.4/en/backup-methods.html
Making a Hot Backup with MySQL Enterprise Backup Customers of MySQL Enterprise Edition can use the MySQL Enterprise Backup product to do physical backups of entire instances or selected databases, tables, or both. (Ideally, the InnoDB tables should ...Backing up the physical database files makes restore much faster than logical techniques such as the mysqldump ...
https://dev.mysql.com/doc/refman/8.4/en/external-locking.html
External locking is the use of file system locking to manage contention for MyISAM database tables by multiple processes. External locking is used in situations where a single process such as the MySQL server cannot be assumed to be the only ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-online-add-node-remarks.html
The ability to add new nodes online includes a means to reorganize NDBCLUSTER table data and indexes so that they are distributed across all data nodes, including the new ones, by means of the ALTER TABLE ... Table reorganization of both in-memory ... This section provides general information about the behavior of and current limitations in adding NDB Cluster nodes ...
https://dev.mysql.com/doc/refman/8.4/en/partitioning-selection.html
This option always follows the name of the table to which the partition or partitions belong. Each name in this list must be the name of an existing partition or subpartition of the specified table; if any of the partitions or subpartitions are not ... Explicit selection of partitions and subpartitions for rows matching a given WHERE condition is ...
https://dev.mysql.com/doc/refman/8.4/en/rewriter-query-rewrite-plugin-usage.html
The plugin determines whether to rewrite statements based on its in-memory cache of rewriting rules, which are loaded from the rewrite_rules table in the query_rewrite database. The following example creates a simple rule to match statements that ...
https://dev.mysql.com/doc/refman/8.4/en/storage-requirements.html
InnoDB Table Storage Requirements NDB Table Storage Requirements Numeric Type Storage Requirements Date and Time Type Storage Requirements String Type Storage Requirements Spatial Type Storage Requirements JSON Storage Requirements The storage ...
https://dev.mysql.com/doc/refman/8.4/en/time-zone-support.html
This section describes the time zone settings maintained by MySQL, how to load the system tables required for named time support, how to stay current with time zone changes, and how to enable leap-second support. Time Zone Variables Populating the ...Time zone offsets are also supported for inserted datetime values; see Section 13.2.2, “The DATE, DATETIME, and TIMESTAMP Types”, for more ...
https://dev.mysql.com/doc/relnotes/mysql/8.4/en/news-8-4-5.html
If this happens in a table's constraints, default expressions, partitioning expressions, or virtual columns, the table could not be opened. This prevented both analyzing the problem (using, for example, SHOW CREATE TABLE) and addressing it (such as ...(Bug #37570206) Audit Log Notes <COMMAND_CLASS> was not populated for ...
https://dev.mysql.com/doc/refman/8.4/en/create-view.html
(Selecting from the view selects, in effect, using the SELECT statement.) The select_statement can select from base tables or from other views. The SELECT statement can use a VALUES statement as its source, or can be replaced with a TABLE statement, ...If the view does not exist, CREATE OR REPLACE VIEW is the same as CREATE ...
https://dev.mysql.com/doc/refman/8.4/en/data-dictionary-information-schema.html
In particular, for each INFORMATION_SCHEMA table that is a view on data dictionary tables: The server no longer must create a temporary table for each query of the INFORMATION_SCHEMA table. When the underlying data dictionary tables store values ...