PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-replication-applier-configuration-table.html
ASSIGN_GTIDS_TO_ANONYMOUS_TRANSACTIONS_TYPE Whether the channel assigns a GTID to replicated transactions that do not already have one (CHANGE REPLICATION SOURCE TO option: ASSIGN_GTIDS_TO_ANONYMOUS_TRANSACTIONS, CHANGE MASTER TO option: ... This ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-replication-asynchronous-connection-failover-table.html
If multiple sources have the same weight, the replica orders them randomly. This table holds the replica's source lists for each replication channel for the asynchronous connection failover mechanism. The asynchronous connection failover mechanism ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-replication-connection-configuration-table.html
This table shows the configuration parameters used by the replica for connecting to the source. Parameters stored in the table can be changed at runtime with the CHANGE REPLICATION SOURCE TO statement (from MySQL 8.0.23) or CHANGE MASTER TO ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-replication-group-members-table.html
UNREACHABLE: The failure detection process suspects that this member cannot be contacted, because the group messages have timed out. This table shows network and status information for replication group members. The network addresses shown are the ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-setup-objects-table.html
The order in which matching occurs matters because different matching setup_objects rows can have different ENABLED and TIMED values. The setup_objects table controls whether the Performance Schema monitors particular objects. This table has a ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-setup-tables.html
For this reason, some columns in these tables can be changed if you have the UPDATE privilege. The setup tables provide information about the current instrumentation and enable the monitoring configuration to be changed. The use of tables rather ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-setup-threads-table.html
For example, threads such as thread/sql/one_connection executing a user session have the user property to differentiate them from system threads. It exposes thread class names and attributes: mysql> SELECT * FROM performance_schema.setup_threads\G ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-socket-summary-tables.html
The socket summary tables have these indexes: socket_summary_by_event_name: Primary key on (EVENT_NAME) socket_summary_by_instance: Primary key on (OBJECT_INSTANCE_BEGIN) Index on (EVENT_NAME) TRUNCATE TABLE is permitted for socket summary tables.
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-stage-summary-tables.html
The stage summary tables have these indexes: events_stages_summary_by_account_by_event_name: Primary key on (USER, HOST, EVENT_NAME) events_stages_summary_by_host_by_event_name: Primary key on (HOST, EVENT_NAME) ... The Performance Schema maintains ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-startup-configuration.html
To use the MySQL Performance Schema, it must be enabled at server startup to enable event collection to occur. To enable or disable it explicitly, start the server with the performance_schema variable set to an appropriate value. For example, use ...