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/atomic-ddl.html
An atomic DDL statement combines the data dictionary updates, storage engine operations, and binary log writes associated with a DDL operation into a single, atomic operation. Atomic DDL Characteristics The characteristics of atomic DDL statements ...The operation is either committed, with applicable changes persisted to the data dictionary, storage engine, and binary log, or is rolled back, even if the server halts during the ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-security-mysql-privileges.html
This includes all MySQL privilege types (SELECT privilege, UPDATE privilege, DELETE privilege, and so on) granted on the database, table, and column level. The only tables that would be safe from this sort of mayhem would be those tables that were ... In this section, we discuss how the MySQL privilege system works in relation to NDB Cluster and the implications of this for keeping an NDB Cluster ...
https://dev.mysql.com/doc/refman/8.0/en/built-in-function-reference.html
The following table lists each built-in (native) function and operator and provides a short description of each one. For a table listing functions that are loadable at runtime, see Section 14.2, “Loadable Function Reference”. ->> Return value ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-single-primary-mode.html
In single-primary mode (group_replication_single_primary_mode=ON) the group has a single primary server that is set to read/write mode. All the other members in the group are set to read-only mode (with super_read_only=ON). All other servers that ...The member that is designated as the primary server can change in the following ways: If the existing primary leaves the group, whether voluntarily or unexpectedly, a new primary is elected ...
https://dev.mysql.com/doc/refman/8.0/en/replication-features-temptables.html
In statement-based replication mode, temporary tables are replicated except in the case where you stop the replica server (not just the replication threads) and you have replicated temporary tables that are open for use in updates that have not yet ...When binlog_format is set to STATEMENT, operations on temporary tables are logged on the source and replicated on the replica, provided that the statements involving temporary tables can be logged safely using statement-based ...
https://dev.mysql.com/doc/refman/8.0/en/grant-tables.html
When using -binlog_format=mixed, DML operations that read data from grant tables are written to the binary log as row events to make the operations safe for mixed-mode replication. Note Direct modification of grant tables using statements such as ...
https://dev.mysql.com/doc/refman/8.0/en/replication-mode-change-online-verify-transactions.html
This is helpful when changing the replication mode online as you can verify that it is safe to change to GTID transactions. Or wait for a day, or whatever time period you consider safe for your deployment. A safer method in the sense that it does ...
https://dev.mysql.com/doc/refman/8.0/en/internal-locking.html
FOR UPDATE statement for each group of rows expected to be modified, even if the data change statements come later in the transaction. Table-Level Locking MySQL uses table-level locking for MyISAM, MEMORY, and MERGE tables, permitting only one ...
https://dev.mysql.com/doc/refman/8.0/en/table-locking.html
But because only one session can write to a table at any one time, for best performance with these other storage engines, use them primarily for tables that are queried often and rarely inserted into or updated. During the update, all other sessions ... InnoDB tables use row-level locking so that multiple sessions and applications can read from and write to the same table simultaneously, without making each other wait or producing inconsistent ...
https://dev.mysql.com/doc/refman/8.0/en/time-zone-support.html
If you start the server using mysqld_safe, its --timezone option provides another way to set the system time zone. For most operating systems, the latest update or service pack prepares your system for the time changes. Check the website for your ...