Search Results
https://dev.mysql.com/doc/refman/9.7/en/sys-user-summary-by-file-io-type.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. These views summarize file I/O, grouped by user and event type. By default, ...
https://dev.mysql.com/doc/refman/9.7/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/9.7/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/9.7/en/telemetry-logs-configuration.html
For information on the configured loggers, see Section 29.12.21.1, “The setup_loggers Table”. Server Configuration System Variables Server Configuration Status Variables Server Configuration Command Line Server Configuration System Variables The ...
https://dev.mysql.com/doc/refman/9.7/en/telemetry-trace-configuration.html
The following configuration options are available: Table 35.2 mysql client Telemetry Option Summary Option Name Description --telemetry_client Enables the telemetry client. Server Configuration Client Configuration Client Configuration Example ...
https://dev.mysql.com/doc/refman/9.7/en/thread-pool-tuning.html
The default value of 6 (60ms) is suitable for servers that primarily execute very simple statements. Assuming that the tp_thread_group_stats table is enabled, you can use the following query to determine the fraction of executed statements that ...
https://dev.mysql.com/doc/refman/9.7/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/9.7/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/9.7/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/9.7/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 ...