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/innodb-compression-internals.html
This section describes some internal implementation details about compression for InnoDB tables. These properties make this compression technique unsuitable for use in an update-intensive database system. This compression algorithm is mature, ...
https://dev.mysql.com/doc/refman/5.7/en/partitioning-limitations-partitioning-keys-unique-keys.html
This section discusses the relationship of partitioning keys with primary keys and unique keys. The rule governing this relationship can be expressed as follows: All columns used in the partitioning expression for a partitioned table must be part ...In other words, every unique key on the table must use every column in the table's partitioning ...
https://dev.mysql.com/doc/refman/5.7/en/index-condition-pushdown-optimization.html
If we know a person's zipcode value but are not sure about the last name, we can search like this: SELECT * FROM people WHERE zipcode='95054' AND lastname LIKE '%etrunia%' AND address LIKE '%Main Street%'; MySQL can use the index to scan through ...
https://dev.mysql.com/doc/refman/5.7/en/memory-storage-engine.html
This limits scalability when load increases, particularly for statement mixes that include writes. To enforce different size limits for MEMORY tables, change the value of this variable. You can set the size for individual tables as described later ... The MEMORY storage engine (formerly known as HEAP) creates special-purpose tables with contents that are stored in ...
https://dev.mysql.com/doc/refman/5.7/en/create-table.html
This works regardless of whether there is a default database, assuming that the database exists. Indexing only a prefix of column values like this can make the index file much smaller. You can work around this restriction by creating an index on a ...| {FULLTEXT | SPATIAL} [INDEX | KEY] [index_name] (key_part,...) [index_option] ...
https://dev.mysql.com/doc/refman/5.7/en/docker-mysql-getting-started.html
Downloading the server image in a separate step is not strictly necessary; however, performing this step before you create your Docker container ensures your local image is up to date. To download the MySQL Community Edition image, run this command: ... Warning The MySQL Docker images maintained by the MySQL team are built specifically for Linux ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-innodb-ft-being-deleted-table.html
This value is used when you do text searches, to skip rows in the INNODB_FT_INDEX_TABLE table before data for deleted rows is physically removed from the FULLTEXT index by an OPTIMIZE TABLE statement. Because the contents of INNODB_FT_BEING_DELETED ... The INNODB_FT_BEING_DELETED table provides a snapshot of the INNODB_FT_DELETED table; it is used only during an OPTIMIZE TABLE maintenance ...
https://dev.mysql.com/doc/refman/5.7/en/server-status-variables.html
Slave_rows_last_search_algorithm_used The search algorithm that was most recently used by this replica to locate rows for row-based replication. Connection_errors_peer_address The number of errors that occurred while searching for connecting client ... The MySQL server maintains many status variables that provide information about its ...
https://dev.mysql.com/doc/refman/5.7/en/index.html
Including MySQL NDB Cluster 7.5 and NDB Cluster 7.6 Abstract This is the MySQL Reference Manual. This manual describes features that are not included in every edition of MySQL 5.7; such features may not be included in the edition of MySQL 5.7 ...It ...
https://dev.mysql.com/doc/refman/5.7/en/handler-scope.html
When a condition occurs in a stored program, the server searches for applicable handlers in the current scope (current BEGIN ... If there are no applicable handlers, the search continues outward with the handlers in each successive containing scope ... A stored program may include handlers to be invoked when certain conditions occur within the ...