Search Results
https://dev.mysql.com/doc/refman/8.4/en/sys-schema-usage.html
To generate a dump file, name the sys schema explicitly on the command line using either of these commands: mysqldump --databases --routines sys > sys_dump.sql To reinstall the schema from the dump file, use this command: mysql < sys_dump.sql . Most ...
https://dev.mysql.com/doc/refman/8.4/en/sys-schema.html
Stored procedures that perform operations such as Performance Schema configuration and generating diagnostic reports. MySQL 8.4 includes the sys schema, a set of objects that helps DBAs and developers interpret data collected by the Performance ...
https://dev.mysql.com/doc/refman/8.4/en/telemetry-trace-format.html
This span type has the following attributes: Name: Session mysql.processlist_id mysql.thread_id mysql.user mysql.host mysql.group This span also contains dynamic attributes generated with the format mysql.session_attr.xxx, where xxx is the session ...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.html
Traces are generated for COM_QUERY commands executed, including non-query commands such as COM_PING, or COM_STMT_CLOSE. Tracing telemetry enables you to visualize the flow of any processing action as it is processed through your server. The data ...
https://dev.mysql.com/doc/refman/8.4/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. This section provides guidelines on determining the best configuration for thread pool performance, as ...
https://dev.mysql.com/doc/refman/8.4/en/view-algorithms.html
In this case, MySQL generates a warning and sets the algorithm to UNDEFINED. The optional ALGORITHM clause for CREATE VIEW or ALTER VIEW is a MySQL extension to standard SQL. For MERGE, the text of a statement that refers to the view and the view ...
https://dev.mysql.com/doc/refman/8.4/en/x-plugin-options-system-variables.html
mysqlx_document_id_unique_prefix Command-Line Format --mysqlx-document-id-unique-prefix=# System Variable mysqlx_document_id_unique_prefix Scope Global Dynamic Yes SET_VAR Hint Applies No Type Integer Default Value 0 Minimum Value 0 Maximum Value ...
https://dev.mysql.com/doc/refman/8.4/en/xa-restrictions.html
Undo the XA transaction that generated the error message, then restart replication. XA transaction support is limited to the InnoDB storage engine. For “external XA,” a MySQL server acts as a Resource Manager and client programs act as ...
https://dev.mysql.com/doc/relnotes/mysql/8.4/en/index.html
Abstract This document contains release notes for the changes in MySQL 8.4. For information about changes in a different version of MySQL, see the release notes for that version. For additional MySQL 8.4 documentation, see the MySQL 8.4 Reference ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/backup-metadata-options.html
Some metadata is stored in the backup directory, other metadata is stored in tables within the mysql database of the backed-up instance. --no-history-logging Turns off the recording of backup progress and history in logging tables inside the ...