PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/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.0/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.0/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.0/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 ...
https://dev.mysql.com/doc/refman/8.0/en/server-options.html
Do not use this option unless you know exactly what it does! --external-locking Command-Line Format --external-locking[={OFF|ON}] Type Boolean Default Value OFF Enable external locking (system locking), which is disabled by default. If you use this ... When you start the mysqld server, you can specify program options using any of the methods described in Section 6.2.2, “Specifying Program ...
https://dev.mysql.com/doc/refman/8.0/en/show-open-tables.html
In_use The number of table locks or lock requests there are for the table. For example, if one client acquires a lock for a table using LOCK TABLE t1 WRITE, In_use is 1. If another client issues LOCK TABLE t1 WRITE while the table remains locked, ...
https://dev.mysql.com/doc/refman/8.0/en/crashing.html
Some external program is manipulating data files or index files at the same time as mysqld without locking the table properly. You are running many mysqld servers using the same data directory on a system that does not support good file system locks ... Each MySQL version is tested on many platforms before it is ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-deadlock-detection.html
When deadlock detection is enabled (the default), InnoDB automatically detects transaction deadlocks and rolls back a transaction or transactions to break the deadlock. InnoDB is aware of table locks if innodb_table_locks = 1 (the default) and ...
https://dev.mysql.com/doc/refman/8.0/en/loadable-function-reference.html
The following table lists each function that is loadable at runtime and provides a short description of each one. For a table listing built-in functions and operators, see Section 14.1, “Built-In Function and Operator Reference” For general ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-limitations-multiple-nodes.html
A LOCK TABLES statement or GET_LOCK() call works only for the SQL node on which the lock is issued; no other SQL node in the cluster “sees” this lock. This is true for a lock issued by any statement that locks tables as part of its operations.