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/point-in-time-recovery.html
Typically, this type of recovery is performed after restoring a full backup that brings the server to its state as of the time the backup was made. (The full backup can be made in several ways, such as those listed in Section 7.2, “Database Backup ... Point-in-time recovery refers to recovery of data changes up to a given point in ...
https://dev.mysql.com/doc/refman/5.7/en/range-optimization.html
MySQL performs an additional check to filter out rows that satisfy the range condition but not the full WHERE clause. If the specified limit is about to be exceeded, the range access method is abandoned and other methods, including a full table ...
https://dev.mysql.com/doc/refman/5.7/en/show.html
SHOW has many forms that provide information about databases, tables, columns, or status information about the server. The pattern is useful for restricting statement output to matching values. Several SHOW statements also accept a WHERE clause ...
https://dev.mysql.com/doc/refman/5.7/en/table-cache.html
MySQL closes an unused table and removes it from the table cache under the following circumstances: When the cache is full and a thread tries to open a table that is not in the cache. If a new table must be opened, but the cache is full and no ...
https://dev.mysql.com/doc/refman/5.7/en/general-thread-states.html
FULLTEXT initialization The server is preparing to perform a natural-language full-text search. If not, verify that you do not have a full disk and that the disk is not in very heavy use. login The initial state for a connection thread until the ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-commands.html
For a list of these commands, type help or \h at the mysql> prompt: mysql> help List of all MySQL commands: Note that all text commands must be first on line and end with ';' ? (\?) Synonym for `help'. mysql sends each SQL statement that you issue ...
https://dev.mysql.com/doc/refman/5.7/en/optimizing-innodb-storage-layout.html
The reorganized tables require less disk I/O to perform full table scans. For tables that are big, or contain lots of repetitive text or numeric data, consider using COMPRESSED row format. Less disk I/O is required to bring data into the buffer ...
https://dev.mysql.com/doc/refman/5.7/en/table-size-limit.html
If you encounter a full-table error, there are several reasons why it might have occurred: The disk might be full. ALTER TABLE tbl_name MAX_ROWS=1000000000 AVG_ROW_LENGTH=nnn; You have to specify AVG_ROW_LENGTH only for tables with BLOB or TEXT ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-data-encryption.html
Encryption is not supported for the InnoDB FULLTEXT index tables that are created implicitly when adding a FULLTEXT index. Instead, InnoDB ensures that the text to be encrypted is a multiple of the block size. About Data-at-Rest Encryption ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-limits.html
For example, you might hit this limit with a column prefix index of more than 255 characters on a TEXT or VARCHAR column, assuming a utf8mb3 character set and the maximum of 3 bytes for each character. The limits that apply to index key prefixes ...