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/partitioning-management-range-list.html
For information about working with tables that are partitioned by hash or key, see Section 26.3.2, “Management of HASH and KEY Partitions”. Adding and dropping of range and list partitions are handled in a similar fashion, so we discuss the ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-log-status-table.html
LOCAL The log position state information from the source, provided as a single JSON object with the following keys: binary_log_file The name of the current binary log file. STORAGE_ENGINES Relevant information from individual storage engines, ...
https://dev.mysql.com/doc/refman/8.0/en/replication-features-errors.html
This can happen, for example, on a multiple-row insert that has one row violating a key constraint, or if a long update statement is killed after updating some of the rows. For example, since MyISAM ignores foreign key constraints, an INSERT or ...
https://dev.mysql.com/doc/refman/8.0/en/replication-options-reference.html
replica_exec_mode: Allows for switching replication thread between IDEMPOTENT mode (key and some other errors suppressed) and STRICT mode; STRICT mode is default, except for NDB Cluster, where IDEMPOTENT is always used. slave_exec_mode: Allows for ... The following two sections provide basic information about the MySQL command-line options and system variables applicable to replication and the binary ...
https://dev.mysql.com/doc/refman/8.0/en/server-options.html
Consider setting at least the admin_ssl_cert and admin_ssl_key system variables on the server side and the --ssl-ca (or --ssl-capath) option on the client side. InnoDB tablespace encryption relies on the MySQL Keyring for encryption key management, ... When you start the mysqld server, you can specify program options using any of the methods described in Section 6.2.2, “Specifying Program ...
https://dev.mysql.com/doc/refman/8.0/en/truncate-table.html
Thus, it does not cause ON DELETE triggers to fire, it cannot be performed for InnoDB tables with parent-child foreign key relationships, and it cannot be rolled back like a DML operation. TRUNCATE TABLE fails for an InnoDB table or NDB table if ...
https://dev.mysql.com/doc/refman/8.0/en/alter-table-problems.html
If you get a duplicate-key error when using ALTER TABLE to change the character set or collation of a character column, the cause is either that the new column collation maps two keys to the same value or that the table is corrupted. In the latter ...
https://dev.mysql.com/doc/refman/8.0/en/audit-log-installation.html
This section describes how to install or uninstall MySQL Enterprise Audit, which is implemented using the audit log plugin and related elements described in Section 8.4.5.1, “Elements of MySQL Enterprise Audit”. For general information about ...
https://dev.mysql.com/doc/refman/8.0/en/binary-varbinary.html
For those cases where trailing pad bytes are stripped or comparisons ignore them, if a column has an index that requires unique values, inserting values into the column that differ only in number of trailing pad bytes results in a duplicate-key ...
https://dev.mysql.com/doc/refman/8.0/en/blob.html
This means that, if the index requires unique values, duplicate-key errors occur for values that differ only in the number of trailing spaces. For example, if a table contains 'a', an attempt to store 'a ' causes a duplicate-key error. A BLOB is a ...