PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 296.5Kb
Man Pages (Zip)
- 401.8Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/mysqlcheck.html
(This is also true for the MySQL upgrade procedure if it determines that table checking is needed because it processes tables the same way.) mysqlcheck must be used when the mysqld server is running, which means that you do not have to stop the ...
https://dev.mysql.com/doc/refman/8.0/en/mysqld-safe.html
(See Section 2.1.5, “Installation Layouts”.) mysqld_safe expects one of the following conditions to be true: The server and databases can be found relative to the working directory (the directory from which mysqld_safe is invoked). mysqld_safe ...
https://dev.mysql.com/doc/refman/8.0/en/non-typed-operators.html
->> Return value from JSON column after evaluating path and unquoting the result; equivalent to JSON_UNQUOTE(JSON_EXTRACT()). / Division operator := Assign a value = Assign a value (as part of a SET statement, or as part of the SET clause in an ...
https://dev.mysql.com/doc/refman/8.0/en/optimizer-hints.html
The same is true if FORCE INDEX is changed to USE INDEX. One means of control over optimizer strategies is to set the optimizer_switch system variable (see Section 10.9.2, “Switchable Optimizations”). Changes to this variable affect execution ...
https://dev.mysql.com/doc/refman/8.0/en/option-files.html
In an option file, you can have spaces around the = character, something that is not true on the command line. Most MySQL programs can read startup options from option files (sometimes called configuration files). Option files provide a convenient ...
https://dev.mysql.com/doc/refman/8.0/en/option-modifiers.html
The “enabled” form of the option may be specified in any of these ways: --column-names --enable-column-names --column-names=1 The values ON, TRUE, OFF, and FALSE are also recognized for boolean options (not case-sensitive). Some options are ...
https://dev.mysql.com/doc/refman/8.0/en/order-by-optimization.html
For example, this is true for a HASH index in a MEMORY table. This section describes when MySQL can use an index to satisfy an ORDER BY clause, the filesort operation used when an index cannot be used, and execution plan information available from ...
https://dev.mysql.com/doc/refman/8.0/en/pam-pluggable-authentication.html
Note PAM pluggable authentication is an extension included in MySQL Enterprise Edition, a commercial product. MySQL Enterprise Edition supports an authentication method that enables MySQL Server to use PAM (Pluggable Authentication Modules) to ...
https://dev.mysql.com/doc/refman/8.0/en/partitioning-columns-range.html
For example, when using a case-sensitive collation, 'and' sorts before 'Andersen', but when using a collation that is case-insensitive, the reverse is true. Range columns partitioning is similar to range partitioning, but enables you to define ...
https://dev.mysql.com/doc/refman/8.0/en/partitioning-limitations.html
More specifically, this means that the following two statements are true: No definition of an InnoDB table employing user-defined partitioning may contain foreign key references; no InnoDB table whose definition contains foreign key references may ... This section discusses current restrictions and limitations on MySQL partitioning ...