Search Results
https://dev.mysql.com/doc/refman/8.4/en/partitioning-limitations.html
As discussed elsewhere in this Manual (see Section 7.1.11, “Server SQL Modes”), the results of many MySQL functions and operators may change according to the server SQL mode. For these reasons, it is strongly recommended that you never change ...
https://dev.mysql.com/doc/workbench/en/wb-migration-database-mssql-connection-windows.html
Select Microsoft SQL Server as the database system and fill out the remaining options as described in this section. Figure 10.42 SQL Server Connection Parameters Example on Windows Database System: Microsoft SQL Server Connection Method: choose ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-distributed-recovery-connections.html
In this situation you can use MySQL Server's report_host system variable to configure a unique host name to be externalized by each of the servers. Important Distributed recovery can fail if a joining member cannot correctly identify the other ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-shm-definition.html
The shared-memory transporter (SHM) can improve performance by negating up to 20% of the overhead required by a TCP connection when running an API node (usually an SQL node) and a data node together on the same host. Suppose a cluster is running a ... Communications between NDB cluster nodes are normally handled using ...
https://dev.mysql.com/doc/internals/en/optimizer-joins-access-methods.html
Bad join choices can cause more damage than bad choices in single-table searches, so MySQL developers have spent proportionally more time making sure that the tables in a query are joined in an optimal order and that optimal access methods (often ...A combination of a fixed order in which tables are joined and the corresponding table access methods for each table is called query execution plan ...
https://dev.mysql.com/doc/connectors/en/connector-j-connp-props-high-availability-and-clustering.html
Default Value 0 Since Version 5.1.6 ha.loadBalanceStrategy If using a load-balanced connection to connect to SQL servers in a MySQL Cluster configuration (by using the URL prefix "jdbc:mysql:loadbalance://"), which load balancing algorithm should ...
https://dev.mysql.com/doc/connector-j/en/connector-j-connp-props-high-availability-and-clustering.html
Default Value 0 Since Version 5.1.6 ha.loadBalanceStrategy If using a load-balanced connection to connect to SQL servers in a MySQL Cluster configuration (by using the URL prefix "jdbc:mysql:loadbalance://"), which load balancing algorithm should ...
https://dev.mysql.com/doc/connectors/en/connector-j-reference-implementation-notes.html
Connector/J also supplies two additional methods: setLocalInfileInputStream() sets an InputStream instance that will be used to send data to the MySQL server for a LOAD DATA LOCAL INFILE statement rather than a FileInputStream or URLInputStream that ... MySQL Connector/J, as a rigorous implementation of the JDBC API, passes all of the tests in the publicly available version of Oracle's JDBC compliance test ...
https://dev.mysql.com/doc/connector-j/en/connector-j-reference-implementation-notes.html
Connector/J also supplies two additional methods: setLocalInfileInputStream() sets an InputStream instance that will be used to send data to the MySQL server for a LOAD DATA LOCAL INFILE statement rather than a FileInputStream or URLInputStream that ... MySQL Connector/J, as a rigorous implementation of the JDBC API, passes all of the tests in the publicly available version of Oracle's JDBC compliance test ...
https://dev.mysql.com/doc/c-api/8.4/en/c-api-building-clients.html
To determine the correct directory, try this command: mysql_config --libs The output from mysql_config might indicate other libraries that should be specified on the link command as well. This section provides guidelines for compiling C programs ...