Search Results
https://dev.mysql.com/doc/refman/8.4/en/audit-log-installation.html
To be usable by the server, the plugin library file must be located in the MySQL plugin directory (the directory named by the plugin_dir system variable). If necessary, configure the plugin directory location by setting the value of plugin_dir at ...
https://dev.mysql.com/doc/c-api/8.4/en/c-api-prepared-statement-data-structures.html
For input, buffer_type indicates the type of the variable containing the value to be sent to the server. For output, it indicates the type of the variable into which a value received from the server should be stored. MYSQL_BIND structures are also ... Prepared statements use several data structures: To obtain a statement handler, pass a MYSQL connection handler to mysql_stmt_init(), which returns a pointer to a MYSQL_STMT data ...
https://dev.mysql.com/doc/refman/8.4/en/upgrading-from-previous-series.html
Changed Server Defaults This section contains information about MySQL server system variables whose default values have changed in MySQL 8.4 as compared to MySQL 8.0. Setting server variables equal to SQL NULL on the command line is not supported.
https://dev.mysql.com/doc/refman/8.4/en/select-into.html
Support is provided for periodic synchronization of output files written to by SELECT INTO OUTFILE and SELECT INTO DUMPFILE, enabled by setting the select_into_disk_sync server system variable introduced in that version. The character_set_filesystem ...INTO form of SELECT enables a query result to be stored in variables or written to a file: SELECT ...
https://dev.mysql.com/doc/refman/8.4/en/reset-persist.html
Removing a persisted system variable causes the variable no longer to be initialized from mysqld-auto.cnf at server startup. RESET PERSIST [[IF EXISTS] system_var_name] RESET PERSIST removes persisted global system variable settings from the ...If ...
https://dev.mysql.com/doc/refman/8.4/en/audit-log-filter-definitions.html
Example: { "filter": { "class": { "name": "general", "event": { "name": "status", "log": { "variable": { "name": "audit_log_connection_policy_value", "value": "::none" } } } } } } Each predefined variable corresponds to a system variable. By writing ...An event in the connection class indicates when a connection-related activity occurs during a session, such as a user connecting to or disconnecting from the ...
https://dev.mysql.com/doc/refman/8.4/en/charset-metadata.html
When you use SELECT column1 FROM t, the name column1 itself is returned from the server to the client in the character set determined by the value of the character_set_results system variable, which has a default value of utf8mb4. If ...The metadata ... Metadata is “the data about the data.” Anything that describes the database—as opposed to being the contents of the database—is ...
https://dev.mysql.com/doc/workbench/en/wb-what-is-new-63.html
Additional suggestions are now available, such as system variables, engines, table spaces, logfile groups, and more. This is another way to transfer data from one MySQL server to another while performing a migration, and it complements the existing ... This section summarizes many of the new features added to MySQL Workbench 6.3, in relation to the MySQL Workbench 6.2 ...
https://dev.mysql.com/doc/connectors/en/connector-cpp-authentication.html
LDAP authentication requires use of a server from a MySQL Enterprise Edition distribution. This package now is required only on hosts where Connector/C++ applications make connections using commercial MySQL server accounts with LDAP authentication.
https://dev.mysql.com/doc/refman/8.4/en/replication-gtids-restrictions.html
If binlog_format is set to STATEMENT, CREATE TEMPORARY TABLE and DROP TEMPORARY TABLE statements cannot be used inside transactions, procedures, functions, and triggers when GTIDs are in use on the server (that is, when the enforce_gtid_consistency ...To prevent execution of statements that would cause GTID-based replication to fail, all servers must be started with the --enforce-gtid-consistency option when enabling ...