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/miscellaneous-optimization-tips.html
For example, by accessing the MySQL InnoDB or MyISAM storage engine directly, you could get a substantial speed increase compared to using the SQL interface. This section lists a number of miscellaneous tips for improving query processing speed: If ...
https://dev.mysql.com/doc/refman/5.7/en/myisam-key-cache.html
The InnoDB storage engine also uses an LRU algorithm, to manage its buffer pool. To minimize disk I/O, the MyISAM storage engine exploits a strategy that is used by many database management systems. It employs a cache mechanism to keep the most ...
https://dev.mysql.com/doc/refman/5.7/en/myisam-storage-engine.html
To specify explicitly that you want a MyISAM table, indicate that with an ENGINE table option: CREATE TABLE t (i INT) ENGINE = MYISAM; In MySQL 5.7, it is normally necessary to use ENGINE to specify the MyISAM storage engine because InnoDB is the ...
https://dev.mysql.com/doc/refman/5.7/en/myisamchk-general-options.html
For more information, see the description of myisam_stats_method in Section 5.1.7, “Server System Variables”, and Section 8.3.7, “InnoDB and MyISAM Index Statistics Collection”. The options described in this section can be used for any type ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-importing-data.html
It is common when setting up a new instance of NDB Cluster to need to import data from an existing NDB Cluster, instance of MySQL, or other source. This data is most often available in one or more of the following formats: An SQL dump file such as ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-limitations-performance.html
There are query performance issues due to sequential access to the NDB storage engine; it is also relatively more expensive to do many range scans than it is with either MyISAM or InnoDB. The following performance issues are specific to or ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-limitations.html
In the sections that follow, we discuss known limitations in current releases of NDB Cluster as compared with the features available when using the MyISAM and InnoDB storage engines. You can report any discrepancies that you encounter to the MySQL ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-replication.html
It is possible to replicate NDB tables from an NDB Cluster acting as the replication source to tables using other MySQL storage engines such as InnoDB or MyISAM on a replica mysqld. NDB Cluster supports asynchronous replication, more usually ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-enterprise-security.html
For more information, see Section 14.14, “InnoDB Data-at-Rest Encryption”, Encrypting Binary Log Files and Relay Log Files, and Encrypting Audit Log Files. MySQL Enterprise Edition provides plugins that implement security features using ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-indexes.html
Exceptions: Indexes on spatial data types use R-trees; MEMORY tables also support hash indexes; InnoDB uses inverted lists for FULLTEXT indexes. Indexes are used to find rows with specific column values quickly. Without an index, MySQL must begin ...