Search Results
https://dev.mysql.com/doc/refman/8.4/en/obtaining-plugin-information.html
There are several ways to determine which plugins are installed in the server: The Information Schema PLUGINS table contains a row for each loaded plugin. The mysql.plugin table shows which plugins have been registered with INSTALL PLUGIN. The ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-examples.html
The following example provides one methodology that you can use to analyze a repeatable problem, such as investigating a performance bottleneck. To begin, you should have a repeatable use case where performance is deemed “too slow” and needs ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-instrument-filtering.html
The setup_instruments table lists the available instruments: mysql> SELECT NAME, ENABLED, TIMED FROM performance_schema.setup_instruments; +---------------------------------------------------+---------+-------+ | NAME | ENABLED | TIMED | ...| ...
https://dev.mysql.com/doc/refman/8.4/en/replication-administration-skip.html
Details of the error and the last successfully applied transaction are recorded in the Performance Schema table replication_applier_status_by_worker. This method of skipping transactions is not suitable when you have enabled GTID assignment on a ...
https://dev.mysql.com/doc/refman/8.4/en/replication-delayed.html
The replication_applier_configuration Performance Schema table contains the DESIRED_DELAY column which shows the delay configured using the SOURCE_DELAY option. The replication_applier_status Performance Schema table contains the REMAINING_DELAY ...
https://dev.mysql.com/doc/refman/8.4/en/replication-features-views.html
Views are filtered by their own name, not by the tables they refer to. This means that a view can be replicated to the replica even if the view contains a table that would normally be filtered out by replication-ignore-table rules. Care should ...
https://dev.mysql.com/doc/refman/8.4/en/rewriter-query-rewrite-plugin.html
The Rewriter plugin uses a database named query_rewrite containing a table named rewrite_rules. The table provides persistent storage for the rules that the plugin uses to decide whether to rewrite statements. Users communicate with the plugin by ...
https://dev.mysql.com/doc/refman/8.4/en/server-side-help-support.html
This information is stored in several tables in the mysql schema (see Section 7.3, “The mysql System Schema”). Proper operation of the HELP statement requires that these help tables be initialized. For a new installation of MySQL using a binary ... MySQL Server supports a HELP statement that returns information from the MySQL Reference Manual (see Section 15.8.3, “HELP ...
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/c-api/8.4/en/c-api-auto-reconnect.html
Loses the association of the client with the Performance Schema threads table row that determines connection thread instrumentation. If the client reconnects after a disconnect, the session is associated with a new row in the threads table and the ... The MySQL client library can perform an automatic reconnection to the server if it finds that the connection is down when you attempt to send a statement to the server to be ...