Search Results
https://dev.mysql.com/doc/refman/8.4/en/group-replication-frequently-asked-questions.html
What is the maximum number of MySQL servers in a group? A group can consist of maximum 9 servers. You can specify them in the START GROUP_REPLICATION statement each time Group Replication is started. Can I scale-out my write-load using Group ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-responses-failure.html
By default, the following behaviors happen if a member is suspected of having failed: In MySQL 8.4, when a suspicion is created, a waiting period of 5 seconds is added before the suspicion times out and the suspected member is liable for expulsion.
https://dev.mysql.com/doc/refman/8.4/en/innodb-performance-thread_concurrency.html
In situations where it is helpful to minimize context switching between threads, InnoDB can use a number of techniques to limit the number of concurrently executing operating system threads (and thus the number of requests that are processed at any ... InnoDB uses operating system threads to process requests from user ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-error-summary-tables.html
Example error event summary information: mysql> SELECT * FROM performance_schema.events_errors_summary_global_by_error WHERE SUM_ERROR_RAISED <> 0\G *************************** 1. Each error summary table has these summary columns containing ... The ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/advanced.replica-backup-restore.html
The duration mysqlbackup waits until it times out is specified by the --safe-replica-backup-timeout option. In addition, mysqlbackup also runs an initial check at the beginning of a replica backup to see if Replica_open_temp_tables becomes 0 within ...MySQL Enterprise Backup does not include temporary tables inside a ... To backup ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-events-transactions-current-table.html
For example: mysql> SELECT * FROM performance_schema.events_transactions_current LIMIT 1\G *************************** 1. The TIMER_START and TIMER_END values indicate when event timing started and ended. If an event has not finished, TIMER_END is ...The table stores one row per thread showing the current status of the thread's most recent monitored transaction event, so there is no system variable for configuring the table ...
https://dev.mysql.com/doc/refman/8.4/en/thread-pool-operation.html
thread_pool_prio_kickup_timer: How long before the thread pool moves a statement awaiting execution from the low-priority queue to the high-priority queue. Consider increasing the value if you experience slower response times due to long-running ...
https://dev.mysql.com/doc/internals/en/event-header-fields.html
The value of this constant is 13 in MySQL 3.23 (v1 format), and 19 in MySQL 4.0 and up (v3 format and up). v1 event header: +============================+ | timestamp 0 : 4 | +----------------------------+ | type_code 4 : 1 | ...The first 19 bytes ...
https://dev.mysql.com/doc/internals/en/guided-tour-osdir.html
But we acknowledge with thanks that they're the products of other projects, and other people's labor, and we only regret that we won't have time to note all the contributed or publicly available components of MySQL, in this manual. We're now ...
https://dev.mysql.com/doc/internals/en/user-level-locks.html
send SELECT GET_LOCK("mysqltest1", 10); --connection conn2 # Wait for INSERT to timeout. MySQL Internals mailing list, 10 Dec 2007: http://lists.mysql.com/internals/35220 One limitation of user-level locks is that a thread can have one lock at a ...