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/implementing-the-info-method.html
The optimizer requests an update of table information by calling the [custom-engine.html#custom-engine-api-reference-info handler::info()] method. These values are also used to populate certain SHOW outputs such as SHOW TABLE STATUS and for queries ...The info() method does not have a return value, instead it is expected that the storage engine will set a variety of public variables that the server will then read as ...
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 ...