Search Results
https://dev.mysql.com/doc/connector-j/en/connector-j-unix-socket.html
Connector/J does not natively support connections to MySQL Servers with Unix domain sockets. However, there is provision for using 3rd-party libraries that supply the function via a pluggable socket factory. Such a custom factory should implement ...
https://dev.mysql.com/doc/refman/9.7/en/audit-log-component-security.html
This can be changed by setting the audit_log.file system variable at server startup. For security reasons, audit log files should be written to a directory accessible only to the MySQL server and to users with a legitimate reason to view the log.
https://dev.mysql.com/doc/refman/9.7/en/audit-log-security.html
This can be changed by setting the audit_log_file system variable at server startup. For security reasons, audit log files should be written to a directory accessible only to the MySQL server and to users with a legitimate reason to view the log.
https://dev.mysql.com/doc/refman/9.7/en/binlog-replication-configuration-overview.html
The source and each replica must be configured with a unique ID (using the server_id system variable). This section describes replication between MySQL servers based on the binary log file position method, where the MySQL instance operating as the ...The information in the binary log is stored in different logging formats according to the database changes being ...
https://dev.mysql.com/doc/refman/9.7/en/data-dictionary-object-cache.html
For information about valid values for dictionary object cache configuration options, refer to Section 7.1.8, “Server System Variables”. Both caches store table definitions but serve different parts of the MySQL server. The dictionary object ...
https://dev.mysql.com/doc/refman/9.7/en/engine-condition-pushdown-optimization.html
To disable it at server startup, set the optimizer_switch system variable's engine_condition_pushdown flag to off. This optimization improves the efficiency of direct comparisons between a nonindexed column and a constant. In such cases, the ...
https://dev.mysql.com/doc/refman/9.7/en/estimating-performance.html
For MyISAM tables, the key cache size is controlled by the key_buffer_size system variable. As long as everything is cached by the OS or the MySQL server, things become only marginally slower as the table gets bigger. In most cases, you can ...
https://dev.mysql.com/doc/refman/9.7/en/group-replication-deploying-in-multi-primary-or-single-primary-mode.html
The group's mode is a group-wide configuration setting, specified by the group_replication_single_primary_mode system variable, which must be the same on all members. Then carry out a full reboot of the group (a bootstrap by a server with ... Group ...
https://dev.mysql.com/doc/refman/9.7/en/key-cache-block-size.html
It is possible to specify the size of the block buffers for an individual key cache using the key_cache_block_size variable. The best performance for I/O operations is achieved when the size of read buffers is equal to the size of the native ...
https://dev.mysql.com/doc/refman/9.7/en/limit-optimization.html
In cases where using some other optimization might be faster, it is possible to turn off this optimization by setting the optimizer_switch system variable's prefer_ordering_index flag to off. If the server uses temporary tables to resolve a query, ... If you need only a specified number of rows from a result set, use a LIMIT clause in the query, rather than fetching the whole result set and throwing away the extra ...