Search Results
https://dev.mysql.com/doc/refman/8.4/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/8.4/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/c-api/8.4/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/connectors/en/connector-j-usagenotes-known-issues-limitations.html
To use Windows named pipes for connections, the MySQL Server that Connector/J wants to connect to must be started with the system variable named_pipe_full_access_group; see Section 3.5.11, “Connecting Using Named Pipes” for details. Therefore, ... The following are some known issues and limitations for MySQL Connector/J: When Connector/J retrieves timestamps for a daylight saving time (DST) switch day using the getTimeStamp() method on the result set, some of the returned values might be ...
https://dev.mysql.com/doc/internals/en/debug-sync-facility.html
To do so, assign a value to the DEBUG_SYNC system variable: SET DEBUG_SYNC= 'after_open_tables SIGNAL opened WAIT_FOR flushed'; This activates the synchronization point named 'after_open_tables'. MySQL supports a Debug Sync Facility, which - in ...
https://dev.mysql.com/doc/relnotes/connector-net/en/news-8-0-13.html
(Bug #26421346, Bug #86974) Slow connections made to MySQL were improved by reducing the frequency and scope of operating system details required by the server to establish and maintain a connection. (Bug #28560189, Bug #92206) Document Store: ...
https://dev.mysql.com/doc/connector-j/en/connector-j-usagenotes-known-issues-limitations.html
To use Windows named pipes for connections, the MySQL Server that Connector/J wants to connect to must be started with the system variable named_pipe_full_access_group; see Section 6.11, “Connecting Using Named Pipes” for details. Therefore, ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-replication-mta.html
Writeset Tracking Memory Usage The amount of memory used to track binary log transaction writesets can be set using the binlog_transaction_dependency_history_size server system variable, which defaults to 25000 row hashes. To use this functionality ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-table-handles-table.html
It is autosized by default; to configure the table size, set the performance_schema_max_table_handles system variable at server startup. This information shows which table handles the server has open, how they are locked, and by which sessions. The ...
https://dev.mysql.com/doc/refman/8.4/en/pluggable-storage.html
The shared library must be located in the MySQL server plugin directory, the location of which is given by the plugin_dir system variable. MySQL Server uses a pluggable storage engine architecture that enables storage engines to be loaded into and ...Plugging in a Storage Engine Before a storage engine can be used, the storage engine plugin shared library must be loaded into MySQL using the INSTALL PLUGIN ...