Search Results
https://dev.mysql.com/doc/refman/8.4/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.4/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.4/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/8.4/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/8.4/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.4/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.4/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.4/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.4/en/tutorial.html
If you are interested only in accessing an existing database, you may want to skip the sections that describe how to create the database and the tables it contains. This chapter provides a tutorial introduction to MySQL by showing how to use the ...
https://dev.mysql.com/doc/refman/8.4/en/upgrade-paths.html
Notes Make sure you understand the MySQL release model for MySQL for MySQL long long-term support (LTS) and Innovation versions before proceeding with a downgrade. We recommend checking upgrade compatibility with MySQL Shell's Upgrade Checker ...