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/audit-log-reference.html
Unless those objects are installed, the audit_log plugin operates in legacy mode (deprecated in MySQL 8.0.34). If these tables are missing, the audit_log plugin operates in (deprecated) legacy mode. Example: mysql> SELECT ...Audit Log Tables MySQL ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-online-upgrade-combining-versions.html
A member applies these policies to decide whether to join the group normally, or join in read-only mode, or not join the group, depending on which choice results in the safe operation of the joining member and of the existing members of the group.
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-single-user-mode.html
Single user mode enables the database administrator to restrict access to the database system to a single API node, such as a MySQL server (SQL node) or an instance of ndb_restore. When entering single user mode, connections to all other API nodes ...You can also check the status column of the ndbinfo.nodes table (see Section 25.6.16.47, “The ndbinfo nodes Table”, for more ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-transaction-isolation-levels.html
For locking reads (SELECT with FOR UPDATE or FOR SHARE), UPDATE, and DELETE statements, locking depends on whether the statement uses a unique index with a unique search condition, or a range-type search condition. It is not recommended to mix ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-backup.html
The key to safe database management is making regular backups. Copy all InnoDB data files (ibdata files and .ibd files) into a safe place. Copy all InnoDB redo log files (#ib_redoN files in MySQL 8.0.30 and higher or ib_logfile files in earlier ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-upgrade-downgrade.html
(Once any possibility of a downgrade is past, you can safely change the corresponding system variable ndb_schema_dist_upgrade_allowed back to 1, the default, in the mysql client.) When each NDB Y SQL node starts, it connects to the cluster and ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-deploying-in-multi-primary-or-single-primary-mode.html
These functions manage the process of changing the group's mode and ensure the safety and consistency of your data. Group Replication operates either in single-primary mode or in multi-primary mode. The group's mode is a group-wide configuration ...
https://dev.mysql.com/doc/refman/8.0/en/replication-options-gtids.html
If all binary logs on the server were generated using MySQL 5.7.8 or later, binlog_gtid_simple_recovery=TRUE can always safely be used. If the server's most recent binary log files do not have GTID log events, for example if gtid_mode=ON was used ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-functions-for-mode.html
When you change to single-primary mode, strict consistency checks are also disabled on all group members, as required in single-primary mode (group_replication_enforce_update_everywhere_checks=OFF). The following functions enable you to control the ...Return value: A string containing the result of the operation, for example whether it was successful or ...
https://dev.mysql.com/doc/refman/8.0/en/date-and-time-functions.html
For the %U, %u, %V, and %v specifiers, see the description of the WEEK() function for information about the mode values. This means, for example, that “zero” dates or dates with part values of 0 are permitted unless the SQL mode is set to ...