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/mysql-cluster-programs-ndb-select-all.html
--delimiter=character, -D character Causes the character to be used as a column delimiter. The column is nonempty only for Disk Data tables having nonindexed columns. --gci Adds a GCI column to the output showing the global checkpoint at which each ... ndb_select_all prints all rows from an NDB table to ...
https://dev.mysql.com/doc/refman/5.7/en/out-of-range-and-overflow.html
If no restrictive modes are enabled, MySQL clips the value to the appropriate endpoint of the column data type range and stores the resulting value instead. When an out-of-range value is assigned to an integer column, MySQL stores the value ...In ...
https://dev.mysql.com/doc/refman/5.7/en/partitioning-list.html
The chief difference between the two types of partitioning is that, in list partitioning, each partition is defined and selected based on the membership of a column value in one of a set of value lists, rather than in one of a set of contiguous ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-replication-connection-configuration-table.html
Parameters stored in the table can be changed at runtime with the CHANGE MASTER TO statement, as indicated in the column descriptions. The column descriptions indicate the corresponding CHANGE MASTER TO options from which the column values are ...
https://dev.mysql.com/doc/refman/5.7/en/static-format.html
It is used when the table contains no variable-length columns (VARCHAR, VARBINARY, BLOB, or TEXT). Note Fixed-length row format is only available for tables without BLOB or TEXT columns. Creating a table with these columns with an explicit ...Of the ...
https://dev.mysql.com/doc/refman/5.7/en/using-innodb-tables.html
When selecting primary key columns, choose columns with the following characteristics: Columns that are referenced by the most important queries. For example, in a table containing information about people, you would not create a primary key on ...
https://dev.mysql.com/doc/refman/5.7/en/explain-extended.html
The Message value in SHOW WARNINGS output displays how the optimizer qualifies table and column names in the SELECT statement, what the SELECT looks like after the application of rewriting and optimization rules, and possibly other notes about the ... For SELECT statements, the EXPLAIN statement produces extra (“extended”) information that is not part of EXPLAIN output but can be viewed by issuing a SHOW WARNINGS statement following ...
https://dev.mysql.com/doc/refman/5.7/en/miscellaneous-optimization-tips.html
Similarly, if your application computes a single result based on several column values or large volumes of data, combining the computation into a loadable function can help performance. If possible, classify reports as “live” or as ... This ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-option-tables.html
ndb-default-column-format: Use this value (FIXED or DYNAMIC) by default for COLUMN_FORMAT and ROW_FORMAT options when creating or adding table columns. ndb_default_column_format: Sets default row format and column format (FIXED or DYNAMIC) used for ... The following list includes command-line options, system variables, and status variables applicable within mysqld when it is running as an SQL node in an NDB ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-replication-issues.html
In older versions of NDB Cluster, operations that updated values of unique key columns of NDB tables could result in duplicate-key errors when replicated. NDB, unlike InnoDB or MyISAM, does not write changes to virtual columns to the binary log; ...