Search Results
https://dev.mysql.com/doc/internals/en/myisam-concurrent-insert.html
This, in turn, is called from ha_myisam::external_lock() from unlock_external() from mysql_unlock_tables(). So it was possible that another thread (or even multiple of them) could thr_lock the table and work with it before the first thread updates ...To support concurrent inserts, every statement starts with copying MYISAM_SHARE::state.state to MI_INFO::save_state and lets MI_INFO::state point to the ...
https://dev.mysql.com/doc/internals/en/optimizer-partition-selection.html
If a partitioned table is accessed in a series of index lookups (that is, using the ref, eq_ref, or ref_or_null access methods), MySQL checks to see whether it needs to make index lookups in all partitions or that it can limit access to a ...If ...
https://dev.mysql.com/doc/internals/en/rnd-init.html
rnd_init() is called when the system wants the storage engine to do a table scan. then the second call should prepare for the new table scan (e.g if rnd_init allocates the cursor, second call should position it to the start of the table, no need to ...Synopsis virtual int rnd_init (scan); bool scan ; Description This is the rnd_init ...
https://dev.mysql.com/doc/internals/en/rnd-next.html
Purpose Reads the next row from a table and returns it to the server. The Field structure for the table is the key to getting data into buf in a manner that will allow the server to understand it. Usage This example is from the ARCHIVE storage ...
https://dev.mysql.com/doc/internals/en/transactions-roles-responsibilities.html
For example CREATE TABLE does not start a transaction, since handler::external_lock() is never called during CREATE TABLE. SELECT does, since handler::external_lock() is called for the table that is being selected from. The server has only one way ...
https://dev.mysql.com/doc/internals/en/update-row.html
You can do these for example by doing these: if (table->timestamp_field_type & TIMESTAMP_AUTO_SET_ON_UPDATE) table->timestamp_field->set_time(); if (table->next_number_field && record == table->record[0]) update_auto_increment(); Called from ...
https://dev.mysql.com/doc/ndbapi/en/mccj-clusterj-sessionfactory.html
Table 4.73 getSession() Parameter Description return the session 4.3.1.23.8 getSession(Map) public abstract Session getSession(Map properties); Create a session to use with the cluster, overriding some default properties with the properties supplied ...Actual connections to the database are managed in a global connection pool, and may be shared by several session factories; each connection will be closed when the last session factory using it is ...
https://dev.mysql.com/doc/ndbapi/en/mccj-issues.html
Known issues in ClusterJ: Joins: With ClusterJ, queries are limited to single tables. Tables are mapped one-to-one onto domain classes, and only single-table operations are supported. NDB tables support foreign keys, and foreign key constraints are ... This section discusses the limitations and known issues in the MySQL NDB Cluster Connector for Java ...
https://dev.mysql.com/doc/ndbapi/en/ndb-examples-timestamp2.html
The file timestamp2.cpp reproduced in this section provides an example of working in NDB API applications with the “new” MySQL temporal data types supporting fractional seconds. For more information working with MySQL temporal and other data ...
https://dev.mysql.com/doc/ndbapi/en/ndb-nodejs-api-session.html
Session extends Context getMapping(Object parameter, Function(Object err, Object mapping) callback); Get the mappings for a table or class. The parameter may be a table name, a mapped constructor function, or a domain object. TableMetadata ... A ...