PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.2Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/miscellaneous-functions.html
There are multiple ways to cause MySQL to accept the query: Alter the table to make name a primary key or a unique NOT NULL column. ON DUPLICATE KEY UPDATE statement, you can use the VALUES(col_name) function in the UPDATE clause to refer to column ...The function return value and type are the same as the return value and type of its argument, but the function result is not checked for the ONLY_FULL_GROUP_BY SQL ...
https://dev.mysql.com/doc/refman/5.7/en/myisamchk-other-options.html
myisamchk supports the following options for actions other than table checks and repairs: --analyze, -a Command-Line Format --analyze Analyze the distribution of key values. To obtain information about the key distribution, use a myisamchk ...This ...
https://dev.mysql.com/doc/refman/5.7/en/myisamchk-repair-options.html
--keys-used=val, -k val Command-Line Format --keys-used=val Type Numeric For myisamchk, the option value is a bit value that indicates which indexes to update. Use the same technique as -r and -n, but create all the keys in parallel, using different ...--correct-checksum Command-Line Format --correct-checksum Correct the checksum information for the ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-install-example-data.html
There are two key points to keep in mind: For a table to be replicated in the cluster, it must use the NDBCLUSTER storage engine. To specify this, use the ENGINE=NDBCLUSTER or ENGINE=NDB option when creating the table: CREATE TABLE tbl_name ... Note ...
https://dev.mysql.com/doc/refman/5.7/en/MySQLInstallerConsole.html
option_value_pair: A single option (for example, --silent) or a tuple of a key and a corresponding value with an options prefix. Passing in a product keyword alone selects the latest version of the product. Alternatively, you can pass in the exact ... MySQLInstallerConsole.exe provides command-line functionality that is similar to MySQL ...
https://dev.mysql.com/doc/refman/5.7/en/partitioning-management.html
For a discussion of managing HASH and KEY partitions, see Section 22.3.2, “Management of HASH and KEY Partitions”. This clause has the same syntax as that as used with CREATE TABLE for creating a partitioned table, and always begins with the ...
https://dev.mysql.com/doc/refman/5.7/en/partitioning-subpartitions.html
Note SUBPARTITION BY HASH and SUBPARTITION BY KEY generally follow the same syntax rules as PARTITION BY HASH and PARTITION BY KEY, respectively. An exception to this is that SUBPARTITION BY KEY (unlike PARTITION BY KEY) does not currently support a ... Subpartitioning—also known as composite partitioning—is the further division of each partition in a partitioned ...
https://dev.mysql.com/doc/refman/5.7/en/repair-table-optimization.html
Also, in addition to setting memory-allocation variables, increasing the myisam_max_sort_file_size system variable increases the likelihood that the repair uses the faster filesort method and avoids the slower repair by key cache method. Changing a ... REPAIR TABLE for MyISAM tables is similar to using myisamchk for repair operations, and some of the same performance optimizations apply: myisamchk has variables that control memory ...
https://dev.mysql.com/doc/refman/5.7/en/replication-encrypted-connections.html
(--ssl-capath is similar but specifies the path name of a directory of CA certificate files.) ssl_cert: The path name of the server public key certificate file. To use an encrypted connection for the transfer of the binary log required during ...
https://dev.mysql.com/doc/refman/5.7/en/alter-table-examples.html
For NDB tables, it is also possible to change the storage type used for a table or column. row *************************** Table: t1 Create Table: CREATE TABLE `t2` ( `c1` int(11) DEFAULT NULL ) /*!50100 TABLESPACE ts_1 STORAGE DISK */ ...