Search Results
https://dev.mysql.com/doc/refman/8.4/en/group-replication-flow-control.html
Depending on why the member is lagging behind, other members in the group may have to save more or less of the replication context to be able to fulfil potential data transfer requests from the slow member. The replication protocol provides a ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-frequently-asked-questions.html
Otherwise, if the server is so slow that it triggers the flow control, then the entire group slows down as well. What is the maximum number of MySQL servers in a group? A group can consist of maximum 9 servers. Attempting to add another server to a ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-multi-primary-mode.html
This means that as soon as the incoming traffic slows down or stops, all group members have the same data content. In multi-primary mode, slower members can also build up an excessive backlog of transactions to certify and apply, leading to a ... In ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-ndbinfo-disk-write-speed-aggregate.html
The disk_write_speed_aggregate table provides aggregated information about the speed of disk writes during LCP, backup, and restore operations.
https://dev.mysql.com/doc/refman/8.4/en/show-replica-status.html
If the network is slow, this is not a good approximation; the replication applier thread may quite often be caught up with the slow-reading replication receiver thread, so Seconds_Behind_Source often shows a value of 0, even if the replication ...
https://dev.mysql.com/doc/refman/8.4/en/audit-log-file-formats.html
This data is available in the slow query log for qualifying queries, and in the context of the audit log it similarly helps to detect outliers for activity analysis. For the bytes_sent and bytes_received fields to be populated, the system variable ... The MySQL server calls the audit log plugin to write an audit record to its log file whenever an auditable event ...
https://dev.mysql.com/doc/refman/8.4/en/select-optimization.html
The main considerations for optimizing queries are: To make a slow SELECT ... Queries, in the form of SELECT statements, perform all the lookup operations in the database. Besides SELECT statements, the tuning techniques for queries also apply to ...Tuning these statements is a top priority, whether to achieve sub-second response times for dynamic web pages, or to chop hours off the time to generate huge overnight ...
https://dev.mysql.com/doc/mysql-monitor/8.0/en/performance-advisors-ref.html
Default frequency 00:01:00 Default auto-close enabled no Excessive Number of Long Running Processes Most applications and databases are designed to execute queries very quickly. If many queries are taking a long time to execute (more than a few ...
https://dev.mysql.com/doc/workbench/en/wb-preferences-sql-editor.html
Progress status update interval (in milliseconds): [ 500 ] When executing long running queries over a slow connection, you may need to increase this value to prevent excess load on the connection. Prevents UPDATE and DELETE queries that lack a ...
https://dev.mysql.com/doc/relnotes/mysql/8.4/en/news-8-4-3.html
This had an adverse effect on queries using joins on InnoDB tables. This also improves the iteration logic complexity in terms of speed and memory to decrease the impact of these queries on the rest of the system. (Bug #36302624) InnoDB: On Windows, ... C API Notes Compilation Notes Configuration Notes SQL Function and Operator Notes JavaScript Programs Performance Schema Notes sys Schema Notes Thread Pool Notes Functionality Added or Changed Bugs Fixed C API Notes The asynchronous interface used unsafe static local variables to store state ...