Search Results
https://dev.mysql.com/doc/internals/en/join-buffer-size.html
A join buffer is never allocated for the first non-const table, even if it would be of type ALL or index. The buffer is allocated when we need to do a full join between two tables, and freed after the query is done. Accepted row combinations of ...
https://dev.mysql.com/doc/internals/en/myisam-directory.html
They are: mi_cache.c --- for reading records from a cache mi_changed.c --- a single routine for setting a "changed" flag (very short) mi_check.c --- for checking and repairing tables. Can be used to exactly replay a set of changes to a table.
https://dev.mysql.com/doc/internals/en/optimizer-determining-join-type.html
index: a sequential scan on an index ALL: a sequential scan of the entire table See: /sql/sql_select.h, enum join_type{}. For example, consider this query: SELECT * FROM Table1 WHERE indexed_column = 5 AND unindexed_column = 6 Since indexed_column ... When evaluating a conditional expression, MySQL decides what join type the expression ...
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/scripts-directory.html
Can be safely run during any upgrade to get the newest MySQL privilege tables mysql_install_db.sh --- Create privilege tables and func table mysql_secure_installation.sh --- Disallow remote root login, eliminate test, etc. mysql_setpermission.sh --- ...Linux programmers use it where Windows programmers would use a *.bat (batch filename ...
https://dev.mysql.com/doc/internals/en/write-row.html
buf is a byte array of data with a size of table->s->reclength You can use the field information to extract the data from the native byte array type. Example of this would be: for (Field **field=table->field ; *field ; field++) { ... } BLOBs must be ...Synopsis virtual int write_row ( buf); byte * buf ; Description This is the write_row ...
https://dev.mysql.com/doc/ndbapi/en/mccj-clusterj-constants.html
4.3.1.14.19 DEFAULT_PROPERTY_MGM_STRICT_TLS public static final int DEFAULT_PROPERTY_MGM_STRICT_TLS = 0; The default value of the MGM TLS level property 4.3.1.14.20 DEFAULT_PROPERTY_TABLE_WAIT_MSEC public static final int ...The default means that ...
https://dev.mysql.com/doc/ndbapi/en/mgm-errors.html
Table 3.9 Node ID allocation errors resulting from failure to assign a node ID Value Description NDB_MGM_ALLOCID_ERROR Generic error; may be possible to retry and recover NDB_MGM_ALLOCID_CONFIG_MISMATCH Non-recoverable generic error ... This section ...
https://dev.mysql.com/doc/ndbapi/en/ndb-examples-secondary-indexes-ndbrecord.html
*/ const NdbDictionary::Column *col1= myTable->getColumn("ATTR1"); if (col1 == NULL) APIERROR(myDict->getNdbError()); const NdbDictionary::Column *col2= myTable->getColumn("ATTR2"); if (col2 == NULL) APIERROR(myDict->getNdbError()); /* NdbRecord for ... This program illustrates how to use secondary indexes in the NDB API with the aid of the NdbRecord ...
https://dev.mysql.com/doc/ndbapi/en/ndb-ndbindexoperation.html
When the NdbTransaction::execute() method is invoked, the operation deletes a tuple from the table. When the NdbTransaction::execute() method is invoked, the operation updates a tuple found in the table. NdbIndexOperation Class Overview ...