Search Results
https://dev.mysql.com/doc/refman/8.4/en/create-table-files.html
For an InnoDB table created in a file-per-table tablespace or general tablespace, table data and associated indexes are stored in a .ibd file in the database directory. When an InnoDB table is created in the system tablespace, table data and ...
https://dev.mysql.com/doc/refman/8.4/en/create-table-foreign-keys.html
MySQL supports foreign keys, which permit cross-referencing related data across tables, and foreign key constraints, which help keep the related data consistent. A foreign key relationship involves a parent table that holds the initial column ...
https://dev.mysql.com/doc/refman/8.4/en/create-table-ndb-comment-options.html
NDB_COLUMN Options NDB_TABLE Options It is possible to set a number of options specific to NDB Cluster in the table comment or column comments of an NDB table. Table-level options for controlling read from any replica and partition balance can be ...
https://dev.mysql.com/doc/refman/8.4/en/create-view.html
If the view does not exist, CREATE OR REPLACE VIEW is the same as CREATE VIEW. If the view does exist, CREATE OR REPLACE VIEW replaces it. For information about restrictions on view use, see Section 27.9, “Restrictions on Views”. The ...
https://dev.mysql.com/doc/refman/8.4/en/creating-accounts.html
To manage MySQL accounts, use the SQL statements intended for that purpose: CREATE USER and DROP USER create and remove accounts. GRANT and REVOKE assign privileges to and revoke privileges from accounts. Account-management statements cause the ...
https://dev.mysql.com/doc/refman/8.4/en/data-dictionary-object-cache.html
The dictionary object cache is a shared global cache that stores previously accessed data dictionary objects in memory to enable object reuse and minimize disk I/O. Similar to other cache mechanisms used by MySQL, the dictionary object cache uses ...
https://dev.mysql.com/doc/refman/8.4/en/diagnostics-area.html
SQL statements produce diagnostic information that populates the diagnostics area. Standard SQL has a diagnostics area stack, containing a diagnostics area for each nested execution context. Standard SQL also supports GET STACKED DIAGNOSTICS syntax ...
https://dev.mysql.com/doc/refman/8.4/en/docker-mysql-more-topics.html
"Mounts": [ { "Type": "volume", "Name": "4f2d463cfc4bdd4baebcb098c97d7da3337195ed2c6572bc0b89f7e845d27652", "Source": "/var/lib/docker/volumes/4f2d463cfc4bdd4baebcb098c97d7da3337195ed2c6572bc0b89f7e845d27652/_data", "Destination": "/var/lib/mysql", ...A MySQL Docker installation is different from a common, non-Docker installation in the following aspects: Only a limited number of binaries are ...
https://dev.mysql.com/doc/refman/8.4/en/error-handling.html
This appendix describes the types of error information MySQL provides and how to obtain information about them. It describes common problems and errors that may occur and potential resolutions.
https://dev.mysql.com/doc/refman/8.4/en/error-log.html
This section discusses how to configure the MySQL server for logging of diagnostic messages to the error log. For information about selecting the error message character set and language, see Section 12.6, “Error Message Character Set”, and ...