Search Results
https://dev.mysql.com/doc/refman/8.4/en/telemetry-trace-format.html
This span type has the following attributes: Name: stmt mysql.event_name mysql.lock_time mysql.sql_text mysql.digest_text mysql.current_schema mysql.object_type mysql.object_schema mysql.object_name mysql.sql_errno mysql.sqlstate mysql.message_text ...The following span types are emitted by the telemetry component: Control Span Session Span Statement Span Control Span Issued when the telemetry configuration changes, notifying downstream system of which signal collection has been enabled or ...
https://dev.mysql.com/doc/refman/8.4/en/telemetry-trace-install.html
This section describes the installation of the server and client OpenTelemetry support. Installing Client Plugin The Telemetry plugin for the MySQL client can be enabled with a command line switch, --telemetry_client or from a configuration option, ...
https://dev.mysql.com/doc/refman/8.4/en/temporary-files.html
Some SELECT queries creates temporary SQL tables to hold intermediate results. On Unix, MySQL uses the value of the TMPDIR environment variable as the path name of the directory in which to store temporary files. If TMPDIR is not set, MySQL uses ...
https://dev.mysql.com/doc/refman/8.4/en/test-pluggable-authentication.html
For example: mysql> SELECT PLUGIN_NAME, PLUGIN_STATUS FROM INFORMATION_SCHEMA.PLUGINS WHERE PLUGIN_NAME LIKE '%test_plugin%'; +--------------------+---------------+ | PLUGIN_NAME | PLUGIN_STATUS | +--------------------+---------------+ | ... MySQL ...
https://dev.mysql.com/doc/refman/8.4/en/thread-commands.html
A thread can have any of the following Command values: Binlog Dump This is a thread on a replication source for sending binary log contents to a replica. Connect Used by replication receiver threads connected to the source, and by replication ...
https://dev.mysql.com/doc/refman/8.4/en/thread-pool-tuning.html
Assuming that the tp_thread_group_stats table is enabled, you can use the following query to determine the fraction of executed statements that stalled: SELECT SUM(STALLED_QUERIES_EXECUTED) / SUM(QUERIES_EXECUTED) FROM ... This section provides ...
https://dev.mysql.com/doc/refman/8.4/en/timezone-problems.html
If you have a problem with SELECT NOW() returning values in UTC and not your local time, you have to tell the server your current time zone. This should be done for the environment in which the server runs (for example, in mysqld_safe or ...
https://dev.mysql.com/doc/refman/8.4/en/update-optimization.html
An update statement is optimized like a SELECT query with the additional overhead of a write. The speed of the write depends on the amount of data being updated and the number of indexes that are updated. Another way to get fast updates is to delay ...
https://dev.mysql.com/doc/refman/8.4/en/upgrade-best-practices.html
Connect to the existing MySQL server and select the MySQL Server version you plan to upgrade to for the utility to report issues to address prior to an upgrade. MySQL supports upgrading between minor versions (within an LTS series) and to the next ...
https://dev.mysql.com/doc/refman/8.4/en/using-log-files.html
You can also try the command EXPLAIN on all SELECT statements that takes a long time to ensure that mysqld is using indexes properly. Note that before starting mysqld with the general query log enabled, you should check all your tables with ...