Search Results
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/heatwave-aws/en/heatwave-aws-sign.html
Signing In 2.3 Signing In This procedure assumes that you are an Oracle Cloud Account customer registered to use MySQL HeatWave on AWS. Signing in to MySQL HeatWave on AWS requires: An Oracle Cloud Account name. This is the Oracle Cloud Account you ...Your user belongs to one of the user Groups described in Groups and ...
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 ...
https://dev.mysql.com/doc/connector-python/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 ...
https://dev.mysql.com/doc/internals/en/rows-event.html
repeat rows until event-end Fields table_id (6) -- If the table id is 0x00ffffff it is a dummy event that should have the end of statement flag set that declares that all table maps can be freed. Note if the post_header_length in the ...
https://dev.mysql.com/doc/internals/en/writing-services-for-use-from-plugins.html
Services are implemented by modifying server code in the sql directory to register the service in the plugin code, and by providing interface files in the libservices directory and under the include directory. For complete instructions on writing a ...As you read the HOWTO file, you might find it useful to examine the files that implement existing ...
https://dev.mysql.com/doc/ndbapi/en/overview-selecting-tc.html
The application programmer can specify the partition key from SQL by using the following construct: CREATE TABLE ... ENGINE=NDB PARTITION BY KEY (attribute_list); For additional information, see Partitioning, and in particular KEY Partitioning, in ... The default method is to select the transaction coordinator (TC) determined to be the "nearest" data node, using a heuristic for proximity based on the type of transporter ...