PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/constraint-foreign-key.html
MySQL supports ON UPDATE and ON DELETE foreign key references in CREATE TABLE and ALTER TABLE statements. MATCH FULL, MATCH PARTIAL, and MATCH SIMPLE are allowed, but their use should be avoided, as they cause the MySQL Server to ignore any ON ...
https://dev.mysql.com/doc/refman/8.0/en/create-table-ndb-comment-options.html
This may be suitable for short-lived data which is frequently updated, and where the loss of all data in the unlikely event of a total cluster failure is acceptable. NDB_COLUMN Options NDB_TABLE Options It is possible to set a number of options ...
https://dev.mysql.com/doc/refman/8.0/en/creating-ssl-files-using-openssl.html
This section describes how to use the openssl command to set up SSL certificate and key files for use by MySQL servers and clients. The first example shows a simplified procedure such as you might use from the command line. The first two examples ...
https://dev.mysql.com/doc/refman/8.0/en/data-dictionary-schema.html
If an upgrade is necessary and supported, the server creates data dictionary tables with updated definitions, copies persisted metadata to the new tables, atomically replaces the old tables with the new ones, and reinitializes the data dictionary.
https://dev.mysql.com/doc/refman/8.0/en/data-size.html
The minimum storage length is N bytes to facilitate in-place updates in typical cases. Indexes are good for retrieval, but slow down insert and update operations. Design your tables to minimize their space on the disk. This can result in huge ...
https://dev.mysql.com/doc/refman/8.0/en/document-store-concepts.html
CRUD Operations The four basic operations that can be issued against a collection are Create, Read, Update and Delete (CRUD). In terms of MySQL this means: Create a new document (insertion or addition) Read one or more documents (queries) Update one ... This section explains the concepts introduced as part of using MySQL as a document ...
https://dev.mysql.com/doc/refman/8.0/en/explain-extended.html
As of MySQL 8.0.12, extended information is available for SELECT, DELETE, INSERT, REPLACE, and UPDATE statements. SHOW WARNINGS displays an empty result for other explainable statements (DELETE, INSERT, REPLACE, and UPDATE). The EXPLAIN statement ...
https://dev.mysql.com/doc/refman/8.0/en/explain-for-connection.html
To obtain the execution plan for an explainable statement executing in a named connection, use this statement: EXPLAIN [options] FOR CONNECTION connection_id; EXPLAIN FOR CONNECTION returns the EXPLAIN information that is currently being used to ...
https://dev.mysql.com/doc/refman/8.0/en/external-locking.html
In this case, if the server tries to update a table that myisamchk is using, the server waits for myisamchk to finish before it continues. If you do use external locking option to enable updates to MyISAM tables from many MySQL processes, do not ...
https://dev.mysql.com/doc/refman/8.0/en/faqs-innodb-change-buffer.html
What types of operations modify secondary indexes and result in change buffering? INSERT, UPDATE, and DELETE operations can modify secondary indexes. When is the change buffer flushed? Updated pages are flushed by the same flushing mechanism that ...