Search Results
https://dev.mysql.com/doc/refman/8.4/en/general-tablespaces.html
A general tablespace is a shared InnoDB tablespace that is created using CREATE TABLESPACE syntax. The server keeps tablespace metadata in memory for the lifetime of a tablespace. Multiple tables in fewer general tablespaces consume less memory for ...To make an unknown directory known to InnoDB, add the directory to the innodb_directories argument ...
https://dev.mysql.com/doc/refman/8.4/en/system-schema.html
It contains tables that store information required by the MySQL server as it runs. A broad categorization is that the mysql schema contains data dictionary tables that store database object metadata, and system tables used for other operational ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/glossary.html
It offers the most efficiency and flexibility when backing up InnoDB tables; it can also back up MyISAM and other kinds of tables. B backup The process of copying some or all table data and metadata from a MySQL instance, for safekeeping. binary log ... These terms are commonly used in information about the MySQL Enterprise Backup ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-persistent-stats.html
Optimizer statistics are persisted to disk when innodb_stats_persistent=ON or when individual tables are defined with STATS_PERSISTENT=1. Formerly, optimizer statistics were cleared when restarting the server and after some other types of ... The ...
https://dev.mysql.com/doc/refman/8.4/en/merge-storage-engine.html
The MERGE storage engine, also known as the MRG_MyISAM engine, is a collection of identical MyISAM tables that can be used as one. “Identical” means that all tables have identical column data types and index information. You cannot merge MyISAM ...However, if the user's privileges on t are subsequently revoked, the user can continue to access t by doing so ...
https://dev.mysql.com/doc/ndbapi/en/ndb-dictionary.html
Dictionary::createIndex() Description This method creates an index given an instance of Index and possibly an optional instance of Table. Signature This method can be invoked with or without a reference to a table object: int createIndex ( const ...
https://dev.mysql.com/doc/refman/8.4/en/replication-options-replica.html
On the source and each replica, you must set the server_id system variable to establish a unique replication ID in the range from 1 to 232 − 1. To specify more than one database, use this option multiple times, once for each database; however, ...
https://dev.mysql.com/doc/refman/8.4/en/partitioning-management-range-list.html
For information about working with tables that are partitioned by hash or key, see Section 26.3.2, “Management of HASH and KEY Partitions”. Dropping a partition from a table that is partitioned by either RANGE or by LIST can be accomplished ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/backup-partial-options.html
For an overview of partial backup and restore, as well as usage examples on the following options, see Section 4.3.5, “Making a Partial Backup” and Section 5.1.4, “Table-Level Recovery (TLR)”. --include-tables=REGEXP Command-Line Format ...
https://dev.mysql.com/doc/ndbapi/en/ndb-error-codes-single.html
Backup failed to insert table list (check configuration) 1347 MySQL error. Backup failed to allocate table memory (check configuration) 1348 MySQL error. Table fragment fixed data reference has reached maximum possible value (specify MAXROWS or ...