Search Results
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/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/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 ...
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/connectors/en/connector-python-api-errors-error.html
errors.Error is internally used by Connector/Python to raise MySQL client and server errors and should not be used by your application to raise exceptions. Additionally, each instance has the attributes errno, msg and sqlstate which can be used in ... This exception is the base class for all other exceptions in the errors ...