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/optimizer-hints.html
If one subquery is nested within another and both are merged into a semijoin of an outer query, any specification of semijoin strategies for the innermost query are ignored. One means of control over optimizer strategies is to set the ...
https://dev.mysql.com/doc/refman/8.0/en/partitioning-selection.html
Whereas partition pruning applies only to queries, explicit selection of partitions is supported for both queries and a number of DML statements. Explicit selection of partitions and subpartitions for rows matching a given WHERE condition is ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-consumer-filtering.html
Wait Event Consumers These consumers require both global_instrumentation and thread_instrumentation to be YES or they are not checked. Stage Event Consumers These consumers require both global_instrumentation and thread_instrumentation to be YES or ...To enable or disable a consumer, set its ENABLED value to YES or ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-memory-summary-tables.html
Allocating a single byte one million times is not the same as allocating one million bytes a single time; tracking both sizes and counts can expose the difference. Otherwise (that is, both the thread and the instrument are enabled), the memory block ...Operation counts help to understand or tune the overall pressure the server is putting on the memory allocator, which has an impact on ...
https://dev.mysql.com/doc/refman/8.0/en/pluggable-authentication-system-variables.html
(These are both empty by default, so if they are not set, the LDAP server must permit anonymous connections.) The resulting bind LDAP handle is used to search for the user DN, based on the client user name. The following value is the default, which ...If FIDO authentication is attempted and this value is not the one expected by the FIDO device, the device assumes that it is not talking to the correct server and an error ...
https://dev.mysql.com/doc/refman/8.0/en/replication-rules-examples.html
If these operations update both filtered-in and filtered-out tables, the results can vary with the binary logging format. Also, do not use multi-table DML statements that update both filtered-in and filtered-out tables. If you use statement-based or ... If you use a combination of database-level and table-level replication filtering options, the replica first accepts or ignores events using the database options, then it evaluates all events permitted by those options according to the table ...
https://dev.mysql.com/doc/refman/8.0/en/server-status-variables.html
Includes both implicit (InnoDB-created) and explicit (user-created) undo tablespaces, active and inactive. The MySQL server maintains many status variables that provide information about its operation. You can view these variables and their values ...
https://dev.mysql.com/doc/refman/8.0/en/socket-pluggable-authentication.html
If a user named valerie tries the same thing, the plugin finds that the user name and the MySQL user name are both valerie and permits the connection. The server-side auth_socket authentication plugin authenticates clients that connect from the ...
https://dev.mysql.com/doc/refman/8.0/en/spatial-operator-functions.html
The function is implemented for LineString geometries in all spatial reference systems, both Cartesian and geographic. The function is implemented for LineString geometries in all spatial reference systems, both Cartesian and geographic. The ...
https://dev.mysql.com/doc/refman/8.0/en/sql-mode.html
When this manual refers to “strict mode,” it means a mode with either or both STRICT_TRANS_TABLES or STRICT_ALL_TABLES enabled. SELECT DELETE (both single table and multiple table) INSERT LOAD DATA LOAD XML SELECT SLEEP() UPDATE (both single ...