Search Results
https://dev.mysql.com/doc/refman/8.4/en/replication-solutions-performance.html
To do this, set the relay_log system variable to specify the location of the relay log. If heavy disk I/O activity for reads of the binary log file and relay log files is an issue, consider increasing the value of the rpl_read_size system variable.
https://dev.mysql.com/doc/refman/8.4/en/revoke.html
When the read_only system variable is enabled, REVOKE requires the CONNECTION_ADMIN or privilege (or the deprecated SUPER privilege), in addition to any other required privileges described in the following discussion. | ...[IGNORE UNKNOWN USER] ...
https://dev.mysql.com/doc/workbench/en/wb-migration-database-concepts.html
Table 10.1 Conceptual equivalents between supported DBMS products and MySQL Concept MS SQL Server Sybase ASE PostgreSQL MySQL Note Authentication Yes Yes Yes Yes Auto_Increment Yes Yes Yes Yes PostgreSQL uses sequences for Auto_Increment. The ...
https://dev.mysql.com/doc/workbench/en/wb-mysql-connections-new.html
Figure 5.1 Setup New Connection Form Important The Configure Server Management button (bottom left) opens an optional configuration wizard for setting shell commands on the host. Fill out the connection details and optionally click Configure Server ... To add a connection, click the [+] icon to the right of the MySQL Connections title on the home ...
https://dev.mysql.com/doc/connectors/en/connector-j-connp-props-debugging-profiling.html
If set to "REQUIRED", an OpenTelemetry library must be available at run time, or connections to the MySQL Server will fail. logger The name of a class that implements 'com.mysql.cj.log.Log' that will be used to log messages to. Default Value ...
https://dev.mysql.com/doc/connectors/en/connector-j-connp-props-result-sets.html
clobberStreamingResults This will cause a streaming result set to be automatically closed, and any outstanding data still streaming from the server to be discarded if another query is executed before all the data has been read from the server.
https://dev.mysql.com/doc/connectors/en/connector-j-schema-validation.html
When working with MySQL Server 8.0.19 and later: Schema validation can be configured for a Collection, so that documents in the Collection are validated against a schema before they can be inserted or updated. This is done by specifying a JSON ...
https://dev.mysql.com/doc/connectors/en/connector-net-ref-mysqlclient.html
MySqlError Collection of error codes that can be returned by the server MySqlException The exception that is thrown when MySQL returns an error. ReplicationServerGroupConfigurationElement Defines a replication server group in the configuration file ... Classes Class Description AuthenticationPluginConfigurationElement Retrieves the authentication plugin configuration from the configuration ...
https://dev.mysql.com/doc/connectors/en/connector-python-api-errors.html
For some MySQL client or server errors it is not always clear which exception to raise. MySQL Server errors are mapped with Python exception based on their SQLSTATE value (see Server Error Message Reference). It is, however, possible to redefine ...
https://dev.mysql.com/doc/connector-net/en/connector-net-ref-mysqlclient.html
MySqlError Collection of error codes that can be returned by the server MySqlException The exception that is thrown when MySQL returns an error. ReplicationServerGroupConfigurationElement Defines a replication server group in the configuration file ... Classes Class Description AuthenticationPluginConfigurationElement Retrieves the authentication plugin configuration from the configuration ...