Search Results
https://dev.mysql.com/doc/internals/en/good-tests.html
There are a lot of strict rules and rules of thumb which may increase the quality of tests written for the tool pair mysqltest/mysqltest-run.pl (MTR). See the Writing Test Cases section of the MySQL Server Doxygen documentation, available at ...
https://dev.mysql.com/doc/connectors/en/connector-j-config-failover.html
This, however, may lead to unexpected results: for example, if the driver is connected to the primary host with read/write access mode and it fails-over to a secondary host in read-only mode, further attempts to issue data-changing queries will ...A ...A connection using failover support works just like a standard connection: the client does not experience any disruptions in the failover ...
https://dev.mysql.com/doc/connector-j/en/connector-j-config-failover.html
This, however, may lead to unexpected results: for example, if the driver is connected to the primary host with read/write access mode and it fails-over to a secondary host in read-only mode, further attempts to issue data-changing queries will ...A ...A connection using failover support works just like a standard connection: the client does not experience any disruptions in the failover ...
https://dev.mysql.com/doc/internals/en/risky-handling-around-additional-sessions.html
Do we really need 10 seconds within the SLEEP? According to my experiences sleep times <= 2 seconds are critical under high load. If a disconnect <connection> or KILL <connection_id> or --exec <client program which connects to the server> occurs ...
https://dev.mysql.com/doc/refman/8.4/en/cost-model.html
To generate execution plans, the optimizer uses a cost model that is based on estimates of the cost of various operations that occur during query execution. The optimizer has a set of compiled-in default “cost constants” available to it to make ...Any non-NULL cost estimate specified in the tables takes precedence over the corresponding compiled-in default cost ...
https://dev.mysql.com/doc/workbench/en/wbcopytables.html
The copy executes a SELECT statement on the source database and then INSERT to insert the retrieved rows into the target MySQL server. You can use ODBC specific data source options from the source RDBMS to specify the number of rows to fetch at a ...
https://dev.mysql.com/doc/c-api/8.4/en/c-api-prepared-statement-interface-usage.html
To prepare and execute a statement, an application follows these steps: Create a prepared statement handler with mysql_stmt_init(). You can repeat the mysql_stmt_execute() to re-execute the statement by changing parameter values in the respective ...To prepare the statement on the server, call mysql_stmt_prepare() and pass it a string containing the SQL ...
https://dev.mysql.com/doc/workbench/en/wb-vertical-toolbar.html
The vertical toolbar appears on the left sidebar (see the following figure) when an EER diagram tab is selected. Figure 9.12 The Vertical Toolbar Clicking a tool changes the mouse pointer to a pointer that resembles the tool icon, indicating which ...
https://dev.mysql.com/doc/workbench/en/wb-migration-database-postgresql-typemapping.html
DATE DATE TIME TIME TIMESTAMP DATETIME INTERVAL TIME BYTEA LONGBLOB TEXT LONGTEXT CIDR VARCHAR(43) INET VARCHAR(43) MACADDR VARCHAR(17) UUID VARCHAR(36) XML LONGTEXT JSON LONGTEXT TSVECTOR LONGTEXT TSQUERY LONGTEXT ARRAY LONGTEXT POINT POINT LINE ...
https://dev.mysql.com/doc/mysql-em-plugin/en/myoem-config-metric-binarylogs-category.html
Binlog Max Flush Queue Time How long in microseconds to keep reading transactions from the flush queue before proceeding with the group commit (and syncing the log to disk, if sync_binlog is greater than 0). Binlog Error Action Controls what happens ... Lists the Binary Logs configuration metrics and provides a brief description of ...