Search Results
https://dev.mysql.com/doc/internals/en/binlog-event-flag.html
Hex Flag 0x0001 LOG_EVENT_BINLOG_IN_USE_F 0x0002 LOG_EVENT_FORCED_ROTATE_F 0x0004 LOG_EVENT_THREAD_SPECIFIC_F 0x0008 LOG_EVENT_SUPPRESS_USE_F 0x0010 LOG_EVENT_UPDATE_TABLE_MAP_VERSION_F 0x0020 LOG_EVENT_ARTIFICIAL_F 0x0040 LOG_EVENT_RELAY_LOG_F ...
https://dev.mysql.com/doc/internals/en/determining-logging-format.html
The sp_head object stores the Lex that was generated when the statement defining the sub-statement was parsed (that is, when CREATE FUNCTION/CREATE PROCEDURE/CREATE TRIGGER/CREATE VIEW/PREPARE was parsed). For each statement, we must determine the ...
https://dev.mysql.com/doc/internals/en/myisam-introduction.html
MySQL creates files named Table1.MYD ("MySQL Data"), Table1.MYI ("MySQL Index"), and Table1.frm ("Format"). "Filler Bits" = 1 The length of the record header is thus: (1 + number of NULL columns + 7) / 8 bytes After the header, all columns are ...
https://dev.mysql.com/doc/internals/en/optimizer-partition-pruning.html
Suppose that we have a partitioned table with N columns, using partitioning type p_type and the partitioning function p_func, represented like this: CREATE TABLE t (columns) PARTITION BY p_type(p_func(col1, col2,... 7.3.2.1.2.2 Interval Walking Let ...Partitions that did not get into this set (that is, those that were pruned away) will not be accessed at all: this is how query execution is made ...
https://dev.mysql.com/doc/internals/en/prepared-stored-statement-execution.html
We don't want the garbage created during execution to be left in the permanent arena of the statement. The execution plan created at prepare stage is not saved (see Section 17.2, “Preparation of a Prepared Statement”), and at execute we simply ... In order to call mysql_execute_command (the function that executes a statement) for a prepared statement and not damage its parse tree, we backup and restore the active Query_arena of ...
https://dev.mysql.com/doc/internals/en/select-union.html
Create a temporary table for storing union results (if UNION without ALL option, 'distinct' parameter will be passed to the table creation procedure). Assign a temporary table to the select_union object created in the first step. A special ...We ...
https://dev.mysql.com/doc/ndbapi/en/mccj-using-clusterj-operations.html
To insert a new row into the table, first create a new instance of Employee. The savePersistent() method updates an existing instance or creates a new instance as needed, without throwing an exception. The process begins with obtaining an instance ...This can be accomplished by calling the Session method newInstance(), as shown here: Employee newEmployee = session.newInstance(Employee.class); Set the Employee instance properties corresponding with the desired employee table ...
https://dev.mysql.com/doc/ndbapi/en/mgm-functions-backup.html
This section provides information about the functions provided in the MGM API for starting and stopping NDB Cluster backups. ndb_mgm_start_backup() ndb_mgm_start_backup2() ndb_mgm_start_backup3() ndb_mgm_start_backup4() ndb_mgm_abort_backup() ...
https://dev.mysql.com/doc/ndbapi/en/ndb-examples-event-handling.html
The source code for this program may be found in the NDB Cluster source tree, in the file storage/ndb/ndbapi-examples/ndbapi_event/ndbapi_event.cpp. #include <NdbApi.hpp> // Used for cout #include <stdio.h> #include <iostream> #include <unistd.h> ...
https://dev.mysql.com/doc/ndbapi/en/ndb-examples-secondary-indexes-ndbrecord.html
*/ NdbDictionary::RecordSpecification spec[2]; spec[0].column= col1; spec[0].offset= offsetof(MyTableRow, attr1); // So that it goes nicely into the struct spec[0].nullbit_byte_offset= 0; spec[0].nullbit_bit_in_byte= 0; const NdbRecord *pk_record= ... This program illustrates how to use secondary indexes in the NDB API with the aid of the NdbRecord ...