PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.5Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/replication-asynchronous-connection-failover.html
When you add a group member to the source list and define it as part of a managed group, the asynchronous connection failover mechanism updates the source list to keep it in line with membership changes, adding and removing group members ...
https://dev.mysql.com/doc/refman/8.0/en/replication-encrypted-connections.html
For a replication connection, specifying a value for either of SOURCE_SSL_CA or SOURCE_SSL_CAPATH corresponds to setting --ssl-mode=VERIFY_CA. For a replication connection, specifying MASTER_SSL_VERIFY_SERVER_CERT=1 corresponds to setting ... To use ...
https://dev.mysql.com/doc/refman/8.0/en/show-triggers.html
row *************************** Trigger: ins_sum Event: INSERT Table: account Statement: SET @sum = @sum + NEW.amount Timing: BEFORE Created: 2018-08-08 10:10:12.61 sql_mode: ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES, NO_ZERO_IN_DATE,NO_ZERO_DATE, ...
https://dev.mysql.com/doc/refman/8.0/en/x-plugin-status-variables.html
Mysqlx_aborted_clients The number of clients that were disconnected because of an input or output error. Mysqlx_address The network address or addresses for which X Plugin accepts TCP/IP connections. If multiple addresses were specified using the ...
https://dev.mysql.com/doc/refman/8.0/en/alter-user.html
In most cases, ALTER USER requires the global CREATE USER privilege, or the UPDATE privilege for the mysql system schema. To require an encrypted connection, a client need specify only the --ssl-mode=REQUIRED option; the connection attempt fails if ... ALTER USER [IF EXISTS] user [auth_option] [, user [auth_option]] ...
https://dev.mysql.com/doc/refman/8.0/en/cursor-restrictions.html
Cursors are read only; you cannot use a cursor to update rows. UPDATE WHERE CURRENT OF and DELETE WHERE CURRENT OF are not implemented, because updatable cursors are not supported. You cannot use a cursor for a statement that generates a result set ... Server-side cursors are implemented in the C API using the mysql_stmt_attr_set() ...
https://dev.mysql.com/doc/refman/8.0/en/flush.html
The server writes a warning to the error log for any unrecognized cost model table entries. For information about these tables, see Section 10.9.5, “The Optimizer Cost Model”. Reloading the grant tables is necessary to enable updates to MySQL ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-innodb-trx-table.html
TRX_AUTOCOMMIT_NON_LOCKING A value of 1 indicates the transaction is a SELECT statement that does not use the FOR UPDATE or LOCK IN SHARED MODE clauses, and is executing with autocommit enabled so that the transaction contains only this one ...Its ... The INNODB_TRX table provides information about every transaction currently executing inside InnoDB, including whether the transaction is waiting for a lock, when the transaction started, and the SQL statement the transaction is executing, if ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-information-schema-understanding-innodb-locking.html
If a second transaction wants to update a row or lock a table already locked by a prior transaction in an incompatible mode, InnoDB adds a lock request for the row to the corresponding queue. When a transaction updates a row in a table, or locks it ... Note This section describes locking information as exposed by the Performance Schema data_locks and data_lock_waits tables, which supersede the INFORMATION_SCHEMA INNODB_LOCKS and INNODB_LOCK_WAITS tables in MySQL ...
https://dev.mysql.com/doc/refman/8.0/en/metadata-locking.html
When updating a parent table, a metadata lock is taken on the child table while updating foreign key metadata. That is, explicitly or implicitly started transactions that update any table (transactional or nontransactional) block and are blocked by ... MySQL uses metadata locking to manage concurrent access to database objects and to ensure data ...