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/xa-restrictions.html
The implementation of internal XA requires that a storage engine support two-phase commit at the table handler level, and currently this is true only for InnoDB. This means that the same XA transaction can appear in the events_transactions_current ... XA transaction support is limited to the InnoDB storage ...
https://dev.mysql.com/doc/refman/8.0/en/set-password.html
Note Rather than using SET PASSWORD to assign passwords, ALTER USER is the preferred statement for account alterations, including assigning passwords. For example: ALTER USER user IDENTIFIED BY 'auth_string'; Note Clauses for random password ... SET ...
https://dev.mysql.com/doc/refman/8.0/en/charset-applications.html
The examples shown here assume use of the latin1 character set and latin1_swedish_ci collation in particular contexts as an alternative to the defaults of utf8mb4 and utf8mb4_0900_ai_ci. To create a database such that its tables use a given default ... For applications that store data using the default MySQL character set and collation (utf8mb4, utf8mb4_0900_ai_ci), no special configuration should be ...
https://dev.mysql.com/doc/refman/8.0/en/connection-options.html
This section describes options supported by most MySQL client programs that control how client programs establish connections to the server, whether connections are encrypted, and whether connections are compressed. Command Options for Connection ...These options can be given on the command line or in an option ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-system-variables.html
group_replication_advertise_recovery_endpoints specifies how a joining member can establish a connection to an existing member for state transfer for distributed recovery. If an alternative port number is specified by the report_port system ... This ...
https://dev.mysql.com/doc/refman/8.0/en/replication-setup-replicas.html
On the source, released the read lock: mysql> UNLOCK TABLES; On the replica, edited the MySQL configuration. Alternatively, you can use the ALTER EVENT statement to set individual events to DISABLE or DISABLE ON SLAVE to prevent them from running on ...Before you proceed, ensure that you have: Configured the source with the necessary configuration ...
https://dev.mysql.com/doc/refman/8.0/en/macos-installation-pkg.html
From the Installation Type page you can either click Install to execute the installation wizard using all defaults, click Customize to alter which components to install (MySQL server, MySQL Test, Preference Pane, Launchd Support -- all but MySQL ...
https://dev.mysql.com/doc/refman/8.0/en/show-grants.html
SHOW GRANTS [FOR user_or_role [USING role [, role] ...]] user_or_role: { user (see Section 8.2.4, “Specifying Account Names”) | role (see Section 8.2.5, “Specifying Role Names”. } This statement displays the privileges and roles that are ...
https://dev.mysql.com/doc/refman/8.0/en/account-activity-auditing.html
When a client connects successfully, the server authenticates the client to a particular row in this table. Its value is constructed from the User and Host columns of the user table row for the account. However, this value does not necessarily ...
https://dev.mysql.com/doc/refman/8.0/en/binary-log-transaction-compression.html
In NDB 8.0.31 and later, you can enable binary logging of compressed transactions for tables using the NDB storage engine at run time using the ndb_log_transaction_compression system variable introduced in that release, and control the level of ...