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/alter-table-partition-operations.html
In this case, partitions 4 and 5 are merged into the first 4 partitions (the partitions numbered 0, 1, 2, and 3). This statement can be used in several ways: To merge a set of partitions into a single partition. This statement may also be used ...
https://dev.mysql.com/doc/refman/5.7/en/create-table.html
When you insert a value of NULL (recommended) or 0 into an indexed AUTO_INCREMENT column, the column is set to the next sequence value. Take this into account when specifying a prefix length for a nonbinary string column that uses a multibyte ...| ...
https://dev.mysql.com/doc/refman/5.7/en/index-preloading.html
Preloading enables you to put the table index blocks into a key cache buffer in the most efficient way: by reading the index blocks from disk sequentially. Without preloading, the blocks are still placed into the key cache as needed by queries. To ... If there are enough blocks in a key cache to hold blocks of an entire index, or at least the blocks corresponding to its nonleaf nodes, it makes sense to preload the key cache with index blocks before starting to use ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-fulltext-index.html
When incoming documents are tokenized, the individual words (also referred to as “tokens”) are inserted into the index tables along with position information and an associated DOC_ID. The inverted index is partitioned into six auxiliary index ...
https://dev.mysql.com/doc/refman/5.7/en/join.html
This includes a join handled by merging derived tables and views in the FROM clause into the outer query block (see Section 8.2.2.4, “Optimizing Derived Tables and View References with Merging or Materialization”). MySQL supports the following ...
https://dev.mysql.com/doc/refman/5.7/en/load-data-local-security.html
The LOAD DATA statement loads a data file into a table. For client programs that use the C API, local data loading capability is determined by the default compiled into the MySQL client library. For the mysql client, local data loading capability ...The statement can load a file located on the server host, or, if the LOCAL keyword is specified, on the client ...
https://dev.mysql.com/doc/refman/5.7/en/merge-table-problems.html
Instead, the rows from the underlying MyISAM tables are copied into the altered table, which then uses the specified storage engine. The INSERT_METHOD table option for a MERGE table indicates which underlying MyISAM table to use for inserts into the ... The following are known problems with MERGE tables: MERGE child tables are locked through the parent ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-ndbd-definition.html
Each table is normally partitioned into the same number of fragments as there are data nodes in the cluster. (This also means that DataMemory pages, once allocated to a given table, cannot be used by other tables.) Performing a data node recovery ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-replication-schema.html
Splitting replication streams into two (or more) binary logs can be done for reasons of performance, a need to replicate different databases to different places, use of different binary logging types for different databases, and so on.
https://dev.mysql.com/doc/refman/5.7/en/optimizing-innodb-bulk-data-loading.html
When importing data into InnoDB, turn off autocommit mode, because it performs a log flush to disk for every insert. COMMIT; The mysqldump option --opt creates dump files that are fast to import into an InnoDB table, even without wrapping them with ... These performance tips supplement the general guidelines for fast inserts in Section 8.2.4.1, “Optimizing INSERT ...