Search Results
https://dev.mysql.com/doc/refman/8.4/en/replication-sbr-rbr.html
SELECT requires a greater number of row-level locks than with row-based replication. UPDATE statements that require a table scan (because no index is used in the WHERE clause) must lock a greater number of rows than with row-based replication. For ...For most users, the mixed replication format should provide the best combination of data integrity and ...
https://dev.mysql.com/doc/refman/8.4/en/telemetry-metrics-meter-metrics.html
table_locks_immediate Table_locks_immediate ASYNC COUNTER The number of times that a request for a table lock could be granted immediately table_locks_waited Table_locks_waited ASYNC COUNTER The number of times that a request for a table lock could ... The following server metrics are registered by default: mysql.stats Metrics mysql.stats.com Metrics mysql.stats.connection Metrics mysql.perf_schema Metrics mysql.stats.handler Metrics mysql.stats.myisam Metrics mysql.stats.ssl Metrics mysql.inno Metrics mysql.inno.buffer_pool Metrics mysql.inno.data Metrics mysql.x Metrics mysql.x.stmt Metrics The maximum number of metric instruments which can be created is set by ...
https://dev.mysql.com/doc/relnotes/mysql/8.4/en/news-8-4-3.html
(Bug #36792180, Bug #36783070) Running SELECT * FROM sys.innodb_lock_waits; on an instance which was under heavy load affected the performance of the server. As of this release, SELECT * FROM sys.innodb_lock_waits; fetches only 2 locks for each ...
https://dev.mysql.com/doc/workbench/en/wb-what-is-new-62.html
Figure 1.15 Data Modeling Script Attachments Client Connections and Metadata Locks The Client Connections management window has a new Show Details window. Locks: MySQL uses metadata locking to manage access to objects such as tables and triggers.
https://dev.mysql.com/doc/mysql-em-plugin/en/myoem-config-metric-innodbconfiguration-category.html
Autoinc Lock Mode The locking mode to use for generating auto-increment values. Checksum Algorithm Specifies how to generate and verify the checksum stored in each disk block of each InnoDB tablespace. Locks Unsafe For Binlog Enabled Affects how ...
https://dev.mysql.com/doc/mysql-em-plugin/en/myoem-metric-innodb-transactionactivity-category.html
Current Lock Wait Count Total The total number of rows lock waits within all currently running transactions. Latest Deadlock The latest deadlock reported by SHOW ENGINE INNODB STATUS. Lock Memory Bytes Total The total number of bytes allocated for ... Lists the InnoDB Transaction Activity metrics and provides a brief description of ...
https://dev.mysql.com/doc/refman/8.4/en/commit.html
The READ ONLY restriction prevents the transaction from modifying or locking both transactional and nontransactional tables that are visible to other transactions; the transaction can still modify or lock temporary tables. Beginning a transaction ...
https://dev.mysql.com/doc/refman/8.4/en/grant-tables.html
account_locked indicates whether the account is locked (see Section 8.2.20, “Account Locking”). Password_locking: The conditions for failed-login tracking and temporary account locking, if any (see Failed-Login Tracking and Temporary Account ...
https://dev.mysql.com/doc/refman/8.4/en/rename-table.html
You can rename tables locked with a LOCK TABLES statement, provided that they are locked with a WRITE lock or are the product of renaming WRITE-locked tables from earlier steps in a multiple-table rename operation. RENAME TABLE tbl_name TO ...
https://dev.mysql.com/doc/refman/8.4/en/replication-options-replica.html
--max-relay-log-size=size Command-Line Format --max-relay-log-size=# System Variable max_relay_log_size Scope Global Dynamic Yes SET_VAR Hint Applies No Type Integer Default Value 0 Minimum Value 0 Maximum Value 1073741824 Unit bytes Block Size 4096 ... This section explains the server options and system variables that apply to replica servers and contains the following: Startup Options for Replica Servers System Variables Used on Replica Servers Specify the options either on the command line or in an option ...