Search Results
https://dev.mysql.com/doc/refman/8.4/en/constraint-foreign-key.html
MySQL supports ON UPDATE and ON DELETE foreign key references in CREATE TABLE and ALTER TABLE statements. Foreign keys let you cross-reference related data across tables, and foreign key constraints help keep this spread-out data consistent. MySQL ...The available referential actions are RESTRICT, CASCADE, SET NULL, and NO ACTION (the ...
https://dev.mysql.com/doc/refman/8.4/en/data-dictionary-file-removal.html
ddl_log.log file: The file contained records of metadata operations generated by data definition statements such as DROP TABLE and ALTER TABLE. Unless otherwise noted, data previously stored in metadata files is now stored in data dictionary tables.
https://dev.mysql.com/doc/refman/8.4/en/faqs-views.html
What happens to a view if an underlying table is dropped or renamed? After a view has been created, it is possible to drop or alter a table or view to which the definition refers. What happens to a view if an underlying table is dropped or renamed? ...Can you insert into views that are based on joins? ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-read-only-instance.html
The same restriction applies to any operation that modifies data dictionary tables, such as ANALYZE TABLE and ALTER TABLE tbl_name ENGINE=engine_name. You can query InnoDB tables where the MySQL data directory is on read-only media by enabling the ...How to Enable To prepare an instance for read-only operation, make sure all the necessary information is flushed to the data files before storing it on the read-only ...
https://dev.mysql.com/doc/refman/8.4/en/keywords.html
Certain keywords, such as SELECT, DELETE, or BIGINT, are reserved and require special treatment for use as identifiers such as table and column names. Reserved words are permitted as identifiers if you quote them as described in Section 11.2, ...
https://dev.mysql.com/doc/internals/en/com-table-dump.html
COM_TABLE_DUMP: dump a table Payload 1 [13] COM_TABLE_DUMP 1 database_len string[$len] [len=database_len] database name 1 table_len string[$len] [len=table_len] tablename Returns a table dump or ERR_Packet .
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-ndbinfo-certificates.html
The certificates table provides information about the certificates used by nodes connecting with TLS link encryption (see Section 25.6.19.5, “TLS Link Encryption for NDB Cluster”). The certificates table contains the following columns: Node_id ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-ndbinfo-cpustat.html
The cpustat table provides per-thread CPU statistics gathered each second, for each thread running in the NDB kernel.
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-ndbinfo-disk-write-speed-aggregate-node.html
The disk_write_speed_aggregate_node table provides aggregated information per node about the speed of disk writes during LCP, backup, and restore operations.
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-ndbinfo-disk-write-speed-aggregate.html
The disk_write_speed_aggregate table provides aggregated information about the speed of disk writes during LCP, backup, and restore operations.