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/innodb-locking-reads.html
Your application code can ensure referential integrity throughout this sequence of operations. If you query data and then insert or update related data within the same transaction, the regular SELECT statement does not give enough protection. Other ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-online-ddl-single-multi.html
Before the introduction of online DDL, it was common practice to combine many DDL operations into a single ALTER TABLE statement. Because each ALTER TABLE statement involved copying and rebuilding the table, it was more efficient to make several ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-install-windows-initial-start.html
Important An NDB Cluster management node caches the configuration data that it reads from config.ini; once it has created a configuration cache, it ignores the config.ini file on subsequent starts unless forced to do otherwise. Once the NDB Cluster ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-replication-mta.html
In this scheme, each transaction in a binary log file is annotated with a sequence_number (1, 2, 3, ...), and as well as the sequence number of the most recent binary log transaction that it depends on, to which we refer as last_committed. Within a ...To use this functionality with NDB Cluster, it is necessary that the following three conditions be met: Binary log transaction dependencies are determined at the ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-instrument-naming.html
An instrument name consists of a sequence of elements separated by '/' characters. Example names: wait/io/file/myisam/log wait/io/file/mysys/charset wait/lock/table/sql/handler wait/synch/cond/mysys/COND_alarm ...The elements of an instrument name ...
https://dev.mysql.com/doc/refman/8.0/en/show-replica-status.html
The relay log file name (Relay_Log_File) is set according to the relay_log_recovery setting, either a new file that was created at server start or the first relay log file present. Inconsistencies in the sequence of transactions from the relay log ... SHOW {REPLICA | SLAVE} STATUS [FOR CHANNEL channel] This statement provides status information on essential parameters of the replica ...
https://dev.mysql.com/doc/refman/8.0/en/solaris-installation-pkg.html
To enable MySQL to startup and shutdown automatically, you should create a link between this file and the init script directories. The typical upgrade sequence is therefore: $> mysqladmin shutdown $> pkgrm mysql $> pkgadd -d ... You can install ...
https://dev.mysql.com/doc/refman/8.0/en/access-control.html
MySQL enables the creation of accounts that permit client users to connect to the server and access data managed by the server. The user interface to MySQL accounts consists of SQL statements such as CREATE USER, GRANT, and REVOKE. You cannot ...
https://dev.mysql.com/doc/refman/8.0/en/account-names.html
MySQL account names consist of a user name and a host name, which enables creation of distinct accounts for users with the same user name who connect from different hosts. Account names appear in SQL statements such as CREATE USER, GRANT, and SET ...This section describes the syntax for account names, including special values and wildcard ...
https://dev.mysql.com/doc/refman/8.0/en/alter-instance.html
To schedule regular rotation of the binary log master key on all applicable source and replica servers, you can enable the MySQL Event Scheduler on each server and issue the ALTER INSTANCE ROTATE BINLOG MASTER KEY statement using a CREATE EVENT ...