PDF (US Ltr)
- 41.8Mb
PDF (A4)
- 41.9Mb
Man Pages (TGZ)
- 272.4Kb
Man Pages (Zip)
- 378.4Kb
Info (Gzip)
- 4.2Mb
Info (Zip)
- 4.2Mb
Search Results
https://dev.mysql.com/doc/refman/9.7/en/mysql-cluster-online-add-node-example.html
In this section we provide a detailed example illustrating how to add new NDB Cluster data nodes online, starting with an NDB Cluster having 2 data nodes in a single node group and concluding with a cluster having 4 data nodes in 2 node groups.
https://dev.mysql.com/doc/refman/9.7/en/mysql-cluster-replication-schema.html
ndb_apply_status Table ndb_binlog_index Table ndb_replication Table Replication in NDB Cluster makes use of a number of dedicated tables in the mysql database on each MySQL Server instance acting as an SQL node in both the cluster being replicated ...
https://dev.mysql.com/doc/refman/9.7/en/mysql-indexes.html
In this context, VARCHAR and CHAR are considered the same if they are declared as the same size. For example, VARCHAR(10) and CHAR(10) are the same size, but VARCHAR(10) and CHAR(15) are not. Indexes are used to find rows with specific column ...
https://dev.mysql.com/doc/refman/9.7/en/mysqlslap.html
--number-char-cols=N, -x N Command-Line Format --number-char-cols=# Type Numeric The number of VARCHAR columns to use if --auto-generate-sql is specified. mysqlslap is a diagnostic program designed to emulate client load for a MySQL server and to ...
https://dev.mysql.com/doc/refman/9.7/en/other-vendor-data-types.html
To facilitate the use of code written for SQL implementations from other vendors, MySQL maps data types as shown in the following table. These mappings make it easier to import table definitions from other database systems into MySQL. If you create ...
https://dev.mysql.com/doc/refman/9.7/en/partitioning-key.html
Partitioning by key is similar to partitioning by hash, except that where hash partitioning employs a user-defined expression, the hashing function for key partitioning is supplied by the MySQL server. NDB Cluster uses MD5() for this purpose; for ...
https://dev.mysql.com/doc/refman/9.7/en/silent-column-changes.html
If strict SQL mode is not enabled, a VARCHAR column with a length specification greater than 65535 is converted to TEXT, and a VARBINARY column with a length specification greater than 65535 is converted to BLOB. Specifying the CHARACTER SET binary ... In some cases, MySQL silently changes column specifications from those given in a CREATE TABLE or ALTER TABLE ...
https://dev.mysql.com/doc/refman/9.7/en/srjs-api-data-metadata.html
This includes the names of the columns in the result set. If the result set is not empty, the contents of each row are printed in the order obtained; otherwise, the function gets the number of rows affected by the statement and the value of the last ...
https://dev.mysql.com/doc/refman/9.7/en/sys-sys-get-config.html
Parameters in_variable_name VARCHAR(128): The name of the configuration option for which to return the value. in_default_value VARCHAR(128): The default value to return if the configuration option is not found in the sys_config table. Given a ...
https://dev.mysql.com/doc/refman/9.7/en/type-conversion.html
For information about connection character sets, see Section 12.4, “Connection Character Sets and Collations”.) This means that such a conversion results in a character (nonbinary) string (a CHAR, VARCHAR, or LONGTEXT value), except in the case ... When an operator is used with operands of different types, type conversion occurs to make the operands ...