PDF (US Ltr)
- 43.2Mb
PDF (A4)
- 43.3Mb
Man Pages (TGZ)
- 295.2Kb
Man Pages (Zip)
- 400.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/replication-features-load-data.html
LOAD DATA is considered unsafe for statement-based logging (see Section 19.2.1.3, “Determination of Safe and Unsafe Statements in Binary Logging”). If you need to recover from a replication error involving a LOAD DATA INFILE operation logged in ...When binlog_format=MIXED is set, the statement is logged in row-based ...
https://dev.mysql.com/doc/refman/8.0/en/replication-features-optimizer.html
(In general, this is not a good practice, even outside of replication.) Examples of nondeterministic statements include DELETE or UPDATE statements that use LIMIT with no ORDER BY clause; see Section 19.5.1.18, “Replication and LIMIT”, for a ...
https://dev.mysql.com/doc/refman/8.0/en/sql-transactional-statements.html
MySQL supports local transactions (within a given client session) through statements such as SET autocommit, START TRANSACTION, COMMIT, and ROLLBACK. XA transaction support enables MySQL to participate in distributed transactions as well.
https://dev.mysql.com/doc/refman/8.0/en/sys-memory-by-host-by-current-bytes.html
The memory_by_host_by_current_bytes and x$memory_by_host_by_current_bytes views have these columns: host The host from which the client connected. Rows for which the HOST column in the underlying Performance Schema table is NULL are assumed to be ...
https://dev.mysql.com/doc/refman/8.0/en/sys-memory-by-user-by-current-bytes.html
The memory_by_user_by_current_bytes and x$memory_by_user_by_current_bytes views have these columns: user The client user name. Rows for which the USER column in the underlying Performance Schema table is NULL are assumed to be for background threads ...By default, rows are sorted by descending amount of memory ...
https://dev.mysql.com/doc/refman/8.0/en/sys-schema-table-lock-waits.html
These views display which sessions are blocked waiting on metadata locks, and what is blocking them. The schema_table_lock_waits and x$schema_table_lock_waits views have these columns: object_schema The schema containing the object to be locked.
https://dev.mysql.com/doc/refman/8.0/en/sys-session.html
These views are similar to processlist and x$processlist, but they filter out background processes to display only user sessions. For descriptions of the columns, see Section 30.4.3.22, “The processlist and x$processlist Views”.
https://dev.mysql.com/doc/refman/8.0/en/x-plugin-option-variable-reference.html
This table provides an overview of the command options, system variables, and status variables provided by X Plugin.
https://dev.mysql.com/doc/refman/8.0/en/account-locking.html
MySQL supports locking and unlocking user accounts using the ACCOUNT LOCK and ACCOUNT UNLOCK clauses for the CREATE USER and ALTER USER statements: When used with CREATE USER, these clauses specify the initial locking state for a new account. If ...
https://dev.mysql.com/doc/refman/8.0/en/alter-tablespace.html
The only values for engine_name compatible with NDB tablespaces are NDB and NDBCLUSTER. A keyring plugin must be installed and configured before encryption can be enabled. It can be used to add a new data file to, or to drop a data file from an NDB ...