PDF (US Ltr)
- 35.0Mb
PDF (A4)
- 35.1Mb
Man Pages (TGZ)
- 255.5Kb
Man Pages (Zip)
- 360.4Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/myisam-storage-engine.html
Table 15.2 MyISAM Storage Engine Features Feature Support B-tree indexes Yes Backup/point-in-time recovery (Implemented in the server, rather than in the storage engine.) Yes Cluster database support No Clustered indexes No Compressed data Yes ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-limitations-transactions.html
NDBCLUSTER stores only part of a column value that uses any of MySQL's BLOB or TEXT data types in the table visible to MySQL; the remainder of the BLOB or TEXT is stored in a separate internal table that is not accessible to MySQL. This issue does ... A number of limitations exist in NDB Cluster with regard to the handling of ...
https://dev.mysql.com/doc/refman/5.7/en/partitioning-limitations-storage-engines.html
The following limitations apply to the use of storage engines with user-defined partitioning of tables. Partitioning of FEDERATED tables is not supported; it is not possible to create partitioned FEDERATED tables. Partitioned tables using the CSV ...InnoDB does not support the use of multiple disks for ...
https://dev.mysql.com/doc/refman/5.7/en/index-page-merge-threshold.html
The MERGE_THRESHOLD for index pages can be defined for a table or for individual indexes. A MERGE_THRESHOLD value defined for an individual index takes priority over a MERGE_THRESHOLD value defined for the table. Setting MERGE_THRESHOLD for a Table ...If the “page-full” percentage for an index page falls below the MERGE_THRESHOLD value when a row is deleted or when a row is shortened by an UPDATE operation, InnoDB attempts to merge the index page with a neighboring index ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-data-encryption.html
About Data-at-Rest Encryption Encryption Prerequisites Enabling File-Per-Table Tablespace Encryption Master Key Rotation Encryption and Recovery Exporting Encrypted Tablespaces Encryption and Replication Identifying Encrypted Tablespaces Encryption ...The data-at-rest encryption feature relies on a keyring plugin for master encryption key ...
https://dev.mysql.com/doc/refman/5.7/en/partitioning-range.html
A table that is partitioned by range is partitioned in such a way that each partition contains rows for which the partitioning expression value lies within a given range. While the examples work as shown for purposes of the present discussion, you ...Ranges should be contiguous but not overlapping, and are defined using the VALUES LESS THAN ...
https://dev.mysql.com/doc/refman/5.7/en/problems-connecting.html
Under Linux or Unix, check your IP tables (or similar) configuration to ensure that the port has not been blocked. The grant tables must be properly set up so that the server can use them for access control. For some distribution types (such as ...
https://dev.mysql.com/doc/refman/5.7/en/external-locking.html
External locking is the use of file system locking to manage contention for MyISAM database tables by multiple processes. External locking is used in situations where a single process such as the MySQL server cannot be assumed to be the only ...
https://dev.mysql.com/doc/refman/5.7/en/fulltext-fine-tuning.html
Some variable changes require that you rebuild the FULLTEXT indexes in your tables. For MyISAM tables, note the remarks regarding myisamchk in the instructions that follow for rebuilding MyISAM full-text indexes. Modifying Boolean Full-Text Search ...You can exert more control over full-text searching behavior if you have a MySQL source distribution because some changes require source code ...
https://dev.mysql.com/doc/refman/5.7/en/handler.html
] HANDLER tbl_name CLOSE The HANDLER statement provides direct access to table storage engine interfaces. OPEN statement opens a table, making it accessible using subsequent HANDLER ... This table object is not shared by other sessions and is not ...