PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.5Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/replication-solutions-unexpected-replica-halt.html
In order for replication to be resilient to unexpected halts of the server (sometimes described as crash-safe) it must be possible for the replica to recover its state before halting. This section describes the impact of an unexpected halt of a ...
https://dev.mysql.com/doc/refman/8.0/en/roles.html
Even with this safeguard, it is better to avoid granting the SYSTEM_USER privilege through a role in order to guard against the possibility of privilege escalation. Like user accounts, roles can have privileges granted to and revoked from them. A ...
https://dev.mysql.com/doc/refman/8.0/en/security-guidelines.html
To create a secure passphrase, ensure that the words and other items in it are not a known phrase or quotation, do not occur in a predictable order, and preferably have no previous relationship to each other at all. Anyone using MySQL on a computer ...
https://dev.mysql.com/doc/refman/8.0/en/server-configuration-validation.html
(Executing the preceding example with the option order reversed produces a message that --defaults-file itself is unknown.) . As of MySQL 8.0.16, MySQL Server supports a --validate-config option that enables the startup configuration to be checked ...
https://dev.mysql.com/doc/refman/8.0/en/server-options.html
If both --defaults-file and --local-service are given following the service name, they can be in any order. When you start the mysqld server, you can specify program options using any of the methods described in Section 6.2.2, “Specifying Program ...
https://dev.mysql.com/doc/refman/8.0/en/server-shutdown.html
Since nontransactional statements cannot be rolled back, in order to guarantee crash-safe replication, only transactional tables should be used. The server shutdown process takes place as follows: The shutdown process is initiated. For example, a ...
https://dev.mysql.com/doc/refman/8.0/en/show-columns.html
If more than one of the Key values applies to a given column of a table, Key displays the one with the highest priority, in the order PRI, UNI, MUL. SHOW [EXTENDED] [FULL] {COLUMNS | FIELDS} {FROM | IN} tbl_name [{FROM | IN} db_name] [LIKE ...
https://dev.mysql.com/doc/refman/8.0/en/show-profile.html
For example, the following queries are equivalent: SHOW PROFILE FOR QUERY 2; SELECT STATE, FORMAT(DURATION, 6) AS DURATION FROM INFORMATION_SCHEMA.PROFILING WHERE QUERY_ID = 2 ORDER BY SEQ; . Note The SHOW PROFILE and SHOW PROFILES statements are ...
https://dev.mysql.com/doc/refman/8.0/en/sorted-index-builds.html
The right-most leaf page at the necessary B-tree depth is allocated and entries are inserted according to their sorted order. InnoDB performs a bulk load instead of inserting one index record at a time when creating or rebuilding indexes. This ...
https://dev.mysql.com/doc/refman/8.0/en/spatial-aggregate-functions.html
MySQL supports aggregate functions that perform a calculation on a set of values. For general information about these functions, see Section 14.19.1, “Aggregate Function Descriptions”. ST_Collect() can be used as a window function, as signified ...