Search Results
https://dev.mysql.com/doc/refman/8.4/en/memory-storage-engine.html
The MEMORY storage engine (formerly known as HEAP) creates special-purpose tables with contents that are stored in memory. Characteristics of MEMORY Tables The MEMORY storage engine does not create any files on disk. DDL Operations for MEMORY ...A ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-replication-schema.html
The ndb_binlog_index and ndb_apply_status tables are created in the mysql database. User intervention is normally not required to create or maintain either of these tables, since both are maintained by the NDB binary log (binlog) injector thread.
https://dev.mysql.com/doc/refman/8.4/en/grant.html
CREATE TABLESPACE Enable tablespaces and log file groups to be created, altered, or dropped. To create or drop a trigger, you must have the TRIGGER privilege for the table, not the trigger. (GRANT does not create such rows when ...(Alternatively, if ...[WITH GRANT OPTION] [AS user [WITH ROLE DEFAULT | NONE | ALL | ALL EXCEPT role [, role ] ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/glossary.html
I .ibd file Each InnoDB tablespace created using the file-per-table setting has a filename with a .ibd extension. .ibz file When the MySQL Enterprise Backup product performs a compressed backup, it transforms each tablespace file that is created ...
https://dev.mysql.com/doc/refman/8.4/en/partitioning-management-range-list.html
If you now execute a SHOW CREATE TABLE statement, you can see how the partitioning makeup of the table has been changed: mysql> SHOW CREATE TABLE tr\G *************************** 1. Another solution might appear to be to make a copy of the table ...
https://dev.mysql.com/doc/ndbapi/en/ndb-error-codes-single.html
Create foreign key failed in NDB - parent table is not table 21023 MySQL error. Create foreign key failed in NDB - invalid parent table version 21024 MySQL error. Create foreign key failed in NDB - child table is not table 21025 MySQL error. Create ...Backup failed to insert table list (check configuration) 1347 MySQL ...
https://dev.mysql.com/doc/refman/8.4/en/merge-table-problems.html
The following are known problems with MERGE tables: MERGE child tables are locked through the parent table. If the parent is a temporary table, it is not locked, and thus the child tables are also not locked; this means that parallel use of the ...
https://dev.mysql.com/doc/refman/8.4/en/merge-storage-engine.html
When you create a MERGE table, MySQL creates a .MRG file on disk that contains the names of the underlying MyISAM tables that should be used as one. Note The use of MERGE tables entails the following security issue: If a user has access to MyISAM ...
https://dev.mysql.com/doc/refman/8.4/en/create-tablespace.html
Considerations for InnoDB Considerations for NDB Cluster Options Notes InnoDB Examples NDB Example Considerations for InnoDB CREATE TABLESPACE syntax is used to create general tablespaces or undo tablespaces. The UNDO keyword must be specified to ...
https://dev.mysql.com/doc/refman/8.4/en/alter-table-partition-operations.html
This clause always begins with PARTITION BY, and follows the same syntax and other rules as apply to the partition_options clause for CREATE TABLE (for more detailed information, see Section 15.1.20, “CREATE TABLE Statement”), and can also be ...