PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 255.8Kb
Man Pages (Zip)
- 360.8Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/innodb-file-space.html
If a row exceeds the maximum row length, variable-length columns are chosen for external off-page storage until the row fits within the maximum row length limit. External off-page storage for variable-length columns differs by row format: COMPACT ...
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-ndbinfo-nodes.html
The config_generation column shows which version of the cluster configuration is in effect on each data node. The nodes table contains the following columns: node_id The data node's unique node ID in the cluster. config_generation The version of the ... This table contains information on the status of data ...
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/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 ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-events-statements-current-table.html
The events_statements_current table has these columns: THREAD_ID, EVENT_ID The thread associated with the event and the thread current event number when the event starts. END_EVENT_ID This column is set to NULL when the event starts and updated to ...The table stores one row per thread showing the current status of the thread's most recent monitored statement event, so there is no system variable for configuring the table ...