Search Results
https://dev.mysql.com/doc/c-api/8.4/en/c-api-basic-interface-usage.html
An advantage of mysql_use_result() is that the client requires less memory for the result set because it maintains only one row at a time (and because there is less allocation overhead, mysql_use_result() can be faster). Application programs should ...For applications that are linked with the client library, they provide improved memory ...
https://dev.mysql.com/doc/refman/8.4/en/replication-delayed.html
MySQL supports delayed replication such that a replica server deliberately executes transactions later than the source by at least a specified amount of time. In MySQL 8.4, the method of delaying replication depends on two timestamps, ...This ...
https://dev.mysql.com/doc/workbench/en/wb-command-line-options.html
In addition to platform-specific command-line options, MySQL Workbench has the following command-line options: --log-level level: Controls the verbosity level for logging output from Workbench. The location of the generated log files, such as ...
https://dev.mysql.com/doc/workbench/en/wb-migration-install.html
The MySQL Workbench Migration Wizard uses ODBC to connect to a source database, except for MySQL. The following figure shows the general components involved in an ODBC connection: An ODBC driver for MySQL server and the other relational database ...
https://dev.mysql.com/doc/workbench/en/wb-performance-explain.html
The visual explain feature generates and displays a visual representation of the MySQL EXPLAIN statement by using extended information available in the extended JSON format. MySQL Workbench provides all of the EXPLAIN formats for executed queries ...Visual Explain Usage To view a visual explain execution plan, execute your query from the SQL editor and then select Execution Plan within the query results ...
https://dev.mysql.com/doc/connectors/en/connector-j-reference-charsets.html
For example, to use the 4-byte UTF-8 character set with Connector/J, configure the MySQL server with character_set_server=utf8mb4, and leave characterEncoding and connectionCollation out of the Connector/J connection string. MySQL to Java Encoding ...Setting the Character Encoding For Connector/J 8.0.25 and earlier: The character encoding between the client and the server is automatically detected upon connection (provided that the Connector/J connection properties characterEncoding and connectionCollation are not ...
https://dev.mysql.com/doc/connectors/en/connector-j-usagenotes-j2ee-concepts-managing-load-balanced-connections.html
Connector/J has long provided an effective means to distribute read/write load across multiple MySQL server instances for Cluster or source-source replication deployments. If you now had an additional instance of MySQL running on port 3309, you ...
https://dev.mysql.com/doc/connectors/en/connector-j-usagenotes-spring-config.html
This article will focus on Java-oriented access to MySQL databases with Spring 2.0. For the examples in this section the MySQL world sample database will be used. The first task is to set up a MySQL data source through Spring. For example, to ...
https://dev.mysql.com/doc/connectors/en/connector-net-medium-trust-gac.html
After installing the library, make the following configuration changes: In the SecurityClasses section, add a definition for the MySqlClientPermission class, including the version to use. <SecurityClass Name="MySqlClientPermission" ... If the ...
https://dev.mysql.com/doc/connectors/en/connector-net-programming.html
MySQL Connector/NET comprises several classes that are used to connect to the database, execute queries and statements, and manage query results. The following are the major classes of Connector/NET: MySqlConnection: Represents an open connection ...