Search Results
https://dev.mysql.com/doc/workbench/en/wb-tutorial-visual-explain-dbt3.html
The Type changed from ALL to range, possible keys (and used key) changed from NULL to i_o_orderdate, and the number of scanned rows changed from 1.5 million to about 33 thousand. This tutorial describes how to use Explain reports to locate and fix ...
https://dev.mysql.com/doc/internals/en/guided-tour-majordir-myisam.html
Key handling programs on mysql-5.0/myisam: size name comment ---- ---- ------- 4668 mi_rkey.c for random key searches 3646 mi_rnext.c for next-key searches 15440 mi_key.c for managing keys + more mi_*.c programs The final notable group of files in ...We will begin by mentioning that myisam is one of what we call the MySQL storage engine ...
https://dev.mysql.com/doc/internals/en/index-read.html
Purpose Find a row based on a key and return. Synopsis virtual int index_read ( buf, key, keypart_map, find_flag); byte * buf ; const byte * key ; ulonglong keypart_map ; enum ha_rkey_function find_flag ; Description This is the index_read method.
https://dev.mysql.com/doc/internals/en/myisam-column-attributes.html
Note that internally this can be 2 even if Field_varchar->field_length < 256 (for example, for a shortened key to a varchar(256)) ... When creating a key for the handler, HA_KEYTYPE_VARTEXT1 and HA_KEYTYPE_BINARY1 are used for a key on a column that ... Next I'll describe the physical attributes of each column in a ...
https://dev.mysql.com/doc/internals/en/sql-directory.html
Programs for handling SQL commands. The "core" of MySQL. These are the .c and .cc files in the sql directory: derror.cc --- read language-dependent message file des_key_file.cc --- load DES keys from plaintext file discover.cc --- Functions for ...
https://dev.mysql.com/doc/internals/en/x-protocol-expect-expectations.html
Conditions Warning The layout of conditions are subject to change: not all may be implemented yet more conditions may be added Condition Key no_error 1 schema_version 2 gtid_executed_contains 3 gtid_wait_less_than_ms 4 no_error Fail all messages of ...Assume the PrepareFind fails: don't execute the Execute don't try to close the stmt Mysqlx.Expect::Open([+no_error]) Mysqlx.Crud::PrepareFind(stmt_id=1, ...) // may fail Mysqlx.PreparedStmt::Execute(stmt_id=1, ...) // expectation(no_error) failed Mysqlx.PreparedStmt::Close(stmt_id=1) // expectation(no_error) failed Mysqlx.Expect::Close() But this would also skip the close if execute ...
https://dev.mysql.com/doc/mysql-installer/en/MySQLInstallerConsole.html
option_value_pair: A single option (for example, --silent) or a tuple of a key and a corresponding value with an options prefix. Passing in a product keyword alone selects the latest version of the product. Alternatively, you can pass in the exact ... MySQLInstallerConsole.exe provides command-line functionality that is similar to MySQL ...
https://dev.mysql.com/doc/ndbapi/en/mccj-clusterj-annotation-extension.html
4.3.2.3.1 Synopsis @Target(value={java.lang.annotation.ElementType.TYPE, java.lang.annotation.ElementType.FIELD, java.lang.annotation.ElementType.METHOD}) @Retention(value=java.lang.annotation.RetentionPolicy.RUNTIME) public @interface Extension { ...
https://dev.mysql.com/doc/mysql-em-plugin/en/myoem-metric-mysqlserver-handleractivity-category.html
Read First (Delta) The number of requests to read a row based on a index key value. Read Key (Delta) The number of requests to read the last key in an index. Read Last (Delta) The number of requests to read the last key in an index. Read Next ...
https://dev.mysql.com/doc/x-devapi-userguide/en/connecting-connection-pool.html
A connection pool is configured using a single key-value pair (see Connecting Using Key-Value Pairs) that contains a single key named pooling. The value for the pooling key is another set of key-value pairs containing any combination of the keys ...