Search Results
https://dev.mysql.com/doc/relnotes/connector-cpp/en/news-8-0-11.html
The server determines the ID format, which should be considered opaque from the API perspective (they are no longer UUID-based). If the server does not support document ID generation, the document-add operation returns an error indicating that ...
https://dev.mysql.com/doc/mysql-monitor/8.0/en/mem-troubleshooting-agent-start.html
On MySQL 5.5, or earlier, MySQL Enterprise Monitor Agent and MySQL Enterprise Service Manager use the unique host ID, stored within the mysql.inventory table on the monitored MySQL Server, to determine whether the instance being monitored is a clone. To do this see: Windows: Section 6.5.1, “Starting/Stopping the Agent on Windows” Unix: Section 6.5.3, “Starting/Stopping the Agent on Unix” macOS: Section 6.5.2, “Starting/Stopping the Agent on macOS” Some additional tips are: To run on start-up, the agent requires correct login credentials for the monitored MySQL ...
https://dev.mysql.com/doc/refman/8.4/en/show-events.html
REPLICA_SIDE_DISABLED indicates that the creation of the event occurred on another MySQL server acting as a replication source and replicated to the current MySQL server which is acting as a replica, but the event is not presently being executed on ...Originator The server ID of the MySQL server on which the event was created; used in ...In its simplest form, SHOW EVENTS lists all of the events in the current schema: mysql> SELECT CURRENT_USER(), SCHEMA(); +----------------+----------+ | CURRENT_USER() | SCHEMA() | +----------------+----------+ | jon@ghidora | myschema | ...
https://dev.mysql.com/doc/refman/8.4/en/system-variable-privileges.html
(For information about dynamic variables, see Section 7.1.9.2, “Dynamic System Variables”.) For certain global system variables, SET can be used to persist their value to the mysqld-auto.cnf file in the data directory, to affect server operation ...To persist a global system variable to the mysqld-auto.cnf file (and set the runtime value), use the SET PERSIST statement, which requires the SYSTEM_VARIABLES_ADMIN or SUPER ...
https://dev.mysql.com/doc/refman/8.4/en/binary-installation.html
MySQL compressed tar file binary distributions have names of the form mysql-VERSION-OS.tar.xz, where VERSION is a number (for example, 8.4.6), and OS indicates the type of operating system for which the distribution is intended (for example, ...This ...These include generic binary distributions in the form of compressed tar files (files with a .tar.xz extension) for a number of platforms, and binaries in platform-specific package formats for selected ...
https://dev.mysql.com/doc/refman/8.4/en/error-log-configuration.html
For example, to load the JSON log sink, issue the following statement: INSTALL COMPONENT 'file://component_log_sink_json'; Loading a component using INSTALL COMPONENT registers it in the mysql.component system table so that the server loads it ...By ... In MySQL 8.4, error logging uses the MySQL component architecture described at Section 7.5, “MySQL ...The error log subsystem consists of components that perform log event filtering and writing, as well as ...
https://dev.mysql.com/doc/refman/8.4/en/stored-routines.html
A stored routine is a set of SQL statements that can be stored in the server. For answers to some commonly asked questions regarding stored routines in MySQL, see Section A.4, “MySQL 8.4 FAQ: Stored Procedures and Functions”. Stored routines can ...Once this has been done, clients don't need to keep reissuing the individual statements but can refer to the stored routine ...
https://dev.mysql.com/doc/mysql-cluster-manager/8.4/en/mcm-configuration-commands.html
We begin with a discussion of what we mean by the term “configuration attribute”, and how this relates to the manual configuration of a MySQL NDB Cluster using MySQL NDB Cluster configuration parameters and MySQL Server options and variables ...
https://dev.mysql.com/doc/connectors/en/connector-j-connection-compression-xdevapi.html
Connector/J supports data compression for X DevAPI connections when working with MySQL Server 8.0.19 and later. Out of all the compression algorithms now supported by MySQL Server for X DevAPI connections, Connector/J provides out-of-the-box ...The ...General details about this feature can be found in Connection Compression with X ...
https://dev.mysql.com/doc/mysql-em-plugin/en/myoem-config-metric-statementprocessing-category.html
Big Selects Enabled If set to 0, MySQL aborts SELECT statements that are likely to take a very long time to execute (that is, statements for which the optimizer estimates that the number of examined rows exceeds the value of max_join_size). Buffer ... Lists the Statement Processing configuration metrics and provides a brief description of ...