Search Results
https://dev.mysql.com/doc/x-devapi-userguide/en/synchronous-vs-asynchronous-execution.html
Traditionally, many MySQL drivers used a synchronous approach when executing SQL statements. This meant that operations such as opening connections and executing queries were blocked until completion, which could take a long time. Any MySQL client ...To allow for parallel execution, a developer had to write a multithreaded ...
MySQL NDB Cluster API Developer Guide :: 4.2.2.5 ClusterJ Mappings Between MySQL and Java Data Types
https://dev.mysql.com/doc/ndbapi/en/mccj-using-clusterj-mappings.html
ClusterJ provides mappings for all of the common MySQL database types to Java types. The following tables show the mappings used by ClusterJ between common Java data types and MySQL column types. The following table shows the ClusterJ mappings ...
https://dev.mysql.com/doc/heatwave-aws/en/heatwave-aws-user-management.html
Alternatively, to access the Oracle Identity Cloud Service from the MySQL HeatWave Console: Sign into the MySQL HeatWave Console as an Administrator. User Management 20.3 User Management User management is performed in the Oracle Cloud ...
https://dev.mysql.com/doc/internals/en/optimizer-determining-join-type.html
When evaluating a conditional expression, MySQL decides what join type the expression has. index: a sequential scan on an index ALL: a sequential scan of the entire table See: /sql/sql_select.h, enum join_type{}. Notice that there are a few other ...(Again: despite the word “join”, this applies for all conditional expressions, not just join ...
https://dev.mysql.com/doc/internals/en/plugin-services-components.html
A plugin accesses this information by including the plugin.h file (which plugins must include anyway): #include <mysql/plugin.h> plugin.h includes the services.h file, which acts as an “umbrella” file that includes the service-specific headers ... On the plugin side of the services interface, the relevant information is provided in a set of header ...
https://dev.mysql.com/doc/internals/en/optimizer-eliminating-dead-code.html
A transformation takes place for conditions that are always true, for example: WHERE 0=0 AND column1='y' In this case, the first condition is removed, leaving WHERE column1='y' See: /sql/sql_select.cc, remove_eq_conds(). Informally, we at MySQL say ...A transformation also takes place for conditions that are always ...
https://dev.mysql.com/doc/workbench/en/wb-mysql-firewall.html
You can modify the plugin controls as follows: Install: Executes queries to install the new MySQL Enterprise Firewall tables and stored procedure needed to switch the state. Note MySQL Workbench executes queries, gets variables, and performs a lot ... MySQL Workbench provides a graphical interface to MySQL Enterprise ...Firewall Rules and Information The Firewall Rules tab lists the active and recorded rules for a given user, the ...
https://dev.mysql.com/doc/internals/en/optimizer-index-join-type.html
Consider this query: SELECT column1 FROM Table1; If column1 is indexed, then the optimizer may choose to retrieve the values from the index rather than from the table. An index which is used this way is called a covering index in most texts. For ...
https://dev.mysql.com/doc/workbench/en/wb-keys.html
The following tables list keyboard shortcuts for MySQL Workbench commands.
https://dev.mysql.com/doc/connectors/en/connector-python-api-mysqlconnection-start-transaction.html
MySQL ignores this for isolation levels for which that option does not apply. If the server is older than MySQL 5.6.5, it does not support setting the access mode and Connector/Python raises a ValueError. This differs from executing a START ...It ...