PDF (US Ltr)
- 41.8Mb
PDF (A4)
- 41.9Mb
Man Pages (TGZ)
- 272.4Kb
Man Pages (Zip)
- 378.4Kb
Info (Gzip)
- 4.2Mb
Info (Zip)
- 4.2Mb
Search Results
https://dev.mysql.com/doc/refman/9.7/en/performance-schema-rwlock-instances-table.html
An rwlock is a synchronization mechanism used in the code to enforce that threads at a given time can have access to some common resource following certain rules. The access is either shared (many threads can have a read lock at the same time), ...
https://dev.mysql.com/doc/refman/9.7/en/performance-schema-setup-metrics-table.html
row *************************** NAME: wait_free METER: mysql.inno.buffer_pool METRIC_TYPE: ASYNC COUNTER NUM_TYPE: INTEGER UNIT: DESCRIPTION: Number of times waited for free buffer (innodb_buffer_pool_wait_free) ... row *************************** ... The setup_metrics table lists the available metrics: mysql> select * from performance_schema.setup_metrics\G *************************** ...
https://dev.mysql.com/doc/refman/9.7/en/performance-schema-startup-configuration.html
It is possible that a plugin installed later may create the instrument, at which time the name is recognized and configured. At runtime, SHOW VARIABLES displays the actual values that autosized parameters were set to. To use the MySQL Performance ...
https://dev.mysql.com/doc/refman/9.7/en/performance-schema-thread-pool-tables.html
In the case of tp_thread_state, all rows for a thread group comprise a snapshot in time. But it does not hold mutexes on all thread groups at the same time, to prevent a statement against tp_thread_state from blocking the entire MySQL server. The ...
https://dev.mysql.com/doc/refman/9.7/en/performance-schema-tp-thread-state-table.html
The value shown in this column is one of CONNECTION_HANDLER_WORKER_THREAD, LISTENER_WORKER_THREAD, QUERY_WORKER_THREAD, or TIMER_WORKER_THREAD. TIME_OF_ATTACH: Timestamp showing when the thread was attached, if attached to a connection; otherwise ...
https://dev.mysql.com/doc/refman/9.7/en/persisted-system-variables.html
Many system variables are dynamic and can be changed at runtime using the SET statement to affect operation of the current server instance. Modifying system variables with SET GLOBAL is a runtime capability that can be done from clients run locally ... The MySQL server maintains system variables that configure its ...
https://dev.mysql.com/doc/refman/9.7/en/postinstallation.html
Optionally, populate time zone tables to enable recognition of named time zones. This section discusses tasks that you should perform after installing MySQL: If necessary, initialize the data directory and create the MySQL grant tables. For some ...
https://dev.mysql.com/doc/refman/9.7/en/replication-asynchronous-connection-failover-source.html
Important When the existing connection to a source fails, the replica first retries the same connection the number of times specified by the SOURCE_RETRY_COUNT option of the CHANGE REPLICATION SOURCE TO. Suitable values are SOURCE_RETRY_COUNT=3 and ... To activate asynchronous connection failover for a replication channel set SOURCE_CONNECTION_AUTO_FAILOVER=1 in a CHANGE REPLICATION SOURCE TO statement for this ...
https://dev.mysql.com/doc/refman/9.7/en/replication-features-timeout.html
The global value of the system variable replica_transaction_retries sets the maximum number of times for applier threads on a single-threaded or multithreaded replica to automatically retry failed transactions before stopping. Transactions are ...
https://dev.mysql.com/doc/refman/9.7/en/replication-gtids-auto-positioning.html
This method is efficient and only takes a significant amount of time if the replica is behind the source by a large number of binary log files. The elapsed time until the replica receives the first missing transaction depends on its offset in the ...