Search Results
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"). (Reminder: This does not refer to BDB and InnoDB tables, which do use pages). So the file Table1.MYD looks like this: Hexadecimal Display of ...These files will be in the directory: /<datadir>/<database>/ For example, if you use Linux, you might find the files in the /usr/local/var/test directory (assuming your database name is ...
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/optimizer-transpositions.html
If an expression of this form refers to an indexed column, then MySQL always uses the index, regardless of the table size. (Exception: If the table has only zero rows or only one row, it is a constant table and receives special treatment. MySQL ...
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 ...