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/mysql-cluster-programs-ndbinfo-select-all.html
--delay=seconds Command-Line Format --delay=# Type Numeric Default Value 5 Minimum Value 0 Maximum Value MAX_INT This option sets the number of seconds to wait between executing loops. --loops=number, -l number Command-Line Format --loops=# Type ...
https://dev.mysql.com/doc/refman/5.7/en/full-disk.html
This section describes how MySQL responds to disk-full errors (such as “no space left on device”), and to quota-exceeded errors (such as “write failed” or “user block limit reached”). The thread is aborted the next time it checks the ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-referential-constraints-table.html
The REFERENTIAL_CONSTRAINTS table has these columns: CONSTRAINT_CATALOG The name of the catalog to which the constraint belongs. CONSTRAINT_SCHEMA The name of the schema (database) to which the constraint belongs. UNIQUE_CONSTRAINT_CATALOG The name ...
https://dev.mysql.com/doc/refman/5.7/en/correlated-subqueries.html
A correlated subquery is a subquery that contains a reference to a table that also appears in the outer query. For example: SELECT * FROM t1 WHERE column1 = ANY (SELECT column1 FROM t2 WHERE t2.column2 = t1.column2); Notice that the subquery ...
https://dev.mysql.com/doc/refman/5.7/en/storage-engine-setting.html
You can set the default storage engine for the current session by setting the default_storage_engine variable: SET default_storage_engine=NDBCLUSTER; The storage engine for TEMPORARY tables created with CREATE TEMPORARY TABLE can be set separately ... When you create a new table, you can specify which storage engine to use by adding an ENGINE table option to the CREATE TABLE statement: -- ENGINE=INNODB not needed unless you have set a different -- default storage ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-ndbinfo-config-values.html
row *************************** Name: NodeId Node: 2 Type: unsigned Default: Minimum: 1 Maximum: 48 Required: Y Current: 2 *************************** 2. row *************************** Name: HostName Node: 2 Type: string Default: localhost Minimum: ... The config_values table, implemented in NDB 7.5.0, provides information about the current state of node configuration parameter ...
https://dev.mysql.com/doc/refman/5.7/en/charset-unicode-utf16.html
Because MySQL must allow for the worst case (that one character requires four bytes) the maximum length of a utf16 column or index is only half of the maximum length for a ucs2 column or index. The utf16 character set is the ucs2 character set with ...
https://dev.mysql.com/doc/refman/5.7/en/multiple-windows-command-line-servers.html
For example, the C:\my-opts1.cnf file might be written like this: [mysqld] datadir = C:/mydata1 port = 3307 enable-named-pipe socket = mypipe1 Modify C:\my-opts2.cnf similarly for use by the second server. The procedure for starting a single MySQL ...
21.7.9.1 NDB Cluster Replication: Automating Synchronization of the Replica to the Source Binary Log
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-replication-auto-sync.html
It is possible to automate much of the process described in the previous section (see Section 21.7.9, “NDB Cluster Backups With NDB Cluster Replication”). The following Perl script reset-replica.pl serves as an example of how you can do this.
https://dev.mysql.com/doc/refman/5.7/en/csv-storage-engine.html
If you examine the test.CSV file in the database directory created by executing the preceding statements, its contents should look like this: "1","record one" "2","record two" This format can be read, and even written, by spreadsheet applications ...