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-locks-set.html
A locking read, an UPDATE, or a DELETE generally set record locks on every index record that is scanned in the processing of an SQL statement. For locking reads (SELECT with FOR UPDATE or FOR SHARE), UPDATE, and DELETE statements, the locks that ...
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/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-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/ansi-diff-foreign-keys.html
If ON UPDATE CASCADE or ON UPDATE SET NULL recurses to update the same table it has previously updated during the same cascade, it acts like RESTRICT. This means that you cannot use self-referential ON UPDATE CASCADE or ON UPDATE SET NULL operations. In an SQL statement that inserts, deletes, or updates many rows, foreign key constraints (like unique constraints) are checked ...For example, if you define a ...
https://dev.mysql.com/doc/refman/8.0/en/trigger-syntax.html
For example, you can have two BEFORE UPDATE triggers for a table. In an UPDATE trigger, you can use OLD.col_name to refer to the columns of a row before it is updated and NEW.col_name to refer to the columns of the row after it is updated. In a ...
https://dev.mysql.com/doc/refman/8.0/en/range-optimization.html
For UPDATE and DELETE statements, if the optimizer falls back to a full table scan and the sql_safe_updates system variable is enabled, an error occurs rather than a warning because, in effect, no key is used to determine which rows to modify. To ...
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/repair-table.html
This type of repair is like that done by myisamchk --safe-recover. Caution Use the USE_FRM option only if you cannot use regular REPAIR modes. For a MyISAM table, if you do not get OK, you should try repairing it with myisamchk --safe-recover. With ...[QUICK] [EXTENDED] [USE_FRM] REPAIR TABLE repairs a possibly corrupted table, for certain storage engines ...
https://dev.mysql.com/doc/refman/8.0/en/replication-features-variables.html
For this reason, replication of such a statement may not be safe when STATEMENT mode is in use. sql_mode is also replicated except for the NO_DIR_IN_CREATE mode; the replica always preserves its own value for NO_DIR_IN_CREATE, regardless of changes ...In addition, the enabling this variable has different effects with regard to temporary tables, table locking, and the SET PASSWORD statement in different MySQL ...