PDF (US Ltr)
- 43.2Mb
PDF (A4)
- 43.3Mb
Man Pages (TGZ)
- 295.2Kb
Man Pages (Zip)
- 400.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/innodb-online-ddl-limitations.html
The following limitations apply to online DDL operations: The table is copied when creating an index on a TEMPORARY TABLE. Tables created before MySQL 5.6 that include temporal columns (DATE, DATETIME or TIMESTAMP) and have not been rebuilt using ...The ALTER TABLE clause LOCK=NONE is not permitted if there are ON...CASCADE or ON...SET NULL constraints on the ...When the DML operations are applied, it is possible to encounter a duplicate key entry error (ERROR 1062 (23000): ...
https://dev.mysql.com/doc/refman/8.0/en/ldap-pluggable-authentication.html
LDAP pluggable authentication provides these capabilities: External authentication: LDAP authentication enables MySQL Server to accept connections from users defined outside the MySQL grant tables in LDAP directories. The following tables show the ... Note LDAP pluggable authentication is an extension included in MySQL Enterprise Edition, a commercial ...
https://dev.mysql.com/doc/refman/8.0/en/partitioning-pruning.html
By limiting the search, it is possible to expend much less time and effort in finding matching rows than by scanning all partitions in the table. When the optimizer can make use of partition pruning in performing this query, execution of the query ... The optimization known as partition pruning is based on a relatively simple concept which can be described as “Do not scan partitions where there can be no matching ...
https://dev.mysql.com/doc/refman/8.0/en/ndb-restore-to-different-version.html
Tables created in NDB 8.0 by default use the utf8mb4_ai_ci character set, which is not available in NDB 7.6 and earlier, and so cannot be read by an ndb_restore binary from one of these earlier versions. Due to changes in how the MySQL Server and ...
https://dev.mysql.com/doc/refman/8.0/en/stored-programs-logging.html
Triggers can update tables, so error messages similar to those for stored functions occur with CREATE TRIGGER if you do not have the required privileges. The use of NAME_CONST() can result in a problem for CREATE TABLE ... If a stored program that ... The binary log contains information about SQL statements that modify database ...
https://dev.mysql.com/doc/refman/8.0/en/audit-log-reference.html
Audit Log Tables MySQL Enterprise Audit uses tables in the mysql system database for persistent storage of filter and user account data. The tables can be accessed only by users who have privileges for that database. If these tables are missing, the ...Unless those objects are installed, the audit_log plugin operates in legacy mode (deprecated in MySQL ...
https://dev.mysql.com/doc/refman/8.0/en/commit.html
In read-only mode, it remains possible to change tables created with the TEMPORARY keyword using DML statements. To disable autocommit mode implicitly for a single series of statements, use the START TRANSACTION statement: START TRANSACTION; SELECT ...SET autocommit disables or enables the default autocommit mode for the current ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-locking-reads.html
However, FOR SHARE supports OF table_name, NOWAIT, and SKIP LOCKED options. FOR SHARE requires the SELECT privilege and at least one of the DELETE, LOCK TABLES, or UPDATE privileges. FOR SHARE statements do not acquire read locks on MySQL grant ...
https://dev.mysql.com/doc/refman/8.0/en/partitioning-management-hash-key.html
Tables which are partitioned by hash or by key are very similar to one another with regard to making changes in a partitioning setup, and both differ in a number of ways from tables which have been partitioned by range or list. For that reason, ...
https://dev.mysql.com/doc/refman/8.0/en/firewall-usage.html
The allowlist is the set of rules that defines which statements are acceptable to the profile. For example: the profile can be placed in training mode to establish the allowlist; the allowlist can be used for restricting statement execution or ...