Search Results
https://dev.mysql.com/doc/connectors/en/connector-j-connp-props-tunes-for-integration-with-other-products.html
overrideSupportsIntegrityEnhancementFacility Should the driver return "true" for 'DatabaseMetaData.supportsIntegrityEnhancementFacility()' even if the database doesn't support it to workaround applications that require this method to return "true" ...
https://dev.mysql.com/doc/connector-j/en/connector-j-connp-props-tunes-for-integration-with-other-products.html
overrideSupportsIntegrityEnhancementFacility Should the driver return "true" for 'DatabaseMetaData.supportsIntegrityEnhancementFacility()' even if the database doesn't support it to workaround applications that require this method to return "true" ...
https://dev.mysql.com/doc/internals/en/tuning-trace-purging.html
This is done with SET optimizer_trace_offset=<OFFSET>, optimizer_trace_limit=<LIMIT> where OFFSET is a signed integer, and LIMIT is a positive integer. The default for optimizer_trace_offset is -1; the default for optimizer_trace_limit is 1. The ...
https://dev.mysql.com/doc/mysql-monitor/8.0/en/mem-agent-tuning-memory.html
The following are the recommended settings for MySQL Enterprise Monitor Agent: A single agent, with default settings and all advisors enabled, should monitor no more than 10 MySQL instances. If the agent is monitoring more than 10 MySQL instances, ...The agent heap size is defined in the MEM_AGENT_JAVA_OPTS parameter in the setenv.sh/bat ...
https://dev.mysql.com/doc/refman/8.4/en/replication-options-binary-log.html
Log flushing occurs as indicated in Section 7.4, “MySQL Server Logs”. For additional information about using MySQL server options and system variables, see Section 7.1.7, “Server Command Options”, and Section 7.1.8, “Server System ...For ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-options-variables.html
This includes all rows read by any primary key, unique key, or scan operation made by this MySQL Server (SQL node). This includes all rows read by any primary key, unique key, or scan operation made by this MySQL Server (SQL node). This section ...
https://dev.mysql.com/doc/refman/8.4/en/docker-mysql-more-topics.html
Configuring the MySQL Server When you start the MySQL Docker container, you can pass configuration options to the server through the docker run command. For example: docker run --name mysql1 -d ...A MySQL Docker installation is different from a ...
https://dev.mysql.com/doc/refman/8.4/en/replication-options-replica.html
On the source and each replica, you must set the server_id system variable to establish a unique replication ID in the range from 1 to 232 − 1. Example my.cnf file: [mysqld] server-id=3 Startup Options for Replica Servers This section explains ...
https://dev.mysql.com/doc/refman/8.4/en/using-encrypted-connections.html
MySQL servers compiled using OpenSSL can generate missing certificate and key files automatically at startup. (The certificate is self-signed if created automatically by the server.) MySQL also provides these system variables for server-side ...See ...
https://dev.mysql.com/doc/refman/8.4/en/keyring-key-migration.html
Subsequent startup fails when a server run as the mysql operating system user attempts to access file system objects owned by isabel. In addition, specify connection options indicating how to connect to the running server, so that ...This pertains ... A keyring migration copies keys from one keystore to another, enabling a DBA to switch a MySQL installation to a different ...A successful migration operation ...