Search Results
https://dev.mysql.com/doc/heatwave/en/mys-hw-genai-generate-content.html
Note In versions older than MySQL 9.2.1, to alter an existing table or create a new table, MySQL requires you to set the sql-require-primary-key system variable to 0. Generate Content To generate text-based content using MySQL HeatWave GenAI, ...
https://dev.mysql.com/doc/mysql-cluster-manager/8.4/en/mcm-set.html
Example: mcm> set filesystem-password-file:ndbmtd:=/home/myndb/myc.pwd mycluster; See Setting Up Encryption, for more information. Setting a variable which is not dynamic triggers an immediate restart. Setting Up Encryption NDB Cluster 8.0.31 and ...
https://dev.mysql.com/doc/refman/8.4/en/set-sql-log-bin.html
Setting the session value of this system variable is a restricted operation. SET sql_log_bin = {OFF|ON} The sql_log_bin variable controls whether logging to the binary log is enabled for the current session (assuming that the binary log itself is ...It is not possible to set the session value of sql_log_bin within a transaction or ...
https://dev.mysql.com/doc/connectors/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/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/8.4/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/8.4/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/8.4/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/8.4/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/8.4/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 ...