Search Results
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 ...
https://dev.mysql.com/doc/ndbapi/en/ndb-examples-synchronous-transactions.html
It first creates a database ndb_examples and a table api_simple (if these objects do not already exist) using the MySQL C API with an SQL node, then performs a series of basic data operations (insert, update, read, and select) on this table using ...
https://dev.mysql.com/doc/ndbapi/en/ndb-index.html
If you create or change indexes using the NDB API, these modifications cannot be seen by MySQL. Index Class Constructor Description This is used to create an new instance of Index. Indexes created using the NDB API cannot be seen by the MySQL Server. It is possible to create an index without a name, and then assign a name to it later using ...Index Class Overview Index Class Constructor Index::addColumn() Index::addColumnName() Index::addColumnNames() Index::getColumn() Index::getLogging() Index::getName() Index::getNoOfColumns() Index::getObjectStatus() Index::getObjectVersion() Index::getObjectId() Index::getTable() Index::getType() Index::setLogging Index::setName() Index::setTable() Index::setType() Index::Type Index Class Overview Parent class ...
https://dev.mysql.com/doc/ndbapi/en/ndb-start-initialization.html
Keep in mind that, before you invoke this function, all Ndb_cluster_connection objects created in your NDB API application must be cleaned up or destroyed; otherwise, threads created when an Ndb_cluster_connection object's connect() method is ...