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-read-only-instance.html
You can query InnoDB tables where the MySQL data directory is on read-only media by enabling the --innodb-read-only configuration option at server startup. This option specifies the path, file name, and file size for InnoDB temporary tablespace ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-redo-log.html
During normal operations, the redo log encodes requests to change table data that result from SQL statements or low-level API calls. The redo log is a disk-based data structure used during crash recovery to correct data written by incomplete ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-transaction-model.html
Typically, several users are permitted to lock every row in InnoDB tables, or any random subset of the rows, without causing InnoDB memory exhaustion. The InnoDB transaction model aims combine the best properties of a multi-versioning database with ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-turning-off.html
In MySQL 5.7, InnoDB is the default storage engine for new tables. Oracle recommends InnoDB as the preferred storage engine for typical database applications, from single-user wikis and blogs running on a local system, to high-end applications ...
https://dev.mysql.com/doc/refman/5.7/en/installing-source-distribution.html
To install in a specific directory, add a DESTDIR parameter to the command line: $> make install DESTDIR="/opt/mysql" Alternatively, generate installation package files that you can install where you like: $> make package This operation produces one ... To install MySQL from a standard source distribution: Verify that your system satisfies the tool requirements listed at Section 2.8.2, “Source Installation ...
https://dev.mysql.com/doc/refman/5.7/en/json-creation-functions.html
Certain special characters are escaped with backslashes per the escape sequences shown in Table 12.23, “JSON_UNQUOTE() Special Character Escape Sequences”. The functions listed in this section compose JSON values from component elements.
https://dev.mysql.com/doc/refman/5.7/en/json-function-reference.html
Table 12.22 JSON Functions Name Description Introduced Deprecated -> Return value from JSON column after evaluating path; equivalent to JSON_EXTRACT(). ->> Return value from JSON column after evaluating path and unquoting the result; equivalent to ...
https://dev.mysql.com/doc/refman/5.7/en/key-cache-block-size.html
To control the size of blocks in the .MYI index file of MyISAM tables, use the --myisam-block-size option at server startup. It is possible to specify the size of the block buffers for an individual key cache using the key_cache_block_size variable. This permits tuning of the performance of I/O operations for index ...
https://dev.mysql.com/doc/refman/5.7/en/key-cache-restructuring.html
Instead, the server directly accesses the table indexes using native file system caching. A key cache can be restructured at any time by updating its parameter values. For example: mysql> SET GLOBAL cold_cache.key_buffer_size=4*1024*1024; If you ...
https://dev.mysql.com/doc/refman/5.7/en/keyring-aws-plugin.html
This is simpler and has no side effects, but is not suitable for installations that require minimal server downtime with as few restarts as possible. Note The keyring_aws plugin is an extension included in MySQL Enterprise Edition, a commercial ...