Search Results
https://dev.mysql.com/doc/refman/8.4/en/information-schema-tables-table.html
If there are no cached statistics or statistics have expired, statistics are retrieved from storage engines when querying table statistics columns. The TABLES table has these columns: TABLE_CATALOG The name of the catalog to which the table belongs.
https://dev.mysql.com/doc/refman/8.4/en/show-events.html
SHOW EVENTS output has these columns: Db The name of the schema (database) to which the event belongs. The value shown in this column reflects the addition or subtraction of any INTERVAL value included in the event's AT clause. For example, if an ...
https://dev.mysql.com/doc/internals/en/frm-file-format.html
First, let's create an example table, using the mysql client: mysql> CREATE TABLE table1 (column1 CHAR(5)) ENGINE=MYISAM COMMENT '*'; Query OK, 0 rows affected (0.00 sec) The .frm file associated with table1 can be found in the directory that ...
https://dev.mysql.com/doc/internals/en/innodb-field-contents.html
I made a table with this definition: CREATE TABLE T (FIELD1 VARCHAR(3), FIELD2 VARCHAR(3), FIELD3 VARCHAR(3)) Type=InnoDB; To understand what follows, you must know that table T has six columns — not three — because InnoDB automatically added ...
MySQL NDB Cluster API Developer Guide :: 4.2.2.5 ClusterJ Mappings Between MySQL and Java Data Types
https://dev.mysql.com/doc/ndbapi/en/mccj-using-clusterj-mappings.html
Java object wrappers of primitive types should be mapped to nullable database columns. Note Since Java does not have native unsigned data types, UNSIGNED columns should be avoided in table schemas if possible. The following tables show the mappings ... ClusterJ provides mappings for all of the common MySQL database types to Java ...
https://dev.mysql.com/doc/ndbapi/en/ndb-ndbtransaction.html
In either case, the key_rec must include all columns of the key. A mask which can be used to filter the columns to be inserted. In either case, the key_rec must include all columns of the key. Only if (mask[attrId >> 3] & (1<<(attrId & 7))) is set ...A transaction consists of a list of operations represented by the NdbOperation class, or by one of its subclasses—NdbScanOperation, NdbIndexOperation, or ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-dictionary-encoding.html
Dictionary encoding (SORTED) has the following characteristics: Best suited to string columns with a low number of distinct values relative to the cardinality of the table. Dictionary encoding reduces the space required for column values on the ...
https://dev.mysql.com/doc/refman/8.4/en/group-by-functional-dependence.html
A UNIQUE index over a NOT NULL column could be used instead of a primary key and the same functional dependence would apply. As with the previous example, a UNIQUE key over NOT NULL columns could be used instead of a primary key. Functional ... The ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-ndbinfo-blobs.html
For more information about how NDB Cluster stores columns of such types, see String Type Storage Requirements. The part and inline sizes of NDB blob columns can be set using CREATE TABLE and ALTER TABLE statements containing NDB table column ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-programs-ndb-desc.html
The Version column in the output contains the table's schema object version. READ_ONLY and FULLY_REPLICATED, if set to 1, are shown in the Table options column. The Extent_space and Free extent_space columns are applicable only to NDB tables having ... ndb_desc provides a detailed description of one or more NDB ...