PDF (US Ltr)
- 35.0Mb
PDF (A4)
- 35.1Mb
Man Pages (TGZ)
- 254.9Kb
Man Pages (Zip)
- 359.9Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/myisamchk-other-options.html
If keys are packed (PACK_KEYS=1), myisamchk must unpack key blocks first, then re-create indexes and pack the key blocks again. (In this case, re-creating indexes is faster than updating offsets for each index.) . myisamchk supports the following ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-added-deprecated-removed-7-5.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_read_backup: Enable read from any replica for all NDB tables; use NDB_TABLE=READ_BACKUP={0|1} ...Parameters Introduced in NDB 7.5 The following node configuration parameters have been added in NDB ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-ndbinfo-table-distribution-status.html
The table_distribution_status table provides information about the progress of table distribution for NDB tables. is_reorg_ongoing Whether table is currently being reorganized (1 if true) Notes The table_distribution_status table was added in NDB ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-upgrade-downgrade-7-6.html
Due to changes in disk format, upgrading to or downgrading from either of the versions listed here requires an initial node restart of each data node: NDB 7.6.2 NDB 7.6.4 To avoid problems relating to the old format, you should re-create any ...
https://dev.mysql.com/doc/refman/5.7/en/mysqlbinlog-hexdump.html
Master ID: The server ID of the replication source server that created the event. For more information about binary log format, see MySQL Internals: The Binary Log. In the example shown, '9d fc 5c 43' is the representation of '051024 17:24:13' in ...
https://dev.mysql.com/doc/refman/5.7/en/optimization-indexes.html
The best way to improve the performance of SELECT operations is to create indexes on one or more of the columns that are tested in the query. Although it can be tempting to create an indexes for every possible column used in a query, unnecessary ...
https://dev.mysql.com/doc/refman/5.7/en/optimizer-trace-implementation.html
A trace is started by creating an instance of Opt_trace_start; information is added to this trace by creating instances of Opt_trace_object and Opt_trace_array, and by using the add() methods of these classes.
https://dev.mysql.com/doc/refman/5.7/en/optimizing-myisam-bulk-data-loading.html
This creates the index tree in memory before writing it to disk, which is much faster than updating the index during LOAD DATA because it avoids lots of disk seeks. The main difference between automatic optimization and using the procedure ... These ...
https://dev.mysql.com/doc/refman/5.7/en/optimizing-spatial-analysis.html
It is also possible to create normal indexes on spatial columns. Other storage engines support non-SPATIAL indexes, as described in Section 13.1.14, “CREATE INDEX Statement”. For MyISAM and InnoDB tables, search operations in columns containing ...
https://dev.mysql.com/doc/refman/5.7/en/other-vendor-data-types.html
If you create a table with types used by other vendors and then issue a DESCRIBE tbl_name statement, MySQL reports the table structure using the equivalent MySQL types. To facilitate the use of code written for SQL implementations from other ...