Search Results
https://dev.mysql.com/doc/refman/8.4/en/sys-ps-thread-id.html
Note ps_thread_id() is deprecated, and subject to removal in a future MySQL version. Applications that use it should be migrated to use the built-in PS_THREAD_ID() and PS_CURRENT_THREAD_ID() functions instead. See Section 14.21, “Performance ...
https://dev.mysql.com/doc/refman/8.4/en/sys-ps-thread-trx-info.html
Returns a JSON object containing information about a given thread. The information includes the current transaction, and the statements it has already executed, derived from the Performance Schema events_transactions_current and ...
https://dev.mysql.com/doc/refman/8.4/en/sys-ps-trace-statement-digest.html
Traces all Performance Schema instrumentation for a specific statement digest. If you find a statement of interest within the Performance Schema events_statements_summary_by_digest table, specify its DIGEST column MD5 value to this procedure and ...
https://dev.mysql.com/doc/refman/8.4/en/sys-ps-trace-thread.html
Dumps all Performance Schema data for an instrumented thread to a .dot formatted graph file (for the DOT graph description language). Each result set returned from the procedure should be used for a complete graph. This procedure disables binary ...
https://dev.mysql.com/doc/refman/8.4/en/sys-schema-prerequisites.html
Before using the sys schema, the prerequisites described in this section must be satisfied. Because the sys schema provides an alternative means of accessing the Performance Schema, the Performance Schema must be enabled for the sys schema to work.
https://dev.mysql.com/doc/refman/8.4/en/sys-schema-table-lock-waits.html
These views display which sessions are blocked waiting on metadata locks, and what is blocking them. For additional information, see the description of the Performance Schema metadata_locks table at Section 29.12.13.3, “The metadata_locks ...
https://dev.mysql.com/doc/refman/8.4/en/sys-schema-usage.html
Most of these views come in pairs, such that one member of the pair has the same name as the other member, plus a x$ prefix. The view with the x$ prefix that displays the same values in raw form is intended more for use with other tools that perform ...
https://dev.mysql.com/doc/refman/8.4/en/sys-session.html
These views are similar to processlist and x$processlist, but they filter out background processes to display only user sessions. For descriptions of the columns, see Section 30.4.3.22, “The processlist and x$processlist Views”.
https://dev.mysql.com/doc/refman/8.4/en/table-corruption.html
If you have started mysqld with the myisam_recover_options system variable set, MySQL automatically checks and tries to repair MyISAM tables if they are marked as 'not closed properly' or 'crashed'. If this happens, MySQL writes an entry in the ...
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, ...