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/mysql-indexes.html
Most MySQL indexes (PRIMARY KEY, UNIQUE, INDEX, and FULLTEXT) are stored in B-trees. Exceptions: Indexes on spatial data types use R-trees; MEMORY tables also support hash indexes; InnoDB uses inverted lists for FULLTEXT indexes. In this context, ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-innodb-cluster-introduction.html
This content is a high-level overview of InnoDB Cluster, for full documentation, see MySQL InnoDB Cluster. This chapter introduces MySQL InnoDB Cluster, which combines MySQL technologies to enable you to deploy and administer a complete integrated ...
https://dev.mysql.com/doc/refman/5.7/en/mysqld.html
For a full description of MySQL Server command options, system variables, and status variables, see Section 5.1, “The MySQL Server”. mysqld, also known as MySQL Server, is a single multithreaded program that does most of the work in a MySQL ...
https://dev.mysql.com/doc/refman/5.7/en/nontransactional-tables.html
To check which storage engines your mysqld server supports, use this statement: SHOW ENGINES; See Section 13.7.5.16, “SHOW ENGINES Statement” for full details. If you receive the following message when trying to perform a ROLLBACK, it means ...
https://dev.mysql.com/doc/refman/5.7/en/numeric-type-attributes.html
For example, a column specified as SMALLINT(3) has the usual SMALLINT range of -32768 to 32767, and values outside the range permitted by three digits are displayed in full using more than three digits. MySQL supports an extension for optionally ...
https://dev.mysql.com/doc/refman/5.7/en/optimizing-innodb-configuration-variables.html
Different settings work best for servers with light, predictable loads, versus servers that are running near full capacity all the time, or that experience spikes of high activity. Setting a limit on the number of concurrent threads that InnoDB ...
https://dev.mysql.com/doc/refman/5.7/en/optimizing-innodb-diskio.html
To take full advantage of this feature, an innodb_flush_method setting of O_DIRECT is recommended. If you follow best practices for database design and tuning techniques for SQL operations, but your database is still slow due to heavy disk I/O ...
https://dev.mysql.com/doc/refman/5.7/en/optimizing-innodb-logging.html
When InnoDB has written the redo log files full, it must write the modified contents of the buffer pool to disk in a checkpoint. Consider the following guidelines for optimizing redo logging: Make your redo log files big, even as big as the buffer ...
https://dev.mysql.com/doc/refman/5.7/en/optimizing-memory-tables.html
For why USING BTREE is often a better choice than the default USING HASH, see Section 8.2.1.20, “Avoiding Full Table Scans”. Consider using MEMORY tables for noncritical data that is accessed often, and is read-only or rarely updated. Benchmark ...
https://dev.mysql.com/doc/refman/5.7/en/option-file-options.html
file_name is interpreted relative to the current directory if given as a relative path name rather than a full path name. Most MySQL programs that support option files handle the following options. Because these options affect option-file handling, ...