Search Results
https://dev.mysql.com/doc/refman/8.4/en/mysql-shell-tutorial-python-shell.html
For more information, see Section 6.2.5, “Connecting to the Server Using URI-Like Strings or Key-Value Pairs”. mysql-py> MySQL Shell supports input-line editing as follows: left-arrow and right-arrow keys move horizontally within the current ...
https://dev.mysql.com/doc/refman/8.4/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.4/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.4/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.4/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.4/en/telemetry-metrics-configuration.html
telemetry.otel_exporter_otlp_metrics_client_key System Variable telemetry.otel_exporter_otlp_metrics_client_key Scope Global Dynamic No SET_VAR Hint Applies No Type String Default Value [none] Client's private key in PEM format. Server ...
https://dev.mysql.com/doc/refman/8.4/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/mysql-enterprise-backup/8.4/en/advanced.encrypted-binlog-relaylog.html
mysqlbackup then copies over from the server the encrypted keyring data file, which contains the replication master key used to encrypt all the passwords for the individual log files, into the meta folder in the backup and names the file keyring_kef. If the server uses a keyring plugin or component other than component_keyring_encrypted_file, mysqlbackup accesses the keyring to obtain the replication master key and uses it to decrypt the individual log files' ...
https://dev.mysql.com/doc/relnotes/connector-j/en/news-9-1-0.html
Functionality Added or Changed Bugs Fixed Functionality Added or Changed When connecting to a server using SSL, the truststore password is now made optional, with a null truststore password taken to mean that there is no need to check the ...
https://dev.mysql.com/doc/mysql-ai/9.5/en/mysql-ai-platforms.html
You have TLS certificates and keys that satisfy the MySQL requirements. See Creating SSL and RSA Certificates and Keys if you want to configure encrypted communication with the MySQL AI components using your own certificates and keys. System ...