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/sys-user-summary-by-file-io.html
Rows for which the USER column in the underlying Performance Schema table is NULL are assumed to be for background threads and are reported with a host name of background. By default, rows are sorted by descending total file I/O latency. The ...
https://dev.mysql.com/doc/refman/8.0/en/sys-user-summary-by-stages.html
Rows for which the USER column in the underlying Performance Schema table is NULL are assumed to be for background threads and are reported with a host name of background. By default, rows are sorted by user and descending total stage latency. The ...
https://dev.mysql.com/doc/refman/8.0/en/thread-pool-tuning.html
Stalled statements generate a lot of extra overhead since they involve extra context switches and in some cases even extra thread creations. The default value of 6 (60ms) is suitable for servers that primarily execute very simple statements. This ...
https://dev.mysql.com/doc/refman/8.0/en/time.html
Note that because '00:00:00' is itself a valid TIME value, there is no way to tell, from a value of '00:00:00' stored in a table, whether the original value was specified as '00:00:00' or whether it was invalid. MySQL retrieves and displays TIME ...
https://dev.mysql.com/doc/refman/8.0/en/traceable-statements.html
Statements which are traceable are listed here: SELECT INSERT REPLACE UPDATE DELETE EXPLAIN with any of the preceding statements SET DO DECLARE, CASE, IF, and RETURN as used in stored routines CALL Tracing is supported for both INSERT and REPLACE ...
https://dev.mysql.com/doc/refman/8.0/en/transport-protocols.html
The following table shows the permissible values for --protocol and indicates the applicable platforms for each value. For programs that use the MySQL client library (for example, mysql and mysqldump), MySQL supports connections to the server based ...
https://dev.mysql.com/doc/refman/8.0/en/tuning-trace-purging.html
A subsequent SELECT from the OPTIMIZER_TRACE table returns the first limit traces of the offset oldest stored traces (if offset >= 0), or the first limit traces of the -offset newest stored traces (if offset < 0). Thus, if a statement contains ...
https://dev.mysql.com/doc/refman/8.0/en/updating-yum-repo.html
mysql_upgrade also performs other functions; for details, see Section 6.4.5, “mysql_upgrade — Check and Upgrade MySQL Tables”. For supported Yum-based platforms (see Section 2.5.1, “Installing MySQL on Linux Using the MySQL Yum ...
https://dev.mysql.com/doc/refman/8.0/en/validate-password-options-variables.html
This section describes the system and status variables that validate_password provides to enable its operation to be configured and monitored. This applies only when changing an existing password, and has no effect when setting a user account's ...
https://dev.mysql.com/doc/refman/8.0/en/window-function-optimization.html
Window functions affect the strategies the optimizer considers: Derived table merging for a subquery is disabled if the subquery has window functions. Semijoins are not applicable to window function optimization because semijoins apply to ...