PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/multiple-column-indexes.html
MySQL can create composite indexes (that is, indexes on multiple columns). A multiple-column index can be considered a sorted array, the rows of which contain values that are created by concatenating the values of the indexed columns. For certain ...
https://dev.mysql.com/doc/refman/8.0/en/multiple-tables.html
Given these considerations, the CREATE TABLE statement for the event table might look like this: mysql> CREATE TABLE event (name VARCHAR(20), date DATE, type VARCHAR(15), remark VARCHAR(255)); As with the pet table, it is easiest to load the initial ... The pet table keeps track of which pets you ...
https://dev.mysql.com/doc/refman/8.0/en/myisam-table-formats.html
The third, compressed format, can be created only with the myisampack utility (see Section 6.6.6, “myisampack — Generate Compressed, Read-Only MyISAM Tables”). When you use CREATE TABLE or ALTER TABLE for a table that has no BLOB or TEXT ...
https://dev.mysql.com/doc/refman/8.0/en/myisamchk-repair-options.html
--data-file-length=len, -D len Command-Line Format --data-file-length=len Type Numeric The maximum length of the data file (when re-creating data file when it is “full”). Use the same technique as -r and -n, but create all the keys in parallel, ...--correct-checksum Command-Line Format --correct-checksum Correct the checksum information for the ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-config-example.html
To create a default value section, simply add the word default to the section name. To configure them all, create an [ndbd default] section that contains a DataMemory line to specify the data memory size. To support NDB Cluster, you should update ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-limitations-database-objects.html
In addition, the maximum offset for a fixed-width column of an NDB table is 8188 bytes; attempting to create a table that violates this limitation fails with NDB error 851 Maximum offset for fixed-size columns exceeded. Some database objects such ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-ndb-transporter-errors.html
This section lists error codes, names, and messages that are written to the cluster log in the event of transporter errors. 0x00 TE_NO_ERROR No error 0x01 TE_ERROR_CLOSING_SOCKET Error found during closing of socket 0x02 ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-ndbinfo-memory-per-fragment.html
memory_per_fragment Table: Notes memory_per_fragment Table: Examples The memory_per_fragment table provides information about the usage of memory by individual fragments. See the Notes later in this section to see how you can use this to find out ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-programs-ndb-error-reporter.html
ndb_error_reporter creates an archive from data node and management node log files that can be used to help diagnose bugs or other problems with a cluster. ndb_error_reporter then includes all of these files in archive that is created in the same ...It is highly recommended that you make use of this utility when filing reports of bugs in NDB ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-programs-ndb-select-all.html
Note This is the name of an index, not of a column; the index must have been explicitly named when created. ndb_select_all prints all rows from an NDB table to stdout. Usage ndb_select_all -c connection_string tbl_name -d db_name [> file_name] ...