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/reset-persist.html
RESET PERSIST [[IF EXISTS] system_var_name] RESET PERSIST removes persisted global system variable settings from the mysqld-auto.cnf option file in the data directory. Removing a persisted system variable causes the variable no longer to be ...
https://dev.mysql.com/doc/refman/8.0/en/resignal.html
RESIGNAL makes it possible to both handle an error and return the error information. The RESIGNAL statement takes condition_value and SET clauses, both of which are optional. RESIGNAL may change some or all information before passing it on. RESIGNAL ...
https://dev.mysql.com/doc/refman/8.0/en/reusing-ssl-sessions.html
Server-Side Runtime Configuration and Monitoring for SSL Session Reuse Client-Side Configuration for SSL Session Reuse Each full TLS exchange can be costly both in terms of computation and network overhead, less costly if TLSv1.3 is used. SSL ... As ...
https://dev.mysql.com/doc/refman/8.0/en/role-names.html
It is possible for a row in the mysql.user system table to serve as both an account and a role. Specifying a role with a non-'%' host part can be useful if you intend to create a name that works both as a role an as a user account that is permitted ... MySQL role names refer to roles, which are named collections of ...
https://dev.mysql.com/doc/refman/8.0/en/show-replica-status.html
When run concurrently with STOP REPLICA, SHOW REPLICA STATUS returns without waiting for STOP REPLICA to finish shutting down the replication SQL (applier) thread or replication I/O (receiver) thread (or both). SQL_AFTER_GTIDS if the replication ...
https://dev.mysql.com/doc/refman/8.0/en/sorted-index-builds.html
Sorted Index Builds and Compressed Tables For compressed tables, the previous index creation method appended entries to both compressed and uncompressed pages. InnoDB performs a bulk load instead of inserting one index record at a time when ...
https://dev.mysql.com/doc/refman/8.0/en/spatial-convenience-functions.html
If both geometry parameters are valid Cartesian Point or MultiPoint values in SRID 0, the return value is shortest distance between the two geometries on a sphere with the provided radius. If both geometry parameters are valid Point or MultiPoint ...
https://dev.mysql.com/doc/refman/8.0/en/subquery-materialization.html
For example, the optimizer might be able to use materialization if both expressions are integer or both are decimal, but cannot if one expression is integer and the other is decimal. The optimizer uses materialization to enable more efficient ...
https://dev.mysql.com/doc/refman/8.0/en/switchable-optimizations.html
If semijoin and materialization are both on, semijoins also use materialization where applicable. If semijoin and materialization are both on, semijoins also use materialization where applicable. Its value is a set of flags, each of which has a ...
https://dev.mysql.com/doc/refman/8.0/en/symbolic-links-to-tables.html
Note The path used with either or both of the DATA DIRECTORY and INDEX DIRECTORY options may not include the MySQL data directory. Note When you drop a table that is using symlinks, both the symlink and the file to which the symlink points are ...