PDF (US Ltr)
- 43.2Mb
PDF (A4)
- 43.3Mb
Man Pages (TGZ)
- 295.2Kb
Man Pages (Zip)
- 400.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/geometry-well-formedness-validity.html
It is permitted to insert, select, and update geometrically invalid geometries, but they must be syntactically well-formed. For geometry values, MySQL distinguishes between the concepts of syntactically well-formed and geometrically valid. Spatial ...Spatial import functions that parse WKT or WKB values raise an error for attempts to create a geometry that is not syntactically ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-deploying-in-multi-primary-or-single-primary-mode.html
ON means single-primary mode, which is the default mode, and OFF means multi-primary mode. In MySQL 8.0.13 and later, you can use the group_replication_switch_to_single_primary_mode() and group_replication_switch_to_multi_primary_mode() functions to ... Group Replication operates either in single-primary mode or in multi-primary ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-index-types.html
To get the best performance from queries, inserts, and other database operations, it is important to understand how InnoDB uses the clustered index to optimize the common lookup and DML operations. If there is no logical unique and non-null column ... Each InnoDB table has a special index called the clustered index that stores row ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-locking-transaction-model.html
To implement a large-scale, busy, or highly reliable database application, to port substantial code from a different database system, or to tune MySQL performance, it is important to understand InnoDB locking and the InnoDB transaction model. This ...Section 17.7.3, “Locks Set by Different SQL Statements in InnoDB” discusses specific types of locks set in InnoDB for various ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-replication-abbreviations.html
Throughout this section, we use the following abbreviations or symbols for referring to the source and replica clusters, and to processes and commands run on the clusters or cluster nodes: Table 25.69 Abbreviations used throughout this section ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-enterprise-data-masking.html
MySQL Enterprise Edition 5.7 and higher includes MySQL Enterprise Data Masking and De-Identification, implemented as a plugin library containing a plugin and several loadable functions. MySQL Enterprise Data Masking and De-Identification functions ...Data masking hides sensitive information by replacing real values with ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-shell-tutorial-javascript-indexes-create.html
Without an index, MySQL must begin with the first document and then read through the entire collection to find the relevant fields. If a collection is large and queries on a specific field are common, then consider creating an index on a specific ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-shell-tutorial-python-documents-index.html
Without an index, MySQL must begin with the first document and then read through the entire collection to find the relevant fields. If a collection is large and queries on a specific field are common, then consider creating an index on a specific ...
https://dev.mysql.com/doc/refman/8.0/en/password-logging.html
Passwords can be written as plain text in SQL statements such as CREATE USER, GRANT and SET PASSWORD. PASSWORD ...) Passwords in those statements are rewritten to not appear literally in statement text written to the general query log, slow query ...If such statements are logged by the MySQL server as written, passwords in them become visible to anyone with access to the ...
https://dev.mysql.com/doc/refman/8.0/en/replication-features-row-searches.html
If there are suitable indexes, one index is selected from the candidates, in the following priority order: A primary key. If the row is found in the hash table, the record in the target table is updated, and the row is deleted from the hash table.