Search Results
https://dev.mysql.com/doc/refman/9.7/en/replication-features-temptables.html
In statement-based replication mode, CREATE TEMPORARY TABLE and DROP TEMPORARY TABLE statements cannot be used inside a transaction, procedure, function, or trigger when GTIDs are in use on the server (that is, when the enforce_gtid_consistency ...
https://dev.mysql.com/doc/refman/9.7/en/rewriter-query-rewrite-plugin.html
The Rewriter plugin exposes system variables that enable plugin configuration and status variables that provide runtime operational information. MySQL supports query rewrite plugins that can examine and possibly modify SQL statements received by ...
https://dev.mysql.com/doc/mysql-shell/9.7/en/mysql-innodb-cluster-working-with-clone.html
The combination of factors mentioned influences which of these options is available at the prompt as follows: Note If the group_replication_clone_threshold system variable has been manually changed outside of AdminAPI, then the cluster might decide ...For an instance considered New, incremental recovery cannot be considered appropriate because it is impossible to determine if the binary logs have been purged, or even if the GTID_PURGED and GTID_EXECUTED variables were ...
https://dev.mysql.com/doc/c-api/9.7/en/mysql-stmt-send-long-data.html
The max_allowed_packet system variable controls the maximum size of parameter values that can be sent with mysql_stmt_send_long_data(). bool mysql_stmt_send_long_data(MYSQL_STMT *stmt, unsigned int parameter_number, const char *data, unsigned long ...It can be called multiple times to send the parts of a character or binary data value for a column, which must be one of the TEXT or BLOB data ...
https://dev.mysql.com/doc/refman/9.7/en/rewriter-query-rewrite-plugin-reference.html
7.6.4.3.3 Rewriter Query Rewrite Plugin System Variables The Rewriter query rewrite plugin supports the following system variables. rewriter_enabled System Variable rewriter_enabled Scope Global Dynamic Yes SET_VAR Hint Applies No Type Boolean ...If ...Users communicate with the plugin by modifying the set of rules stored in this ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-genai-rag.html
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. To define your natural-language query, set the @query variable: mysql> SET ... The ...
https://dev.mysql.com/doc/connectors/en/connector-j-named-pipe.html
As a workaround, the MySQL Server that Connector/J wants to connect to must be started with the system variable named_pipe_full_access_group, which specifies a Windows local group containing the user by which the client application JVM (and thus ...
https://dev.mysql.com/doc/connector-j/en/connector-j-named-pipe.html
As a workaround, the MySQL Server that Connector/J wants to connect to must be started with the system variable named_pipe_full_access_group, which specifies a Windows local group containing the user by which the client application JVM (and thus ...
https://dev.mysql.com/doc/refman/9.7/en/innodb-benefits.html
InnoDB tables have the following benefits: If the server unexpectedly exits because of a hardware or software issue, regardless of what was happening in the database at the time, you don't need to do anything special after restarting the database.
https://dev.mysql.com/doc/refman/9.7/en/macos-installation-notes.html
Homebrew: For example, if you installed MySQL Server using Homebrew to its default location then the MySQL installer installs to a different location and won't upgrade the version from Homebrew. Stop the other MySQL Server instances before running ... You should keep the following issues and notes in mind: Other MySQL installations: The installation procedure does not recognize MySQL installations by package managers such as ...