Search Results
https://dev.mysql.com/doc/internals/en/differences-master-slave.html
Any intermediate state of the slave is identical to some intermediate state of the master. Note: it is not required that each intermediate state of the master is identical to some intermediate state of the slave. We now state the architectural ...
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/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/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 ...
https://dev.mysql.com/doc/ndbapi/en/ndb-nodejs-api-tablemapping.html
A TableMapping describes the mapping of a domain object in the application to a table stored in the database. A default table mapping is one which maps each column in a table to a field of the same name. TableMapping = { String table : "" , String ...mapAllColumns, if true, creates a default FieldMapping for all columns not listed in fields, such that that all columns not explicitly mapped are given a default mapping to a field of the same ...
https://dev.mysql.com/doc/ndbapi/en/ndb-nodejs-api-tablemetadata.html
The indexes array of TableMetadata contains one IndexMetadata object per table index. NDB implements a primary key as both an ordered index and a unique index, and might be viewed through the NDB API adapter as two indexes, but through a MySQL ...