PDF (US Ltr)
- 41.8Mb
PDF (A4)
- 41.9Mb
Man Pages (TGZ)
- 272.3Kb
Man Pages (Zip)
- 378.3Kb
Info (Gzip)
- 4.2Mb
Info (Zip)
- 4.2Mb
Search Results
https://dev.mysql.com/doc/refman/9.7/en/performance-schema-query-profiling.html
Performance Schema displays event timer information in picoseconds (trillionths of a second) to normalize timing data to a standard unit. In the following example, TIMER_WAIT values are divided by 1000000000000 to show data in units of seconds. The ...
https://dev.mysql.com/doc/refman/9.7/en/performance-schema-replication-applier-status-table.html
REMAINING_DELAY If the replica is waiting for DESIRED_DELAY seconds to pass since the source applied a transaction, this field contains the number of delay seconds remaining. This table shows the current general transaction execution status on the ...
https://dev.mysql.com/doc/refman/9.7/en/performance-schema-replication-connection-configuration-table.html
(CHANGE REPLICATION SOURCE TO option: SOURCE_RETRY_COUNT) HEARTBEAT_INTERVAL The replication heartbeat interval on a replica, measured in seconds. This table shows the configuration parameters used by the replica for connecting to the source.
https://dev.mysql.com/doc/refman/9.7/en/performance-schema-setup-meters-table.html
This column can be modified DESCRIPTION: A string describing the meter.
https://dev.mysql.com/doc/refman/9.7/en/performance-schema-system-variables.html
performance_schema_max_digest_sample_age Command-Line Format --performance-schema-max-digest-sample-age=# System Variable performance_schema_max_digest_sample_age Scope Global Dynamic Yes SET_VAR Hint Applies No Type Integer Default Value 60 Minimum ...The Performance Schema automatically sizes the values of several of its parameters at server startup if they are not set ...
https://dev.mysql.com/doc/refman/9.7/en/processlist-access.html
If a thread stays in a given state for many seconds, there might be a problem that needs to be investigated. For a replica SQL thread, the value is the number of seconds between the timestamp of the last replicated event and the real time of the ...
https://dev.mysql.com/doc/refman/9.7/en/query-attributes.html
The second SELECT shows that attributes do not persist across statements. The most visible part of an SQL statement is the text of the statement. Clients can also define query attributes that apply to the next statement sent to the server for ...
https://dev.mysql.com/doc/refman/9.7/en/replica-io-thread-states.html
The thread is sleeping for the number of seconds set by the CHANGE REPLICATION SOURCE TO statement before attempting to reconnect. The following list shows the most common states you see in the State column for a replication I/O (receiver) thread ...
https://dev.mysql.com/doc/refman/9.7/en/replication-features-shutdowns.html
However, the replica notices the network outage only after receiving no data from the source for replica_net_timeout seconds. It is safe to shut down a replication source server and restart it later. When a replica loses its connection to the ...
https://dev.mysql.com/doc/refman/9.7/en/replication-features-transaction-inconsistencies.html
If the last transaction in the relay log is only half-received and the multithreaded replica's coordinator thread has started to schedule the transaction to a worker, then STOP REPLICA waits up to 60 seconds for the transaction to be received. If ...