PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.3Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/multiple-tables.html
In this example, the ON clause specifies that the name column in the pet table must match the name column in the event table. Because the name column occurs in both tables, you must be specific about which table you mean when referring to the column. This is done by prepending the table name to the column ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-limitations-transactions.html
NDBCLUSTER stores only part of a column value that uses any of MySQL's BLOB or TEXT data types in the table visible to MySQL; the remainder of the BLOB or TEXT is stored in a separate internal table that is not accessible to MySQL. This issue does ... A number of limitations exist in NDB Cluster with regard to the handling of ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-ndbd-definition.html
Unique hash indexes are updated only when the unique index columns are updated, in which case a new entry in the index table is inserted and the old entry is deleted upon commit. A value between 0 and 100 inclusive is interpreted as a percent of the ... The [ndbd] and [ndbd default] sections are used to configure the behavior of the cluster's data ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-ndbinfo-nodes.html
The nodes table contains the following columns: node_id The data node's unique node ID in the cluster. Notes The uptime column shows the time in seconds that this node has been running since it was last started or restarted. When the status is ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-ndbinfo-operations-per-fragment.html
The type column shows the schema object type used for this fragment, which can take any one of the values System table, User table, Unique hash index, or Ordered index. The table_id column value is unique at any given time, but can be reused if the ... The operations_per_fragment table provides information about the operations performed on individual fragments and fragment replicas, as well as about some of the results from these ...
https://dev.mysql.com/doc/refman/5.7/en/mysqlimport.html
--columns=column_list, -c column_list Command-Line Format --columns=column_list This option takes a list of comma-separated column names as its value. The order of the column names indicates how to match data file columns with table columns. The ...
https://dev.mysql.com/doc/refman/5.7/en/mysqlslap.html
--auto-generate-sql-add-autoincrement Command-Line Format --auto-generate-sql-add-autoincrement Type Boolean Default Value FALSE Add an AUTO_INCREMENT column to automatically generated tables. --number-char-cols=N, -x N Command-Line Format ...
https://dev.mysql.com/doc/refman/5.7/en/optimize-blob.html
For a table with several columns, to reduce memory requirements for queries that do not use the BLOB column, consider splitting the BLOB column into a separate table and referencing it with a join query when needed. See Section 8.4.2.2, ... When ...
https://dev.mysql.com/doc/refman/5.7/en/optimizing-innodb-storage-layout.html
In InnoDB, having a long PRIMARY KEY (either a single column with a lengthy value, or several columns that form a long composite value) wastes a lot of disk space. (See Section 14.6.2.1, “Clustered and Secondary Indexes”.) Create an ... Once ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-connection-tables.html
Each connection table has CURRENT_CONNECTIONS and TOTAL_CONNECTIONS columns to track the current and total number of connections per “tracking value” on which its statistics are based. The accounts table has USER and HOST columns to track ...